Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
When I export a term with a komma in the field Description (D7), I get the below message. I suppose this shouldn't be necessary when each field in the export is surround by "-characters.
Errors have been reported during export process. Process failed at term 2 (R2-DC) of a total of 5 [ERROR : Current line contains delimiter, enclosure or unprotected line ending. You need to change them if you want to import correctly a taxonomy.].
Comments
Comment #1
johnvI discovered that you can set the values on 2nd tab, after which the komma's can get exported. I suggest 2 changes in the UI:
1. Please change the following in the message
from : "You need to change them if you want to import correctly a taxonomy."
to: "Change the content of the term, or set appropriate format-settings in tab 2."
2. Your tabs have titles beginning with 'Hide 1.'. etc. In the Import-side, you just show a number, which is better.
Comment #2
Daniel_KM CreditAttribution: Daniel_KM commentedHi,
I have considered your suggestion. I'm going to commit them in the 6/7.x-5.5 release.
I don't understand why your titles begin with
"Hide 1"
. I don't use this word in the module. Perhaps a problem of localization.Daniel Berthereau
Knowledge manager
Comment #3
johnvOK, I'll wait for your next release. I only have one language installed: English.
Kind regards, John
Comment #4
Daniel_KM CreditAttribution: Daniel_KM commentedHi,
I commit your suggestion.
SIncerely,
Daniel Berthereau
Knowledge manager
Comment #5
Daniel_KM CreditAttribution: Daniel_KM commentedDaniel Berthereau
Knowledge manager
Comment #6
Summit CreditAttribution: Summit commentedHi, I open this thread again. I got with every setup:
I tried "," and ";" and other things, nothing helped to get my terms exported.
Thanks a lot in advance for going into this again.
Greetings, Martijn
Comment #7
Daniel_KM CreditAttribution: Daniel_KM commentedHi,
Which release do you use? What is your term (description, parent...)? Did you try to add a CSV value enclosure?
Sincerely,
Daniel Berthereau
Infodoc & Knowledge management
Comment #8
Daniel_KM CreditAttribution: Daniel_KM commentedComment #9
Ashlar CreditAttribution: Ashlar commentedI am also experiencing this problem. The export process fails due to html coding in a 'description'
My export settings:
The error:
The term:
Although it appears to be a problem with 'export' not dealing with an embedded comma, I added commas in other terms and they were processed properly. Als0, this term fails with and without commas in the description body. Additional testing points to the problem being with the embedded html codes. The failure occurs at the first term with these codes and I can cause an earlier failure by inserting the description code with html in an earlier term.
Comment #10
Daniel_KM CreditAttribution: Daniel_KM commentedHi,
Thanks for your detailled report. It allows me to reproduce your issue.
In fact, your description is multiline, so you need to set a CSV value enclosure (commonly quotation mark "), even if there is no comma.
I 'll change this to default in the next release.
Sincerely,
Daniel Berthereau
Infodoc & Knowledge management
Comment #11
Daniel_KM CreditAttribution: Daniel_KM commentedHi,
I committed the change: default export enclosure is now « " ».
Sincerely,
Daniel Berthereau
Infodoc & Knowledge management
Comment #12
Summit CreditAttribution: Summit commentedHi
Opening this again if it is ok.
I have also these errors:
But only when I use export to Hierarchical tree structure and Fields. Hierarchy structure without fields is working ok.
Sorry if this is unrelated than I close this issue again.
Greetings,
Martijn
Comment #13
Daniel_KM CreditAttribution: Daniel_KM commentedHi,
This is strange. Can I have the full content and fields of this term and its parent?
Sincerely,
Daniel Berthereau
Infodoc & Knowledge management
Comment #14
Anne-Pierre CreditAttribution: Anne-Pierre commentedHello,
I get an error similar to #1 on a D6 website. On that specific taxonomy vocabulary, I have an Image Taxonomy. I guess this is the reason for my error message.
Comment #15
kenorb CreditAttribution: kenorb commentedThe same problem here.
My term contained double-quotes in Description field (e.g. "London Bridge", "London Bridge"). After removing it, it went further.
Comment #16
searchmax CreditAttribution: searchmax commentedThe solution here worked for me -
https://cmsinsider.blogspot.in/2018/01/issue-with-comma-delimiter-while....
Comment #17
steniya CreditAttribution: steniya commented#16 worked for me...
Please find the URL: https://cmsinsider.blogspot.in/2018/01/issue-with-comma-delimiter-while....
Comment #18
Summit CreditAttribution: Summit as a volunteer commentedHi, using this for Migration D7 -> D10.
Info from webpage #17
Issue :-
After exporting the data using taxonomy csv module in Drupal, it separates the "description" into different cells treating the comma in the "description" field as the delimiter.
Solution:-
Add htmlspecialchars() in the file taxonomy_csv/export/taxonomy_csv.export.inc in the function taxonomy_csv_term_export().
Replace the line
$result['line'][] = _taxonomy_csv_escape_line_break($item['value']);
with
Wouldn't it not be better to put this in a patch please?
Greetings, Martijn