Import Functionality

[shivani42]

Hello All,

We have a requirement where a SAM_Admin user wants to import the data in user allocation & device allocation table. But a Sam admin can't be able to see the import functionality according to SN roles. Is there any way, we can give them the ability to import the data in these two specific tables. As it is very difficult to create an allocation records one by one manually.

Anyone has any idea?

Best,

Shivani

[dreinhardt]

Hi @shivani42,

to use the "Load data" one of the following roles is required "import_admin" or "import_set_loader".

Based on this setting, you can create your own data source and transform map to automate your allocation process.

As these two roles are not restricted and a user is allowed to run all other existing data sources, I would recommend to create a catalog item to allow your SAM users to request the allcations based on a template. The catalog item prevents the need to the discussed roles.

Best, Dennis

[shivani42]

Hi Dennis,

I have added these roles to the user but still he is not able to transform the data. He can see the modules but when he creates the transform map, he is not able to see source table filed. For example, he created a table testing and upload the file which he wants to import. When he come to the transform map page and try to map the filed. he can't see any fields in the source table.

Regards,

Shivani