What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    MySql Export App only downloads as one file

    Asked by AA_C on October 18, 2014 at 10:37 AM

    Hi,

    Earlier I used your MySQL Export application and downloaded a file successfully. I tried it again as I hand a field name error so I renamed the field in the app. and tried to down load it again and it wouldn't download. So I tried another form, checked the field names and tried to download it and it won't download.

    It appears it will only let me down load one file, why is that? Do I have to buy this app or am I doing something wrong?

    The forms I tried to download are;

    Dog ID Registration Form, formID=33504157430850

    Club Membership Registration Form, formID=33435415238250

     

    Thank you,

    Robert

    app registration form name another form
  • Profile Image
    JotForm Support

    Answered by KadeJM on October 18, 2014 at 03:16 PM

    If I understand you correctly our MySQL Export App is giving you issues when you attempt to download files, correct? 

    I did a separate test of this and it appears to be working normally as it should.I did the same with three tests from your jotform and it was the same result.

    I've cleared your jotforms caches, can you please try it again and let us know if you're still having problems with it or not?

  • Profile Image
    JotForm Support

    Answered by KadeJM on October 18, 2014 at 03:17 PM

    I meant to additionally explain it should pull all of your received submission data. If you look in the notepad preview above of the .SQL File I had opened it shows 3 test submissions which appear normal.

  • Profile Image

    Answered by AA_C on October 19, 2014 at 11:44 AM

    Hi,

    Thanks for the reply.

    I tried it again and after following the steps and clicking on download nothing happens.

    I keep trying download and nothing, is it processing all the data first and this takes a bit of time, if so how will I know when it is done?

    Also, after I add the application where do I find it to use again. Currently I'm going back to plugins, apps and adding it every time I want to use it. I don't see it in my widgets list or anywhere else.

    Also after I have created the table(s) and it is (they are) populated with current data how do I update the table(s) data, do I run the app every time or do I create a php file with the code that generates this table and it updates new entry's ? Hope I'm clear on this point.

    Robert

  • Profile Image
    JotForm Support

    Answered by EltonCris on October 19, 2014 at 02:48 PM

    Hi Robert,

    Thanks for your reply.

    I have also tried it my self and it seems working just fine. When you press the download button, it should automatically download the compressed sql file (.zip) like the following.

    May I suggest to try clearing your browser's cache and check it again. You can also try it with different browsers. If none of these helps, would you be so kind to help us track the error? Here's what you need to do,

    1. Open your browser console

    2. Try to export an sql file again. If it failed, check if there are errors shown in the console.

    3. Paste the error here so we can forward it to our developers.

    We'll await your reply. Thanks!

    P.S. You can actually bookmark this app URL http://mysqldump.jotform.io/ so you can quickly open it from your bookmark bar.

    ----

    Your question about the PHP thing will be answered on a separate thread. Thanks!

  • Profile Image

    Answered by AA_C on October 19, 2014 at 10:31 PM

    Hi,

    Thank you for your help. I have tried everything you have suggested.

       1. Chrome, reset and cleared all history and cache. It still won't download new sql.zip file.

       2. IE 11, reset and cleared cache. When I try using the app it keeps asking me to Authenticate, when I do it indicates authentication successful and then asks me to Authenticate again and again, as if I'm not even logged into JotForm.

       3.  Netscape, The first time I tried it the sql.zip downloaded. I then was able to upload the sql file to my db and it worked just fine.  I tried it again and nothing happens when I click the download button just like when using Chrome. I reset the browser cache and still the new file will not download. 

    I don't see any error messages.

     I don't understand why its works for you and not me.

    Any further help is appreciated.

    TNX

    Robert

     

  • Profile Image
    JotForm Support

    Answered by ashwin_d on October 19, 2014 at 11:58 PM

    Hello Robert,

    That is strange.

    I also tested the "MySQL Export" app and I am unable to replicate the issue you are having. I was able to download the MySQL zip file multiple times without any issue. 

    Can you please confirm which operating system you are using? If would like to replicate the issue here and then send it to our back end team. 

    We will wait for your response.

    Thank you!

  • Profile Image

    Answered by AA_C on October 20, 2014 at 04:45 AM

    Hi,

    My OS is Win.8.1

    It lets me download one file and nothing after that even if I pick a different form.

    I Will try this on my Win.7 PC and Mac and let you know how that works.

    Have you tried renaming any of the column names before downloading?  Perhaps that may be the problem or not???? 

    Don't you just love a mystery?

  • Profile Image

    Answered by AA_C on October 20, 2014 at 06:07 AM

    OK,

    I tried this on a iPad and a Win 7 PC and I get exactly the same problems.

    One thing I have seen is that no matter which computer I use my Column Names are the new ones I used. I also noted no matter which data base export application I use the columns retain the new names, applications like;

    MS Sql Server Export

    SQL Lite Export

    Maria DB Export

     and none will download the files when I click on 'Download'

    The only app I can reuse is; 'Combine Submissions', it works every time.

    Please feel free to use my forms and their data to test this out.

    Regards,

    Robert

  • Profile Image
    JotForm Support

    Answered by ashwin_d on October 20, 2014 at 07:44 AM

    Hello Robert,

    Thank you for the additional details.

    Yes I did test it after changing the columns names and I was able to download the SQL file more than once.

    Let me report it to our back end team and they will be able to troubleshoot this issue. We will get back to you as soon we have any update form them. I would also suggest you to please send us the changed column names of your form #33504157430850 and #33435415238250 and we will take a look if that is causing this issue.

    Thank you!

  • Profile Image

    Answered by AA_C on October 20, 2014 at 09:01 AM

    Hi and thank you,

    Here is a list of column names for #33504157430850

     Name = OwnerName

    AAC Membership Number = AACNum

    Country = Country

    Address = Address

    City = City

    Province = Prov

    Postal Code = PC

    State = State

    ZIP Code = ZIP

    Phone Number = PhNum

    Cell Number = CellNum

    E-mail = Email

    Breed = Breed

    Dog's Birth Date = Dog_DOB

    Dog's Call Name = CallName

    Registered name = RegName

    Select One = Selected

    Dog ID No. = DogIDNum

     

    The Column names for the equivalent French form #33516475949265 are changed to match the above.

    The form #33435415238250 has no data at this time so is not a requirement right now. We use another form at our site for this using ASP.net . I want to use the new #33435415238250  at some point once I can get the php code working properly so lets not worry about it. there are two other forms that I want to get this app to work with also; #41196977333969 and #41902989566975.

    Here are the names for #41196977333969

    Confirm                                                 NoIncident

     

    The French equivalent form#33435415238250 columns have new names to match these ones.

     

    Again thank you for your help.

    Regards,

    Robert

  • Profile Image
    JotForm Support

    Answered by ashwin_d on October 20, 2014 at 09:33 AM

    Hello Robert,

    Thank you for the details.

    I have already reported it to our back end team. I will also try to download the SQL file on your cloned form with the above column names and see if I am able to replicate the issue.

    We will get back to you as soon as we have any update on this.

     

    Thank you!

  • Profile Image

    Answered by AA_C on October 21, 2014 at 09:06 PM

    Hi,

    I believe I have resolved the problem.

    I did a right click on the download button and clicked reload. I was then able to download a file and select another and download it right away.

    Please don't spend anymore time on this and thank you for your help. 

    Best regards to the JotForm Team,

    Robert

    AAC

  • Profile Image
    JotForm Support

    Answered by ashwin_d on October 22, 2014 at 12:04 AM

    Hello Robert,

    I am glad to know that you are able to download the files now.

    Do get back to us if you have any questions.

    Thank you!