Joined: 7/8/2017
UploadDocument and EasyUploadSingleDocument (depending on document size). In fact, my code does not show the part where indexes are generated from the dwcontrol file -- that was a different routine. As long as you can load indexes into a DocuWare Document class (in code), you can use whatever indexing scheme you want. public static Document UploadFileToFileCabinet(FileCabinet fileCabinet, string uploadFile, string[] indexFieldNames, dynamic[] indexValues, bool timestampsAlreadyUTC = false)
{
Document indexInfo = new Document();
indexInfo.Fields = new List<DocumentIndexField>();
int numIndexFields = Math.Min(indexFieldNames.Length, indexValues.Length);
string fieldName = "";
dynamic value = null;
Type valueType = null;
for (int i = 0; i < numIndexFields; i++)
{
fieldName = indexFieldNames[i];
value = indexValues[i];
valueType = ((ObjectHandle)value).Unwrap().GetType();
if (valueType.Name.ToUpper() == "STRING")
{
indexInfo.Fields.Add(DocumentIndexField.Create(fieldName, (string)value));
}
else if (valueType.Name.ToUpper() == "INT")
{
indexInfo.Fields.Add(DocumentIndexField.Create(fieldName, (int)value));
}
else if (valueType.Name.ToUpper() == "DECIMAL")
{
indexInfo.Fields.Add(DocumentIndexField.Create(fieldName, (decimal)value));
}
else if (valueType.Name.ToUpper() == "DATETIME")
{
DateTime timestamp = (DateTime)value;
if (!timestampsAlreadyUTC)
{
// We need to make timestamps UTC (Universal Coordinated Time) for storage in DocuWare, as that is how
// all date/time fields are stored in the database.
timestamp = timestamp.ToUniversalTime();
}
indexInfo.Fields.Add(DocumentIndexField.Create(fieldName, timestamp));
}
}
return UploadFileToFileCabinet(fileCabinet, uploadFile, indexInfo);
}
public static Document UploadFileToFileCabinet(FileCabinet fileCabinet, string uploadFile, Document indexInfo = null)
{
LastError = "";
try
{
// We will use a standard upload method for smaller files, but the "Easy" version for larger files, otherwise
// large file uploads might fail (the "Easy" version is meant for huge file uploads, according to the documentation).
int largeFileThresholdInBytes = 10 * 1024 * 1024; // 10 MB
Document uploadedDoc = null;
FileInfo fileInfo = new FileInfo(uploadFile);
if (fileInfo.Length < largeFileThresholdInBytes)
{
// Smaller file.
uploadedDoc = fileCabinet.UploadDocument(indexInfo, fileInfo);
}
else
{
// Larger file.
uploadedDoc = fileCabinet.EasyUploadSingleDocument(fileInfo, indexInfo);
}
return uploadedDoc;
}
catch (Exception ex)
{
LastError = ex.Message;
return null;
}
}
Mark,
The import was very fast, mainly because I wrote it as a multi-threaded app that did various document types at the same time (wrote the utility in C#/.NET).
It actually took longer to get all the documents out of Fortis, which I did via Foxpro and the Fortis COM object. That job, too, could be split up just by running code on two or three workstations (old-fashioned multi-threading. *smile*)
I can't really share the multi-threaded nature of the code because that depends on how documents are segmented. But if you need examples of code to upload a document and index it, I can post snippets that might go beyond what is in online documentation.
How much faster than import files? I recall it being a lot faster, even without multi-threading. But, I didn't spend that much time trying to make the import jobs faster. There are various things you can tweak, I just never saw much performance improvement. That's why I decided to roll my own solution and I never looked back. Plus, we still use parts of the application I wrote for ongoing integrations between DocuWare and our custom-developed apps.
Good luck!
Joe Kaufman
Shawn,
We discovered that even in the Canon software scans would slow down.
So, we bought a Fujitsu 7160, and it is very speedy and does a nice job. No slowdowns so far for anyone with Feature Update 2004.
Thanks,
Joe Kaufman