Hi All! I have 3 saved searches in NS built that I...
# generalm
Manda
03/19/2021, 2:26 PMHi All! I have 3 saved searches in NS built that I'd like to be pulled from NS and saved in Excel format on our server. I want them to be pulled hourly and can simply replace the previous hours' document. These will serve as manual backups for our shipping department to utilize in the event of the NS going down in the evening so that orders can still be processed and go out. What would be the best method to make this happen?
k
KevinJ of Kansas
03/19/2021, 2:28 PMI'd be tempted to just email it on an hourly basis with a saved search to an inbox.
KevinJ of Kansas
03/19/2021, 2:28 PMand then there's no extra work - all native.
m
Manda
03/19/2021, 2:31 PMThat had been my first thought but I wasn't aware that you could schedule the saved searches hourly....just daily at a set time. Am I missing something?
k
KevinJ of Kansas
03/19/2021, 2:37 PMtime to copy searches 12/24 times to have it go daily at a set time. 2 hours.
time to develop script: 20 plus hours
It sucks. It's boring. It's tedious. Not fun to maintain, but it works.
KevinJ of Kansas
03/19/2021, 2:38 PMand you can do it in at least a 10th of the time - if not more efficient
m
Manda
03/19/2021, 2:48 PMHa! Lovely! OK, looks like this afternoon will be fun and exciting for me. Thank you!
k
KevinJ of Kansas
03/19/2021, 2:51 PMI would just make darn sure that my search was right before copying it that many times though haha
😆 1
KevinJ of Kansas
03/19/2021, 2:52 PM(to copy - change the name of the search and hit "save as"
c
Chris Corcoran
03/19/2021, 3:26 PM3 Views