Difference between revisions of "Asset Data Import Tool"
Jump to navigation
Jump to search
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | This document can now be found at its new location in the [https://docs.hornbill.com/data-imports-guide/assets/overview Hornbill Document Library]. | ||
| + | |||
| + | [[file:hornbill-document-library.png|Data Imports Guide|link=https://docs.hornbill.com/data-imports-guide/assets/overview]] | ||
| + | |||
| + | <!-- | ||
| + | |||
| + | |||
=About the Hornbill Asset Import Utility= | =About the Hornbill Asset Import Utility= | ||
| Line 6: | Line 13: | ||
The Azure User Import Utility is no longer provided open-source, and is maintained solely by Hornbill as a closed-source, but free-to-use, tool. | The Azure User Import Utility is no longer provided open-source, and is maintained solely by Hornbill as a closed-source, but free-to-use, tool. | ||
| − | |||
| − | |||
| − | |||
==Installation Overview== | ==Installation Overview== | ||
| Line 327: | Line 331: | ||
* <code><nowiki>{{.columnName | epoch}}</nowiki></code> will convert an epoch value to the YYYY-MM-DD HH:II:SS format required for a Hornbill DateTime field | * <code><nowiki>{{.columnName | epoch}}</nowiki></code> will convert an epoch value to the YYYY-MM-DD HH:II:SS format required for a Hornbill DateTime field | ||
* <code><nowiki>{{.columnName | epoch_clear}}</nowiki></code> will convert an epoch value to the YYYY-MM-DD HH:II:SS format required for a Hornbill DateTime field. Defaulting to CLEAR the column if unable to convert. | * <code><nowiki>{{.columnName | epoch_clear}}</nowiki></code> will convert an epoch value to the YYYY-MM-DD HH:II:SS format required for a Hornbill DateTime field. Defaulting to CLEAR the column if unable to convert. | ||
| − | * <code><nowiki>{{.columnName | date_conversion "date time format of the content in .columnName"}}</nowiki></code> Provide the input format based on the following reference time of Jan | + | * <code><nowiki>{{.columnName | date_conversion "date time format of the content in .columnName"}}</nowiki></code> Provide the input format based on the following reference time of Jan 2nd 2006 4 minutes and 5 seconds past 3pm - eg "02/01/2006 15:04:05" will convert the regular UK/European date time format to the format useable in the Hornbill datetime field, whereas "01/02/2006 15:04" will process default US date time. '''Please note''' that IF your formatting is already in the Hornbill date time format (2006-01-02 15:04:05), you don't need to convert anything. |
| − | * <code><nowiki>{{.columnName | date_conversion_clear "date time format of the content in .columnName"}}</nowiki></code> Provide the input format based on the following reference time of Jan | + | * <code><nowiki>{{.columnName | date_conversion_clear "date time format of the content in .columnName"}}</nowiki></code> Provide the input format based on the following reference time of Jan 2nd 2006 4 minutes and 5 seconds past 3pm - eg "02/01/2006 15:04:05" will convert the regular UK/European date time format to the format useable in the Hornbill datetime field, whereas "01/02/2006 15:04" will process default US date time. Defaulting to CLEAR the column if unable to convert. |
==AssetTypeFieldMapping== | ==AssetTypeFieldMapping== | ||
| Line 757: | Line 761: | ||
* data:entityUpdateRecord | * data:entityUpdateRecord | ||
* data:queryExec | * data:queryExec | ||
| + | * session:getApplicationList | ||
* system:logMessage | * system:logMessage | ||
* apps/com.hornbill.core:getSitesList | * apps/com.hornbill.core:getSitesList | ||
| Line 852: | Line 857: | ||
[[Category:Integration]] | [[Category:Integration]] | ||
| + | --> | ||
| + | [[Category:HDOC]] | ||
Latest revision as of 18:06, 10 April 2024
This document can now be found at its new location in the Hornbill Document Library.
