Difference between revisions of "Upload Assets CSV"
Jump to navigation
Jump to search
| (12 intermediate revisions by 4 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 22: | Line 28: | ||
:** 0 - if Used By is a coworker | :** 0 - if Used By is a coworker | ||
:** 1 - if Used By is a contact | :** 1 - if Used By is a contact | ||
| − | :* Owned By requires both the | + | :* Owned By requires both the ownedById, ownedByName and ownedByType attributes to be completed. ownedByType should be populated with either: |
:** 0 - if Owned By is a coworker | :** 0 - if Owned By is a coworker | ||
:** 1 - if Owned By is a contact | :** 1 - if Owned By is a contact | ||
:* 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 --> | |
