[Plugin: CSV Importer] add subcategory

Hi

suggestion

make all the posts go into a CATEGORY that doesn’t exist. After they are imported, make that new category a subcategory by assigning it a parent.

Or create the subcategory you need first and then import your posts to that newly created subcategory.

I would do that except I want to create many subcategories so manually creating them is time consuming

I have a similar same issue. I am importing business listings in many states and cities. I have the states as categories and I want the cities for that particular state to be the sub-category. For example, I am using the “California, Los Angeles” on my CSV sheet but that makes 2 new categories (one for CA, one for LA). Any way of doing this without having to manually edit each city to place it into it’s parent? I love this plugin I just need a way around this one issue, thanks!

WPML: You can specify category IDs instead of names.

Dvkbob, by doing that I can import the posts into sub-categories rather than categories? I’m just not clear on how that would be different than my current issue, thanks. I have about 15,000 cities that need to be imported into their respective state/parent category.

WPML: Say you have a top-level category called Los Angeles with ID 30. And then you also have a category called Los Angeles with ID 55 under Cities category. By specifying 55 instead of category name (Los Angeles), you can make sure that all your stuff goes under the intended category, which in this case would be Cities -> Los Angeles.

Thanks for trying to assist with this. However, I need the cities to strictly be sub-categories for their particular state. My issue is I only have 50 categories right now, one for each state. I was hoping to import all of the state’s cities using the plugin and creating the city sub-category during the import. I see what you’re saying above but from what I understand that would require me to manually enter thousands of city names nationwide before importing. If I’m mis-understanding please let me know, thanks again for your time.

WPML: I should’ve read the thread more carefully. Currently you cannot create new subcategories with this plugin. Maybe in the future version.

WPML – i would try this using an XML file. Here’s what I would do. I would set up a city & state category, just as you wanted as a parent / child. Then I would then export my blog to an XML file to see how wordpress formats this in an XML file. Search around the file, study what’s before and after each. Then, I would copy that format for all my cites and states, maybe in an Excel file. Have column A be what’s before the city, column B is the city name, column C is what’s after, then column D combines all of those columns. Then, take column D and paste it into an XML file. Take notice of the special top and bottom of the wordpress XML file you first downloaded and paste your info in the middle. Then upload. Should work. Make sense?

gcarson,

you made it really complex, WPML please let me know if you solved this or what did you use if other than common sense coding.

anyone, I will solve this no matter what so please let me know, thanks,

Luis

post a way to contact you and I’ll simplify it for you. Its really not that complex. I have zero coding experience but use this method all the time. I’m probably just not good at explaining it ??