To build a relationship with technical personnel help create and then distribute reports to our customers requiring ongoing support for updates and expansion of reporting suite.
My company has a number of computerised monitoring systems installed on a variety of heavy mobile equipment. The monitoring systems are programmed to capture information detailing the performance and utilization of the heavy vehicles. This information once captured is then transmitted to a central database over a mobile phone GSM network. We are then able to run reports from the database for our customers. The problem I face is that the database can only run reports using [url removed, login to view] to [url removed, login to view] as the cut off times. This has proved to be extremely limiting to our operation as we need the reports to show the information in a more production orientated format which would typically be two 12 hour periods between 6.00 am to [url removed, login to view] day and nightshift.
I need to have a script written that will automatically take raw data (Excel or csv are the available formats) from list reports sent every day to an outlook account, lay them into an Excel report template supplied by us or by whoever we use to do this and then distribute the subsequent reports again via outlook to our customer base. This whole process needs to be automated from a dedicated computer at our facility in Perth WA.
I hope this makes sense