How to migrate Gravity Forms entries?

[Toby Cryns]

Hi y'all!

Can anyone provide me with a tip on how to migrate Gravity Forms entries from one site to another?  There is a nice export-to-csv option out of the box, but I need to migrate those entries to another site.

I tried the Gravity Forms Mass Import plugin, but that didn't work for me: http://wordpress.org/extend/plugins/gravity-forms-mass-import/

I also tried migrating the database tables manually, but that didn't work.  It appears that the database schema is mapped specific to each domain: http://www.gravityhelp.com/forums/topic/import-csv#post-38736

Any ideas or experience with this?

Thanks!
Toby

[Nick Ciske]

Hmmm... that plugin seems like exactly what you need... too bad it didn't work!

Moving the tables should work fine as long as the form IDs match (there's really no domain data, just form id and lead id). If the forms were migrated via WP and not assigned the same ID as the previous site, I could see why the entries may not show or be broken as GF is trying to map the data to the wrong form.

Did you migrate all the GF tables at once, or just the data tables?

_________________________

Nick Ciske

http://thoughtrefinery.com/

@nciske

[Toby C]

NickC,

The ids on the form in question are the same (1).  

I migrated all of the GF tables at once.  Are you saying that I might try only migrating certain tables?  If so, which ones are the "data" tables?

Thanks!

Toby

----

to...@themightymo.com
http://themightymo.com
(612) 293-8629

www.twitter.com/themightymo
www.linkedin.com/in/tobycryns

--
You received this message because you are subscribed to the Google Groups "Minneapolis St. Paul WordPress User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mpls-stpaul-word...@googlegroups.com.
To post to this group, send email to mpls-stpau...@googlegroups.com.
Visit this group at http://groups.google.com/group/mpls-stpaul-wordpress?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Nick Ciske]

Hmmm... just tried this on my local dev server and it worked like a charm. I'd think you'd want to migrate all the _rg_ tables  at once.

What I did:

Installed and activated Gravity Forms (same version) on both sites.

Added a form and some entries to one site.

Exported the _rg_ tables via PhpMyAdmin (with DROP tables statements enabled).

Imported the SQL on the other site.

2nd site looks just like the first as far as forms & entries go.

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

Nick Ciske

@nciske

http://thoughtrefinery.com/

[barbara schendel]

Hey all, I have a followup on a very old question on here, but I'm having the same problem and the steps used are not working for me...

I have had a copy of a site on staging for a while and I need to grab all Gravity Forms entries from the live site and import them before launch.

Here are the steps I followed:

1) on source phpmyadmin, exported table wp_4fdd6_gf_entry and saved to my computer. Here is a screenshot of all the options. Everything is default except I checked the "add drop table statement" option, and unchecked  "Add create table statement"

2) Renamed the file so that the WP prefix matches the destination site (renamed wp_4fdd6_gf_entry to wp0t_gf_entry.sql)

3) on destination phpmyadmin, opened table wp0t_gf_entry and imported the sql file. 

4) Here is screenshot of the result.  Says "Import has been successfully finished, 46 queries executed. (wp0t_gf_entry.sql)"  but then below that is a big red error box with the below. And, more importantly, the entries on the destination site do not change. What am I screwing up here? 

Here's the error:

-- Database: `acr_mainsite`

--

--

-- Dumping data for table `wp_4fdd6_gf_entry`

--

INSERT INTO `wp_4fdd6_gf_entry` (`id`, `form_id`, `post_id`, `date_created`, `date_updated`, `is_starred`, `is_read`, `ip`, `source_url`, `user_agent`, `currency`, `payment_status`, `payment_date`, `payment_amount`, `payment_method`, `transaction_id`, `is_fulfilled`, `created_by`, `transaction_type`, `status`) VALUES

