Support » Plugin: Import CSV or XML Datafeed With Ease » Custom taxonomy – hierarchical terms

  • Resolved Rayken

    (@rayken)


    Column A is the term parent
    Column B is the term child

    How can we associate a row in the CSV-file to belong to a parent term in col A and also be assigned to a child term seen in col B?

    As is right now, one can select one column to be a custom taxonomy term, unfortunately I don’t see how I can assign the hierarchy.

    Is this possible?

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

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author smackcoders

    (@smackcoders)

    To import the multi taxonomies through csv importer means the taxonomies should be separated with “|” symbols in your csv. EX:- ProPlugin | WordPress | CSVImporter.

    Thread Starter Rayken

    (@rayken)

    I don’t think you either understood my question or read it properly…

    I’m not talking about adding multiple taxonomies per se, I’m talking about adding hierarchical terms with the CSV importer using parent and children.

    So instead of assigning Post X to term A _and_ term B as you’ve described I would like to assign Post X to belong to child term B _under_ parent term A.

    So, instead of Term1 | Term 2 | Term 3 so perhaps a syntax such as Term 1 > Term 2 so that Term 1 would be parent of Term 2.

    Do you understand? I have a CSV with over 900 rows. About 300 belong to A1, 300 more belong to A2 and the last 300 belong to A3. ALL 900 belong to parent A.

    Example

    • (A): Cars (900)
    • (A1): BMW (300)
    • (A2): Mercedes (300)
    • (A3): Audi (300)

    Possible? If not, why not?! The entire idea here should be quite self explanatory. Dynamically assigning terms as parents or children using a markup relevant for it in the CSV. Having to have “created” all the terms prior to importing if not hundreds maybe even thousands of posts is simply out of the question. I think this plugin would benefit a lot of this added functionality if it does not exist. Make it a “Pro” feature if you feel that is what you want – I just need it to work!

    Plugin Author smackcoders

    (@smackcoders)

    The parent and child hierarchical categories import feature is not available in our free product.

    If you have the categories with parent and child hierarchical means you can just mentioned those in your CSV file. It will be assign those categories for the respective posts with those hierarchical.

    EX: Categ1 | Categ2 | Categ3 | Categ4 | Categ5

    Here,
    Categ1 & Categ3 are parent categories.
    Categ2 is child of Categ1 category.
    Categ4 is child of Categ3 category.
    Categ5 is child of Categ4 category.
    If you gave above mentioned example value to one of your post means, It will shown the hierarchical view as like below in your post edit view after imports get completed.

    View of assigned hierarchal Category:
    — Categ1
    — — Categ2
    — Categ3
    — — Categ4
    — — — Categ5

    Otherwise, The mentioned categories which is present in CSV will be created as new category without parent and child hierarchal like below.

    View of assigned non-hierarchical Category:
    — Categ1
    — Categ2
    — Categ3
    — Categ4
    — Categ5

    Thread Starter Rayken

    (@rayken)

    The parent and child hierarchical categories import feature is not available in our free product.

    Does this mean it will work in the bought (Pro) version? If so, how do I assign them without having to set them up prior to importing posts?

    I want the CSV to create the hierarchical terms for me. If that means I have to buy your plugin then so be it. The only assurance I need is that what I’m asking will work if I do.

    So does it? And if so, how does it work?
    Cat1 | Cat2 wouldn’t mean Cat2 is a child of Cat1 but a sibling. Cat1 > Cat2 | Cat3 (to me) would mean Cat1 is parent and Cat2 and Cat3 are both siblings and belong to Cat1 (parent).

    Plugin Author smackcoders

    (@smackcoders)

    Yes, the free edition doesnt have category import module. Only the pro edition have this feature also it works as follows

    Cat_Name
    First level 01
    First level 02
    First level 03
    First level 04
    First level 05
    First level 01 | second level 01
    First level 01 | second level 02
    First level 01 | second level 03
    First level 01 | second level 01 | third level 01
    First level 01 | second level 02 | thrd level 02
    First level 01 | second level 01 | third level 01 | fourth level
    First level 01 | second level 01 | third level 01 | fourth level | level 5
    First level 02 | second level 01
    First level 02 | second level 02
    First level 02 | second level 03
    First level 03 | second level 01
    First level 03 | second level 02
    First level 03 | second level 03

    So the parent should be in first lines and followed by their child to be nested properly. Only this pattern works with nested category import module. You can check this in our live demo here.

    Thread Starter Rayken

    (@rayken)

    I’ve tried your demo without any success. The terms are being added as parents, not as children. I also tried the “Custom Taxonomy” import feature to *only* import category parents and children – this also failing miserably.

    This is following your guidelines above.

    Here’s a dump of the CSV-file I’m failing with:

    ID;Group;k;p;Material
    4.8x18 AL/ST ELF16;BLINDNIT | STANDARD KULLRIG;2.5;27;AlMg3.5/Stål FZB
    4.8x20 AL/ST ELF16;BLINDNIT | STANDARD KULLRIG;2.5;27;AlMg3.5/Stål FZB
    4.8x22 AL/ST ELF16;BLINDNIT | STANDARD KULLRIG;2.5;27;AlMg3.5/Stål FZB
    4.8x25 AL/ST ELF16;BLINDNIT | STANDARD KULLRIG;2.5;27;AlMg3.5/Stål FZB
    4.8x28 AL/ST ELF16;BLINDNIT | STANDARD KULLRIG;2.5;27;AlMg3.5/Stål FZB
    4.8x30 AL/ST ELF16;BLINDNIT | STANDARD KULLRIG;2.5;27;AlMg3.5/Stål FZB
    2.4x6 AL/ST C;BLINDNIT | STANDARD FÖRSÄNKT;1.0;27;AlMg3.5/Stål FZB
    2.4x8 AL/ST C;BLINDNIT | STANDARD FÖRSÄNKT;1.0;27;AlMg3.5/Stål FZB
    2.4x10 AL/ST C;BLINDNIT | STANDARD FÖRSÄNKT;1.0;27;AlMg3.5/Stål FZB
    3.0x6 AL/ST C;BLINDNIT | STANDARD FÖRSÄNKT;1.0;27;AlMg3.5/Stål FZB
    3.0x8 AL/ST C;BLINDNIT | STANDARD FÖRSÄNKT;1.0;27;AlMg3.5/Stål FZB
    5.0x20 AL/ST C;BLINDNIT | STANDARD FÖRSÄNKT;1.5;27;AlMg3.5/Stål FZB
    5.0x25 AL/ST C;BLINDNIT | STANDARD FÖRSÄNKT;1.5;27;AlMg3.5/Stål FZB
    4.8x25 TAL/ST D;BLINDNIT | TRYCKTÄT KULLRIG;2.0;27;AlMg5.0/Stål FZB
    6.4x12.5 TAL/ST D;BLINDNIT | TRYCKTÄT KULLRIG;2.5;31;AlMg5.0/Stål FZB
    6.4x16 TAL/ST D;BLINDNIT | TRYCKTÄT KULLRIG;2.5;31;AlMg5.0/Stål FZB
    3.2x7.5 TAL/ST C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.0;27;AlMg5.0/Stål FZB
    3.2x9 TAL/ST C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.0;27;AlMg5.0/Stål FZB
    3.2x10.5 TAL/ST C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.0;27;AlMg5.0/Stål FZB
    4.0x9.5 TAL/ST C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.0;27;AlMg5.0/Stål FZB
    4.0x11.0 TAL/ST C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.0;27;AlMg5.0/Stål FZB
    4.0x12.5 TAL/ST C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.0;27;AlMg5.0/Stål FZB
    4.8x9.5 TAL/ST C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.2;27;AlMg5.0/Stål FZB
    4.8x11 TAL/ST C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.2;27;AlMg5.0/Stål FZB
    4.8x12.5 TAL/ST C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.2;27;AlMg5.0/Stål FZB
    4.8x14 TAL/ST C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.2;27;AlMg5.0/Stål FZB
    4.8x15.5 TAL/ST C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.2;27;AlMg5.0/Stål FZB
    4.8x17 TAL/ST C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.2;27;AlMg5.0/Stål FZB
    4.8x19 TAL/ST C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.2;27;AlMg5.0/Stål FZB
    3.2x6 TST/ST D;BLINDNIT | TRYCKTÄT KULLRIG;1.0;27;Stål FZB/Stål FZB
    3.2x8 TST/ST D;BLINDNIT | TRYCKTÄT KULLRIG;1.0;27;Stål FZB/Stål FZB
    4.8x14 AL/A2 D;BLINDNIT | TRYCKTÄT KULLRIG;2.0;27;AlMg5.0/A2
    4.8x16 AL/A2 D;BLINDNIT | TRYCKTÄT KULLRIG;2.0;27;AlMg5.0/A2
    4.8x18 AL/A2 D;BLINDNIT | TRYCKTÄT KULLRIG;2.0;27;AlMg5.0/A2
    4.8x21 AL/A2 D;BLINDNIT | TRYCKTÄT KULLRIG;2.0;27;AlMg5.0/A2
    4.8x25 AL/A2 D;BLINDNIT | TRYCKTÄT KULLRIG;2.0;27;AlMg5.0/A2
    3.2x7.5 AL/A2 C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.0;27;AlMg5.0/A2
    4.8x15.5 AL/A2 C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.2;27;AlMg5.0/A2
    4.8x17 AL/A2 C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.2;27;AlMg5.0/A2
    4.8x19 AL/A2 C;BLINDNIT | TRYCKTÄT FÖRSÄNKT;1.2;27;AlMg5.0/A2
    4.8x20 MAL/ST ELF16;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/Stål FZB
    4.8x24.8 MAL/ST ELF16;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/Stål FZB
    3.2x8 MAL/ST C;BLINDNIT | MULTIGRIP FÖRSÄNKT;1.4;27;AlMg2.5/Stål FZB
    4.8x12.5 MAL/ST C;BLINDNIT | MULTIGRIP FÖRSÄNKT;2.0;27;AlMg2.5/Stål FZB
    4.8x15 MAL/ST C;BLINDNIT | MULTIGRIP FÖRSÄNKT;2.0;27;AlMg2.5/Stål FZB
    4.8x17 MAL/ST C;BLINDNIT | MULTIGRIP FÖRSÄNKT;2.0;27;AlMg2.5/Stål FZB
    4.8x20 MAL/ST C;BLINDNIT | MULTIGRIP FÖRSÄNKT;2.0;27;AlMg2.5/Stål FZB
    3.0x8 MAL/A2 D;BLINDNIT | MULTIGRIP KULLRIG;1.4;27;AlMg2.5/A2
    4.0x17 MAL/A2 LF12;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/A2
    4.0x20 MAL/A2 LF12;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/A2
    4.8x10 MAL/A2 LF14;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/A2
    4.8x12.5 MAL/A2 LF14;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/A2
    4.8x15 MAL/A2 LF14;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/A2
    4.8x17 MAL/A2 LF14;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/A2
    4.8x20 MAL/A2 LF14;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/A2
    4.8x10 MAL/A2 ELF16;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/A2
    4.8x12.5 MAL/A2 ELF16;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/A2
    4.8x15 MAL/A2 ELF16;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/A2
    4.8x17 MAL/A2 ELF16;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/A2
    4.8x20 MAL/A2 ELF16;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/A2
    4.8x24.8 MAL/A2 ELF16;BLINDNIT | MULTIGRIP KULLRIG;2.5;27;AlMg2.5/A2
    3.2x8 MAL/A2 C;BLINDNIT | MULTIGRIP FÖRSÄNKT;1.4;27;AlMg2.5/A2
    3.2x9.5 MAL/A2 C;BLINDNIT | MULTIGRIP FÖRSÄNKT;1.4;27;AlMg2.5/A2
    3.2x12.5 MAL/A2 C;BLINDNIT | MULTIGRIP FÖRSÄNKT;1.4;27;AlMg2.5/A2
    4.0x9.5 MAL/A2 C;BLINDNIT | MULTIGRIP FÖRSÄNKT;1.7;27;AlMg2.5/A2
    4.0x12.5 MAL/A2 C;BLINDNIT | MULTIGRIP FÖRSÄNKT;1.7;27;AlMg2.5/A2
    4.0x17 MAL/A2 C;BLINDNIT | MULTIGRIP FÖRSÄNKT;1.7;27;AlMg2.5/A2
    4.8x10 MAL/A2 C;BLINDNIT | MULTIGRIP FÖRSÄNKT;2.0;27;AlMg2.5/A2
    4.8x12.5 MAL/A2 C;BLINDNIT | MULTIGRIP FÖRSÄNKT;2.0;27;AlMg2.5/A2
    4.8x15 MAL/A2 C;BLINDNIT | MULTIGRIP FÖRSÄNKT;2.0;27;AlMg2.5/A2
    4.8x17 MAL/A2 C;BLINDNIT | MULTIGRIP FÖRSÄNKT;2.0;27;AlMg2.5/A2
    4.8x20 MAL/A2 C;BLINDNIT | MULTIGRIP FÖRSÄNKT;2.0;27;AlMg2.5/A2

    So when importing this data I would obviously like BLINDNIT to be the parent and everything after to be children of this parent. It doesn’t matter how much I try, it simply won’t work. Can you explain more thoroughly how this is meant to work!?

    As said, I can’t make the terms prior to importing the posts. I need the CSV to create the terms with their hierarchy intact!

    Plugin Author smackcoders

    (@smackcoders)

    This is identified as feature conflict will be fixed in upcoming release. You can expect this fix with other features in upcoming version. Will update you once demo get updated.

    Did this ever get addressed? I’m trying to do the same thing – import hierarchical categories, tags or custom taxonomies.

    I want to buying a BMW X7 but i can more about it, please share with me. thank you so much

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Custom taxonomy – hierarchical terms’ is closed to new replies.