https://legacy.forums.gravityhelp.com/topic/unale-to-merge-data-and-import Gravity Support Forums Topic: Unable to merge data and import en-US Tue, 07 Apr 2026 04:58:44 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/unale-to-merge-data-and-import#post-30324 Mon, 18 Jul 2011 15:30:04 +0000 josey 30324@https://legacy.forums.gravityhelp.com/ <p>I got it, I was making a mistake by export all the db tables when I thought I was only exporting the rg_tables.</p> <p>Thanks for the node to Meta Recovery Tool, will use if need be. All looks okay now though.</p> <p>Cheers </p> https://legacy.forums.gravityhelp.com/topic/unale-to-merge-data-and-import#post-30321 Mon, 18 Jul 2011 15:23:21 +0000 josey 30321@https://legacy.forums.gravityhelp.com/ <p>I started to drop the form tables and import them to the new db, and got: #1062 - Duplicate entry '234' for key 'PRIMARY' </p> <p>I can't get the tables to import, maybe I'll try another time. </p> https://legacy.forums.gravityhelp.com/topic/unale-to-merge-data-and-import#post-30317 Mon, 18 Jul 2011 15:17:35 +0000 Carl Hancock 30317@https://legacy.forums.gravityhelp.com/ <p>Exporting and Importing Forms creates a new form, it doesn't overwrite existing forms.</p> <p>You would have to export all of the Gravity Forms related database tables and then import them into your new site. This would bring over all your forms and all your form entries. </p> <p>After doing so, if the forms don't work you may need to use the Meta Recovery Tool that is available on the Plugin Downloads page. Sometimes exporting/importing causes problems with the serialized data and you need to correct this using the Meta Recovery Tool. It's a plugin that adds a new "Meta Recovery" navigation item under Forms that you use to correct the meta data for each form. </p> https://legacy.forums.gravityhelp.com/topic/unale-to-merge-data-and-import#post-30185 Sat, 16 Jul 2011 14:41:04 +0000 josey 30185@https://legacy.forums.gravityhelp.com/ <p>I thought I could just export forms from live site, and import into local, but I get duplicate forms. And this is not including the entries? Right?<br /> ~~~~~~~~~~~~~~~~~~~<br /> I went ahead and exported the rg_ tables from the production/live site, dropped them from the local/dev site and tried to import them to the local. I got this error:</p> <p>#1062 - Duplicate entry '234' for key 'PRIMARY' </p> <p>I'm not experienced with advanced sql db editing, but probably could figure this out if given some direction, thanks. </p> https://legacy.forums.gravityhelp.com/topic/unale-to-merge-data-and-import#post-30184 Sat, 16 Jul 2011 14:37:23 +0000 josey 30184@https://legacy.forums.gravityhelp.com/ <p>I'm trying to manages entries of forms from a development site to a production site. So, I'm making local site/db changes to entire site and need to push out updates, but then their are entries from the live site in the live db. I don't want to lose those, how is the best way to merge those entries to my local db? Also, if the production/live site make notification edits, I want to merge those with local/dev db, too.</p> <p>Do I have to manually do a db replace of GF tables to local db before making it live. I don't do sql queries, and rarely pull tables into databases. </p> https://legacy.forums.gravityhelp.com/topic/unale-to-merge-data-and-import#post-23878 Thu, 21 Apr 2011 15:07:08 +0000 Carl Hancock 23878@https://legacy.forums.gravityhelp.com/ <p>I'm not sure what you are trying to do.</p> <p>Form Entries are exported to CSV which can then be imported into Excel. Form Entries can only be exported to CSV, they cannot be imported.</p> <p>Form Settings, not to be confused with Form Entries, are exported to XML which aren't designed to be imported or edited at all in Excel. They are merely for exporting a form from one site and importing it to another site. </p> https://legacy.forums.gravityhelp.com/topic/unale-to-merge-data-and-import#post-23868 Thu, 21 Apr 2011 13:05:28 +0000 accurate 23868@https://legacy.forums.gravityhelp.com/ <p>Hi,</p> <p>I have a separate excel file that has all the attributes my form has. What I'm trying to do is merge the information on the excel file with the excel file that is created from exporting. When I merge the data, I am unable to import it:</p> <p>Forms could not be imported. Your XML export file is not compatible with your current version of Gravity Forms.</p> <p>Is there any way that I can merge both excel files together through importing? </p>