**self-hosted organization*
I see the FILESAVE REPORT PATH in T_DEFAULTS, but here is the thing - Marketing wants there reports in one place, Finance another, Philanthropy another, etc. Can I make that happen? Are all the reports just going to be save in this location regardless of who scheduled it?
My over all goal is to automate saving the pdf to the location that they want.
Thanks,
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
Someone just suggested to me that I use command prompt to move files... sounds interesting and I am going to investigate. Does anyone have experience using that??
Ashley
"Command prompt" isn't really specific enough unfortunately, but what you could do is create a script (this could be a batch file, powershell script, or vbscript even depending on what you're most familiar with) that moves files to different locations based on a set of rules that you would program into the script.
Then you could use a scheduled task to periodically execute your script every n minutes, so that the reports are automatically moved to the desired folders.
If you wanted to get *fancy*, you could even have your script query the API to find out which user scheduled the request based on the request_no contained in the file name, and route the destination based on the user...
Going along with what Nick suggested, when our Consortium was self-hosted I had some batch scripts running in the backend to move extractions onto users' desktops. I believe I even shared the script to the Network years ago, and it was part of the Shared Reports section on the old TASK site, but I'm not seeing it on the new one. I may have missed it, though. At any rate, I'm happy to share the vb script with you, Ashley, just know that the script is at least 3 years old, and you'll definitely want to tweak it to work for your organization.
Katie,
That would be awesome! Can you email me the script at ashleye@slso.org? I am confident that we can make the necessary edits on our end.
Ashley, I sent the script to you. Let me know if you didn't get my email.
If anyone else would like to take a look, let me know and I'll send it along.
Got it! Thanks. It went to an folder in my Outlook account initially. I will look at this over the next few days and let you know if I have questions.
You guys... I just created my first .bat file. Yay!
It wasn't for this - it was to delete log files at a specific interval - but I am on my way to this now.
Progress. Slow going, but still progress.