Skip Navigation

[Resolved] entering hierarchical taxonomy data for custom post

This thread is resolved. Here is a description of the problem and solution.

Problem:

Import terms of hierarchical taxonomy with csv importer pulgin.

Solution:

It is a question for plugin "CSV Importer", I just checked in their document, it does support hierarchical taxonomy, see it here:
https://wordpress.org/plugins/csv-importer/

Hierarchical taxonomies

The syntax for hierarchical taxonomies is more complicated. Each hierarchical
taxonomy field is a tiny two-column CSV file, where the order of columns
matters. The first column contains the name of the parent term and the second
...
Sample examples/custom-taxonomies.csv file included with the plugin

I suggest follow their document to setup your CSV file

Relevant Documentation:

https://wordpress.org/plugins/csv-importer/

This support ticket is created 6 years, 9 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

Author
Posts
#635842

Hi, I'm using the free csv importer pulgin to upload data to my site.
One of my post fields is an hierarchical taxonomy, I've been using the documentation on this Toolset support thread:
https://toolset.com/forums/topic/importing-hierarchical-taxonomies-with-csv-importer/
explaining how to import all the categories and sub-categories.
My question is how to enter the taxonomy (category & sub-category) for each custom post - if the custom post is 1 row in a csv file.
For example if one of my custom post fields contained the hierarchical taxonomy "Accounting, Accountant - Chartered / CPA"
would that appear in a cell in the row under the column heading csv_ctax_job-category (assuming I was using the same fields as the example) .
Would I need to first import all the categories and sub-categories of the hierarchical taxonomy or could the whole structure be built as each custom post containing the taxonomy is imported.

Thanks for any help
David

#636520

While waiting for you, I checked out the csv importer sample file custom-taxonomies.csv and if I understand correctly I need to enter in the cell under column csv_ctax_job-category the hierarchical taxonomy as: "Accounting, Accountant - Chartered / CPA" , before that I need to setup all the categories and sub-categories for Accounting, is this correct?
Also if there is more than one Parent job category say Accounting and Programming but I want them all to appear under the taxonomy of jobs, how would I do that?

PARENT --> 0, Accounting
CHILDREN ---> Accounting, Accountant - Chartered / CPA
CHILDREN ---> Accounting, Accountant - Cost
PARENT --> 0, Programming
CHILDREN --->Programming, C#

Is that correct?

#638019

Dear David,

It is a question for plugin "CSV Importer", I just checked in their document, it does support hierarchical taxonomy, see it here:
https://wordpress.org/plugins/csv-importer/

Hierarchical taxonomies

The syntax for hierarchical taxonomies is more complicated. Each hierarchical
taxonomy field is a tiny two-column CSV file, where the order of columns
matters. The first column contains the name of the parent term and the second
...
Sample examples/custom-taxonomies.csv file included with the plugin

I suggest follow their document to setup your CSV file

#646027

Hi Luo, Thanks for your reply.
I posted my questions here 'cause this is one of 2 plugins recommended by you for importing csv files.
You also mentioned recently that toolset were in the process of developing a csv importer of their own, I believe this would be very useful to many toolset types users, can you give any indication about when we might see this included in toolset .
Thanks
David