I mean one field for one excel input.
When I go to the administration page and look at form data, I see a table where each form entry is a row, and each entry’s field is in its own cell. When I export to Excel, I get the same table. Is that not what you get? Do I not understand? I’m not sure what you mean by “excel input”.
It’s exactly what I mean. When I export to excel, I don’t get the same table of the admin page. All the entries’s field are in the same cell, not in their own cell. It looks like this: |”name”,”subject”,”email”,”field1″,”field2″|
and I would like this:
|name|subject|email|field1|field2|
How can I do to export to have the same table of the admin page ?
For excel input, I meant excel entry, sorry for my english.
Thanks a lot for your help.
Try opening Excel and creating a new spreadsheet. Then import the exported .csv file into it. If asked about delimiters, indicate the delimiter is “,”
Goodmorning,
I tried to import the file but I did’nt find how to do.
I think it will be better to force the right export format (one field for one spreadsheet cell). How can I edit the code to force it ?
thanks for your help.
Julien.
You can find a example for the export at this adress:
“http://kurzumdesign.free.fr/data_reporting.csv“
thanks again.
Hi,
I’ve got another question.
How to select data from Contact Form DB like
from “March, the 14th” to “March, the 29th” using
a generated export link ?
Thanks.
Use the short code builder page, which builds both short codes and export links. Filter on submit_time. See http://cfdbplugin.com/?page_id=553
e.g.
[cfdb-table form="Contact form" filter="submit_time>2013-03-14&&submit_time<2013-03-29"]
Ok, it works well.
About the previous question, there is no way
to edit the code and have the same as the admin page
without converting the exported excel file ?
Thanks a lot.
Julien.
I don’t follow what you mean exactly.
Goodmornrning.
Sorry to be vague.
I mean what I said the first time:
“It looks like this:
|”name”,”subject”,”email”,”field1″,”field2″|
and I would like this:
|name|subject|email|field1|field2|”
Instead of specify manually in the csv file, the delimiter is “,”:
Which file do I edit (Which file to add lines in the code) in the plugin files to force it directly ?
Thanks again.
Julien
I downloaded your example file. When I double-click it, Excel opens and it shows data in 4 columns as expected. I think this an Excel issue.
ok :/
Thanks you for helping me for all of this.
Have a nice day.
Julien.
