Difference between revisions of "Upload Assets CSV"
Jump to navigation
Jump to search
| (5 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 7: | Line 12: | ||
* 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== | ||
It is possible to upload assets of different asset '''Types''' but only those which are managed under the same asset '''Class''' from a single CSV template. If you require to upload assets for types which are managed under different asset classes, you are required to create different CSV templates for each asset class grouping. | It is possible to upload assets of different asset '''Types''' but only those which are managed under the same asset '''Class''' from a single CSV template. If you require to upload assets for types which are managed under different asset classes, you are required to create different CSV templates for each asset class grouping. | ||
| 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 | + | :* 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 --> | |
