Frank
I do something like that now and I let the user name the files JSmith123 and set
a filter for that in a file list box.
When I try to think this through I always find a snag that my users will trip
over.
Most of them don't know how to use a backup program.
Thanks Marc
----- Original Message -----
From: Frank Taylor
To: RBASE-L Mailing List
Sent: Monday, June 09, 2008 3:06 PM
Subject: [RBASE-L] - RE: Saving Scanned Docs
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
To: RBASE-L Mailing List
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.
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 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 **
_______________________________________________________________________
