Need to create multiple requests from excel attached

[Pallavi65]

Hi all,

There will be an excel file attached to an incident via Inbound email action. That excel consists of 3 columns

Server, Application and Group.

For example, there are 5 rows in that excel and there are two applications that are in common.

1. Server1, App1, Database group

2. Server2, App1, Database group

3. Server3, App2, Database Group

4. Server4, App3, Infra Group

5. Server5, App4, Logistics Group

So, here the first two records have same application name. So, from this excel I want to create 4 requests automatically. In the first request, the short description should have Application name and the description should have the two servers. And the separate requests for other rows of the excel and they should be assigned to the assignment group mentioned in the third column.

So, in one word, for every one application one request should be created.

Please tell me how can I get this?

Thanks in advance.

Regards,

Pallavi

[Pallavi65]

Hi Saurabh,

As I discussed earlier about the requirement, I create 3 variables in a catalog item. Server, Application and Assignment Group. But please tell me how can we achieve the requirement from here?

Regards,

Pallavi

[Saurabh Gupta]

Give me the fields of your import set table (manual fields)

[Pallavi65]

Hi Saurabh,

The fields on import set table are, 

u_server

u_application

u_assignment_group

Regards,

Pallavi