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 comments

2 replies

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


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. 


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