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.

Important information for almost every question:
V1: Which Visforms version is running?
V2: Which Joomla version is running?
V3: Which PHP version is running?

</br> tag in CSV file

More
11 months 2 weeks ago #9938 by NuovaFolati
</br> tag in CSV file was created by NuovaFolati
Hi, in the CSV file, the list of items selected by a "checkbox group" appears separated by the </br> tag.
Is it possible to export this data separated for example by comma, but without the </br> tag?

Thanks for your help

More
11 months 2 weeks ago #9940 by Administrator IV
Replied by Administrator IV on topic </br> tag in CSV file
Hello NuovaFolati,

The values of checkbox groups are stored comma-separated in the database and I don't know that this is changed anywhere in the CSV export.
So the br tags cannot be the value separators.

Can you provide me with an excerpt from the export file where the br tags can be seen?

Kind regards, Ingmar

: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 :-).

More
11 months 2 weeks ago #9941 by NuovaFolati
Replied by NuovaFolati on topic </br> tag in CSV file
I send you a jpg file because CSV file is not allowed, tell me if there is another method to send you CSV file.
Attachments:

More
11 months 2 weeks ago #9942 by Administrator IV
Replied by Administrator IV on topic </br> tag in CSV file
Hello NuovaFolati,

the image shows the export file opened in Excel.
How Excel displays a CSV file exactly depends on the configuration in Excel for the specific CSV file.
This usually happens when you open the file in Excel.
However, it is also possible to change the settings in Excel for the file that has already been opened.
Excel does not show what the export file looks like exactly, but rather how Excel interprets the export file.

But first we're talking about the original text file in CSV format, as generated by Visforms' CSV export.
To do this, you have to open the export file in a text editor and look at the lines.

There are now 2 alternative options for you.

1. Open the export file in a simple text editor.
Copy some example lines from the file.
Simply paste the text directly into your post.

2. Upload the export file to your web server so that it can be opened in a browser with a direct link.
Copy the link to the file into your post.

Kind regards, Ingmar

: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 :-).

More
11 months 2 weeks ago - 11 months 2 weeks ago #9943 by Administrator IV
Replied by Administrator IV on topic </br> tag in CSV file
Hello NuovaFolati,

Here is the content of a just exported CSV file with the selected data separator 'Semicolon':
Code:
text-1;number-1;checkboxgroup-1;checkboxgroup-2 one selected;10;value1;value1 two selected;11;value1, value2;value1, value2 three selected;12;value1, value2, value3;value1, value2, value3


The specific data separator can be set:
Form configuration, tab 'Separator', options 'Comma' and 'Semicolon'.

The field names are separated by semicolons in the first line.
Then come the data lines, in which the data is separated by semicolons.
There are 4 fields included with the following types in the following order:
- Number,
- text,
- first checkbox group,
- second checkbox group.

The selected options of a checkbox group are separated by commas:
Code:
value1, value2, value3


Data separator 'Semicolon' is best suited for importing into Excel.
Without making any further changes to the configuration in Excel, the file above opens as follows:
vi-solutions.de/forum-uploads/csv-export_excel-view.png

HTML-tags, especially a br-tag, are not involved here.
However, HTML-tags can certainly appear in the field data.

Kind regards, Ingmar

: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 :-).
Last edit: 11 months 2 weeks ago by Administrator IV.

More
11 months 2 weeks ago - 11 months 2 weeks ago #9944 by NuovaFolati
Replied by NuovaFolati on topic </br> tag in CSV file
sorry, see my next message
Last edit: 11 months 2 weeks ago by NuovaFolati.

Moderators: Administrator AVAdministrator IV
Powered by Kunena Forum