IFS DMS mass download

Hi Dominik,

assumed you’d like to do this from inside IFS (taking directly from Orcale database obviously would not be that problem) the first way which comes to my mind is copying required document files out from the Document Revisions window after Advanced Search, which can be done as follows:

1. Copy your list of document numbers to a text editor (e.g. Notepad++) which can replace regular expression characters (if you’re in the IFS QR results window you’ll first need to export the results to Excel - RMB “Export to Excel” - and subsequently from there to the text editor).
2. Replace all line breaks (CR) by: singe quote, komma, single quote (‘, ‘), as will be required for the SQL IN query (in Text editor e.g. may look as follows):

   

3. Add a paranthesis and a single quote at the beginning of the text and ensure it ends with a single quote and paranthesis; then copy the whole text - will look like: (‘DocNo0001’, ‘DocNo0002’, ‘DocNo0003’, ...)
4. Go to the IFS Document Revisions window and query those listed documents through an Advanced Search by SQL query, starting with “Doc_No IN “ and the copied text -> will look e.g. like follows (the blue marked text is the final copy from text editor):

   

5. After retrieving these document records in the Document Revisions window you can select them and RMB - File Operations - Copy to Folder …

There may be quicker/simpler ways (especially when directly SQL querying the database - which probably is required for really long lists of documents), however, at least this works without special requirements or skills.

Hope this helps,

Mark