Creating a one to many relationship

  • Resolved artmuns

    (@artmuns)


    4 years, 1 month ago

    I recently installed PODS and I am trying to figure how to replicate a typical database. I have a lot of experience with Alpha Five a traditional database with many tables, similar to MySQL. I have looked a lot at the documentation on PODS but can’t quite get my head around how to set up what I am trying to achieve.

    I have an addresses spreadsheet, residents spreadsheet and a vehicles spreadsheet. The residents and vehicles spreadsheet have an ID column that matches the address ID column in the addresses spreadsheets to keep the data normalized.

    What I would like to do is import those various spreadsheets and create a one to many relationship to display all that data on one page. Is this possible with PODS? Would I create separate custom posts for each spreadsheet and custom fields for the data in the spreadsheets? I am using WP All Import for the imports.

    Thank you for any help.

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

    (@keraweb)

    Hi @artmuns

    Welcome to Pods! Unfortunately, the question you ask is very general so I am inclined to forward your to the following page:
    https://docs.pods.io/faqs/what-can-you-build-with-pods/

    In short: Yes, you can use Pods for this project.
    However, Pods will not magically put everything together. It will only provide you with tools to help you with this project.
    You’ll have to plan your project properly, configure your objects and make sure your import files are compatible with WP All Import.
    Pods does not have any integration code for WP All Import but I believe they have some addons for more enhanced imports if needed.

    Good luck and feel free to ask if you run into specific problems!

    Cheers, Jory

    Thread Starter artmuns

    (@artmuns)

    Okay, thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Creating a one to many relationship’ is closed to new replies.