|
21 May 2003, 15:15
|
#1
|
Clerk
Join Date: Jun 2001
Posts: 13,940
|
Tech Recommendation
I have two sets of reports, which are currently run daily.
One is a special phone system report, which produces graphs on how many calls (in a call centre type environment) are taken each day, who by, etc, etc. This program produces a report which can then be printed or saved in .CSV format. The data kinda looks like this (in the CSV file):
"Ext#", "Name", "Date", "CallsTaken", "BreakTime", "WorkTime", "Blah"
The second report logs how many particular tasks a user has done (e.g. repairs raised or whatever). The results of this report can be outputted to Excel and then saved as whatever you like. The report will look like :
John Smith, 21
Tom Brown, 12
etc.
Now, at the moment both reports are printed and then the numbers transferred manually into a spreadsheet which records the daily record. Stupidly inefficient obviously.
What tech would you recommend using to try and streamline this somewhat? Please bare in mind that the people doing this aren't exactly computer experts, so that limits it somewhat. Also a purely windows environment, and there's a limit to what they could do on a daily basis.
Two thoughts I had :
1. Get them to run the reports as normal, save the contents into a set directory. Then have a specific Perl script to parse the sets of data and combine them in one .CSV (or whatever).
2. They do have an internal intranet which I could use to do an .ASP style "battlecalc" (i.e. they simply paste the reports in, and then it puts it into a seperate access file).
|
|
|
21 May 2003, 18:38
|
#2
|
Xenoc
Join Date: Feb 2001
Location: Great Britain
Posts: 297
|
Well, excel will open a csv file.
If you want some automation then I agree, perl is very suited for that.
You can either do the sums in perl or use formulas. Formulas go in in the usual way. Use tab as field separator and give the output file a .xls extension and all you have to do in excel is formatting (or copy the content into an already formatted spreadsheet).
I've done similar things before, the excel spreadsheet version of the stats (posted here) is generated from the published stats using a perl script.
|
|
|
21 May 2003, 23:30
|
#3
|
Proud ex EnTitY bc
Join Date: Jan 2003
Location: cornwall, england
Posts: 244
|
what about using xml?
|
|
|
22 May 2003, 09:56
|
#4
|
Clerk
Join Date: Jun 2001
Posts: 13,940
|
Quote:
Originally posted by virogenesis
what about using xml?
|
Well, I'd need to parse the existing data (i.e. from the reports) into XML and then present the XML somehow - so I'm not sure how that helps my problem.
If this was something from home, I'd simply use PHP to present the data (kinda like Pilkara) using a MySQL db as a backend. However, I don't have access to either PHP or MySQL so I'm looking for the easiest alternative.
And yes, I can use Excel to open up .CSV files, but the key is automation. These people run the reports every day, and a solution which requires too much effort/thought is doomed for failure. The weakness of simply building a Perl parser is (a) I don't know Perl yet, (b) parsers can be easy to break, and I'm not sure how I could make it "user friendly" or adjustable.
|
|
|
22 May 2003, 10:10
|
#5
|
Xenoc
Join Date: Feb 2001
Location: Great Britain
Posts: 297
|
Quote:
Originally posted by Dante Hicks
... I can use Excel to open up .CSV files, but the key is automation. These people run the reports every day, and a solution which requires too much effort/thought is doomed for failure. The weakness of simply building a Perl parser is (a) I don't know Perl yet, (b) parsers can be easy to break, and I'm not sure how I could make it "user friendly" or adjustable.
|
Well, I learned perl while doing a project for a friend.
Quote:
Excertp from the "Manual"
Put the log file to be processed in <dir>, make sure it has a .<ext> extension.
Double-click the parse.pl script.
The script asks for the name of the log file (the name includes the extension).
Default value is the most recent file with a .<ext> extension that has not yet been processed.
etc.
|
Apparently the script is now in production...
|
|
|
23 May 2003, 15:58
|
#6
|
Throwing Shapes
Join Date: Apr 2000
Posts: 797
|
Quote:
Originally posted by Dante Hicks
And yes, I can use Excel to open up .CSV files, but the key is automation.
|
In that case wouldnt an Excel Macro make sense?
|
|
|
24 May 2003, 03:26
|
#7
|
Clerk
Join Date: Jun 2001
Posts: 13,940
|
Quote:
Originally posted by CjC
In that case wouldnt an Excel Macro make sense?
|
Is that likely to have a lot of flexibility? I've never used Excel macros for anything beyond ridiculously menial tasks.
This would need to handle changes in personnel, plus other random changes.
|
|
|
24 May 2003, 11:08
|
#8
|
Bitch
Join Date: Jun 2002
Location: North Yorkshire
Posts: 3,848
|
Quote:
Originally posted by Dante Hicks
Is that likely to have a lot of flexibility? I've never used Excel macros for anything beyond ridiculously menial tasks.
This would need to handle changes in personnel, plus other random changes.
|
You can do some fairly serious stuff with VBA these days
__________________
ACHTUNG!!!
Das machine is nicht fur gefingerpoken und mittengrabben. Ist easy
schnappen der springenwerk, blowenfusen und corkenpoppen mit
spitzensparken. Ist nicht fur gewerken by das dummkopfen. Das
rubbernecken sightseeren keepen hands in das pockets. Relaxen und vatch
das blinkenlights!!!
|
|
|
25 May 2003, 23:40
|
#9
|
/dev/zero Retired Mod
Join Date: May 2000
Posts: 415
|
__________________
#linux : Home of Genius
<idimmu> ok i was chained to a desk with this oriental dude
|
|
|
28 May 2003, 10:35
|
#10
|
Registered User
Join Date: Jan 2003
Posts: 340
|
The easiest and most sensible would be a VBA script to parse the .CSV files and input them into the spreadsheet.
|
|
|
28 May 2003, 20:15
|
#11
|
/dev/zero Retired Mod
Join Date: May 2000
Posts: 415
|
Quote:
Originally posted by Not_RIT
The easiest and most sensible would be a VBA script to parse the .CSV files and input them into the spreadsheet.
|
in some alternate universe where easy means hard and hard means easy?
__________________
#linux : Home of Genius
<idimmu> ok i was chained to a desk with this oriental dude
|
|
|
|
All times are GMT +1. The time now is 21:14.
| |