-
David,
What version of DocuWare? For several releases now there is the ability to filter on any column of the workflow task.
When hovering over the column name you will see a little funnel icon. That opens a small dialog where you can enter a search term. It works exactly like a normal DocuWare search.
Phil Robson
-
Joe makes a very good point. From my side, I am interested in why 1 page of 12,000 records is more desirable than 12 pages of 100 records?
The reason for wanting this behavior is of interest. Of course, if you had it the next problem would be how long it takes to load a result list with a million entries on one page - if it ever loaded.
So what is the use case here?
Phil Robson
-
David,
No. The page view is limited to 100 lines. There is no way to change it.
Phil Robson
-
Julio,
It sounds like there is a field referenced in the form that no longer exists in the file cabinet. Start by checking that.
Phil Robson
Senior Director Client Services, Americas
-
Given the age of Active Import and the old Toolkit, my first impression is the path. Is it failing on the first document?
Create a path without any spaces.
\\2serv\complete\30_purchase_order_pdfs\px37890.pdf
Phil Robson
Senior Director Client Services, Americas
-
Michael,
You will need to create a new field in the DocuWare file cabinet with a type of either numeric or decimal. Then, you will need to transfer the contents of the text field to the new numeric or decimal field using a query in the database, since you cannot transfer text data to numeric with Autoindex.
Generally MSSQL will transfer data from a varchar field to an INT (numeric field) as an implicit conversion - meaning that you do not need to specify a conversion. You will however need to pay careful attention to decimal places if you use an INT (numeric field).
If your text value is '10.00' then you need to strip the decimal and write 1000 to the numeric field (if you have it set to 2 decimal places in DocuWare).
If you want to write it to a decimal field then I think that will work as a straight copy since that conversion is also an implicit conversion. My preference would be to create the new field as decimal as this will be a simpler conversion.
When transferring data, you must also be careful not to try and write anything else but numerical data otherwise your query will fail on the first record where the conversion cannot be completed.
Whatever you do you need to check the converted data carefully to ensure that you have written the values correctly depending on the target field type.
If all that seems a little difficult, Professional Services will be pleased to provide a quote to do the conversion for you.
Phil Robson
Senior Director Client Services, Americas
-
The DocuWare API does not provide direct database access. In an On-Premise system you would have to write your own connection and query using standard programming tools.
Phil Robson
Senior Director Client Services, Americas
-
Aaron,
We do not actually document any specific backup procedure for DocuWare. This is because there are many backup solutions for Windows on the market.
There is 3 elements to backing up DocuWare:
1. The actual windows installation files.
2. The file system where the documents reside.
3. The database.
Any IT person worth their salt should be able to develop a backup strategy using commercial backup software that encompasses the 3 elements above.
Importantly, MySQL does not contain any backup ability at all, but there are tools available to implement regular backups of the database - MySQL Workbench for example.
Backing up the document repository is always critical and must be included in a strategy.
Of course everyone performs backups of their Server installation regularly so that takes care of the DocuWare program files side of things.
You may wish to refer to my blog article on protecting your business data:
https://start.docuware.com/blog/document-management/protect-your-business-with-a-data-backup-plan
As far as migrating from MySQL to MSSQL, this is a task that must be performed by Professional Services. The process can be fraught with difficulties and it is best that we do it to ensure a satisfactory and timely result.
Phil Robson
Senior Director Client Services, Americas
-
In a 'one off' scenario all of the above are reasonable approaches. However you now have a maintenance issue where any new documents will not have the number. So you have to decide how often you update the database or DocuWare regardless of the method used.
AutoIndex is the right method for this function as you can pretty well set it and forget it.
Phil Robson
Senior Director Client Services, Americas
-
Connie,
It is always handy to know what version of DocuWare and whether it is an On-Premise or Cloud installation. That said, in recent versions of DocuWare it is important to set the Time Zone of the system in DocuWare Administration.
Open the desktop app DocuWare Administration. Navigate to to your Organization > General.
Under Calendar set the Time Zone to your local Time Zone.
If this does not solve the problem then please open a support request so that support can investigate further.
Phil Robson
Senior Director Client Services, Americas
