how to export data in CSV file?

[nadeem_khan5]

I am a beginner in MII and doing a task in wgich I need to export my data from table as CSV format, can any one help me out with the same?

for that I am creating a BLS

in BLS calling my SQL Query

Using  XSL Transformation action block.

now how to do linking and further process to take done??

[Former Member · Accepted solution]

Hi Nadeem,

If it is not required for your project, I guess you have no need to put any XSL action block to get csv output. After SQL query, just put a assignment action block and pass the SQL output to a Output parameter defined in transaction properties with data type XML. and now simple call the execute query containing that BLS from UI with Content-Type=text/csv. So you will get the csv output of that query.

Hope it will help you.

Regards,

Suman

[nadeem_khan5 · Accepted solution]

Thanks for your solution Suman

[Former Member]

Hi Nadeem,

MII has file related action blocks in File I/O category.

Assuming that you have created the data, use the Write File Action block to write the data into a file.

Regards,

Rohit Negi.