Saving Data to CSV? - Post ID 213058

User 207904 Photo


Registered User
6 posts

How do I get the save data to CSV to work on a "manual" server?

I tested on one and the form would throw errors about not having permissions.

I tested on another and am not seeing any errors, nor a CSV file anywhere.

The box is checked in form settings, and a file name has been provided. Just not seeing any results of this option - nor am I sure where I should be looking.

Do I need to create the file and assign permissions? Anything else I need to do to make this work?
User 103173 Photo


VP of Software Development
0 posts

What is going on here is your permissions on your sever are incorrect. Over FTP, locate the storage folder and change the permissions to 755 for that folder and all folders under it.
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
User 207904 Photo


Registered User
6 posts

That was it - all questions answered. Thanks.
User 2342626 Photo


Registered User
11 posts

If you make your form work with .CSV file, how does my client retrieve the information from the form I made on there site? I bought this program to setup forms but I can't afford $24.95 /month for mre than 25 forms and I need the client to retrieve the info for their form only not every form I creted in S-Drive. I use a GoDaddy linux server, can someone explain what exactly I should be doing here? I'm lost at this point.
User 103173 Photo


VP of Software Development
0 posts

Steven Love wrote:
If you make your form work with .CSV file, how does my client retrieve the information from the form I made on there site? I bought this program to setup forms but I can't afford $24.95 /month for mre than 25 forms and I need the client to retrieve the info for their form only not every form I creted in S-Drive. I use a GoDaddy linux server, can someone explain what exactly I should be doing here? I'm lost at this point.

You would have to provide them with FTP access to your server to access the CSV file or you could just email it to them weekly/daily etc..
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
User 2176928 Photo


Registered User
21 posts

Could this be done with htaccess, so that a hyperlink & password would allow download?

I've just tried using code from the coffeecup htaccess pdf guide, but I can't get it to work...
J
User 115146 Photo


Registered User
3 posts

Is there an easy way to integrate a csv file into an html page? I want to present data collected from a web form directly on a Web page. Embeded code? How?
User 187934 Photo


Senior Advisor
20,271 posts
Online Now

You need to use a little php to sparse the file. I use mysql myself but Prism is our resident expert on csv to php. He may chime in here at some time but until then this should get you started.
<?PHP

$file_handle = fopen("form-results.csv", "r");

while (!feof($file_handle) ) {

$line_of_text = fgetcsv($file_handle, 1024);

print $line_of_text[0] . $line_of_text[1]. $line_of_text[2] . "<BR>";

}

fclose($file_handle);

?>
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 115146 Photo


Registered User
3 posts

Ok, ... but could you guide me to where I put the code?
User 187934 Photo


Senior Advisor
20,271 posts
Online Now

With my example the code would be on a php page and be in the same directory as the form-results.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.