Practical Programs

rdhuntley

I have installed FolderWatch (Pro V143) on a fairly hefty server. (dual quad-core 2.8 processors, 4 Gig RAM, Win2K3 Server) I see each instance is a new service, how many instances can I expect to run? The server is also the DvTDM server, should we have a dedicated server for FolderWatch?

rdhuntley · Posted: Mon Jun 02, 2008 4:30 pm Post subject:

Has anyone used multiple instances in FW? And if so does anyone have a feel for quantity of instances limitations?

Thanks,

RD

justin · Posted: Mon Jun 02, 2008 7:50 pm Post subject:

The most instances we know of FolderWatch being used on a server is four.

The only time you would need a different instance is if you are importing into different databases, or different data structures (form designs).

The FolderWatch instances would not be the limiting factor, it would be the AppConnect instances, which FolderWatch uses to connect to the databases.

rdhuntley · Posted: Mon Jun 09, 2008 1:00 pm Post subject: Dv Folder Watch Support Request

Justin,

Thanks for the response. The specific solution that we are attempting to address for a client is that they have a single database, but want to scan documents for various projects and want records for those documents to automatically be populated with a project number. We intend to configure the Dv FW database entry to have a static project number.

In this case, the end user will need an instance for each Project the company is involved in.

They want an on-going solution so that project reps can scan files into predetermined folders, then Dv Folder Watch can index the files by the links establish in the set-up of each instance (one for each project).

They do not/cannot use csv files to map database field links for each project (total 100+ projects).

The way I understand this situation I will need to set-up a separate instance for each project so that I can map database field links under database configuration for each instance.

Any recommendations would be greatly appreciated.

Thanks,

RD

justin · Posted: Tue Jun 10, 2008 1:59 am Post subject:

Setting up 100 FW instances is not going to be viable.

Is it possible to determine what project a document belongs to once it has been imported into Dv TDM? Say from it's filesname? Perhaps the scanning software could do that.

There are breakpoints that could be used to look at the file coming in from FW, and set the database field values accordingly, so you don't need to configure a FW instance to set field values.

rdhuntley · Posted: Tue Jun 10, 2008 6:55 am Post subject:

Thanks again for the input. You have an excellent idea regarding breakpoints; we will look down that avenue since an instance for each project is not viable.

rdhuntley · Posted: Fri Jun 27, 2008 7:56 am Post subject:

Instead of setting up an instance in FW for each Project, I'd like to have FW watch one folder, then set-up sub-folders for each Project.

I do not seem to get any data from the 7 breakpoints listed here:

http://www.practicalprograms.net/forum/viewtopic.php?t=260

I have looked at UserValue1 & UserValue2 collected from these BPs with no joy.

Where can I collect the path that says which sub-folder FW is importing a file from?

Thanks,

RD

justin · Posted: Wed Jul 02, 2008 9:35 pm Post subject:

In the AppConnect - After Document Saved breakpoint you can find the name of the document that has just been processed by FolderWatch / AppConnect

eg

Application.DebugMessage "processed " & Database.ImageFileName

Note this will give you the path to the file that was added, not where FolderWatch found it. Getting the path where it came from is more involved.

Is it possible that the documents could be named in such a way that the macro could know what project it is for?

eg

project 1
p1_0001.tif
p1_0002.tif

project 2
p2_0001.tif
p2_0002.tif

rdhuntley · Posted: Mon Jul 14, 2008 11:46 am Post subject:

I have seen that Database.ImageFileName displays the path to the repository, which does not help.

The End User (EU) does not have the ablity to name the files by project.

They want an on-going solution so that project reps can drop files into predetermined folders, then FW is to provide help in indexing those files.

You said:

Getting the path where it came from is more involved.

How much "more involved"? This is Exactly the info we need. Can FW define the path it just got a file from?

justin · Posted: Tue Jul 15, 2008 1:19 am Post subject:

The only way to do this presently, if the users can not rename the files, is to include a CSV file with the images.

Instead of using FolderWatch to watch the folder for images, in the wizard set the option to look for CSV files and associated images.

The CSV file must have at least the filenames column of the images that should be imported.

eg

sample.csv
filename,dgnum
c:\watch\p1_0001.tif,0001
c:\watch\p1_0002.tif,0002

Then in the csv importing section in the folderwatch wizard, under custom processing, select
call after record processed breakpoint for each row

This means that in the breakpoint
app connect - after document processed

you now have access to the filename from the CSV file, this is the filename where the file came from