export to csv bug

[Firekenny]

Your current DaDaBIK version
You are using DaDaBIK version 10.1-Manarola enterprise, installed on 06-24-2020 (installation code: 156665ef2fb5c0ef4a), the latest version of DaDaBIK is 10.1-Manarola released on 03-09-2020

You are runnning the last release of DaDaBIK

In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enteprise to Platinum) please contact us.

System info
PHP Version: 7.1.33

mysql version: 10.2.31-MariaDB-cll-lve

Web server: Apache

Client: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.61 Safari/537.36


_______________________________________________________

I have a database with around 3100 rows. When exporting directly from my PHPMYADMIN portal, all rows are correctly exported, but when i export the same within Dadabik some rows do not get properly exported (i have some data missing in some columns).
Anything I am doing wrong?
As a note, when csv opens with Excel, I need to transform "text to column" and even thought i am only selecting the first column, when proceeding i have an alert saying "there's already data here, do you want to replace it?".
I dont have the same when transforming data from the CSV exported file from PHPMYADMIN, only with the one from Dadabik.

 

[eugenio]

Hello,
can you open the csv file with a text editor and tell me what you see for a specific missing field and what you expected to see.
It's also important to know field type and formatting rules you implemented (if any).

Best,

 

[Firekenny]

Hi Eugenio,
Thanks for your feedback. When i open the csv file under Excel, i noticed that instead of having all data in the first column with separator (for me its a semi-column), some rows have the data split between the first and the second column, this is why i get the error message when trying to proceed with "text-to-column".
When digging further, the issue happens only for some data entry where the field content description has a "," (comma) so Excel seems to consider this as a separator although i am clearly asking to use semi-column as separator when proceeding with the "text-to-column" function.
Within Dadabik, the relevant field format in the form configurator is "TEXT" and the table field format in SQL is also "TEXT".
I need to ensure i can keep using the "," sign for description as it pertains to medical supplies (such as Hydroalcoolic gel 1,5L)
Any idea how to fix this?

Thanks,

Patrick