Importing existing data and relationships

  • Resolved supton

    (@supton)


    5 years, 6 months ago

    I have a database of over 68000 rows, each row is a person. Each person can have multiple addresses, so I have created a separate pod for the addresses (I’m thinking a one to many relationship).

    I am struggling to understand how I can import the data and have these records connected. The connected field on a database table would be the ID but I am not sure how to work with that model in Pods. Can someone point me in the right direction?

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Jory Hogeveen

    (@keraweb)

    Relationships are stored as metadata in the {prefix}_postmeta table.
    The relationship field name is the metakey and the value is the related post ID.

    There are addons for WP All Import that can handle Pods fields (https://vipp.com.au/cio-custom-fields-importer/product/cio-pro/) but you might just try WP All Import without addons first.

    Good luck!

    Regards, Jory

    Thread Starter supton

    (@supton)

    Hi Jory,

    Thanks for the info. Taking it one step further… users will be submitting their data on a front end page – is there a way to connect the submitted data on a front end form and create the connection between the two pods – bearing in mind the first pod is one submission and the second pod could be multiple submissions connected to the first pod?

    • This reply was modified 5 years, 6 months ago by supton.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Importing existing data and relationships’ is closed to new replies.