c0z420

Ok...i have a little dilemma here @ my job that i'm trying to figure out how to solve. So here goes...

We run a job in a Reflections Session that produces reports. After they are finished the reports are tranfer out of their to a place on our network in "txt" documents. We then run a program that will post them on a part of our Intranet for our business office to view. The problem is, we (Computer Operators) @ night have to look @ about 3 of the reports and make sure there are No errros between figures. So for example we have a Beginning AR, a Net Change, and an Ending AR on one report that we have to actually open an EXCEL document and put those figures into. WE have to do this for a few other reports into another excel document. The thing is, we would like to Automate this somehow that it can check to see if there are any Errors in Figures and then post them into an excel or even access database automatically for archiving. Any suggestions...??? At our last meeting one of the guys suggested doing it all in VB. I tried doing Macros in Excel and tried fiddling with Access but it really wasnt working much. Let see how many ideas we can get flowing, i'll take any suggestions.

Ghost

Hire a good programmer. (Answer to your titled question)

c0z420

WE have programmers, i wanted to be the one to rise a lil above my job to maybe actually get ahead. I've been reading up on programming and I want to do more of it.

Ghost

What type of programming, because you cant just know vb and expect to program it all in C++

MegaArcon

I think you may be posting this in the wrong section. :p Do you want this to be a web interface? Even if you do, this seems more like a server side thing then a client side. A language like Python might be better. (A language which has gone on my top 5 list as of the last year or so. ^_^ )

Although given the nature of the problem, a web interface seems kinda silly. Wrighting in a high level language to make some sort of command line driving program seems best to me. (Of course I'm living in a Linux world. Mabye the people at your work place would like some sort of GUI to work with in Windows? )

Although Ghost brings up a good point. What languages ARE your programmers fimiliar with? That's a good place to start to figure out what to write the app in.

c0z420

I can program in C++, VB or ASP.net .....just tryin to get Ideas from everyone of what would work best.

c0z420

The problem with this is, theres alot of data that we really dont need in these output files....we only need like 1 line of data out of like 5-6 pages of reports. So i'm just wondering how we can get the numbers we want from the reports....compare the numbers....make sure there are no errors in the figures....which means that the difference will be 0, and the last report u compare 3 differnt reports and make sure all the grand totals match and are the same value. That really what i need to have with this project.

Ghost

ASP.NET wont do you any good because its not web. C++ is a lot of work for something so simple I think (Not a C++ Programmer) I'd say use a quick crappy VB App to parse some strings.

__________________
People who click "images" that end with .exe shouldn't have computers.

c0z420

Thats what i would probably have the easiest access to its VB over anything else.

Infinite Recursion

I'd go with C# and/or Perl.

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."