Upload Assets CSV: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(10 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
This document can now be found at its new location in the [https://docs.hornbill.com/servicemanager-user-guide/asset-management/upload-assets/ Hornbill Document Library]. | |||
[[file:hornbill-document-library.png|Upload Assets|link=https://docs.hornbill.com/servicemanager-user-guide/asset-management/upload-assets/]] | |||
<!-- | |||
__NOTOC__[[Main Page|Home]] > [[Service Manager]] > [[Asset Management]] > [[Manage Assets]] > Assets CSV | __NOTOC__[[Main Page|Home]] > [[Service Manager]] > [[Asset Management]] > [[Manage Assets]] > Assets CSV | ||
{{#ev:youtube|9qi1GvqwsYw|400|right}} | {{#ev:youtube|9qi1GvqwsYw|400|right}} | ||
Line 6: | Line 11: | ||
* As an Asset Management Administrator select the '''Asset Upload''' option from the '''Asset Management''' Icon on the Application navigation bar. | * As an Asset Management Administrator select the '''Asset Upload''' option from the '''Asset Management''' Icon on the Application navigation bar. | ||
==Creating The Upload Template== | ==Creating The Upload Template== | ||
Line 27: | Line 33: | ||
:* Site requires both the site and the siteId attributes to be completed. SiteId refers to the database numerical value not the display name | :* Site requires both the site and the siteId attributes to be completed. SiteId refers to the database numerical value not the display name | ||
:* Date attributes are required in the following format: yyyy-mm-dd hh:mm:ssZ | :* Date attributes are required in the following format: yyyy-mm-dd hh:mm:ssZ | ||
:* Country requires the ISO Alpha 2 codes as per the listing here - [https://en.wikipedia.org/wiki/ISO_3166-1] | |||
The fields in the CSV file are mapped on the assets database table. To find what values and types need to be populated in the fields, navigate to Home > Applications > Service Manager > Entity Viewer. Select "Database Schema Viewer" and navigate to the the "h_cmdb_assets" table. | |||
==Validation== | ==Validation== | ||
Line 55: | Line 64: | ||
[[File:CSV_Import_Errors.png|600px]] | [[File:CSV_Import_Errors.png|600px]] | ||
--> | |||
[[Category:Videos]][[Category:HDOC]] | |||
<!-- /servicemanager-user-guide/asset-management/upload-assets --> |