(1, 2, NULL, '2014-09-25 21:08:23', NULL, 0, 0, '75.73.89.242', 'http://acrhomes.dreamhosters.com/employment-2/applications/', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.124 Safari/537.36', 'USD', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'trash'),

(2, 2, NULL, '2014-09-26 13:45:04', NULL, 0, 1, '75.73.89.242', 'http://acrhomes.dreamhosters.com/employment-2/applications/', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.124 Safari/537.36', 'USD', NULL, NULL, NULL, NULL[...]

MySQL said: Documentation

#1062 - Duplicate entry '1' for key 'PRIMARY'

[Nick Ciske]

The import bails on the first record due to the duplicate primary key ID (1). You need to TRUNCATE the table(s) first so there’s no data (if you want to do an INSERT).

http://www.mysqltutorial.org/mysql-truncate-table/

You'll also need the entry_meta and entry_notes tables as well to get all the entry data imported.

I’d suggest you look at using WP Migrate DB Pro (also available on on GitHub as WP Sync DB) as it’ll handle all this for you and allow you to sync the tables with a single click (push or pull).

___________________

Nick Ciske

CTO / LuminFire

@nciske

https://luminfire.com/

--
You received this message because you are subscribed to the Google Groups "Minneapolis St. Paul WordPress User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mpls-stpaul-word...@googlegroups.com.
To post to this group, send email to mpls-stpau...@googlegroups.com.

Visit this group at https://groups.google.com/group/mpls-stpaul-wordpress.
For more options, visit https://groups.google.com/d/optout.

[barbara schendel]

Thanks Nick. Truncate is not an option on the sql export. Can you send a link with more info on how/where to do that?

To unsubscribe from this group and stop receiving emails from it, send an email to mpls-stpaul-wordpress+unsub...@googlegroups.com.
To post to this group, send email to mpls-stpaul-wordpress@googlegroups.com.

Visit this group at https://groups.google.com/group/mpls-stpaul-wordpress.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Minneapolis St. Paul WordPress User Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to mpls-stpaul-wordpress+unsub...@googlegroups.com.
To post to this group, send email to mpls-stpaul-wordpress@googlegroups.com.

[barbara schendel]

Sorry duh I was in a hurry. You of course DID send a link. Thanks.

To unsubscribe from this group and stop receiving emails from it, send an email to mpls-stpaul-wordpress+unsubscri...@googlegroups.com.

To post to this group, send email to mpls-stpaul-wordpress@googlegroups.com.
Visit this group at https://groups.google.com/group/mpls-stpaul-wordpress.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Minneapolis St. Paul WordPress User Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to mpls-stpaul-wordpress+unsubscri...@googlegroups.com.

[Nick Ciske]

I thought maybe I forgot to paste it, but I certainly intended to send a link ;-)

Honestly though, just use WP Sync DB, it’s amazing. And if you like it, consider purchasing a license from Delicious Brains for WP Migrate DB Pro.

https://github.com/wp-sync-db/wp-sync-db

Nick Ciske

CTO / LuminFire

@nciske

https://luminfire.com/

To unsubscribe from this group and stop receiving emails from it, send an email to mpls-stpaul-word...@googlegroups.com.
To post to this group, send email to mpls-stpau...@googlegroups.com.

[barbara schendel]

Oh yes this worked great. Thanks for the link. However I noticed that the signatures from the Signatures Addon don't come through. I'm not sure where those are stored but they don't seem to be in any of the GF tables. 

Does anyone have any ideas how to get those? 

To unsubscribe from this group and stop receiving emails from it, send an email to mpls-stpaul-wordpress+unsub...@googlegroups.com.

To post to this group, send email to mpls-stpaul-wordpress@googlegroups.com.
Visit this group at https://groups.google.com/group/mpls-stpaul-wordpress.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Minneapolis St. Paul WordPress User Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to mpls-stpaul-wordpress+unsub...@googlegroups.com.

[Nick Ciske]

I believe those are stored as images in the GF uploads folder. 

_______________________ 

 Nick Ciske 

CTO / Web Engineer 

@nciske 

 https://LuminFire.com 

To unsubscribe from this group and stop receiving emails from it, send an email to mpls-stpaul-word...@googlegroups.com.
To post to this group, send email to mpls-stpau...@googlegroups.com.