Nick Brailsford Posted November 27, 2018 Posted November 27, 2018 Hi, We are starting to look at importing our assets from Support Works using the Database Asset Import Tool, has anyone done this before and if so got any tips etc? Thanks Nick
Steve G Posted November 28, 2018 Posted November 28, 2018 Hi @Nick Brailsford, Importing the assets from Supportworks is just like importing then from an SCCM database (which there examples of in the documentation), just the driver, SQL query and mappings will be different As you're pulling data from Supportworks, the database driver should be: If you're using Supportworks 7.x and Core Services 3.x then set the driver to be swsql If you're using Supportworks 8.x and Core Services 4.x then set the driver to be mysq I actually wrote the tool, so if you have any questions about the import as you're building your config or running the tool, feel free to tag me in the post and I'll help where I can! Cheers, Steve
Nick Brailsford Posted November 28, 2018 Author Posted November 28, 2018 @Steve Goldthorpe Hi Steve, Thanks for your reply, What I am looking at to start with is what fields (headers) are required coming from SW into Hornbill, I can generate an SQL statement to bring them out but we don't hold all the required options such as Class. Would these then need to be classed within SW? We also have some custom fields within SW. Are there no examples of others exporting SW data? Thanks Nick
Nick Brailsford Posted December 13, 2018 Author Posted December 13, 2018 Hi @Steve Goldthorpe I have imported one class of assets and moved on to the next, however its not importing and i susspect its to do with this and me not understanding / having selected the correct fields :- "AssetTypes": [ { "AssetType": "Mobile", "Query": "AND e.generic = 'mobile'", "AssetIdentifier": { "DBColumn": "h_name", "Entity": "AssetsMobileDevice", "EntityColumn": "h_name" } Can you advise please?
SamS Posted December 17, 2018 Posted December 17, 2018 Hi @Nick Brailsford, From the little "Query" bit I see, I suspect you are importing date from ITHD/ITSMF - where the asset data is stored in the "equipmnt"-table. In this case, the primary ID/unique identifier would be "equipid", so that would be the setting in "DBColumn" (not "h_name").
Nick Brailsford Posted December 19, 2018 Author Posted December 19, 2018 Thanks i have now resolved this. Is there anywhere in Hornbill assets to enter Supplier names? Nick
Conor Posted December 20, 2018 Posted December 20, 2018 Hi @Nick Brailsford Against an asset within Hornbill there is a supplier ID field within the Financial Information section of an asset (if turned on within the asset type). It says supplier ID, but it seems to be a free text field so at the moment doesn't link to anything else - however - you may already be aware we have Hornbill Supplier Manager coming in the next few weeks so this may then link into the ID of suppliers defined in the new application. You can of course update the supplier values against an asset or multiple assets following the release of Supplier Manager if necessary, but I'd recommend trying to keep names consistent to keep any corrections to a minimum in the future. Kind regards Conor
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