import to category

4 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: July 12, 2023   (RSS)

By ht1080z - July 11, 2023


To import records to category, do I need to prepare all the fields in csv, like: 

globalOrder, siblingOrder, lineage, depth, parentNum, breadcrumb  ?

In the excel I working only have the parentNum the other fields is very messy to create manually.

Is there any help  to make this easier?


By ht1080z - July 12, 2023

Hi Dave,

I imported the records with empty lineage and breadcrumb (these 2 fields was required) for the first level. I changed the order manually from cmsb and the records for the special category fields (globalOrder, siblingOrder, lineage, depth, parentNum, breadcrumb) are generated.

After that I imported the second level records again with empty lineage and breadcrumb but with parentNum and after I changed the order for one record again and everything regenerated again filling the fields as needed.

Thank you for your help on this!

By Dave - July 12, 2023

Great!  Glad to hear it's working.  Thanks for the update. :-)

Dave Edis - Senior Developer