export to CSV, multiple rows for each form entry?

i had just installed chronoforms and i'm loving it! thank you to all the developers of this great component.

i have a question about the "export to CSV" feature. is it possible for a single form submission to enter data into multiple rows of the excel spreadsheet rather than just a single row?

i'm thinking of creating a registration form for an event where there are 5 members per team and i would like the form values for each member to occupy a single row of the spreadsheet, can it be done?

thanks in advance for your help 🙂

Hi Harrychia,

Yes, but not using the automatic feature in the toolbar. You can adapt that code to write your own exporter to present the data differently. Or you could write code to save each member to their own database record.

I think that i posted the code for something similar in the forums here a few months ago.

Bob

thanks for the prompt response🙂

may i know in which file can the relevant code be found? is it in the "excelwriter" folder of the component? there are several files and subfolders in it and i'm not sure where to start. i'm really bad in programming... 😶

after editing the code, when i use the automatic export button in the toolbar, the csv files will be rendered differently right? thanks.

Hi harrychia,

No, don't change the code in the ExcelWriter module, or the ChronoForms code at all. I'd create a separate little form to do the backup - that way all the ChronoForms core code remains unchange. The code to copy to start with is in the BackupCSV and/or BackupExcel functions in admin.chronocontact.php

This is not difficult to write - but if you are a non-coder it could be quite a challenge. You might be better finding someone to do it for you.

Bob

Hi,

there is a sticky post in the "HOW TO" forums posted by me which has a similar code!

Cheers
Max