Hello,
I was looking for some advice on the best way to deal with thousands of files
(PDFs or TIF files of contracts and paper relating to the contracts) using
ColdFusion 5.0.
Here is the scenario: We are purchasing a sharp copy machine that is
networkable. One of the best features of this machine is that it will email
scans of documents to an email address. What I plan to setup is a system
whereby when a salesman brings in a contract, s/he puts it in the copy machine,
and sets it to email a copy of the document to an email address monitored by
ColdFusion. In the subject line, they will put in a unique ID for that
customer and possibly a description code (ie- Contract, Check, Material Order,
etc...). ColdFusion will pick up the email message, do something with the file
attached and pop at least the description into the database with the customer's
ID number to key it against the customer's record so that it could be retrieved
remotely as needed. The question I have is what is the best way to handle
those documents on the server? Should they be stored as files in a single
directory (Windows 2003 Server), should they be put in some kind of
subdirectory system, or should they be inserted into the database? If the
later, can anyone give me an idea or point me to a resource that would describe
how this is done with ColdFusion 5, as I haven't ever actually done any work
where files are kept in the database.
Thank you!
---------------------------------
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250706
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
