search
No Code Service CreationPowerful Integrated FormsGCloud Information

IT Facing Functionality

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.

  1. Get the Bulk Upload Tool application (exe file) from IEG4

  2. Get the Import Claim Extract application (bat file) from IEG4

  3. 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.

  4. Edit the Import Claim Extract.bat file (you can simply edit the file using notepad) to:

    1. Tell it the location of the exe file

    2. Tell it where to pull files from

To provide an example of 4) this is the configuration you might have for the license extract from earlier. The bits in bold 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\TestExtract\IDOXLicensingExtract.txt"

openprocesstestindexing ?sv=2017-11-09^&sr=c^&si=bulk-import- tool^&sig={key} extracts-for-processing Endpoint=sb:// openprocess-test- northeu.servicebus.windows.net/;SharedAccessKeyName=bulkuploader;SharedAcc essKey={securekey}

The bit above in italics should not be touched.

When the bat file is clicked the program will run. You can see a trace of the process with an example below:

"C:\Users\johnmcmahon\Desktop\bulk-upload-tool-v1.0.0\bulk-upload-tool-
v1.0.0\bulk-upload-tool.exe"
“C:\Users\johnmcmahon\Desktop\TestExtract\IDOXLicensingExtract.txt"
openprocesstestindexing ?sv=2017-11-09^&sr=c^&si=bulk-import-
tool^&sig=ZPe2ZpWE2nYIZzLT0gsEvKdjie7zoquT5Un6kYqP%%2FMM%%3D edf290f5-
fce6-43ff-8e62-acd48c7d1ffc extracts-for-processing Endpoint=sb://openprocess-
test-
northeu.servicebus.windows.net/;SharedAccessKeyName=bulkuploader;SharedAccessKey
={securekey}

Destinition location: https://openprocesstestindexing.blob.core.windows.net/ edf290f5-fce6-43ff-8e62-acd48c7d1ffc/IDOXLicensingExtract.txt? sv=2017-11-09&sr=c&si=bulk-import- tool&sig=ZPe2ZpWE2nYIZzLT0gsEvKdjie7zoquT5Un6kYqP%2FMM%3D

SIMPLES!

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.


PreviousUser FunctionalityNextIntroduction

Last updated

Was this helpful?