Building a customized file exporting format

[Admin Pro]

We are asked to build a file extension format other than .CSV, .XML and other formats available from SN. I have spent quite sometimes to figuring out how these OOB formats are being build and what are the ways for us to build a custom version, but have had no luck so far. So I am asking here to see if anyone has any experience on this and can guide us to the right direction. Any help is greatly appreciated. Please let me know if any one needs more information.

[john_andersen]

I did something similar at one time. I created a way to export data from servicenow in a type of CSV format, but with any delimiter that you want.

Here is how I did it:
http://www.john-james-andersen.com/blog/service-now/beyond-the-comma-file-export-delimiters.html

Not sure it will address what you want to do exactly, but will give you a perspective on where I took things.

[Admin Pro]

John,
Thank you for the link. This is excellent. I have a few questions:
1- Can I use the same script, but instead of JSON plugin with Scheduled Data Extract solution form SNguru?!
2- If the answer is yes, then does the script will be included in the Processor script?! if not, then where would be the script placed to generate an export file with custom extension and delimiter?!

Once again thanks for providing feedback.

[john_andersen]

Yes, you can use this in conjunction with the Scheduled Data Extract. I have actually done this before. You will use the same processor as created in my blog. You would just need to modify the Scheduled Data Extract to include the Processor you created.

In order to do this, I believe all you need to do is Personalize the Choices on the "Format" field in the Scheduled Data Extract to include your processor.

[User150433]

Custom processor can not be used for extracting reports as it uses JSON and it is only applicable for table extracts. Any thought for extracting reports in custom delim?

Amit