terminal42 / contao-leads

Leads extension for Contao Open Source CMS; Store and manage form data with ease!
GNU Lesser General Public License v3.0
35 stars 24 forks source link

Multiple Checkbox Value displayed as serialized string in Export #147

Closed LBeckX closed 4 months ago

LBeckX commented 1 year ago

Hi together, The checkbox menu gives me the data in the export as a serialized array. Is there a way to output the values as a simple list? Thanks in advance

Konfiguration:

image

fritzmg commented 1 year ago

Each lead is one row in the export, one column for each field. Thus multiple values need to be serialised.

LBeckX commented 1 year ago

Thank you for the quick answer. Is there a simple way to modify the output or register a new value parser like "Rohdaten", "Ja/Nein", "Email", "Datum/Zeit", etc.?

aschempp commented 1 year ago

they are not supposed to be serialized… can you show an example of your config? The field setup in the form generator as well as what leads saved?

LBeckX commented 1 year ago

This always happens when we have a checkbox menu.

Form field config: image

Form: image

Export configuration: image

Saved values and labels image

aschempp commented 1 year ago

that last screenshot is from the database, right? Do you also get that in an Excel export?

chromagnon commented 1 year ago
Bildschirmfoto 2023-10-10 um 22 36 34

I have the same issue. Checkboxgroups, wether with one or multiple options checked, are exported in serialized form, as raw data, because thats the form how they are saved in the database. The target of the export doesn'z matter, csv, excel, pdf, its always in serialized form.

contaoacademy commented 9 months ago

I can confirm the problem.

Total-Reality commented 5 months ago

I can also confirm the problem. It appears in version 3.0.4. The export was correct in version 1.4.33.

SpeGal commented 4 months ago

In the backend the stored array is showen correctly as e.g. "Samstag, Sonntag" if you click on the "data" button at the end of the line. But at the export it showes in the Excel table: a:2:{i:0;s:7:"Samstag";i:1;s:7:"Sonntag";}

It used to be formated correctly at the export. There must be a bug in the programming somewhere.

aschempp commented 4 months ago

Fixed in 5a7b9fedc6f2e36391d831b1e04a36cfd48f8713