topic RE: How to export XML-file including data in Product Forum

How to export XML-file including data

Christian_Brand — Fri, 30 Aug 2019 08:33:00 GMT

Hi,

I need to export a XML-file containing all field names and rows from a specific collection.
So far I exported the page using File>Export>Page/Object. However, it does not contain the data from the collections.
Therefore my developer will not be able to help me out writing a code stage, that will help me fix my original problem.

The XML utility does not seem to be helpful in this situation either.

Any suggestions?

Best regards

/Christian

------------------------------
Christian Brandt Larsen
RPA Developer
Forca A/S
Europe/Copenhagen
------------------------------

RE: How to export XML-file including data

JerinJose — Fri, 30 Aug 2019 09:09:00 GMT

Hi Christian,

if its a user defined collection that has fields and values prepopulated all of these will be will be part of the xml file exported using File>Export>Page/Object. however if the collection is getting value when a process/object is excecated those values will not be part of the export.

------------------------------
Jerin Jose
RPA Product SME
EY
Asia/Kolkata
------------------------------

RE: How to export XML-file including data

Christian_Brand — Fri, 30 Aug 2019 09:26:00 GMT

Hi Jerin

The collection is populated by data retrieved from a queue using VBO Queue Reports ´Get data from queue´. I suppose that means that those values will not be part of the export.

In that case, maybe I can create a dummy collection containing the same fields and values as the collection and make my export on the basic of that.

I´ll try.

Thanks

------------------------------
Christian Brandt Larsen
RPA
Forca A/S
Europe/Copenhagen
------------------------------

RE: How to export XML-file including data

Anonymous — Fri, 30 Aug 2019 09:56:00 GMT

Have you tried Utility - XML?

------------------------------
Ionut Cohen
RPA Developer
Luxoft Romania
Europe\Bucharest
------------------------------

RE: How to export XML-file including data

GopalBhaire — Sat, 31 Aug 2019 10:48:00 GMT

I don't really understand the question, but I assume you're trying to output the collection as XML. If so you can loop over the collection and use a multicalc to generate the desired XML.

OR you can use code stage with collInput (collection) as input and xmlResult (text) as output.

Dim sw as Object
sw = new StringWriter() 
collInput.WriteXml(sw)
xmlResult = sw.ToString()

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------