Export multi-row variable set to excel or csv?

[Brun]

Hi Experts,

I'm began using some MRVS within an item, and find that it's really difficult to read from the task or RITM form due to the amount of columns and rows getting added. Has anyone been able to export a MRVS to an excel file or csv and attach it to the RITM? 

If not, is there any way to make the table easier to read for the fulfiller? Even exporting to a PDF would be beneficial.

Thank you!

[Brun]

Hi @Brad Bowman  

Thank you for the solution, this is exactly what I was looking for! Unfortunately I'm having trouble trying to get this to work with a test MRVS I created - the csv exports the column labels, but it doesn't pull any values from the variable set.

Would you be able to help with an example script for the test I've setup to get a better understanding of how this should look?

I've created a simple MRVS with 3 columns.

Field 1 (field_1): Text Field

Field 2 (field_2): Select Box

Field 3 (field_3): Reference on sys_user table

I have the UI action running on the sc_task table.

Greatly appreciate your help with this.

Thank you,

[TJ29]

Hi Brun,

Did you manage to find a solution for this, afraid I'm only getting labels too.

Appreciate any assistance.

Thanks

Taylor

[TJ29]

@Brun  Managed to get this working by making sure the following line was specific to my MRVS variables and in the same order the labels appeared. 

mrvsexp.push(row.question_1 + ',' + row.question_2 + ',' + usr.name + '\r\n');

Thanks @Brad Bowman for this great solution!

[MB12]

Hi Brad,

Thank you for the solution, this is exactly what I was looking for! Unfortunately I'm having trouble trying to get this to work with a test MRVS I created - the csv exports the column labels, but it doesn't pull any values from the variable set.

Would you be able to help with an example script for the test I've setup to get a better understanding of how this should look?

I've created a simple MRVS with 3 columns.

Field 1 (field_1): Text Field

Field 2 (field_2): Select Box

Field 3 (field_3): Reference on sys_user table

I have the UI action running on the sc_task table.

Greatly appreciate your help with this.

Thank you,

[Feasood]

Giving this post a bit of a bump as I am trying to set it up but also only get the column headers appear in the CSV file that downloads.

Did anyone get this working so that the variables from the MRVS export to the CSV file?