Josef Zayats

Hello,
I've been a member of this forum and wider DocuWare community for years, but now is the time for me to move on to a well deserved retirement.
My company is looking for someone to replace me. Help them God.
Must be an accomplished DocuWare support professional with advanced knowledge of all areas of Docuware software. Also, an understanding of MSSQL scripts and ability to create/troubleshoot such is a requirement.
The company is a large copier dealer in NYC with homeoffice in NYC (but can work from anywhere). We are also a permanent member of DocuWare Diamond Club. Good pay for right person.
If interested, please contact me at jzayats@yahoo.com

Anyone knows if Docuware is going to introduce storing files attached to a Docuware Form as separate documents - similarly to what they recently done to emails?

Steve,
If you have an on-premise system, you can do the following:
Enable  "Allow database Access via SQL statement" on your system (in Docuware Administration)
Create a new select list - using external database - in database configuration select Authentication database connection - and type the following  SQL statement. This will give you desired select list
----
select a.name from dwuser a, dwgroup b, DWUserToGroup c where a.uid=c.uid and b.gid=c.gid and b.name='DesiredGroupName'
-----

The following command will give you list of users assigned to a role directly (not via group membership)
---
select a.name from dwuser a, dwroles b, DWUserTorole c where a.uid=c.uid and b.rid=c.rid and b.name='DesiredRoleName'
-----
I do not believe this is possible with Docuware Cloud system without going to API programming.

Mark,
this option is available in version 7.3, for both in C2O and C2M under section Import Options/Attachments/Separation - see below



********************* Below is pasted from C2M (General Email) configuration screen of V7.3 *******************

Attachments

 

I've been trying to get the Duplicate Invoices check Store Validation JS Node webservice to work. I thought it would be pretty simple to adapt the sample for such a service Docuware has available on its Developers website.
So, after spending a lot of effort on this, the service that is accessing my Docuware Cloud system (7.2)  runs correctly only once or twice before giving me 401 error, and then I have to wait awhile before I can use the service again.
401 error means Authentication problem, and most likely the license I use to access Docuware system is not being released from previous access. I've been told that I need to use Token instead of username/password login for attempts after the 1st one. Unfortunately I have no idea how to that in the JS program. Can anyone assist? I have the following code - this is exactly how it came from the downloaded sample. 
*************************
exports.isDuplicateInvoice = function (fileCabinetGUID, invoiceNo) {
    return new Promise((resolve, reject) => {    
        var CookieJar = unirest.jar(true);

        //logon to DW PLATFORM and retrieve cookie;
        unirest.post(DWparameters.DWPlatformUrl + '/Account/Logon')
        .headers({'Accept': 'application/json', 'Content-Type': 'application/x-www-form-urlencoded'})
        .jar(CookieJar)
        .send({ 'UserName': DWparameters.DWPlatformUser, 'Password': DWparameters.DWPlatfromPassword, 'Organization': DWparameters.DWPlatformOrganization, 'RememberMe': false, 'RedirectToMyselfInCaseOfError': true })
        .end(function (response) {
            unirest.post(DWparameters.DWPlatformUrl + '/FileCabinets/'+ fileCabinetGUID +'/Query/DialogExpression?dialogId='+ DWparameters.DWSearchDialogGUIDForInvoiceSearch +'&format=table')
            .headers({'Accept': 'application/json', 'Content-Type': 'application/json'})
            .jar(CookieJar)
            .send({ 'Condition':[
                { 'DBName':DWparameters.fieldNameDOCNUMBER, 'Value': [invoiceNo] },
                ],
            'SortOrder':[],'ForceRefresh':true,'FlagConditions':{'IncludeCheckedOut':false},'Operation':'And','AdditionalResultFields':[],'Start':0,'Count':1})
            .end(function (response) {
                if (response.error) {
                    return reject(new Error(response.error.message));
                }


                try {
                    var resultCount = response.body.Count.Value;
                    return resolve(resultCount == 0);                
                } catch (error) {
                    return reject(new Error("Unable to retrieve similar invoices. Error:" + error));
                }
            });
        });
    })
}
 

So I am trying to run the sample node validation on my local server and have it accessed from Docuware Cloud system.
I followed instructions to download/install/configure and run the supplied sample. It is running, but I can't access it from my cloud system.
Are their any missing requirements for my local server, such as open ports, SSL certificate, IIS iconfiguration to make this to work (So far I opened port 4444 but that did not make a difference)
Has anyone got this to work and would share details?
Thanks in advance. 

Steve, try this for length of 20
[\s\S]{20}
or this for range of lengths
[\s\S]{19,21}

In earlier versions we could backup and restore Docuware system settings and that enabled process of migrating from mySQL to MSSQL.
But now you only can backup/restore organization settings which does not include - among other things - Database connections and storage locations. Storage locations cannot be simply re-created as they referenced not only by name, but by GUIDs. This makes migration process somewhat even more complex.
Does anyone know of a way to restore system settings when migrating from mySQL to MSSQL database?

Has anyone succeeded?
I am trying to import A FC created with Request Export, but can't figure our nor find any information on what exactly needs to be copied to Request  storage location for the Request Export function see the File Cabinet to be exported.
Do I copy the content of the zipped file into the root of storage location? or do I copy the whole zip-file container? Whatever I try I still can't see the File Cabinet to be exported.
Also could not find any description of the export screen. 

Ross,
the most probable cause would be that these documents have a stamp applied to them that was configured as a 'signature' stamp - that would preclude any further annotations