Import / Export Form Data

[Joffcom]

Sometimes when moving the database between servers then updating the URLs to match the prod system the plugin clears the information from the database.

Manually putting the information from dcal_options / salesforce2 also gets removed.

Adding a button to export / import data would save a lot of time.

[nciske]

Improperly modifying serialized data is not really a bug. If you deserialize, replace, then reserialize it works fine.

There are plenty of plugins and tools that allow you to search and replace in the wp_options table without breaking serialized data.

Not sure what the second bit means - if you copy the entire field, it should use the data without issues. Can you give me exact steps to replicate?

Sent from my iPhone 5

On Aug 22, 2014, at 4:38 AM, Jonathan Bennetts notifications@github.com wrote:

Sometimes when moving the database between servers then updating the URLs to match the prod system the plugin clears the information from the database.

Manually putting the information from dcal_options / salesforce2 also gets removed.

— Reply to this email directly or view it on GitHub.

[Joffcom]

Yea sure,

Set up 2 Wordpress Installs Install WP2L on Wordpress A and make some forms Install WP2L on Wordpress B Go to the DB and pull out the salesforce2 info from options on Wordpress A Load that data into DB2 for Wordpress B Login to Admin Panel

[nciske]

Are you replacing the data or adding a second option with the same name?

I just tested replacing the option data with the data from another site and it worked fine…

Adding a second option would probably not work as the plugin assumes there’s only a single option called salesforce2 in the options table.

On Aug 26, 2014, at 11:13 AM, Jonathan Bennetts notifications@github.com wrote:

Yea sure,

Set up 2 Wordpress Installs Install WP2L on Wordpress A and make some forms Install WP2L on Wordpress B Go to the DB and pull out the salesforce2 info from options on Wordpress A Load that data into DB2 for Wordpress B Login to Admin Panel

— Reply to this email directly or view it on GitHub.

[Joffcom]

I was replacing the data using phpmyadmin so just opening the salesforce2 entry and pasting the data from the test db into the live db.

I will try it again and see what happens

[nciske]

Form import/export is on the wish list, in the mean time, here are tools to migrate URLs in serialized data (this issue affects thousands of WP plugins) without breaking them:

In place

GoLive Update URLS Free https://wordpress.org/plugins/go-live-update-urls/

ICIT Search and Replace Tool Free https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

When migrating

WP Migrate DB Free https://wordpress.org/plugins/wp-migrate-db/ Pro/Paid https://deliciousbrains.com/wp-migrate-db-pro/

BackupBuddy Paid http://ithemes.com/purchase/backupbuddy/

There are others, but I use and trust these tools to do the job.

[nciske]

Version 3 stores forms as custom post types, so forms will be able to be exported/imported using the tools built into WordPress. A importer/exporter for core plugin options will follow shortly after.