Automatic update imported dataset from Google Drive Spreadsheet

[Romana Velflova]

I need to automaticly refresh imported data to project with every change in Google Spreadsheet. Unfortunately I don´t know how. Can anybody advise?

[Martin Magdinier]

Hello Romana,

Sorry for the late reply.
OpenRefine doesn't support such process.
When you create a project from Google Spreadsheet, OpenRefine copy the data in its local memory making a distinct file.

Regards
Martin

On 14-07-02 04:31 AM, Romana Velflova wrote:

I need to automaticly refresh imported data to project with every change in Google Spreadsheet. Unfortunately I don´t know how. Can anybody advise?

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Tim Williams]

The only method I have found for my own work is to:

1. Capture & save  the JSON from the original OR project.

2. Create a new project, import the updated spreadsheet

3. APPLY the JSON from the original OR project.

This works for me because I am re-applying an RDF skeleton, captured as JSON, then applied to an updated or new source spreadsheet. AFAIK, any transformations, reconciliations, etc. will have to be re-applied manually, so this will not likely address your issue.

Tim W.