Capture the data in the update set ?

HungMiju
Mega Expert

I have a lot of data in the table

when i move the update set to the new instance

I need to export these data to a file excel and then import it.

How can I capture it in update set?

 

Thanks.

5 REPLIES 5

Ashutosh Munot1
Kilo Patron
Kilo Patron

HI,

 

We can write a script to push your data to update set. But what i suggest is to take XML of that data and import it using import xml feature on each table. This table should be present in this instance when you import this table.

 

If you want to import using XML then right click on hearder of that report and at bottom you can find import xml option.

 

Thanks,
Ashutosh Munot

Hi Ashutosh 
Where can I find this code?

Mukesh Sharma
Giga Expert

there a small code that can capture the data in update set record by record. but the suggested way would be to do it by xml ( Insertion by XML wont run any business rule. you can use excel and data source if you want BRs to run  ) .

Hi Mukesh
Do you have the code with you?