Pods for separate database import from WordPress

  • Resolved siteprowizard

    (@siteprowizard)


    3 years, 9 months ago

    I have a database table of about 7700 rows that I want to set up Pods for, so that each row data can be indexed under WordPress as a post.

    What I am looking to do import the database using Mysql and then establish the link with Pods. I have tried setting this up by using Advanced Content Type and then importing into that table. This meant I had to manually input each field into Pods -which is considerable (many columns). This did not work since the link to row was not established somehow.

    Anyway, is there a good way to set this up from the backend (Mysql), by importing to a database and then manipulating the database?
    Or, what is the proper way to do this, without tons of manual effort?

    The page I need help with: [log in to see the link]

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

  • Hi

    What I did for my own site is I created a pod content type in WP on the other side I have my database (as csv file) with thousands of rows and dozens of columns.

    I use then the plugin WP all import pro to perform the import (with a mapping to be done during the preparation of the import) from my csv file into the pods content post and I get as many posts as I have rows

    The plugin is not cheap for sure but at the moment that’s the only way I found to do the import of such amount of rows

    Plugin Author Jory Hogeveen

    (@keraweb)

    Hi @siteprowizard

    As @bkantique mentioned, if you need to create Posts from that table then WP All Import would be your best choice.
    If you need a separate table for these fields then your best option is to create a ACT with all fields and THEN import all rows from your existing table.

    Cheers, Jory

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Pods for separate database import from WordPress’ is closed to new replies.