Skip to main content
Solved

Export XML file


Forum|alt.badge.img+4

Hi,

Is it possible to gather data then generate, export and download an .xml file by executing a task in Web GUI?

Thanks!

Best answer by Marvin Alibahadoer

Hi,

 

You can create a task and do select statement of the records you would like and use XML path to create the XML. If you want to create a .xml file of the result you could convert the result to a varbinary(max). We use a similair task and save the varbinary to a new record in a table that holds exported files so the user can download the file from the application. Alternatively, you could probably save the file on a storage location.

Hope this helps!

Marvin

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

2 replies

Forum|alt.badge.img+4

Hi Marvin, 

I have tested this with some dummy code and does work! Thank you!
Although the automatic download is not achievable (as far as I tried), but I can at least generate a .xml file. 


Hi,

 

You can create a task and do select statement of the records you would like and use XML path to create the XML. If you want to create a .xml file of the result you could convert the result to a varbinary(max). We use a similair task and save the varbinary to a new record in a table that holds exported files so the user can download the file from the application. Alternatively, you could probably save the file on a storage location.

Hope this helps!

Marvin


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings