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
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
There is nothing else to configure. Just import your source data.
Sep 07, 2022 10:46 PM
Even, I'm working on similar requirements but still, the location is not created with a proper
hierarchy. I'm uploading two locations /INDIA/CITY, TOWER 2/SOUTH/6/S6-319/ and /INDIA/CITY, TOWER 2/SOUTH/6/S6-320/ but it creates a single record for each level and it doesn't nest.
I'm attaching a screenshot of my adapter configuration and the output of the web UI
Jul 26, 2023 10:47 AM
I think I could simulate your issue. I see from your screenshot that the "ID" under location is not set.
In contrast, when I create a fresh Business Import, it looks like this:
With this in the import, it works just fine:
Jul 27, 2023 04:36 AM