Buy Now
Sign in

XLS Export in СF6

Maxvl , August 23 2017
Answered
M
Maxvl
Hello!

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

Where the fields are in СF6?

Thank you
admin
Hi Maxvl,

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

Best regards,
Max
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
M
Maxvl
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
admin
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
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
admin
I'm attaching a demo csv download form reading the Joomla content table!

Best regards,
Max
Attachments
demo_csv_27_Sep_2017_10-25-54.cf6bak
(1.97 KiB)
56 Downloads/Views
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
M
Maxvl
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
admin
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
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
M
Maxvl
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
Attachments
2017-09-29_134029.jpg
2017-09-29_134029.jpg
(57.08 KiB)
207 Downloads/Views
2017-09-29_134125.jpg
2017-09-29_134125.jpg
(141.21 KiB)
233 Downloads/Views
admin
Hi Maxvl,

The CSV is set to download ? if yes then it will stop any actions after it!
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
M
Maxvl
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?
Attachments
2017-10-16_211357.pdf
(76.53 KiB)
37 Downloads/Views
admin
Hi Maxvl,

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

Best regards
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
M
Maxvl
Hi Bob

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

I have no idea but you can import a CSV file into Excel very easily.

Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
M
Maxvl
HI, Bob

Thanks for the answer

In СF5 it was possible to save in xls
admin
Hi,

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

Best regards
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!