moving to MB custom tables

This topic has 5 replies, 2 voices, and was last updated 5 years, 7 months ago by tsttech.

Viewing 6 posts - 1 through 6 (of 6 total)

Author

Posts
April 25, 2019 at 11:55 PM #14289

tsttech
Participant

Dear Support,

I have a question. I have an old site which I created custom fields for the user section, pre-custom tables. Now I am moving the data over to a new site and wondering if i move the data over with custom tables installed. Will that data be moved into that custom table.

I have the MB builder installed, so would i just have to set the custom tables in the settings section of the field group?

Thank you

Add New Note to this Reply

April 27, 2019 at 10:58 AM #14322

Anh Tran
Keymaster

Hi Dave,

I'm afraid you have to write a custom script to migrate existing data from custom fields to custom tables. The plugin doesn't auto transfer data for you.

Add New Note to this Reply

April 27, 2019 at 10:19 PM #14337

tsttech
Participant

Dear Tran,
I was worried you might say that as that is way above my head.

If you know any where to start learning how to do it, that would be much appreciated.

Thank you
Dave

Add New Note to this Reply

April 27, 2019 at 11:26 PM #14339
tsttech
Participant
Dear Tran,

How would i make a table for the following
```
array (
    'id' => 'image_26',
    'type' => 'image',
    'name' => 'Business Logo',
    'max_file_uploads' => 4,
),
```
What SQL data type should i use and do i have to add anything to allow 4 file?

Add New Note to this Reply
May 2, 2019 at 11:16 AM #14378
Anh Tran
Keymaster
Hi Dave,

Please try this script (put it in your functions.php file and go to this URL: yourdomain.com?action=migrate):

https://pastebin.com/BPXTEy6H

The idea of the script is:
- Make sure it runs only when the URL contains ?action=migrate to avoid running the script on every page load.
- Query all the posts that need to migrate the data. You should modify the query to get your correct posts.
- For each post, get the old meta value for each field. Note about the value format to see if it's an array or simple string.
- Insert the values into the new table. If the value is an array, it need to be serialized.
The script comes directly from my mind without testing, so please check it first.

Add New Note to this Reply
May 2, 2019 at 1:44 PM #14383

tsttech
Participant

Dear Anh,

Thank you for that and will give it a test.

Thank you
Dave

Add New Note to this Reply
Author

Posts

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.