Issue with Scheduled Exports

[Sathwik1]

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?

[Sathwik1]

@Ankur Bawiskar 

Client will not accept for 1st approach.. 

we are using almost 10 tables so data will be more high...so I don't want to proceed with 2nd procedure..

so I will proceed with 3rd procedure...but can use please provide me script how to stop schedule export on Saturday and Sunday…

and for Saturday and Sunday I will proceed with what you have mentioned..

but here the issue is almost I am using 10 tables...

so I want to create 10 schedule exports for Saturday and 10 for sunday....so can you please suggest any other alternative? 

[Ankur Bawiskar]

Hi,

Since every table is different and you want for saturday and sunday you need to create those many scheduled data export

1 each for each table for saturday and 1 for sunday

Script to allow to run only on weekdays

answer = checkCondition();
function checkCondition(){

var d = new Date();
var dayOfWeek = d.getDay();

// exclude weekends
if(dayOfWeek != 6 && dayOfWeek != 7){

return true;

}

return false;

}

Script to allow only for saturday

answer = checkCondition();

function checkCondition(){

var d = new Date();
var dayOfWeek = d.getDay();

if(dayOfWeek == 6){
return true;
}

return false;
}

Script to allow only for Sunday

answer = checkCondition();

function checkCondition(){

var d = new Date();
var dayOfWeek = d.getDay();

if(dayOfWeek == 7){
return true;
}

return false;
}

Regards
Ankur

[Sathwik1]

Thank you @Ankur Bawiskar 

I will try with the above script..but I had a small query...

Where I am using separate schedule for saturday and sunday,..so I am having option to select Saturday and sunday..

Run : Weekly

Day : Saturday/Sunday so I can use that thing right? why again to write script for saturday and sunday?

[Ankur Bawiskar]

@Sathwik 

that's correct; then no need to script in condition field

For Saturday - Weekly and Select Saturday

For Sunday -  Weekly and Select Sunday

Regards
Ankur

[Ankur Bawiskar]

@Sathwik 

Let me know if I have answered your question.

If so, please mark my response as correct & helpful so that this thread can be closed and others can be benefited by this.

Regards
Ankur