How to export and import values/answers from a multi row variable set via XML?

[Phong Lo]

I'm trying to move values/answers from a variable set in a record producer from instance A to instance B by exporting and importing the data via XML, using data from the "sc_multi_row_question_answer" table, but the data isn't being populated in instance B. I'm not sure if this is the correct table. Additionally, I was given info that the data is essentially stored in a format of a UI macro to display the data. I don't have much experience in this. Any guidance would be great! Thank you!

[Ankur Bawiskar]

Hi,

what's the business requirement to move the variable data?

[Phong Lo]

This is for testing purposes from dev to test. Thank you.

[Tony Chatfield1]

Hi, unfortunately your post contains no clear details of your issue\the results of your upload attempt?

What exactly happened/what were the results of the xml upload?

I have just tested this between 2 instances for the table identified and xml file uploaded as expected.

Perhaps you can clarify your configuration\requirements?
Why are you uploading answer?, I cannot think of any value this would deliver unless you were moving them to a sub-production instance to assist with debugging?

Normally if creating/updating a record producer and\or its variables, the process would be to utilize an update set to move to another instance.

[Phong Lo]

Providing clarity. Below is a screenshot from a Record Producer in Instance A. Some text have been expunged due to customer confidentiality:

I want the above multi-row variable set data plus the UI along with its values/answers to be transferred to Instance B. When I export the "sc_multi_row_question_answer" table via XML from Instance A to Instance B... The results in Instance B looks like below:

You can see, nothing was carried over. I'm not sure what the issue is.

Please let me know if this provides enough details. Thank you for responding.