question Excel sheet data import to MultiRow variable Set in ITSM forum

Excel sheet data import to MultiRow variable Set

Geetha Lukka — Thu, 24 Feb 2022 07:06:12 GMT

How can we load data from excel sheet to Multirow variable set.

Re: Excel sheet data import to MultiRow variable Set

AnirudhKumar — Thu, 24 Feb 2022 07:13:02 GMT

Not possible directly.

A multi row variable set needs to have data entered manually and only stores data temporarily.

The excel load involves server side actions. Think of like this. There needs to be a feature that receives the excel sheet, then system has to attach the document in the Attachment table, then read data from the excel and finally do a redirect to your form containing the Multi Row Variable set. A Client script needs to re-populate the data in the Multi row variable set.

In short, it's possible, but involves bad UI and elaborate architecture

Re: Excel sheet data import to MultiRow variable Set

Sai Kumar B — Thu, 24 Feb 2022 07:16:34 GMT

@Geetha Lukka

It's possible with customization

1.) Create a UI macro and add it as variable

2.) When you attach the sheet click the Macro on the form the data will be populated into MRVS

You can refer to the @Kieran Anson response from this link - Attach csv to catalog item to populate a Multi-Row Variable Set (MRVs) and modify the script accordingly as per the columns in your excel sheet

Re: Excel sheet data import to MultiRow variable Set

Ankur Bawiskar — Thu, 24 Feb 2022 07:18:16 GMT

@Geetha Lukka

this article is worth checking; see if it helps you

Service Catalog - Import Spreadsheet Info Multi Row Variable Set (MVRS)

Regards
Ankur