Importing data from other than WordPress sources - relationships - Meta Box

This topic has 1 reply, 2 voices, and was last updated 4 years, 8 months ago by Anh Tran.

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

Author

Posts
March 19, 2020 at 6:39 PM #18587

Donald
Participant

I need the advice of someone advanced. I will import data from sources other than WordPress into custom posts with custom fields created from metabox. How to prepare MB relationship data? Has anyone already performed such an operation to import data and automatically connect with the relationships of individual posts.

Add New Note to this Reply

March 20, 2020 at 3:50 PM #18601
Anh Tran
Keymaster
Hi Donald,

You might want to take a look at the data structure of mb_relationships table, which is quite simple and easy to understand. It has 5 columns:
- ID: connection ID (auto increment)
- from: the ID of the "from" object
- to: the ID of the "to" object
- type: the connection type (ID)
- order_from: the order for the "from" side
- order_to: the order for the "to" side
And based on that, you can prepare the data accordingly.

When inserting into the database manually, you can omit the order_from and order_to for simplicity.

Add New Note to this Reply
Author

Posts

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

You must be logged in to reply to this topic.