Generating customized csv or .xls file

[uma17]

Hi All,

I have a requirement were I have to create a .xls/csv file with dynamic data.

Is there any specific template table where I can create a template and store the data? Else what should I do how to proceed?

Thanks,

Uma

[Joe McCarty1]

Depending on the complexity of the requirement, you may need to build a processor if you can't use the OOB CSV or XLS export processors.   That would allow you flexibility to script the dynamic response.   You can find an example of an export processor here (Beyond the Comma — File Export Delimiters | John Andersen )   some tutorials here (https://developer.servicenow.com/app.do#!/training/article/app_store_learn_integration_helsinki_c_Mo... ) and the API documentation here (Processor API components ) and here (Processors ).

Otherwise, you could create a custom table for reporting that meets your needs and generate the report into that table (which I'm guessing will be scripted based on your 'dynamic' requirement).   Then use the standard processors to export.   But if the structure itself is dynamic rather than just computed data, the first option is probably more suitable.

[uma17]

Thank you Joe.Will definitely try the option suggested by you.

Thanks,

Uma

[Ak Islam]

Hi Uma,

Any solution for this?

Thanks

AK

[M_rio Rui Castr]

Hello Uma,

I believe we can assist you on this. We work with templates and data exporting into Excel, Word or PPT. If you are still looking for a solution, please have a look at the following article: https://community.servicenow.com/community?id=community_article&sys_id=35679790db1bcc90414eeeb5ca961...

Kind regards,

MRC