DC-BEN Posted February 1, 2017 Share Posted February 1, 2017 Hi, We have around 160 devices that have been added into the Service Manager asset database automatically via SCCM. We have other information to add to all of these assets that SCCM doesn't populate such as; order number, supplier ID, room, order date, received date, warranty expires. Just wondering if anyone can help advise if there is an easy way to add this information into existing records without going into each asset and manually changing it? I'm guessing the asset upload feature is for new assets only and can't be used to add more information to existing assets? Thanks Link to comment Share on other sites More sharing options...
ArmandoDM Posted February 1, 2017 Share Posted February 1, 2017 Hi @DC-BEN, yes the asset upload feature is for new assets only, not for update. Unfortunately I cannot see any shorter way to update the asset details one by one. If you have an updated CSV file and if the assets are not currently linked to any entity, you may delete the existing assets and import them again. Regards, Armando Link to comment Share on other sites More sharing options...
DC-BEN Posted February 1, 2017 Author Share Posted February 1, 2017 Hi @armandoDM Thanks for your prompt response. I'll be sure to bear this in mind going forward. Thanks Link to comment Share on other sites More sharing options...
Steven Boardman Posted February 1, 2017 Share Posted February 1, 2017 Hi @DC-BEN The Asset Import Utility which was used to import assets from SCCM can also be used to update existing assets in Hornbill, it can import / update from different sources (you will of course need to create the configs / queries for each data source). If the information you mention is not held in SCCM, but is in another data source you can create another script to update the existing assets in Hornbill. As long as the identifier set in the config and returned by the query matches an asset in Hornbill, then the record will be updated rather than creating a new one Hope that helps Steve Link to comment Share on other sites More sharing options...
Steve Giller Posted February 1, 2017 Share Posted February 1, 2017 @Steven Boardman Would that "another data source" include a csv file? And if so is the connection documented? If not I'm sure we can get a CSV into a MSSQL table and import/update from there. Link to comment Share on other sites More sharing options...
Steve G Posted February 1, 2017 Share Posted February 1, 2017 Hi @DeadMeatGF @DC-BEN, No, the tool will only connect to MySQL, MariaDB or MSSQL data sources. Steve Link to comment Share on other sites More sharing options...
dwalby Posted December 9, 2017 Share Posted December 9, 2017 Have there been any further developments on capability for updating assets? I also have a number of assets imported from SCCM, which I have purchase information, etc. as well as images for each device model. Is there any way to bulk update them from CSV or similar? Link to comment Share on other sites More sharing options...
Steve G Posted December 11, 2017 Share Posted December 11, 2017 Hi @dwalby @DeadMeatGF @DC-BEN, Yes, the CSV Asset Import tool can import new or update existing asset records from a CSV, and can be scheduled. Please see the wiki & github pages for more information: https://wiki.hornbill.com/index.php/CSV_Asset_Import https://github.com/hornbill/goCSVAssetImport Kind regards, Steve Link to comment Share on other sites More sharing options...
dwalby Posted December 11, 2017 Share Posted December 11, 2017 @Steve G Thanks! On the reverse, is there a way to export the current list of assets from Hornbill in csv? Link to comment Share on other sites More sharing options...
Victor Posted December 12, 2017 Share Posted December 12, 2017 @dwalby 12 hours ago, dwalby said: is there a way to export the current list of assets from Hornbill in csv on a quick thought, a report on assets will do just that... Link to comment Share on other sites More sharing options...
Steve G Posted December 12, 2017 Share Posted December 12, 2017 @dwalby, As @Victor has suggested, you could do this with a report. We do have a story planned to add export functionality to the assets lists, so I'll add you as an interested customer to the story. Kind regards, Steve Link to comment Share on other sites More sharing options...
dwalby Posted December 12, 2017 Share Posted December 12, 2017 @Victor @Steve G - Thanks both Link to comment Share on other sites More sharing options...
dwalby Posted December 13, 2017 Share Posted December 13, 2017 @Victor @Steve G - Just had another thought... Historically we've maintained our assets within an Excel document, if I formatted this as per the relevant template then imported, would the information be merged with the already existing asset info from SCCM? Link to comment Share on other sites More sharing options...
Steve G Posted December 20, 2017 Share Posted December 20, 2017 @dwalby, Yes, if the imports are configured correctly then existing asset records will be updated rather than duplicates created. Kind regards, Steve Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now