I have about 1200 photos in which I used OCR and a translation software to transcribe and translate the text in said photos. I want to import the transcriptions and translations into the notes section to each corresponding photo. (I used Mathematica to automate the transcription and translation process and used Mathematica also to put this edits into an exported JSON file of the project)
Is there a way to import the edited JSON into an existing project? Alternatviely is it possible to access and later import an sqlite database?
You can re-import the JSON data into your project, but this will create new items. If your original items have not changed in Tropy after you exported them, you can just delete the old items and import the edited items instead.
You can access the project’s SQLite database directly. The .tpy file is a SQLite database and you can open it with all SQLite tools. Reading from the project database should be relatively straight forward. If, by later importing an SQLite database you mean to import data from a SQLite database into the Tropy project, this is certainly possible, though in that case it might be easier to go via JSON format using an import plugin. (We’re also working on a new plugin hook that will allow to alter extisting items via JSON).
We’re also currently working on built-in transcription support (via ALTO XML). As opposed to storing transcriptions in the note field this will allow highlighting the transcribed words in the photos.
Okay thanks! How do I import the new JSON data? When I go to file-import it only allows me to import folders or photos and the JSON file doesn’t appear