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.
This is a really good question. I have a similar situation coming up. I haven't thought too much about it yet...
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
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!
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.
+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?
+1 for entry import -- this would be incredibly useful.
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!!!
I am eager to read your helpful reply. Please don't forget me.
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
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 :-)
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.... :)
@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.
Awesomeness has been created.
We'll direct all support questions for this plugin to the plugin author:
http://wordpress.org/extend/plugins/gravity-forms-mass-import/
