Posted by Greg on 01/30/06 18:49

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

[Back to original message]