Difference between revisions of "Upload Assets CSV"
Jump to navigation
Jump to search
| (17 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | __NOTOC__[[Main Page|Home]] > [[Service Manager]] > [[ | + | 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 | ||
{{#ev:youtube|9qi1GvqwsYw|400|right}} | {{#ev:youtube|9qi1GvqwsYw|400|right}} | ||
===Introduction=== | ===Introduction=== | ||
| 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 19: | Line 25: | ||
* Note - Whilst other attributes are not mandatory to perform the import, it is good practise to populate the attribute fields to match those which you have enabled for each asset type, when you were defining the asset types. Examples being Usedby, or Site, should you want the assets to appear as linked to these entities when performing other Service Manager actions, such as logging requests through progressive capture and having the option to choose from a list of assets associated to the user. | * Note - Whilst other attributes are not mandatory to perform the import, it is good practise to populate the attribute fields to match those which you have enabled for each asset type, when you were defining the asset types. Examples being Usedby, or Site, should you want the assets to appear as linked to these entities when performing other Service Manager actions, such as logging requests through progressive capture and having the option to choose from a list of assets associated to the user. | ||
| − | :* Used by requires | + | :* Used by requires the usedById, usedByName and usedByType attributes to be completed. usedByType should be populated with either: |
| − | :* Owned By requires both the | + | :** 0 - if Used By is a coworker |
| + | :** 1 - if Used By is a contact | ||
| + | :* 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 | ||
| + | :** 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 48: | Line 61: | ||
* Which rows failed | * Which rows failed | ||
| − | * The | + | * The reason for the failures |
[[File:CSV_Import_Errors.png|600px]] | [[File:CSV_Import_Errors.png|600px]] | ||
| + | --> | ||
| + | [[Category:Videos]][[Category:HDOC]] | ||
| − | + | <!-- /servicemanager-user-guide/asset-management/upload-assets --> | |
