Kathy Horan wrote:
...When I put in the path for the csv data file that is created by WFB, i get a pop up asking if I want to open the file. It is excel, looks great, and is the ongoing update of the form submissions. My clients and everyone else that tries this, gets a raw data file, not a good tool for what they need.
......
You can save the raw csv to excel, can be read, but has a lot of extra html across the page. The one I open from the path, looks great.
.....
I tried with a published form of my own in four different browsers and the .csv file consistently downloads and opens nicely in Excel. The only difference between browsers is that, while Firefox, Opera and IE9 pops up the question about which program (default: Excel) to open with, Chrome simply downloads the .csv file without automatically opening it.
Since it is only a question of a simple download of a .csv file, which is a well-defined entity, I don't quite understand what you mean when you say that others get a "raw data file" and that it has "a lot of html across the page". This implies that they are downloading the wrong file of the wrong type.
The .csv file does not contain any html, so I don't know where that could possibly come from.
The default path to the .csv file is:
www.[domain.com]/[form-name]/storage/csv/form-results.csv
Does the path you give to your client and others look like that - complete with the .csv file extension?