Dan Munns Posted July 27, 2017 Share Posted July 27, 2017 Hi all, Is there a way to automate uploading assets from a CSV file? I have a feeling the answer is no but I can but hope" Thanks Dan Link to comment Share on other sites More sharing options...
Guest NadeemMazhar Posted July 27, 2017 Share Posted July 27, 2017 Hi @Dan Munns Unfortunately, the CSV upload option is very much a manual process. If you do require automation, we do have the asset import utility which you can schedule periodic imports. https://wiki.hornbill.com/index.php/Database_Asset_Import Kind regards Nadeem Link to comment Share on other sites More sharing options...
Dan Munns Posted July 27, 2017 Author Share Posted July 27, 2017 Hi @NadeemMazhar Unfortunately we don't currently use SCCM (or anything similar) so I was hoping for a way of automating the process with a CSV file much like the old way of doing user imports in Supportworks. Thanks Dan Link to comment Share on other sites More sharing options...
Gerry Posted July 27, 2017 Share Posted July 27, 2017 @Dan Munns In terms of an automated CSV import, how would you propose this works. Where does the CSV file come from? is it automatically generated? or are you generating it manually? Gerry Link to comment Share on other sites More sharing options...
Dan Munns Posted July 27, 2017 Author Share Posted July 27, 2017 @Gerry I have been told we can automate the CSV output from AD with powershell and place it on the network (I have been told that they should also be able to format the CSV to enable the uploader to read it correctly). I was hoping that you had an app to auto upload the output file on a daily / weekly basis. Dan Link to comment Share on other sites More sharing options...
Gerry Posted July 27, 2017 Share Posted July 27, 2017 @Dan Munns Ok you could possibly automate the upload by calling the same API as we do for the upload from within PowerShell I guess, I am not sure I have seen anyone do that but I am sure it would be possible in theory, the alternative would be for us to implement an importer script that looks on your network share for the file and imports it - I am sure we can help you one way or the other, I have asked the question internally, lets see what we can come up with Gerry Link to comment Share on other sites More sharing options...
Dan Munns Posted July 27, 2017 Author Share Posted July 27, 2017 Thanks @Gerry Appreciate it Link to comment Share on other sites More sharing options...
Gerry Posted July 27, 2017 Share Posted July 27, 2017 @Dan Munns one of our expert techs is going to have a look at this in the next 2-3 weeks, we have a number of other things that need to be completed. This is what he said..We don't have anything as yet to auto-import assets from a CSV. It wouldn't be overly complicated to knock one up though, using the existing code in the DB asset importer... There should be no reason why we can't write an XMLMC module in PowerShell too, we have some of the code already in the invokeXMLMC runbook I knocked up for the MSSCOrch content pack. Let me look in to how PoweShell modules work and I'll get back to you... Watch this space.. Gerry 1 Link to comment Share on other sites More sharing options...
samwoo Posted July 27, 2017 Share Posted July 27, 2017 Hi, I think this is similar to my request here: I will watch this space as well as it's something that would benefit us. +1 Thanks, Samuel Link to comment Share on other sites More sharing options...
Steve G Posted July 31, 2017 Share Posted July 31, 2017 Hi @Dan Munns, Good news I've just written and released a Powershell module for making API calls against the Hornbill platform. The Github repo for this module is here: https://github.com/hornbill/powershellHornbillAPIModule So your Powershell developers can now use this module, alongside the Hornbill APIs, to develop scripts to add or update your assets in Hornbill with AD as its data source. I'll be looking at automating the import of assets from a CSV in the near future, so watch this space... Kind regards, Steve 1 1 Link to comment Share on other sites More sharing options...
Dan Munns Posted August 1, 2017 Author Share Posted August 1, 2017 Hi @Steve G That is good news. Thank you for the work you have put in. I look forward to the automation. Thanks again, Dan 1 Link to comment Share on other sites More sharing options...
Steve G Posted August 3, 2017 Share Posted August 3, 2017 Hi @Dan Munns, I've just released a tool to allow you to import assets from CSV files, which can be scheduled using your task scheduler of choice. The wiki page is:https://wiki.hornbill.com/index.php/CSV_Asset_Import And Github repo is:https://github.com/hornbill/goCSVAssetImport Let me know how you get on with this! Cheers, Steve 2 Link to comment Share on other sites More sharing options...
Dan Munns Posted August 3, 2017 Author Share Posted August 3, 2017 Thanks @Steve G we will give it a go and report back 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