I am a beginner trying to use Tropy to organize years of documents collected for genealogy research.
Because of the way that I have filed my scanned documents in the past, I think it would be easier for me to import one file of scanned documents, export them to CSV, enter the elements, tags, and notes in CSV, then import the CSV.
I am experimenting with this. I exported 4 items, added a few things, then imported them. The first two items work import correctly, but the last two items cause an error and do not import.
Here is the error report:
I have also saved the Log file if that helps.
Thank you for your help!
Could you post one of the CSV rows that failed to import? Ideally, both the original and altered version.
Here are the two lines from the export in CSV with the header:
Here are the same lines from the import. These seemed to cause the error:
I am suspicious that I entered the date incorrectly, but I put it in quotes (it contains a comma) and it still didn’t work.
Perhaps I don’t understand the correct date format?
I think the issue is that your CSV data contains trailing columns. This causes issues, because the CSV data is flexible in the way that you can add multiple photos per item/row so if there are trailing blank columns the CSV plugin will interpret those as additional photos (which it then can’t parse because they are blank).
For the date field we suggest to use ISO format (YYYY-MM-DD); Tropy will then parse the date and format it according to your locale. Using a different format is fine too, Tropy will just display it as a string. However, since you’re working with CSV here you need to be careful if your values contain commas such as in your example: you always need to use quotations around those values like you say.
How do you work with the CSV data? I’m assuming you’re using a spreadsheet in Libre Office or Excel? Either way, you need to be careful with the export options. Ideally, use quoted values (so you don’t need to add quotes yourself) and make sure not to export any additional columns. If you’re still having problems, please post the altered CSV data you’re trying to import (that is, not as a table but the raw data) then we can tell you exactly what the issue is, but I’m relatively confident that it’s just trailing columns.
I understand about the ISO date format, and can use it easily. I was
just unsure which format to use.
I will look into the trailing columns issue. That is probably the
problem because three of the four item lines had two images. The error
always occurred at the line with only one image.
Oh, yes, I see how this could be a problem when you export the data from the spreadsheet again. We should look into skipping trailing blank columns to make this a little easier.
It’s fixed! It was the trailing columns. I am trying so many new things at once that I didn’t realize my data input process should put “Conslolidate” items after I had cleaned them up in my CSV export/import. I was trying to import a mix of items with one and two images. The error was for the first one that was just one image after the first items had two images.
I believe that this information is in the Help section, but it didn’t make sense to me until I saw it in action.
I have a couple of additional questions, but will start a new thread as they are very different subjects.
Again, thank you for your quick support.