Difference between revisions of "Upload Assets CSV"
Jump to navigation
Jump to search
(7 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 - | + | :* 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 56: | 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 --> |