Import CSV 2.0

[txau]

• Add an icon in uploads for importing CSV file
• Halt on first error and provides feedback
• Add support for multiple languages (add id and lang columns)
• Support updates when Uwazi ids are provided
• Support file uploads (upload a zip)
• validate zip has only one csv
• When I don't have a lang, I use the default lang to create the records
• Add an icon for importing thesauri in a thesauri

[RafaPolit]

• Be able to delete file once assigned (removing the column has no effect, assigning empty value to the column has no effect either) (We will decide how to approach this if the need arises... it needs to be discussed with partial updates of metadata, CSV export, and other related functionality)

[RafaPolit]

The UI, we have some general UX questions that we have included in #2353, or maybe everything should be consolidated here?

[daneryl]

@RafaPolit @txau

The UI, we have some general UX questions that we have included in #2353, or maybe everything should be consolidated here?

lets finish the the more tech side here and continue with ux things in the other one.

Be able to delete file once assigned (removing the column has no effect, assigning empty value to the column has no effect either)

should a blank value on the file column delete the file then ?

[daneryl]

@txau thinking about this

validate zip has only one csv

what if they want to add a csv as an attachment, should we some kind of naming convention to specify which csv to use for the import ?

[txau]

@daneryl good call. It totally makes sense.

[daneryl]

@txau, so do nothing about it until we implement attachments sounds good ?

[txau]

@daneryl since you are going to check nevertheless for the presence of a CSV, check for a particular CSV name, ie. import.csv.

[habbes]

@daneryl when you have a .zip file with multiple files, including multiple .csv files, it correctly imports the import.csv file.

If there's no import.csv in the zip folder, this notifcation is displayed:

It stays on the sidebar indefinitely. You can close it, but it reappears when you click the "import" button. Which means you lose access to the import form, until you refresh the page.

The notification goes on the top bar when you go to the library page:

I can't see any way to close it. It stays there indefinitely, until you refresh the page.

[daneryl]

@habbes ok, nice one ... will look into it thx !

[daneryl]

@habbes the fix is ready on the PR, error handling was missing on the endpoint, ready for QA

[habbes]

@daneryl alright

And regarding this:

what if they want to add a csv as an attachment, should we some kind of naming convention to specify which csv to use for the import ?

How do I add attachments in the zip for imports?

[daneryl]

@habbes attachments support is not implemented yet, this was just to prevent this problem in the future.

[habbes]

@daneryl oh alright