Bulk Import - Meta Box

This topic has 2 replies, 2 voices, and was last updated 6 years, 1 month ago by david.h.

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

Author

Posts
February 7, 2019 at 6:01 PM #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

Add New Note to this Reply

February 14, 2019 at 5:03 PM #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.

Add New Note to this Reply

February 15, 2019 at 11:06 PM #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

Add New Note to this Reply
Author

Posts

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

You must be logged in to reply to this topic.