Import data through Excel Using Import option from Context n=menu

[ram11vrnr]

Hi All,

I want to import a data through excel format using Import option from Form Context menu. I'm aware using import set we can load data to any specific table.

But here i want ITIL user needs to Export data from table and made changes on the same and needs to upload ( import) the excel back to the table with the changes.

Please suggest how can i allow access to OOB "Import" form context menu to particular user for the particular table.

Table name : x_test

User role: ITIL

User is having export access but he doesn't have Import access. How can i achive and how can we provide access only to particular table (x_test)

[Sai Kumar B]

@ram11vrnr 

I would suggest you do the following

1.) Create a transform map at the backend

2.) Create a Catalog item for ITIL users

3.) Use workflow/Flow designer to run the transform map upon submission of catalog request
4.) Create a module under the application menu for ITIL users to redirect them to the catalog item directly

You can refer to the below link to run the data load via catalog item
Data load and transform via Catalog Item 

[ram11vrnr]

Hi,

Thanks for the reply.But i dnt want to use transform map. Kindly suggest me how can load data through Import option ( form context menu)

[Sai Kumar B]

Please try the following in your PDI first
1.) Click the context menu

2.) Choose the Import option

3.) And choose the below and import the excel directly