cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

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

(Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".)
(1) 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

View solution in original post

(2) Replies

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

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