MB Custom Table beginner questions

Hi Brian,

Once the table is created should I delete this code?

It’s fine if you delete the code. If you keep the code, it will check for table existence before trying to create.

If your data set is large do you advise setting all your fields to VARCHAR(length) NOT NULL

Varchar is for a text that you don’t know the length. It’s usually used for fields like title, short description. If the field is large, I’d recommend using TEXT.

What’s the best way to import xml or csv data into my newly created custom post type that uses the mb custom table?
I set the field ID to AUTO_INCREMENT. This allowed me to import my csv file and everything in the custom mb table imported correctly. But when I go to my custom post type in wp admin these listings do not show. This is driving me bananas.

The ID column must map the ID of the posts in the WordPress’s table. Otherwise, the plugin can’t know which post that a row belongs to.

I think, you need to edit the ID column first. Then using phpMyAdmin to import.

Hi Brian,

Is there something I can add to phpmyadmin so that on import of the csv file it also creates the needed info for each in the wp_post table?

Creating a new post in the wp_posts table requires coding. So, I think this can be done with custom code only. Take a look at this tutorial on how to process a CSV file with PHP.

Is there a hook that I can add to functions.php to tell my field to output the full url path and not the ID.

File and image fields save attachment IDs in the database instead of URL. To get file URL, you can use wp_get_attachment_url function.