PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Import Data into Gravity Forms

  1. Hi

    I have some existing data from a client which they would like imported into this new setup. I've just had a look at the database and realised that the information is not stored in columns, which makes a direct import into the database very troublesome.

    Has anyone successfully imported any data directly into the database? I have over 1900 entries which I need to get into this system for a client.

    Posted 14 years ago on Thursday November 5, 2009 | Permalink
  2. This is a really good question. I have a similar situation coming up. I haven't thought too much about it yet...

    Posted 14 years ago on Thursday November 5, 2009 | Permalink
  3. This is a bit tricky. We won't be able to do a simple import, but I think we can create the insert statements with some excel manipulation. Shoot me an email to alex[at]rocketgenius.com and I can help you getting this done. If you can send me a sample of your data in CSV or excel format, that will help me get a better idea on what it will take to do this

    Posted 14 years ago on Friday November 6, 2009 | Permalink
  4. Hi Alex

    Thanks for your prompt response, I've sent off an email with attachments.

    Posted 14 years ago on Monday November 9, 2009 | Permalink
  5. jcmilton
    Member

    Any followup? Were you able to successfully import a CSV file into GF?

    I'm trying to migrate one of my forms from Wufoo to GF, and I have a form with about 500 entries (CSV rows) in it and about 50 fields (CSV columns).

    I'd love to have it all moved to GF so I have everything in one place and can continue to collect data. I'd be happy to send you the file to evaluate to see if it's possible.

    Thanks!

    Posted 14 years ago on Wednesday July 21, 2010 | Permalink
  6. jcollier
    Member

    I'm hoping there might be an entry import feature in the roadmap, too.

    I am using Turbo CSV to import into custom fields and custom post types, but I'd rather be entering to Gravity Forms entries.

    Posted 13 years ago on Monday December 27, 2010 | Permalink
  7. Yes, there are plans for an entry import tool in the future. I don't, however, have a timeline that I can give you. But it is an add-on we plan on creating.

    Posted 13 years ago on Tuesday December 28, 2010 | Permalink
  8. jcollier
    Member

    It's great to know it's being considered. Thank you.

    Posted 13 years ago on Tuesday December 28, 2010 | Permalink
  9. +1 for an entry import add-on. It would make my life much easier.

    Posted 13 years ago on Friday March 25, 2011 | Permalink
  10. +1 for the entry import add-on as well. I am in the same situation at the moment, and I have encountered cases before where I just ended giving up and going manual :-/

    Anyways, love your product, but pretty please. Develop an import add on :-)

    Perhaps you can otherwise explain a way to process submissions entirely via PHP code?

    Posted 12 years ago on Wednesday December 21, 2011 | Permalink
  11. +1 for entry import -- this would be incredibly useful.

    Posted 12 years ago on Tuesday January 10, 2012 | Permalink
  12. Any update on this? been 1+ years since it was originally suggested. Should we just assume that it won't happen?

    Posted 12 years ago on Friday February 3, 2012 | Permalink
  13. Gravity forms is terrific. Almost embarrassing, though, that there is no way to import mass records, straight through the plugin.

    Posted 12 years ago on Tuesday March 13, 2012 | Permalink
  14. Absolutely agree with you. I am having a heck of a time either completing a simple two colum import from excel/csv/xlm output, for a mere 800 records.

    The main reason I bought Gravity forms is to create a better "spreadsheet type" of sales page for domain names. Presently, I look pretty stupid with a cut and pasted spreadsheet, accented with a one way hyperlink to the Gravity contact form. If the customer has to type in the domain name they want, the cannot easily purchase multiple items, nor will spelling mistakes be controlled.

    Arg!!!

    Posted 12 years ago on Saturday April 21, 2012 | Permalink
  15. I am eager to read your helpful reply. Please don't forget me.

    Posted 12 years ago on Monday April 23, 2012 | Permalink
  16. rogerlos
    Member

    Another vote for this. Thanks.

    Posted 12 years ago on Wednesday May 9, 2012 | Permalink
  17. lindaeve
    Member

    I really really need a way to import a CSV data into a GF as well. +++1 from me. When will this ever happen?

    Posted 12 years ago on Friday June 22, 2012 | Permalink
  18. +1

    Posted 12 years ago on Monday July 2, 2012 | Permalink
  19. grahamlindsey
    Member

    One more vote - working on an online ordering system for a client, and having all the data in GF is key so they don't have to work with new orders from GF and old orders from their other system.

    Do you have a projected timeframe for this functionality? I'm sure most of us understand that it takes time to develop a tool like this, so even if you say "we're hoping to get it done in the next year", we'll know what to expect.

    Cheers,
    Graham

    Posted 12 years ago on Monday July 9, 2012 | Permalink
  20. thulbourn
    Member

    Even if no Plugin importer, any hints on SQL needed to inject data in here so developers can at least get information transferred in from an existing system?
    This is a fundamental feature requirement for a system like this - it's going to mean people go elsewhere, which is a shame because gravity forms is a pretty nice form system, apart from the inability to import :-)

    Posted 12 years ago on Tuesday August 28, 2012 | Permalink
  21. thulbourn
    Member

    If anybody needs some PHP code to import from a CSV file into Gravity Forms then place a post here and I'll try to figure out how to get it to you, or I'll post it somewhere on my own site.
    It isn't a plugin.
    It is written for a very specific import.
    It isn't supported.
    But it might help you get started... it's fairly straightforward.... :)

    Posted 12 years ago on Wednesday August 29, 2012 | Permalink
  22. @thulbourn If you need to import data it can be done via SQL, we can provide you with some guidance if you absolutely need to do so. Drop me an email at carl@rocketgenius.com about it and i'll see what we can do to give you some guidance on it.

    Import functionality, while very valuable to some users, isn't as critical to our overall user base. The majority of our users don't have existing data to import, and all data is created going forward after installing Gravity Forms. I understand it can be critical to some use cases, but it just hasn't been something that has been demanded by our user base to push us to focusing development efforts on it up to this point.

    Importing entry data is much more complex than it sounds. Because forms are whatever the user makes, it adds complexities because to import data you need to make sure that where you are importing the data makes sense for it's destination, etc. There are a wide variety of complexities involved.

    We do plan on tackling it in the form of an Add-On. We plan on pulling out the export functionality and making a robust Import/Export Add-On that will not only provide more advanced export functionality, but also enabling importing of entry data. I can't give you a timeframe because it's just one of a long list of features or add-ons we'll be developing as Gravity Forms continues to evolve. It's difficult to give any kind of timeframe on development that hasn't yet begun.

    But if importing data is critical, drop me a line and we can see what we can do to provide you with some guidance on how to accomplish it via SQL. It sounds like based on your last thread post that you have got it under control for what you wanted to accomplish.

    Posted 12 years ago on Wednesday August 29, 2012 | Permalink
  23. Joe T
    Member

    +1 for data import capabilities.

    Posted 12 years ago on Sunday September 9, 2012 | Permalink
  24. +1 for data import, it would be extremely useful.

    Posted 12 years ago on Sunday September 23, 2012 | Permalink
  25. julieconnect
    Member

    +1 for data import capabilities.

    Posted 12 years ago on Tuesday October 2, 2012 | Permalink
  26. +1 for data import, it would be extremely useful

    Posted 11 years ago on Friday October 12, 2012 | Permalink
  27. Awesomeness has been created.

    Gravity Forms Mass Import

    Posted 11 years ago on Thursday October 18, 2012 | Permalink
  28. We'll direct all support questions for this plugin to the plugin author:

    http://wordpress.org/extend/plugins/gravity-forms-mass-import/

    Posted 11 years ago on Tuesday October 23, 2012 | Permalink

This topic has been resolved and has been closed to new replies.