Hello!
i have another problem importing joomla content. I exported data from an old website and prepared it for import into joomla. in 2 columns the text content is HTML text. in it are German umlauts (ä,ü,ö) as ü (=ü) shown. the semicolon is now interpreted as a split and thus the import becomes erroneous. Is there a way to bypass this issue? Possibly to define another column separator (did not find this option).
Thanks for your help!
Chris
PS: No debug log found
-
true_studios
- RO CSVI
- Wednesday, 26 July 2023
- Subscribe via email
Accepted Answer
Pending Moderation
Hello Chris,
A correct CSV looks like this, it does not matter if you use comma or semi-colon.
If you follow the use of the separator and text enclosure you can use anything you like within your text enclosure.
Let us know how it goes.
the semicolon is now interpreted as a split and thus the import becomes erroneous. Is there a way to bypass this issue?There definitely is, by following the CSV standards
A correct CSV looks like this, it does not matter if you use comma or semi-colon.
"title";"introtext"
"A great escape";"On a long winter night it was very dark; You can hear the trees whisper ""Oh what a night"""
If you follow the use of the separator and text enclosure you can use anything you like within your text enclosure.
Let us know how it goes.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory