How can we help?
Searching in {{docApp.searchFilterBySpecificBookTitle}}
{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}}
in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.
You have an odd number of " characters in your search terms - each one needs closing with a matching " character!
-
{{resultItem.title}}
{{resultItem.url}}
{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}
{{docApp.libraryHomeViewProduct.description}}
{{group.title || group.id}}
{{group.description}}
Ultimately, the executable will be scheduled in the Windows task scheduler (see later) but to test, gain confidence, and perform an initial upload of asset records into Document Manager, the utility can be executed from a command prompt window on an ad-hoc basis. The command used to execute the import can contain several command line arguments.
Command Line Parameters
apikey
- API Key to use as Authentication when connecting to Hornbill Instanceapitimeout
- Number of Seconds to Timeout an API Connection (default 60)csvc
- Name of the CSV file containing document collection datacsvd
- Name of the CSV file containing main document datacsvs
- Name of the CSV file containing document sharing datacsvt
- Name of the CSV file containing document tag datadebug
- true/false, defaults to false - Log extended debug informationdryrun
- true/false, defaults to false - Allow the Import to run without Creating Documentsinstanceid
- This is the name of your Hornbill instance and can be found within the URL you use to navigate to it: live.hornbill.com/[instance name]/
. E.g. if the URL you use to access your instance islive.hornbill.com/arescomputing/
, then your instance id would be “arescomputing”. This value is case sensitive.version
- Output the tools version number, and exit
First Run
When you first run the utility it will prompt you for two vital pieces of information:
- The Instance ID (also referred to as the instance name) can be found in the URL used by your organization to access the Hornbill service:
- https://live.hornbill.com/instanceid (case sensitive).
- A valid API key. This needs to be created against a Hornbill user account with enough rights to create and update asset records in Document Manager. Details on how to create an API key can be found in the Hornbill Platform Fundamentals book. This information will be encrypted and stored locally on the host computer that will run the utility. For each subsequent import run, the utility will decrypt your instance ID and API key from the client and will use those to make the API calls back into Hornbill as necessary to perform the import.
Important
The authentication information can only be decrypted on the computer (physical or virtual) that the encryption was performed on, and by the user that performed the encryption, so please bear this in mind when scheduling your imports.
Testing Overview
There is no substitute for hands-on experience when becoming familiar with the Hornbill import utilities. The Asset Import utility accepts and understands a number of command line arguments that can be used when running the utility from the Windows command line or PowerShell.
Tip
The most important argument when testing is -dryrun=true
. When this is provided, no documents will be sent to Hornbill. Instead, all import requests that would have been made into Hornbill are output to a log file, including input parameters, which provides you with an opportunity to review their content and understand any error messages that may occur.
Below are some high level steps to help you build confidence in your configuration:
- In the configuration, write your query accordingly to target a single or small set of document records. It’s good practice to initially test against a single, or small set of, objects, as this allows the dryrun to complete quicker and there is less log content to review.
- Perform a dryrun (by executing the utility along with the
-dryrun=true
command line parameter) - this allows you to confirm that the configuration is correct and that a connection to the source database can be established, without importing any asset data into your Hornbill instance. - Review the commind line output and log file for any errors or warnings, and where necessary check and rectify any errors against the Common Error Messages listed in the Troubleshooting Document Imports section of this book.
- Continue with dryrun tests until you are happy that all the errors are accounted for.
- Perform a live import against a single asset record (set
-dryrun=false
). - Review the imported document record in Document Manager, and check all properties are as expected i.e. Document tag contains a valid Document tag etc.
- Where necessary, adjust the configuration file asset property mappings
- Loop through steps 5 - 7 as many times as is necessary until you are happy with the information being transported into the Document Manager document record properties.
- Amend the query to target the asset objects required for a full import.
- Perform a dryrun
- Review the commind line output and log file for any errors or warnings, and where necessary check and rectify any errors against Common Error Messages listed in the Troubleshooting Document Imports section of this book.
- Continue with dryrun tests until you are happy that all the errors are accounted for.
Command Line Examples
goHornbillDocumentImport.exe -dryrun=true
.\goHornbillDocumentImport.exe - dryrun=true
Resetting Encrypted Credentials
Should you wish to use a different Instance ID or API key to what has been previously encrypted, then simply delete the import.cfg
file from the folder where the import binary resides. Once you re-run your import from the command line, the utility will again ask for the Instance ID and API Key details just as it would have on its first run.
- Version {{docApp.book.version}}
- Node {{docApp.node}} / {{docApp.build}}