Marc, In our case each scanned document has a corresponding line in a table that links the data to each scan file. In that table, it stores the date the file was created. When we need to retrieve a document, it pulls the date and then uses that to create the directory to look in .. Here is an example of the code where I just verify that the file exists. The BLNO is the unique number for each transaction and thus each document is stored using this number with the .pdf extension
SET VAR vScanDrive = 'T:\' DEBUG SET VAR vScanDrive = 'C:\Araho Scans\' SET VAR vSTranDate DATE = NULL SELECT trandate INTO vSTranDate FROM blading WHERE blno = .vBLNo SET VAR vScanTD = (.vScanDrive + FORMAT(.vSTranDate,'MmmYYYY')) SET VAR vScanFile = (.vScanTD + '\' + CTXT(.vBLNo) + '.PDF') SET VAR vFileCount = (CHKFILE(.vScanFile)) Now if the file exists I bring up a form that will load the scan into a pdfobject so the users can view, print or add to the scans along with the RBase data related to that scan. n Frank Frank Taylor - Information Systems Administrator F.J. O'Hara & Sons, Inc - Araho Transfer Inc. Boston, MA - Rockland, ME - Miami, FL Direct Dial - 617-790-3093 email: [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Sent: Monday, June 09, 2008 3:35 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Saving Scanned Docs Frank How were you retrieving the scanned files when it was slow? I am using a File List box and double clicking on the file. I am worried my users do not know enough about computers to save the file in the correct customer folder. Thanks for the help Marc ----- Original Message ----- From: Frank Taylor<mailto:[EMAIL PROTECTED]> To: RBASE-L Mailing List<mailto:[email protected]> Sent: Monday, June 09, 2008 8:50 AM Subject: [RBASE-L] - RE: Saving Scanned Docs Marc, We are scanning up to 5000 documents for our customers per month. Each one does have a unique identifier, but when we used to hold them in one folder we found speed in retrieving them was getting very slow. We now break them down by month/year and put them in the respective folder of their creation date. Since then things have gotten much faster and easier to pull up. So I would recommend some sort of breakdown scheme to store them into different folders. * Frank Frank Taylor - Information Systems Administrator F.J. O'Hara & Sons, Inc - Araho Transfer Inc. Boston, MA - Rockland, ME - Miami, FL Direct Dial - 617-790-3093 email: [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Sent: Monday, June 09, 2008 9:07 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Saving Scanned Docs HI I need to save about 4-6 scanned documents for about 5,000 customers Would it be better to create a folder for each customer such as c:\Scanned Files\Cust 123\ c:\Scanned Files\Cust 124\ c:\Scanned Files\Cust 125\ or Have all the scanned files in one folder ? Any suggestions on how to orginize 30,000 scanned files? I remember years ago there were limits to the number of files per folder but I have not heard anything about that the last few years Thanks Marc _______________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. If you need assistance, please contact the Systems Administrator, Frank Taylor at [EMAIL PROTECTED] - 617-790-3093. ** REMEMBER NEVER OPEN AN ATTACHMENT UNLESS YOU ARE SURE OF IT'S CONTENT AND SENDER ** _______________________________________________________________________ _______________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. If you need assistance, please contact the Systems Administrator, Frank Taylor at [EMAIL PROTECTED] - 617-790-3093. ** REMEMBER NEVER OPEN AN ATTACHMENT UNLESS YOU ARE SURE OF IT'S CONTENT AND SENDER ** _______________________________________________________________________
