- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2020 12:20 AM
We had a scheduled Export export which used to export all the incident table data daily at 6.00 am
so I have unchecked "Appended Timestamp" so every time new data will replace in the MID Server..
For first time export all the records, but from second time only new records need to export...so this I can do by taking records which are updated last 24hrs...but here my issue is for saturday and sundays records...because in those two days the end users will not take data from the mid server..
so can any one suggest some alternative for this?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2020 01:58 AM
Yes if they don't pick it up then they will miss as the file doesn't have timestamp and it will get overridden.
So now you have 3 approaches here
1) Inform them to pick the files on Saturday and Sunday as that is by their requirement that they required daily files to be pushed for records updated in last 24hrs
OR
2) Append timestamp so that file doesn't get overridden
OR
3) Approach 3
a) Don't run your existing Scheduled Data Export on Saturday and Sunday using the Condition script
b) Create fresh Scheduled Data Export and make it run Daily; This would only run on Saturday.
Create fresh export Target for this and create Folder for Saturday Export and give that path
You can handle this via Condition Script.
c) Create fresh Scheduled Data Export and make it run Daily; This would only run on Sunday.
Create fresh export Target for this and create Folder for Sunday Export and give that path
You can handle this via Condition Script.
Easiest approach is 1st or 2nd But check with your client and business team on this
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2020 12:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2020 01:22 AM
Hi,
So what is the issue?
You want to include records created on saturday/sunday or want to exclude that
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2020 01:46 AM
Hi @Ankur
I want to include Saturday and Sunday also...
I have selected Daily...so daily schedule will run...so same Saturday and Sunday schedule will run and the data will put into the mid server..
But for clients Saturday and Sunday they will not take data from mid server..
They directly takes data on monday...so there is a chance to losse the data on Saturday schedule..and Sundays schedule...
So I need those data also.....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2020 01:58 AM
Yes if they don't pick it up then they will miss as the file doesn't have timestamp and it will get overridden.
So now you have 3 approaches here
1) Inform them to pick the files on Saturday and Sunday as that is by their requirement that they required daily files to be pushed for records updated in last 24hrs
OR
2) Append timestamp so that file doesn't get overridden
OR
3) Approach 3
a) Don't run your existing Scheduled Data Export on Saturday and Sunday using the Condition script
b) Create fresh Scheduled Data Export and make it run Daily; This would only run on Saturday.
Create fresh export Target for this and create Folder for Saturday Export and give that path
You can handle this via Condition Script.
c) Create fresh Scheduled Data Export and make it run Daily; This would only run on Sunday.
Create fresh export Target for this and create Folder for Sunday Export and give that path
You can handle this via Condition Script.
Easiest approach is 1st or 2nd But check with your client and business team on this
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader