Filenames already reconciled when starting an OpenRefine project from Commons categories

[trnstlntk]

When users start an OpenRefine project using the Commons categories feature, it would be great if the file name column would already be reconciled against Wikimedia Commons.

Currently the project loads like this (checked M-id and categories options):

Where the user still needs to manually reconcile the file names.

It would be great if a project would start with the file names already reconciled like this:

[trnstlntk]

I think @antoine2711 was already thinking about a similar feature for the SPARQL importer extension as well?

[antoine2711]

I think @antoine2711 was already thinking about a similar feature for the SPARQL importer extension as well?

Yes, we are currently working on that, and I will try to bring the code to do the same with the Commons Importer.

Regards, Antoine

[wetneb]

So, to work on this, I would recommend to follow what the "Use values as identifiers operation" is doing:
https://github.com/OpenRefine/OpenRefine/blob/master/main/src/com/google/refine/operations/recon/ReconUseValuesAsIdentifiersOperation.java#L114-L137
(this shows how to create a reconciled cell, you should use similar code in your conversion from FileRecord to Row).

And then we should add reconciliation statistics and configuration on the column header (but that can be done in a second step). For this you could have a look at the Wikitext importer:
https://github.com/OpenRefine/OpenRefine/blob/master/main/src/com/google/refine/importers/WikitextImporter.java#L751-L760