Joomla 5 Notice

We are pleased to announce that as of January 29, 2024, all of our Joomla extensions are compatible with Joomla 5.

For all who are still updateing from Joomla 3 to Joomla 4: Joomla 4 Migration instructions are available here:

There is now a separate Documentation for Visforms for Joomla 4 and for Visforms for Joomla 5!

Forum

Visforms Subscription user can ask questions in our forum. Please log in with the relevant user first.
Everybody can access the forum for reading.

Please only ask 1 question per topic.

Сharacter escaping in text during data export

More
2 years 7 months ago #7628 by Oleg
When export form's data, I use Semicolon as Separator. But, when in data are text with semicolons, these semicolons don't escape. And as result import CSV file to OpenOffice is not correct. Is any way to solve this problem?

More
2 years 7 months ago #7629 by Administrator AV
Replied by Administrator AV on topic Сharacter escaping in text during data export
Hi,
if the data contains the selected separator, then the whole data string is put inside double quotes.
As far as I know, this is the proper way to escape the separator in a CSV file.
And, as Visforms is used by thousands of people, I'm quite sure, that this works.

Importing the CSV to OpenOffice is a second step, which actually has nothing to do with Visforms in the first place.
I actually think, that the semicolon in the data is not really the problem, but that there is at least one condition, which causes the import of your CSV to fail.

So, please, open the CSV file in a text editor and check, whether the double quotes are in place, around the data in question.
And whether there might be some other problem with the data in question (unescaped double quotes...)..

Regards,
Aicha

:idea: I recommend you the new and up-to-date documentation for Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/en/docs/
Most of this also applies retrospectively to Joomla 3.
Please only ask 1 question per topic :-).

:idea: Ich empfehle Dir die neue und aktuelle Dokumentation für Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/docs/
Das meiste gilt rückwirkend auch für Joomla 3.
Bitte immer nur 1 Frage pro Thema stellen :-).

Moderators: Administrator AVAdministrator IV
Powered by Kunena Forum