Errors using the Import/Export CSV Plugin

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:
image

I have also saved the Log file if that helps.

Thank you for your help!

Peggy

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:

DCMI: Title DCMI: Creator DCMI: Date DCMI: Type http://purl.org/dc/elements/1.1/source https://tropy.org/v1/tropy#collection https://tropy.org/v1/tropy#box https://tropy.org/v1/tropy#folder http://purl.org/dc/elements/1.1/identifier DCMI: Rights https://tropy.org/v1/tropy#tag https://tropy.org/v1/tropy#path https://tropy.org/v1/tropy#note https://tropy.org/v1/tropy#path https://tropy.org/v1/tropy#note
007545888_00881 Wohl C:\Users\Peggy.Peggy-HPp7-1155\Documents\GEN Family History Documents Tropy\myheritage-immigration&travel\007545888_00881.jpg
007545933_00973 Wohl C:\Users\Peggy.Peggy-HPp7-1155\Documents\GEN Family History Documents Tropy\myheritage-immigration&travel\007545933_00973.jpg C:\Users\Peggy.Peggy-HPp7-1155\Documents\GEN Family History Documents Tropy\myheritage-immigration&travel\007545933_00974.jpg

Here are the same lines from the import. These seemed to cause the error:

http://purl.org/dc/elements/1.1/title DCMI: Creator http://purl.org/dc/elements/1.1/date http://purl.org/dc/elements/1.1/type DCMI: Source https://tropy.org/v1/tropy#collection https://tropy.org/v1/tropy#box https://tropy.org/v1/tropy#folder DCMI: Identifier http://purl.org/dc/elements/1.1/rights https://tropy.org/v1/tropy#tag https://tropy.org/v1/tropy#path https://tropy.org/v1/tropy#note https://tropy.org/v1/tropy#path https://tropy.org/v1/tropy#note
007545888_00881 Nov 5, 1889 Passport My Heritage 007545888_00881 Wohl C:\Users\Peggy.Peggy-HPp7-1155\Documents\GEN Family History Documents Tropy\myheritage-immigration&travel\007545888_00881.jpg
007545933_00973 Feb 27, 1865 Loyalty Oath My Heritage 007545933_00973 Wohl C:\Users\Peggy.Peggy-HPp7-1155\Documents\GEN Family History Documents Tropy\myheritage-immigration&travel\007545933_00973.jpg C:\Users\Peggy.Peggy-HPp7-1155\Documents\GEN Family History Documents Tropy\myheritage-immigration&travel\007545933_00974.jpg

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?

Thank you.
Peggy

Thanks!

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.

Thank you!

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.

Peggy

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.
Thank you!

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.