Meta Box

Custom Table Migrate/Transfer the existing values to new table

Support › MB Custom Table › Custom Table Migrate/Transfer the existing values to new tableResolved

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • September 14, 2021 at 1:15 AM #30739
    ambrdigitalambrdigital
    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

    September 14, 2021 at 11:48 AM #30750
    Long NguyenLong 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

    September 14, 2021 at 5:01 PM #30753
    Long NguyenLong Nguyen
    Moderator

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

    September 14, 2021 at 11:52 PM #30766
    ambrdigitalambrdigital
    Participant

    Thank you!

    August 30, 2024 at 4:04 PM #46296
    Oscar Domingo Mateo OroOscar 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?

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.