need some help with this solution...

I have a new client (an ag pesticide sprayer) and he has a piece of software that generates reports about all the chemicals that he sprays on any particular day. The reports are in .txt format. As an end result I need to take that .txt file and and

a) create an upload script for the .txt file

b) open and read the text file into an array ( implode() ?)

c) insert the text of that array into the database.

d) save the .txt file to another folder on the server to act as a back up should anything ever happen to the database.

e) create a user end that will allow clients to view which pesticides have been sprayed on which day, etc...

f) as a side note, if someone could explain a little about cron jobs, as i would want the database backed up nightly and have the db file emailed to my inbox. I've never dabbled with cron jobs so I don't know much about them.

Does this sound like the best way to do this? I was just going to store the .txt file in the database, but figured it may be to processor intensive when it comes to searching ALL the files which will grow to a huge amount over time. I would really appreciate any feedback on the above logic. Thanks in advance.

Greg
.

Relevant Pages

  • Re: Convert Access application to .NET?
    ... I am learning as I go and the client does not want to ... I had assumed that the instability came from the UI, not the database. ... do you know how Crystal Reports compares to the reports in Access. ... We decided to convert the whole app to .Net. ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: excel sheet creation??
    ... I still think you should add thise functionality in your database. ... Otherwise you have to store all the information in Excel also. ... > gets talks to the database - but the custom reports don't have all ... > client per hour - which is determined by the total fee we invoice to ...
    (microsoft.public.excel.misc)
  • Identifying Tables And Queries Used in Reporting Code
    ... I have developed a large system for a client based on ... reports that have been coded. ... It is a single user database and my clients ... documentation on which reports rely on which tables and queries. ...
    (microsoft.public.access.reports)
  • Re: Copying reports from one database to another
    ... you can EXPORT most any object to another database. ... REPORTS section and highlight a report. ... PLAN C: Copy and rename the entire database using windows explorer, ... We prepare 4-5 reports for each client. ...
    (microsoft.public.access.reports)
  • Re: need some help with this solution...
    ... > I have a new client (an ag pesticide sprayer) and he has a piece of ... The reports are in .txt format. ... Just searching on google for "php simple upload script" generates around ... > c) insert the text of that array into the database. ...
    (alt.php)