• Fabrice,

    Fabrice,

    Glad you got that working! Python makes the coding look easy.  *smile*

     

    Thanks,

    Joe Kaufman

  • Power BI

    Power BI supports just about every data source under the sun, though of course that will only work if you have DocuWare installed in-premise. If you are attempting to access cloud data, then the Platform Service route may be your only play.

     

    Thanks,

    Joe Kaufman

  • Casey,

    Casey,

    I have used many different queries, most recently:

    [ASSET_ID] LIKE "P*"

    to get all Fixed Asset documents having an Asset ID starting with "P". I have also used:

    [DWDOCID]>0

    which should return everything for the file cabinet.

    As I said, the queries work, and they return multiple documents in the result list integration. So, it isn;t that I am just always returning a single document. It is clearly downloading lust the first document of multiples, instead of combining them all into a ZIP file.

    What version of DW are you on?

     

    Thanks,

    Joe Kaufman

  • Casey,

    Casey,

    No, should I need that? I am using Windows integration, and I get logged in fine. 

    If I run the integration in Result List mode, I get all documents according to the query. "Display first one" is not turned on.

    If I run the integration as the Viewer, the first matching document (only) is displayed in the viewer.

    If I run the integration in Download mode, the first found document for the search is downloaded.

    There is no scenario I can generate where multiple documents download as a ZIP file, and I am receiving no authentication or query errors. I am on 6.11. What version of DocuWare is working correctly for you?

    EDIT: I thought versioning might have something to do with it, but I have now tried this on versioned and non-versioned cabinets -- still cannot get multiple files to download as a ZIP file in DocuWare 6.11 (on-premise).

     

    Thanks,

    Joe Kaufman

  • Tim,

    Tim,

    The result list is not set to display first, though I did make the error go away by making the "Source" a result list instead of a File Cabinet.

    But it is still only downloading the first document it finds that meets the criteria. 

    I assume a "Download Type" of "Download" is appropriate ("Plugin" is also an option)? I cannot get the Download integration type working for multiple files no matter what I try.

    But, as I said, going with the reult list gets rid of the File Cabinet direct query error, so thanks for that!

     

    Thanks,

    Joe Kaufman

  • Casey,

    Casey,

    I am afraid it is not working for me.  :\   I get query errors and the result is a single. downloaded file that is the first to meet the criteria.

    Can you provide a screenshot of your query, one that will download multiple documents at once? I am on 6.11, so maybe that is the problem...

     

    Thanks,

    Joe Kaufman

  • Casey,

    Casey,

    Is that effective for hundreds of documents? Or can you do multiple documents that way? In other words, can you do a very wide query and have it download hundreds of docs at once? Smart enough to put them in a zip file? That is a cool trick, and a great use of URL integration!

    EDIT: I keep getting errors on my query, even something that should return everything like:

    [DWDOCID]>0

    Though, it does still download the first document in the search results. How are you able to download multiple documents at once using this methodology? How can you force multiple documents into a ZIP file the way the web client would download them?

     

    Thanks,

    Joe Kaufman

  • Folders

    Hameed,

    Are you saying you want to overcome the 100-document-view limit so you can select more documetns at once and download as a ZIP file?

    If so, you can use Folders to help with this. If you set up a folder into a file cabinet (make the criteria something that grabs the documents you want), a folder will display everything it matches to (up to 10,000 documents). Then you can highlight all the documents you want and pull them all down at once. Not sure how great performance is going to be downloading more than 100 documents at a time, but a Folder view allows you to see more documents at once.

    The other option would be to use the Platform SDK and download documents via a separate integration.

    Hope this helps!

     

    Thanks,

    Joe Kaufman

     

  • xmlhttp

    Fabrice,

    If you search the support form for "xmlhttp" and "serverxmlhttp" you will see some examples of accessing the API via Visual Foxpro, and others have asked about toolkits like node.js. The full list of entry points (URL resources) to consume via the API can be found here:

    http://<your DW server>/DocuWare/Platform/Home/UriTemplatesDocumentation

    (online DW documentation appears to not be loading this morning. Grrrr.)

    At some point I wish DocuWare would post more generic examples (such as curl), or a Postman package with examples. As far as I know, though, no such pieces of documentation exist at this time. You just need to become familiar with how pythom does GETs and PUTs and POSTs and you should be off to the races.

     

    Thanks,

    Joe Kaufman

  • Don't you use LogCollector to

    Don't you use LogCollector to collect errors on the Desktop, found at:

    C:\Program Files (x86)\DocuWare\Desktop\LogCollector

    ?

     

    Thanks,

    Joe Kaufman