Generate txt file on ServiceNow with user records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2019 12:33 AM
Hello everyone,
I should create a .txt file (as attachment) that contains user records with current columns:
Username,Created_date, "U" (static char)
Note: must be comma separated.
I have to generate the file everyday at 8.00PM.
Could I use a scheduled job script?
Thanks.
Gaetano
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2019 12:48 AM
Hi Gaetano,
.txt export format is not supported OOB.
You will find below post helpful.
https://community.servicenow.com/community?id=community_question&sys_id=5f360ba1db1cdbc01dcaf3231f961928
Regards,
Adilakshmi

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2019 12:50 AM
Yes, you can use a scheduled job to run every day at 8.00 pm and call the script from there.
However, there is no direct txt export available. why don't you export to csv and then convert to txt from there?
Mark the answer as correct/helpful if this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2021 03:18 AM
Hi Asifnoor,
Can you please help me with sample script for converting csv to txt after export?
Thanks!