Announcement

Collapse
No announcement yet.

Getting form-submitted data into .csv (or similar) file

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    Getting form-submitted data into .csv (or similar) file

    Hi Naval (or whoever) . . . Having a slight problem with the Form Wizard: I've been using the "Contact 1" template to create a simple name-and-email capture form. It works fine in terms of sending the submitted info to the email address I give it and re-directing the user to the page I want after he/she submits.

    But I also want the form data to be copied to a .csv file in cPanel. So in BV, I click the form, Form Properties opens, and I tick the box beside "Write form data to a .csv file" and I follow the prompts to create the .csv in the directory where I want it. After doing this, I see the correctly named .csv in that folder in cPanel and re-publish the page with the form on it.

    Then, when I try using thru the form, I get an error page saying:
    Warning: fopen(./public_html/testdata.csv) [function.fopen]: failed to open stream: No such file or directory in /home/vtrsgwu/public_html/resources.php on line 16
    can't open file

    After getting this message, I go into cPanel, open the .csv, the data (just name and e-mail address) I entered is NOT in it. Worse, I find the data also hasn't been e-mailed to me (but data was e-mailed to me before I ticked "Write form data to a .csv file" and re-published).

    I'm guessing there's (fairly) simple solution to this, just wondering if you or anyone can confirm what it is. THANK YOU.
    Tags: None
  • #2
    Re: Getting form-submitted data into .csv (or similar) file

    The csv file must be in the same folder as the form.

    Pls try and post back.
    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!

    Comment

    • #3
      Re: Getting form-submitted data into .csv (or similar) file

      Thank you, Naval, for your prompt reply. I've confirmed that both the .csv and page containing the form are in the root directory (public_html) of my BV site. Here's the page:
      404 Not Found | Web Design & Copywriting for Service firms: JH Web Marketing
      http://www.jhwm.net/resources.php


      In the BV page file, when I double-click the form, are there any restrictions on what can types of data can go in the "Form Name" field? It currently has all alpha characters and one punctuation mark (a colon :). Hoping you have another suggestion for me . . . thanks.

      Comment

      • #4
        Re: Getting form-submitted data into .csv (or similar) file

        Hi, just checking in on this thread, hoping a moderator can help me figure out why, even though I have the csv file in the same folder as the form on this page, data submitted thru the form is not being captured in the csv AND is not being e-mailed to the address specified in the form properties. THANK YOU.

        Comment

        • #5
          Re: Getting form-submitted data into .csv (or similar) file

          The form name should only contain letters and underscores (no white spaces). However this will only affect the built in Validation Javascript, not the form funtionality.

          I'm sorry, since these are errors that we can NOT see just by looking at the form, one would need to enter your account to find out why it doesn't work for you.
          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!

          Comment

          • #6
            Re: Getting form-submitted data into .csv (or similar) file

            Good news, I figured out the TWO things I had wrong in the form:

            1) As you said, the form name has to be a continuous string of characters (had spaces before)
            2) In Form Properties, the "Filename" field must contain ONLY the name of the .csv file (until today, I'd had "public_html/testdata.csv" in that field).

            Now that I've made those two changes, when I test the form:

            - I'm re-directed to the correct thank you page (no error message comes up)
            - The info entered in the form is e-mailed to the correct address
            - The info entered in the form is captured in the testdata.csv file which I can download via cPanel

            All of which makes me HAPPY.

            Thanks for your help, Naval!

            Comment

            • #7
              Re: Getting form-submitted data into .csv (or similar) file

              Hello Naval, would you be able to help me with my .csv form related problem?

              When you download the .csv the first column on the spreadsheet displays the date and time which is great for the application that i will be using it in. However, the time is displayed 6 hours behind the UK time - How can I get the time to show GMT?

              Appreciate your input

              Comment

              • #8
                Re: Getting form-submitted data into .csv (or similar) file

                You will have to trick the code, as the built in form processor doesn't allow adding any code.

                In the Form Properties, in the "Subject" field, type this code:

                Website form';date_default_timezone_set("Europe/London");$a='

                You MUST include the single quotes.
                You can replace the standard Subject Website Form with whatever you need (but NO quotes please)
                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!

                Comment

                • #9
                  Re: Getting form-submitted data into .csv (or similar) file

                  One word... Genius!

                  Thank you, you've solved my problem

                  Comment

                  Previous template Next

                  Find your perfect domain name

                  Working...
                  X