Export to csv in Connectivity6

martinmarcos 23 Feb, 2017
I'm trying to export a table (where i have data from a chronoform) to csv but a i can't.
i've done a read data function ("read_regs"), it Works ok beacuse i've used it with a table view and everything was right. But when i used with the csv function i have problems
In the csv i put {var:rear_regs} in the data provider and when i execute the function the file has this information:
regs
Array
Array
Array
..
if i put {var:rear_regs.0} or {var:rear_regs.1}.. i get the information for each register but i need all the info in one csv.
I'm sure its a silly thing i cant see, can anyone help me please?
Max_admin 23 Feb, 2017
Answer
1 Likes
Hi Martin,

You will need to use this in the data provide field:
{var:read_regs.[n].Model_name}


Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
ataylor14 05 May, 2017
Hello Max
Sorry to crash in this post... It helped me so thank you for the one posting this question and for your answer.

I was wondering what is the reason for having [n] in the data provider field?

Thank you
Amelia
Max_admin 05 May, 2017
Hi Amelia,

To get the correct structure of data required by the "csv" action, the read data returns a complex structure, but the csv expects a numerically indexed array of data sets.

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.

VPS & Email Hosting 20% discount
hostinger