I'm currently trying to do an import of custom location names via business adapter for flexera on prem. When trying to import the location names I am putting a / in the sub-level path, however, after being imported none of the locations are showing up nested. I can't do a bulk sql insert even though I am db owner. I've also tried nesting the location names in the csv itself. Anybody have experience with this?
Sep 02, 2022 04:01 PM
For the locations, make sure you are providing the full path with a leading slash, please.
I'm assuming that your data source looks like the following example CSV file, using a leading forward slash ('/') for the location path.
LocationName /Test/Sublocation A /Test/Sublocation B
When configuring the 'Name' target property of the 'Location' target object in Business Adapter Studio, make sure that in the 'Data Transformation' section, you have the forward slash ('/') character configured in the 'Split values on' configuration field please:
When importing your source data, Business Adapter Studio will create a location 'Temp' in the root, and 'Sublocation A' as well as 'Sublocation B' als children of the 'Temp' location.
Sep 04, 2022 12:22 PM
Thank you this looks really helpful. I will give this a shot when I have time later this morning.
Sep 06, 2022 09:06 AM
I had the same results with this, although it did update the description of the top level with a value from one of the sub-levels. Would you recommend making a field of arbitrary values for 'ID'? Not sure what the source value for that field should be.
Sep 07, 2022 10:40 AM
That should be it. When importing the data, any level of the '/folder1/folder2/folder3' path that does not exist yet will be generated.
Sep 07, 2022 11:53 AM
I believe my name location is correct. The ID field has a 'row number' option, but when selected it doesn't successfully run a query to Flexera.
Sep 07, 2022 02:41 PM
@StefanGrisham - Do not assign a value to the ID field, Flexera will set that automatically. Just leave it blank.
Sep 07, 2022 02:57 PM
There is nothing else to configure. Just import your source data.
Sep 07, 2022 10:46 PM