Build Your Own Business Website header image

Community Library Website – Part 16b – Final Data Import

Difficulty Level -

Whoops, you've found some premium content!

Watch the opening clip of this video to preview it,
the full video is available to paid members.

This is the sixteenth in a series of live lessons on using WordPress and Thesis as a Content Management System (CMS). We are using the CSV Importer plugin to import an existing database from a CSV file. A member has followed the directions but is getting an error on data import. We look at her configuration and determine why isn’t working properly.

Community Library Website – Case Study Part 1 – Site Organization
Community Library Website – Case Study Part 2 – Create Custom Post Types
Community Library Website – Case Study Part 3 – Custom Post Type Configuration
Community Library Website – Case Study Part 4 – Custom Taxonomy Decisions – Theory
Community Library Website – Case Study Part 5 – Custom Taxonomy Decisions – Practical Application
Community Library Website – Case Study Part 6 – Incorporating Existing Data Into the Project
Community Library Website – Case Study Part 7 – Creating Hierarchical Custom Taxonomies
Community Library Website – Case Study Part 8 – Creating Non-Hierarchical Custom Taxonomies
Community Library Website – Case Study Part 9 – Creating Custom Post Meta
Community Library Website Case Study – Part 10a – Restore the Database Using BackupBuddy
Community Library Website Case Study- Part 10 – Creating Custom Post Meta – Continued
Community Library Website – Part 11 – Importing Existing Data to the Website
Community Library Website – Part 12 – Prepare Existing Data for import by the CSV Importer plugin
Community Library Website – Part 13 – Import Existing Data Using the CSV Importer Plugin
Community Library Website – Case Study Part 14 – Date in Permalink Configuration
Community Library Website – Part 15 – Importing Images
Community Library Website – Part 16b – Final Data Import
Community Library Website – Part 17 – Add Thesis Post Meta to Custom Post Type
Community Library Website – Part 18 – Add WordPress 3.0 Menus
Community Library Website – Part 19 – Add Post Meta and Taxonomy Information to the Post Display
Community Library – Part 20 – Add topics and audience to book display
Community Library – Part 21 – Display the Rest of the Post Meta in the Post
Community Library Website – Part 22, Create the Permalink Structure
Community Library – Part 23 – Remove Custom Post Meta from Post Display
Community Library Website – Part 24, Add Taxonomy and Post Meta Data to the Teaser
Community Library Website – Part 25, Add Taxonomy Data to the Teaser
Community Library Website – Part 26, Adjust the Teaser Styling Using Design Options
Community Library Website – Part 27, Styling the Teaser Using CSS
Community Library Website – Part 28 – Fine Tune the Teaser Display
Community Library Website – Part 29, Designing a Custom Catalog Page
Community Library Website – Part 30, Using a Query String in a URL
Community Library Website – Part 31, Adding Custom WordPress Menus
Community Library Website – Part 32, Add Custom Menus to the Catalog Page
Community Library Website – Part 33, Add Another Custom Menu to the Catalog Page
Community Library Website – Part 34, Troubleshooting Custom Menus
Community Library Website – Part 35, Add Styling to WordPress Menus
Community Library Website – Part 36, Add HTML Markup to WordPress Menus
Community Library Website – Part 37, Add WordPress Menus to Archive Pages
Community Library Website – Part 38, Add and Style a List of Tags
Community Library Website – Part 39, Add a Search Box to the Sidebar
Community Library Website – Part 40, Add Links to the Sidebar
Community Library Website – Part 41, Add Taxonomy Drill Down Browsing
Community Library Website – Part 42, Custom Loop to Display Custom Post Types
Community Library Website – Part 43, Simple Custom Query
Community Library Website – Part 44, Custom Taxonomy Query
Community Library Website – Part 45, Add Thesis HTML Structure to Teasers
Community Library Website – Part 46, Display Posts from the Last 60 Days
Community Library Website – Part 47, Custom Loop If Have Posts
Community Library Case Study – Part 48, Increase the Number of Posts that Display on the Custom Catalog
Community Library Website – Part 49 – Naming Conflicts in Custom Taxonomies
Community Library Website – Part 50 – Find and Replace Semi-colons in the Database
Community Library Website – Part 51 – Modify Taxonomy Names Directly in the Database
Community Library Website – Part 52 – Sort Posts by Meta Value
Community Library Website – Part 53 – Show the Term Label Only when a Term Exists
Community Library Website – Part 54 – Sort Archive Posts by Meta Value
Community Library Website – Part 55 – Add Sort Order to Custom Taxonomy

Video Transcript

Rick: Let’s see, before we dive right into it though, I think I’m going to unmute Pam’s microphone and see if there’s anything she wants to add before we dive into it. Pam?

Pam: Good evening, Rick.

Rick: Good evening, Pam.

Pam: I’m having a problem but it’s not related to this… to what you’re doing this evening so looking forward to what you have to say.

Rick: Well, what problem are you having?

Pam: When I followed along where we are so far and as soon as we import, it said that it imported 145 items but it also said that… let’s see here… what did it say? Unknown post type catalog item. Then it said it imported 145 posts but I don’t see any posts that it had imported.

Rick: Yeah because there’s some kind of a difference between… I mean, that’s all happening in that heading. That heading at the top of the catalog items, that has to be exactly the same as the name of the catalog of the custom post type. It has to be exactly the same so all lower case, it has to have a little hyphen in it, that kind of stuff.

Pam: Okay, I thought I’d done it correctly. The heading catalog on the… the heading is csv_post_type and then it’s catalog-items, all in lower case.

Rick: Here, why don’t we… let’s see… why don’t we look at your screen for just a minute then and I’m going to make you a presenter and then I’m going to let you show your screen with us. Okay so there you are. Can you… okay, here we go. So can you share your screen with us now?

Pam: I’m trying. Let’s see what I’d do to get rid of this…

Rick: Well there should be a little thing that’s popped up saying “Would you like to show your screen…”

Pam: Oh okay. Did that work?

Rick: Yes, it does.

Pam: This is the column I’m referring to with the heading csv post type and underneath it, everyone is catalog-items.

Rick: Okay show me what it looks like created on your site.

Pam: First, catalog items… down here somehow I have…

Rick: Actually, go all the way down to the bottom where you’ve got the post type… custom post type, yeah. Look at Manage Post Types.

Pam: Okay so Manage Post Types, here we are.

Rick: Okay and you can see that you’ve named it catalog space items.

Pam: Oh that means we’ve got a… okay, so I have to call it catalog… I think this must have happened because I did a backup and restore and I restored it to the wrong space. I know I’ve done that at one time. Okay, that you. So that should fix it.

Rick: That will fix it and the import should happen just fine now. Obviously, it did actually add all those posts to the database so what you really want to do is you know, throw that database away, reload your old… the database you had before and then do it again. Obviously, when you do that, you’re going to have to change this post type again, right? Because you’re going to throw the database away and part of throwing the database away is throwing away this thing.

Pam: Right, right. The mysterious part to me was it said it imported 145 posts. Where did it put them?

Rick: It puts them in the database but it doesn’t give them a post type so it just recorded them in the database.

Pam: Okay, thank you. I’m sorry to take up time with that but that’s very helpful. Now I see what I did.

Rick: Yeah, no problem. No, that’s what the live call-in question and answer is for… is to have these kind of conversations so it’s no problem.

0 Comments… add one

Save $200 on Membership Now!

Start learning today for as little as
$0.82 PER DAY!
THIS IS A LIMITED TIME OFFER!
Subscription Options
0 comments… add one

Leave a Comment