Issue with Scheduled Exports

Sathwik1 · ‎11-28-2020

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?

Ankur Bawiskar · ‎11-28-2020

@Sathwik

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

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · ‎12-30-2020

Hi,

Let there be daily files with new timestamp.

You can have mid server script include triggered may be monthly etc to delete the files from that mid server folder location so that clean up is performed

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Sathwik1 · ‎01-21-2021

@Ankur Bawiskar

Small Query, please help on this....

If I am using "updated" field in the Export definition...then we will not delta export..right?

so what my question is...

I have daily export... today record 1 was exported...ok fine

after exporting... on record 1 someone have updated the comment...

then in tomorrow schedule will it get exported again?

if so....delta export also will work same as this...please help

@asifnoor @Ankur Bawiskar

Ankur Bawiskar · ‎01-21-2021

Hi,

points below

If I am using "updated" field in the Export definition...then we will not delta export..right? - correct

use either Enable Delta or Updated Condition

after exporting... on record 1 someone have updated the comment...

then in tomorrow schedule will it get exported again? - if the record got updated after the last scheduled export run then yes it will be included in the next export run

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Sathwik1 · ‎01-21-2021

Just a question... Assume I am exporting only 5 fields(number, item name, RITM number, RTSK) Assume after today's export..requestor updated the worknotes..(so it was updated today also after schedule...) Due to this it will appear in next schedule right? But in export we are not using so then end user many confuses right Ankur?

Ankur Bawiskar · ‎01-21-2021

Hi,

So if you are exporting 5 fields and after the last run any other field got updated other than those 5 then still it would be sent over.

So you need to discuss this with the business team which fields to be kept over.

Usually those fields which change/update frequently are sent over such as Assigned To, Assignment Group, work notes, etc

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader