Hello and good week everyone!
Here is my "other" headache.
I am consulting for a client and building Reporting System for them.
Client using People Soft query downloaded to Excel file. Every time whoever runs those queries saves them on Share Drive with whatever names(Dates) in whatever format they wish.
Imagine there are Excel files saved in directory as
abc-12012004.xls
abc_1/12/05.xls
abc122320004 etc.
And every pay/period it adds up.
So I can ask Client to use naming convention, but how am I suppose to control it when I am gone?
Plus people will come and go and here is no IT people to check on it or fix it if broken.
Then how am I suppose to find new file if I don't know (it is not set) what date does it have?
I need to come up with whole System Idea and I can't because all this is a nightmare (datawise...lol)
Let say I allocated file on Share Drive and told to save Excel files into it. How will I be able to find the newest one and extraction is going to have to be done using Wizard, right? hmmmmmmmmmmmmmmm
My Reports are suppose to be run using those Excel files. I am Importing them into Access97 database and creating Reports.
For now i am using latest files they have but in future when I am gone - they will have to be able to run those Reports themselves. When I got here I had no idea that data for my Reports going to be this type so I am totally unprepared what to do.
Please, advice
Here is my "other" headache.
I am consulting for a client and building Reporting System for them.
Client using People Soft query downloaded to Excel file. Every time whoever runs those queries saves them on Share Drive with whatever names(Dates) in whatever format they wish.
Imagine there are Excel files saved in directory as
abc-12012004.xls
abc_1/12/05.xls
abc122320004 etc.
And every pay/period it adds up.
So I can ask Client to use naming convention, but how am I suppose to control it when I am gone?
Plus people will come and go and here is no IT people to check on it or fix it if broken.
Then how am I suppose to find new file if I don't know (it is not set) what date does it have?
I need to come up with whole System Idea and I can't because all this is a nightmare (datawise...lol)
Let say I allocated file on Share Drive and told to save Excel files into it. How will I be able to find the newest one and extraction is going to have to be done using Wizard, right? hmmmmmmmmmmmmmmm
My Reports are suppose to be run using those Excel files. I am Importing them into Access97 database and creating Reports.
For now i am using latest files they have but in future when I am gone - they will have to be able to run those Reports themselves. When I got here I had no idea that data for my Reports going to be this type so I am totally unprepared what to do.
Please, advice
