Custom Table Migrate/Transfer the existing values to new table - Meta Box

This topic has 4 replies, 3 voices, and was last updated 7 months ago by Oscar Domingo Mateo Oro.

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

Author

Posts
September 14, 2021 at 1:15 AM #30739

ambrdigital
Participant

Hi there,

I've enabled the Custom Table extension and have set up the new table "mb_lfr_list". My meta fields are also saving properly to this new table.

However, I have thousands of values I need to transfer over. Is there a way to migrate these old values to the new table programatically?

Let me know - this would be a huge help! Thanks so much

Add New Note to this Reply

September 14, 2021 at 11:48 AM #30750

Long Nguyen
Moderator

Hi,

I think it is possible to move current post data from the default table wp_postmeta to the custom table. But need a lot of code to do, you can try to use the public API update to do that. Please read more here https://docs.metabox.io/extensions/mb-custom-table/#update

Add New Note to this Reply

September 14, 2021 at 5:01 PM #30753

Long Nguyen
Moderator

Refer to this article https://metabox.io/move-custom-fields-data-to-custom-tables/

Add New Note to this Reply

September 14, 2021 at 11:52 PM #30766

ambrdigital
Participant

Thank you!

Add New Note to this Reply

August 30, 2024 at 4:04 PM #46296

Oscar Domingo Mateo Oro
Participant

After following this steps, I can see the values in the custom table. I can also see values as admin columns.
However, when I edit the post, field seems to be empty. ¿Some caching problem?

Add New Note to this Reply
Author

Posts

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

You must be logged in to reply to this topic.