Notifications
Clear all
Topic starter
Does anyone know if it is possible to schedule reports (aging, billing, etc.) to run after-hours? Any command line options available with the CPS client that might help me accomplish this?
Thanks,
Chris
Posted : August 15, 2012 2:37 am
Going to bump this up, I need to do this. I have a crazy plan of recording clicks to do it for me. However since the end of month reports take our billing department 4 people over 2 days we could save a lot of time with some automatic scripting tools.
Posted : January 14, 2013 2:37 am
So I dove into this knowing that it takes about 4 people 3 days to run our end of month reports. I am not a very good programmer, but what this does is a keyboard macro to print the reports to pdf.
You can start this process and let it run it will run over night:
Documentation:
I use an application called Auto-Hot Key, what it does is
runs a script that reades the title bar and matches it to a list of reports.
c:\list.txt If the title bar matches the report it goes through and then exports
using the cute pdf. Then starts the loop over to go to the next line of list.txt
Points that are important
- You have to have centricity already open and
at the monthly reports folder selected
- Cute writer has to beinstalled
- the list has to be in c:\list.txt
- The list alphabetical, so it may
skip a lot of reports to get the one on the list
- You cannot have empty report folders within centricity
Send me a msg, and I will shoot you my script. I cannot figure out how to attach files, maybe I am too new of a member.
Posted : January 15, 2013 11:39 pm
Topic starter
I'll have to take this technique up to my manager. In general I can't implement a solution with third party software, it would have to be native to GE.
I think it's a cool solution though...
Thanks,
Chris
Posted : January 16, 2013 1:06 am
I agree it is third party, but it is just a keyboard macro script.
It is essentially just a series of keystrokes with some IF statements and a list of reports to run.
If GE had an option for this, I would have not wrote it. I just asked our billing manager said 7 people 8 hours to run our end of month reports.
When you are ready send me a pm, I will send you my script.
Posted : January 16, 2013 1:10 am
Chris, you should be safe to use 3rd party solutions such as the one chews has mentioned. We use a few 3rd party applications on our dts. One runs a script to close the dts, then reboots the machine. We have a 3rd party scheduling software that runs a script that I built using AutoIt that does mouse clicks to open up a socket on a custom interface to our local hospital. This allows us to reboot the dts daily without any intervention by us.
Posted : January 16, 2013 3:25 am
