This topic contains 2 replies, has 2 voices, and was last updated by  david.h 4 months ago.

  • Creator
    Topic
  • #13229

    david.h
    Participant

    Hi,

    I need to import three custom taxonomies, each with one to four custom fields using Metabox and Custom Tables. The taxonomies are large, one exceeding 4,000 entries, so I would rather do this via an automated script.

    After creating the custom taxonomies and associated custom fields, could I create a TSV of the taxonomy data and use the Metabox created MySQL table definitions to perform a LOAD DATA INFILE?

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • Author
    Replies
  • #13333

    Anh Tran
    Keymaster

    Hi David, can you give more details on load data in file? As all the data imported, I don’t understand why you need a TSV file.

    #13363

    david.h
    Participant

    Hi Anh,

    Apologies, I realise my question was not well written.

    The taxonomies are not already setup, they are imported directly into a fresh WordPress database using SQL – these scripts form the WordPress taxonomy hierarchy by creating entries in wp_term_taxonomy that relate to the imported wp_terms data.

    At present, the scripts also add related taxonomy meta into wp_termmeta, although I wish to use Metabox’s Custom Tables feature to store these entries in a separate table.

    Maybe this is straightforward, so I will give it a try and come back if there are any problems.

    Thanks,
    David

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.