XLS Export in СF6

Hello!

In CF5 there is XLS Export and there are Data Path, Fields list, Headers list

Where the fields are in СF6?

Thank you

Hi Maxvl,

v6 is different, you need the data provider added correctly, how do you get your data ?

Best regards,
Max

Hi Max

Data from the form is stored in the database.

How to export and where to specify Data Path, Fields list, Headers list?

Best regards,
Maxvl

Hi Maxvl,

There is a default export if the table is connected to the form, check it under the connected tables list.

Otherwise you need to read the table data using a "Read data" action then pass the data returned (using the {var:read_data}) to the data provider of the CSV action in correct format (there are some topics on this here)

The CSV action has a headers setting, but all the fields available in the data provider are going to be listed, let me know if you need to list specific fields only.

Best regards,
Max

I'm attaching a demo csv download form reading the Joomla content table!

Best regards,
Max

Hello, Max!

Thanks for Demo;)

I would like to save the file on the server in the Images folder
How to set the correct path to the folder in Storage path?

In the field Titles pointed out in the format P1:Phone1,P2:Phone2
How to restrict the export of fields and indicate their names?

Best regards,
Maxvl

Hi Maxvl,

How to set the correct path to the folder in Storage path?

Please try:

{path:root}/images/csv.csv

The headers should be in multiline format:

P1:Phone1
P2:Phone2

Assuming you have keys P1 and P2 in the data list

Best regards,
Max

Hello Max!

Thank you. Stuck on another (:

How do I change the sequence of columns in a csv file?

In the database, the sequence of columns is one and in the file is different.


Where to put the CSV block so that the result is not at the top of the page. See screenshot


Can I save data in xls format?

Best regards,
Maxvl

Hi Maxvl,

The CSV is set to download ? if yes then it will stop any actions after it!

Hi Max,

The CSV is set to download and stop any actions after it.
The result is not at the top of the page. Why?

Hi Maxvl,

If you have any kind of file download action then no output will be displayed on the page!

Best regards

Hi Maxvl,

If you want to show a message then you can save the CSV file to your server and include a download link in your messagfe.

Bob

Hi Bob

Thank you. Tell me how to save data in xls file?

HI, Bob

Thanks for the answer

In СF5 it was possible to save in xls

Hi,

I think this may be added in a future update, it was not requested before.

Best regards

Hello,

Chronoforms v6 is an awesome tool!

I am trying to export data that are saved from a form into a table to a csv/xls file, but the exported file is empty.

Following the advice written above, in the Load area, I have used a ReadData action with model name Data1. I am returning all matching records without any criteria. I also print all matching records (in a Display action) with custom html code and a Loop action.

In the form there is a checkboxes field named "answers", so I used "answers/json" in the Special Fields of the ReadData action.

I have a submit button in order the file to start downloading thus, in the Submit area, I have placed the CSV action with:
Data provider: {var:read_data1}
Action: Download
Delimeter: ,
filename: csv1.csv
and Titles:
aid.ID
firstname:FirstName
lastname:LastName
answers: Answers

The only export I get is a csv file with Titles but no data (table records).

Could you please send me any advice.

Best regards,