Difference between revisions of "Upload Assets CSV"
Jump to navigation
Jump to search
(3 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/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 29: | Line 34: | ||
:* 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] | :* 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 57: | 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 --> |