[Alma] - export items job - csv format - always add / embed in double quotes as text qualifiers / delimiters
Right now in Alma, when running a job to export a set of Items in csv format, double quotes are added only to values containing commas (see attached example).
Which is not wrong at all, but it would be much better (e.g. for postprocessing the file in a text editor or using regex) if the double quotes were always added by default in the .csv format.
For example, right now is.
03149898,Machine à lettres,MeMo,Book,"Magnani, Julien",AM 22800
but it would be much easier to process if it were:
"03149898","Machine à lettres","MeMo","Book","Magnani, Julien","AM 22800".
Luigi Siciliano
shared this idea
Hello All,
This idea has been closed as part of a cleanup process for ideas older than two years with fewer than 20 votes.
This cleanup process is necessary to streamline our idea management process and ensure that the most relevant and impactful ideas receive the attention they deserve. If you still feel strongly about this idea, you may submit it via the NERS process.
We value your feedback and encourage you to continue submitting and voting for ideas that you believe will enhance Alma.
Alma Product Team
-
Aliouat Rachid
commented
Hi,
after long discussions with ExLibris via Salesforce, the problem would be solved within the framework of a long-term plan (end of 2020, or 2021).But EL proposes to use the PERL TEXT::CSV library to fix the problem.
sample code in the attached.
I tested and it fixes the problem well.
It's ok
Rachid -
Luigi Siciliano
commented
Dear Rachid, thank you.
Unfortunately this idea did not gather many votes so far. Perhaps you could share it among your french speaking colleagues.. -
Aliouat Rachid
commented
Hello,
It's a real problem for me whit the french titles that could contain semi-coma.
i made a case about this. And ExLibris suggested me to vote for your idea.
Rachid Aliouat
Université de Lille (France)
