CSV export

[Former Member]

I need to create a simple CSV file from an output using the BLS. Can anyone offer some guidance?

[Former Member · Accepted solution]

There are many ways to do that.

Please explain your requirement in detail.

If you are getting data from any query template add content-type=text/csv.

http://<server>:<port>/XMII/Illuminator?QueryTemplate=<TemplateName>&Content-Type=text/csv

You can use this with xacuteQuery as well.

Hope this will help!!

Thanks

Anshul

[Former Member · Accepted solution]

Bascially, I would use a query template to contain the data I wish to export, and I would need to take this data and save it as a csv file in a folder on the network somewhere. I am having trouble taking the data and converting it to csv. I want to be able to run this transaction as a BLS so there is no human interaction other than the user pressing a button on their UI.

[Former Member · Accepted solution]

Hi

In BLS call you query.

Use XSL Transformation action block.

Use URL = http://<server:port>/XMII/Stylesheets/IllumRowsetCSV.xsl

Pass query output as input and check for text output.

save this as csv file.

Thanks

Anshul