mediacritical
Member
Hi Eugenio,
I have a table "events". Inside of this table there is one field "participants". In my form this field allows me to assign multiple participants that come from a different table "participants". In the database this results in multiple entries divided by the "~"-character. In the Dadabik-table-view the first name and name are shown without a divider thanks to defining a lookup table for the values.
When I now export the table "events" I get a mixed up Excel sheet (I enabled the excel-export ($export_to_csv_feature = 1) because the multiple "participants"-values of a single event aren't obviously properly divided from another. Everey participant of an event creates a seperate line in the Excel file and is not put into a single field together with the other participants for that single event.
I also tried to export as native .csv ($export_to_csv_feature = 0 but the problem remains.
How can I achieve it to get a proper Excel-formatting of multiple values in one cell?
Thanks in advance!
Best wishes
Andreas
You are using DaDaBIK version 8.1-Lerici enterprise, installed on 11-12-2017 (installation code: 124685910a21b35192), the latest version of DaDaBIK is 8.2-Lerici released on 12-19-2017
You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.
PHP Version: 7.0.25
mysql version: 5.7.20
Web server: Apache/2.4.29 (Unix) PHP/7.0.25
Client: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:59.0) Gecko/20100101 Firefox/59.0
I have a table "events". Inside of this table there is one field "participants". In my form this field allows me to assign multiple participants that come from a different table "participants". In the database this results in multiple entries divided by the "~"-character. In the Dadabik-table-view the first name and name are shown without a divider thanks to defining a lookup table for the values.
When I now export the table "events" I get a mixed up Excel sheet (I enabled the excel-export ($export_to_csv_feature = 1) because the multiple "participants"-values of a single event aren't obviously properly divided from another. Everey participant of an event creates a seperate line in the Excel file and is not put into a single field together with the other participants for that single event.
I also tried to export as native .csv ($export_to_csv_feature = 0 but the problem remains.
How can I achieve it to get a proper Excel-formatting of multiple values in one cell?
Thanks in advance!
Best wishes
Andreas
You are using DaDaBIK version 8.1-Lerici enterprise, installed on 11-12-2017 (installation code: 124685910a21b35192), the latest version of DaDaBIK is 8.2-Lerici released on 12-19-2017
You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.
PHP Version: 7.0.25
mysql version: 5.7.20
Web server: Apache/2.4.29 (Unix) PHP/7.0.25
Client: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:59.0) Gecko/20100101 Firefox/59.0