Enterprise group upload (One-Off) Upload sample excel is needed

[Kevin_Hou]

Hello 

I am trying to use this feature to create enterprise group: eg - Locations with one or two level hierarchy. But what format of data in the excel sheet need to be followed? 

Does anyone can share a working sample sheet ( a few lines of rows) for me to test ?

Thank you in advance.

Best Regards

Kev

[kclausen]

By default, the Business Adapter users a "\" to delimit each level of the tree.  For example, if you submit a spreadsheet with the following rows:

North America\Canada\Montreal

North America\Canada\Toronto

North America\USA\Chicago

North America\USA\Atlanta

You will have a Location Tree Structure that looks like this:

North America

   Canada

      Montreal

      Toronto

   USA

      Chicago

      Atlanta

[Nico_Erasmus · Accepted solution]

Hi @Kevin_Hou 

See the attached sample fro upload via the data import function in the GUI.  It is important to load the parent level first.

Regards