Jotform Application - Upgrade & Database Questions

  • Profile Image
    rrobertsgreencircle
    Asked on March 29, 2011 at 08:16 PM

    Questions about Jotform Applicaiton / Upgrade & Database

    1. If we upgrade from Premium Account to the Application 100 / $450 install will I have to recreate all my existing forms & data? Or can it be moved into the new location?

    2 We have web hosting with Go Daddy and have php / mysql etc. Is there any known issues with installing @ Godaddy?

    3. If I upgrade to the 100 / $450 account and find that I need to upgrade again to the 1000 / $950 is there an upgrade / trade up value?

    4. I have a XML content feed that I want to parse into the database. Is this possible? (Not a techie so I hope I asked this one correctly)

    5. Does each Jotform create its own table within the database?

    6. Is it possible (with programming) to use one table created by Jotform to validate another Jotform.

    Example:

    A user registers their email, name, etc. and then later we want them to be able to upload a contest photo but only if the email address has been registered before. With the application version and control of the data – I am hoping  we validate the data in one table against the form and then allow the new form to be executed?

    7. Does the 100 (or 1000) represent the number of unique users that can create their own forms? Basically becoming a Premium account under our Private Label Application?

    Thanks.

    -R

  • Profile Image
    liyam
    Answered on March 30, 2011 at 03:27 AM

    Hello,

    I will submit your inquiries to the better person to handle this.

    Thank you for your patience.

  • Profile Image
    aytekin
    Answered on March 30, 2011 at 11:38 PM

    1. If we upgrade from Premium Account to the Application 100 / $450 install will I have to recreate all my existing forms & data? Or can it be moved into the new location?

    Yes, it is possible transfer accounts from JotForm site to a JotForm Application installation on your own server.

    2 We have web hosting with Go Daddy and have php / mysql etc. Is there any known issues with installing @ Godaddy?

    No, there are no known issues with Godaddy.

    3. If I upgrade to the 100 / $450 account and find that I need to upgrade again to the 1000 / $950 is there an upgrade / trade up value?

    If you upgrade within 1 month you can get the difference credited on JotForm Application Enterprise purchase. Since we have a 30 day money back guarantee. Otherwise, no, if you need the new license, you will have to pay the full price. Since there is a huge discount for getting a 1000-user license.

    4. I have a XML content feed that I want to parse into the database. Is this possible? (Not a techie so I hope I asked this one correctly)

    No, not currently. But this has been asked previously so it is something we might implement in the future.

    5. Does each Jotform create its own table within the database?

    No, all forms are in the same table.

    6. Is it possible (with programming) to use one table created by Jotform to validate another Jotform.

    Example:

    A user registers their email, name, etc. and then later we want them to be able to upload a contest photo but only if the email address has been registered before. With the application version and control of the data – I am hoping  we validate the data in one table against the form and then allow the new form to be executed?

    JotForm Application comes with full source code and you are free to customize it. So, you might be able to implement such functionality on your own.

    7. Does the 100 (or 1000) represent the number of unique users that can create their own forms? Basically becoming a Premium account under our Private Label Application?

    Yes, exactly.

  • Profile Image
    rrobertsgreencircle
    Answered on March 31, 2011 at 02:34 PM

    Thanks for the above answers.

    I have another question.

    With the Applicaiton version - Will I be able to create additional tables within the jobform database that are separate from jotform? Or is there a security restriction on the applicaton that keeps me from doing this?

    -Robbin

  • Profile Image
    rrobertsgreencircle
    Answered on March 31, 2011 at 03:09 PM

    I forgot to ask how long does the installation usually take? From the time of purchase?

  • Profile Image
    liyam
    Answered on April 01, 2011 at 01:45 AM

    Hello Robbin,

    For your question about tables and databases.  As long as you have control with your database, you can manipulate it to whatever you want.  You can add your own tables in it if you wish. 

    For your inquiry about the duration of the installation, we'll wait for Aytekin or others to answer.

    Thanks.

  • Profile Image
    aytekin
    Answered on April 01, 2011 at 09:13 AM

    Yes, as liyam stated above when you install JotForm Application on your server, the database will be completely independent from JotForm site. 

    We provide installation within 1-2 business days. Most of the time, in the same day. If you wouldl like you can also install it yourself. All you have to do is to upload all files to your site and then complete the web based installer

  • Profile Image
    rrobertsgreencircle
    Answered on April 01, 2011 at 09:45 AM

    Perfect. This is going to make it very easy to do what we need. Except the XML feed parsing. If I could just get that in a table and set it to update on a regular basis - I would be 100% there.

    If anyone has any advice on how to take a feed from a weblink that my source provided me with and parse it into a table .... I would be so grateful.

    Thanks for all the info; it really helped make a decision. I love Jotform!

     

    -Robbin

  • Profile Image
    aytekin
    Answered on April 01, 2011 at 11:41 AM

    If you need to create an HTML table from the submissions data that is already possible.

    1. Select your form on My Forms page,

    2. Click on "Reports" button on the toolbar and then select "Add New Report",

    3. Choose "HTML Table Listing" option, click Next,

    4. On the next screen define which fields should be included in the table,

    5. On the final page, copy the HTML code provided to your site.

  • Profile Image
    rrobertsgreencircle
    Answered on April 01, 2011 at 12:14 PM

    I am good with the above ...

    My question was more about XML feeds which is out side the scope of Jotform at this time.

    I was just wishing that someone who uses Jotform had an easy solution to take a website xml feed that I am getting from a supplier and move it into a totally new table in the my databse. (Never hurts to ask....)

    If anyone has attempted this before and was successful I would love to hear how they did it. Who knows maybe it is the motivation Jotform needs to add this to the features of the program. (Hint)

    Thanks again for all your help,

    Robbin

     

     

     

     

  • Profile Image
    aytekin
    Answered on April 02, 2011 at 02:16 AM

    There is no XML feed feature and we do not have any plans to add it in the near future.

    If you need to programmatically parse the XML output you can probably also do the same using CSV Report. Create a CSV feed for your forms and then use one of the many CSV parsers to get the results and then you can show them on your site.

  • Profile Image
    rrobertsgreencircle
    Answered on April 11, 2011 at 11:18 AM

    Hi there.

    Just a quick update - I have purchased the Jotform application. I am just waiting for the licensing information & install. 

    Also a note for anyone who is looking for a XML solution, I found a great way to accomplish this with Dreamweaver CS5. I was able to save the XML feed from my vendor source as a xml file of my own and then use SpryAssests to bring it into my website. I didn't have to parse or do anything major to it. There are even templates to help you with how the data displays and updates. You can learn more at AdobeTV - Search Spry Assets

    Thanks again for everything.Jotform is the best.

    -Robbin

     

     

  • Profile Image
    liyam
    Answered on April 11, 2011 at 11:38 PM

    Hello Robbin,

    Thank you for purchasing the JotForm application.  Thank you for your kind comment as well.

    It is good to know you found a work around for your XML.  I will look into this as well and study it.  Who knows, someone might need this information too.  Thank you for sharing your solution.

    If you have other concerns or inquiries, please do let us know.

    Thanks!

  • Profile Image
    rrobertsgreencircle
    Answered on June 04, 2011 at 10:23 AM

    5. Does each Jotform create its own table within the database?

    No, all forms are in the same table.

    Just a quick update; Incase someone is reading this; after installing the program and connecting to my own database and looking over the tables - this is "kinda" true all answers are posted to an "answers" table - however there are other tables that hold key information. Like there is a "submissions" table that is joined by the "form Id" and it holds the date & time stamp. 

    For our purposes we are creating a widget for websites to show sales - we have to join these two tables to get the right output. Which is really not a problem - The database set up is extremely easy to naviagate and understand. The freedom that it gives you is outstanding. I was able to combine my affiliate keys and my campaign keys into the long form source and when the data is returned through a form then I get everything I need..

    Jotform just gets better and better! And I am not even a power user..... 

     

     

  • Profile Image
    liyam
    Answered on June 05, 2011 at 12:07 AM

    It's good to know that the application is working really well for you, Robbin.

    If you have other comments, concerns, inquiries, or suggestions that you have in mind, just let us know, we're here to assist.

    Thanks,

    Liyam

  • Profile Image
    ajlst21
    Answered on June 25, 2012 at 11:30 AM

    4. I have a XML content feed that I want to parse into the database. Is this possible? (Not a techie so I hope I asked this one correctly)

    No, not currently. But this has been asked previously so it is something we might implement in the future.

    ----------------------------

    We'd also like have this as XML output for parsing into our CRM.