excel data to multiple variable set

[Peter Xiang]

Hi, Now I have a batch upload requirement. In the record producer, the client upload a file of excel type, and we parse the file content into our multiple variable set in a certain way. In the background, we can mass-produce data. What's the solution?

[Community Alums · Accepted solution]

Hi @Peter Xiang ,

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 

This involves heavy customization:

this article is worth checking; see if it helps you

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

[Peter Xiang]

Hi @Community Alums ,

Thanks for your reply, that is my think, i want create onChange client script when excel is uploaded, call Ajax and get content of excel, and the put the content in the multiple variable sets, i will try it, many thanks.

[Community Alums]

Yes @Peter Xiang , you can try that.