How Configure CSV delimiter character in CSV export options

[Roberto JR]

Hello.

Many stored descriptions contain the character "," (comma) inside the text, which results in a messy csv (with "," as a delimiter). How can I configure the option to export csv with different delimiter character?

Thanks

[Dan Gillean]

Hi Roberto, 

It is not possible without development to change AtoM's use of the comma as the text delimiter in a CSV - after all, CSV stands for comma separated values ;)

If you have commas in your descriptive content, this should not affect the CSV output from being well-formed. 

Cheers, 

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/62183957-4a64-4d30-beaa-3e8190490d72%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Roberto JR]

Hello Dan,

Thanks

Well... I do not agree with this statement (about csv), but the important thing is that the exported file do affects the CSV output indeed, since I tried to "re-import" it and AtoM rejected the file with errors!

So, I would try use XML but my installation does not provide XML export (I dont know why).

I´ve posted this issue too.

Thanks

[[]]

R.J.R.

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/BxE6kZNKWAM/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/CAC1FhZK2ADKmN00uguA77ZweTJAOs%2BHW_qWmoPZXD-XtXfiLKg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

[Dan Gillean]

Hi Roberto, 

Is the AtoM site from which you are exporting publicly available? I would be happy to test running an export, and importing it locally to see if I can recreate the issues you are experiencing? Alternatively, feel free to send me a sample CSV and I will take a look, if you like. 

Cheers, 

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

@accesstomemory

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/CAFZR1xomuk%2BcVz%2B-EkTRhObUVxyFPu4g420wRu0bOy%2BU%3DErsjg%40mail.gmail.com.

[Roberto JR]

Hello,

Thanks!

I just answered you in another post

"Re: [atom-users] Atom XML Export not available"

In short, I believe the problem with csv was in the UFT-8 (or WideLatin encoding).

Thanks again! 

[[]]

R.J.R.

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

For more options, visit https://groups.google.com/d/optout.

--