CSV Export

[Tatiana Canelhas]

Hi Group, 

for some reason, some fields in the CSV file are coming blank, such as the title. 

I do not know what might be causing this. 

Can someone help me? I attached an CSV example.

Thanks, 

Tatiana Canelhas

[Dan Gillean]

Hi Tatiana, 

What was the expected outcome? Is this a CSV you were trying to import, or is this the result of a CSV export, that you expected to be populated?

Looking at this CSV in LibreOffice Calc, I see only 3 out of 46 descriptions that have titles. There are a few rows (such as rows 8, 19, and 20) that have only a legacyID, publication status, and culture - nothing else including title, identifier, level of description, etc. So... if you were trying to import this and not seeing titles, it may be because your CSV is malformed?

If this is an export, then my guess is that this is a culture issue. Every description here has an en culture code. I am guessing that your descriptions have been added in a mixture of English and Portuguese, and the Portuguese content is not being exported. 

There are some known i18n issues with CSV export, which are described in the following tickets: 

• https://projects.artefactual.com/issues/12155 
• https://projects.artefactual.com/issues/12107 

There is also a related thread here, which includes a command-line workaround: 

• https://groups.google.com/d/msg/ica-atom-users/HSNdPCY-Ey4/Rz-8mVMnAgAJ

Hope that helps!  

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To post to this group, send email to ica-ato...@googlegroups.com.
Visit this group at https://groups.google.com/group/ica-atom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/6127df96-7e7c-4290-8261-85ff833fdc9e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Tatiana]

Hi Dan, 


Yes, it is an CSV export. And all of it has a title which was not exported in this csv.

I will try the workaround.

Thanks.

Tatiana Canelhas

You received this message because you are subscribed to a topic in the Google Groups "AtoM Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/ica-atom-users/qQOc-miL4Ro/unsubscribe.
To unsubscribe from this group and all its topics, send an email to ica-atom-user...@googlegroups.com.

To post to this group, send email to ica-ato...@googlegroups.com.
Visit this group at https://groups.google.com/group/ica-atom-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/CAC1FhZJiGPJmZLqrSB9139KOk84mabJbYVoa_gjYWAtOysfeMw%40mail.gmail.com.