Results 1 to 12 of 12

Thread: Form data into excel
      
   

  1. #1
    Join Date
    Jul 2009
    Posts
    69

    Default Form data into excel

    Hi,

    I seted up a form which acts like a survey.
    Is there a way to get the results (by field) in Excel instead of the mail?

    Thanks
    Ophir

  2. #2
    Join Date
    Oct 2005
    Location
    Italy
    Posts
    12,080

    Default Re: Form data into excel

    Yes, set the built in form processor to store the data in a csv file, and then you can download this CSV directly from your site. Please note that the entire file (all submissions) will be downloaded each time.
    Navaldesign
    Logger Lite: Low Cost, Customizable, multifeatured Login script
    Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
    DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
    Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!


  3. #3
    Join Date
    Jul 2009
    Posts
    69

    Default Re: Form data into excel

    Thanks.
    Do i have to check out the box
    "Use built-in PHP..."

    When i do that the succses and error URL turns off.

    Also - what do you mean when you say:
    " Please note that the entire file (all submissions) will be downloaded each time."


    Thanks
    Ophir

  4. #4
    Join Date
    Oct 2005
    Location
    Italy
    Posts
    12,080

    Default Re: Form data into excel

    Are you using the built in form processor ? or some other processor ?
    My instructions above were based on the assumption that you were already using the built in form processor.

    If you are using something else, then you should ask whoever provided that processor to you, to tell you how you can save (store) the data in a CSV file.

    " Please note that the entire file (all submissions) will be downloaded each time."

    This means that each form submission will be added in the CSV file. So when you download the file you will have, as content, all the data that has been submitted, not only the data of the last submission.
    Navaldesign
    Logger Lite: Low Cost, Customizable, multifeatured Login script
    Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
    DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
    Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!


  5. #5
    Join Date
    Jul 2009
    Posts
    69

    Default Re: Form data into excel

    OK - i see.
    I am using the built-in form processor.

    Thank you very much
    Ophir

  6. #6
    Join Date
    Jul 2009
    Posts
    69

    Default Re: Form data into excel

    Hi,
    I did set up a form but after i fill it i only get the last 4 fields in the mail.

    http://www.icanpiano.net/Survey1.php

    This is what i get in the mail:
    "
    Values submitted from web site form:
    Button1 : Submit
    Name : e
    Email : piano@icanpiano.net
    Age : Under 18
    Years Of Playing : 1 - 3 years
    "

    Am i missing something?

    Thanks
    Ophir

  7. #7
    Join Date
    Oct 2005
    Location
    Italy
    Posts
    12,080

    Default Re: Form data into excel

    The fields that you don't recieve are outside the form boundaries.

    Stretch the form as required to cover all fields.
    Move EACH field a couple of pixels until you see the form border become highlighted, which will indicate that the field has become part of the form.
    Repeat for all fields.
    Rename the Submit button to have the name "Submit" instead of "Button1".
    Save, Publish, Refresh your browser before testing.
    Navaldesign
    Logger Lite: Low Cost, Customizable, multifeatured Login script
    Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
    DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
    Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!


  8. #8
    Join Date
    Jul 2009
    Posts
    69

    Default Re: Form data into excel

    All fields are working now and I get the data to my mail.

    When I tic the 'write from data to a .csv file' the success
    page fail to upload.

    The csv. file stays empty.

    ?

    Thanks
    Ophir
    When

  9. #9
    Join Date
    Oct 2005
    Location
    Italy
    Posts
    12,080

    Default Re: Form data into excel

    Did you create the file ?
    Did you provide the correct path to the file in the form properties ?
    Navaldesign
    Logger Lite: Low Cost, Customizable, multifeatured Login script
    Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
    DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
    Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!


  10. #10
    Join Date
    Jul 2009
    Posts
    69

    Default Re: Form data into excel

    I created the file.
    I put it in public_html directory.
    so the path i use is:
    http://www.icanpiano.net/Survey1.csv

    Is that corect?

    Ophir

  11. #11
    Join Date
    Oct 2005
    Location
    Italy
    Posts
    12,080

    Default Re: Form data into excel

    Since both the form and the file are in public_html, the file in the form properties should be simply "Survey1.csv" without the http://www.icanoiano.net part
    Navaldesign
    Logger Lite: Low Cost, Customizable, multifeatured Login script
    Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
    DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
    Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!


  12. #12
    Join Date
    Jul 2009
    Posts
    69

    Default Re: Form data into excel

    Thank you.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •