Can I sensibly recreate this data set this with PODS???

  • Resolved burbleweb

    (@burbleweb)


    3 years, 11 months ago

    I would like some advice please. I have read the help and tried setting up on a localhost with my PODS but am stuck when it comes to designing the data setup and wonder if I am on a fools errand.

    I have a database in Quickbase. It has 4 interrelated tables. Participations, Productions, People & Companies. These data relate to one another such that a “Person” will have many “Participations” and those may be in many different “Productions”. Therefore there are some shared relationship fields that cross between the tables.

    This quickbase is going down and the team I work for wanted to explore if we can get this data into WordPress. We have a wordpress site that Uses Pods for other data sets (I did not set that up but now administer the site).

    Question is:
    1, Is it possible create a Pods setup that gives the same functionality. The 4 Pods, but then essentially one uses Participations to bind multiple People to Productions in a one to many way and each Participation has its own extra data attached to it. This is a simplified example of how 3 pods would relate

    Film: Gone With The Wind, 1939, Drama,
    People: Clark Gable, [email protected],
    Participation: Clark Gable, Gone With The Wind, Hollywood, Cast, Actor
    2, Could I then bulk import the existing data set (we can get single CSV | Tab or XML tables down from QB). I cannot see any byulk import method

    Or is this all a stupid idea because WordPress wasnt built for this sort of thing…

    We then may wish to make a private login area for staff to browse the data set.

    We could then one day integrate some of the data on the front end.

    This is beyond me and I have posted a job up on Code able as per your advice, however I just wanted to check with you direct whether you thought this was something I could do and do well in WP with PODS. There is a lot of data to import and I cannot see a way of doing that as the existing plugin is deprecated?

    OPEN TO OTHER SOLUTIONS…. or being told I should tell my boss to think again.

    I would hugely appreciate any guidance on if you think this is sensibly possible or really inappropriate and will just be a nightmare to administer.

    Thanks in advance.

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

    (@keraweb)

    Hi @burbleweb

    The short answer would be, “Yes, you can built this in WordPress using Pods”. However, the configuration is something you’ll need to setup yourself, just like the templates etc.
    As for bulk editing, this isn’t a Pods feature. You can use a plugin like Admin Columns Pro for this.

    See this page on scope for the Pods project:
    https://docs.pods.io/faqs/what-can-you-build-with-pods/

    Cheers, Jory

    Just my two cents… The great relationship features of Pods, is to me one of the major selling points into using Pods instead of other popular plugins for your custom post types. I’ve been using Pods for years on high traffic sites maintained by not particular tech-savvy content creators, and they enjoy the Pods interface, and it just works.

    Regarding import, there are plugins for that. I’ve been importing 78000 rows into a Pods database, and while its surely not the fastest, it’s doable.

    I’m not sure WordPress was “built for that”, but the whole ecosystem around WordPress, makes it worthwhile in my opinion.

    Kind regards
    Bjarne

    Thread Starter burbleweb

    (@burbleweb)

    Thanks for taking the time to reply. Okay good to know. More learning to be done!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Can I sensibly recreate this data set this with PODS???’ is closed to new replies.