Bulk Document Import
Where a customer has the EDMS module of OpenProcess we provide a little app who’s job it is to import files. The process is very simple.
Get the Bulk Upload Tool application (exe file) from IEG4
Get the Import Documents application (bat file) from IEG4
Download its contents and place in a location which has access to your extracts i.e. it can import from a server location but it’s clearly best to place the application on the same server as where the extracts are saved to.
Edit the Import Documents.bat file (you can simply edit the file using notepad) to:
a) Tell it the location of the exe file
b) Tell it where to pull files from
To provide an example of 4) this is the configuration you might have.
The bits in bold italics relate to a) and b) above:
"C:\Users\johnmcmahon\Desktop\bulk-upload-tool-v1.0.0\bulk-upload-tool- v1.0.0\bulk-upload-tool.exe"
"C:\Users\johnmcmahon\Desktop\TestImportDocuments"
openprocesstestindexing ?sv=2017-11-09^&sr=c^&si=bulk-import- tool^&sig={key} documents-for-indexing Endpoint=sb://openprocess-test- northeu.servicebus.windows.net/;SharedAccessKeyName=bulkuploader;SharedAccessKey={secret key}
So in the above example any documents held in the TestImportDocuments folder on my desktop are automatically pushed into OpenProcess when the bat file is run.
The following illustrates the output from the bat file when run when there are two files in there:
Bytes uploaded: 0, Files Transferred: 0, Files Skipped: 0, Files Failed 0 Bytes uploaded: 0, Files Transferred: 0, Files Skipped: 0, Files Failed 0 Bytes uploaded: 0, Files Transferred: 0, Files Skipped: 0, Files Failed 0 Bytes uploaded: 0, Files Transferred: 0, Files Skipped: 0, Files Failed 0 Bytes uploaded: 8539, Files Transferred: 0, Files Skipped: 0, Files Failed 0 Bytes uploaded: 8539, Files Transferred: 1, Files Skipped: 0, Files Failed 0 Bytes uploaded: 8572, Files Transferred: 1, Files Skipped: 0, Files Failed 0 Bytes uploaded: 8572, Files Transferred: 2, Files Skipped: 0, Files Failed 0
This therefore shows the two files and the names of the files transferred too.
The important thing to note is that this process copies the files it does not delete them. So you may wish to put this into your processes.
Also as the files are bat files you can run a windows script to automate this process to be in the middle of the night etc.
Last updated
Was this helpful?