Buy Now
Sign in

XLS Export in СF6

Maxvl , August 23 at 19:15
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!

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!

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)
21 Downloads/Views

Max
If your main question got answered then please mark the answer using the button!

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!

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)
77 Downloads/Views
2017-09-29_134125.jpg
2017-09-29_134125.jpg
(141.21 KiB)
76 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!

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)
18 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!

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