QEHNick Posted February 11, 2022 Share Posted February 11, 2022 I'm importing software assets into Service manager via a CSV. The fields I need are populated, and those which require a variable are also populated. When importing, everything goes through with no errors. So far so good... However... There is no data being imported, just a record with a name as the Asset ID; none of the detail provided on the CSV at all, for any of the records. Any ideas what's going wrong here? Link to comment Share on other sites More sharing options...
Steve Giller Posted February 11, 2022 Share Posted February 11, 2022 The first thing to check would be that all the fields are populated as the database expects. There are a number of fields where the UI presents a human-readable value but the actual data is a number, for example. I can't remember which these would be off the top of my head, but that's always my first step. Link to comment Share on other sites More sharing options...
QEHNick Posted February 11, 2022 Author Share Posted February 11, 2022 Thanks Steve, does anyone know where I can find a list of the expected field types for software assets? (It would be handy if the downloadable template came with a demo set of items). Link to comment Share on other sites More sharing options...
QEHNick Posted February 11, 2022 Author Share Posted February 11, 2022 I found this, but it's not very helpful. Understanding the Asset Structure - Hornbill Link to comment Share on other sites More sharing options...
QEHNick Posted February 11, 2022 Author Share Posted February 11, 2022 Ahha! Don't worry about it, I see what's going on. It's those mandatory junk fields. I'll get it sorted, cheers. Link to comment Share on other sites More sharing options...
QEHNick Posted February 11, 2022 Author Share Posted February 11, 2022 Ok, still no joy. I have Version, Type, State, Name, locationType, lastUpdatedBy and acqmethod populated as specified, and yet it is still not bringing any information across. Link to comment Share on other sites More sharing options...
QEHNick Posted February 11, 2022 Author Share Posted February 11, 2022 Here's my test file. Test_assetSoftware.csv Link to comment Share on other sites More sharing options...
QEHNick Posted February 11, 2022 Author Share Posted February 11, 2022 I've removed the quotes from Admin - I tried both variations. Also removed the "degrees" symbol in the software title of that test. Same result. Link to comment Share on other sites More sharing options...
Steve Giller Posted February 11, 2022 Share Posted February 11, 2022 @QEHNick Part of the issue may be that some items need to be defined, they're not simple text fields although they appear that way. Check the wiki page for Manage Vendors, Products, Versions for this area, there may be other fields that require this kind of setup also. Link to comment Share on other sites More sharing options...
QEHNick Posted February 11, 2022 Author Share Posted February 11, 2022 Thanks for the advice Steve. I've filled in the sheet according to the required and optional fields as shown in https://wiki.hornbill.com/index.php?title=Understanding_the_Asset_Structure so I can't understand why it doesn't work. Surely that's the gold standard method. Link to comment Share on other sites More sharing options...
QEHNick Posted February 14, 2022 Author Share Posted February 14, 2022 Ok, I figured it out, I had "Auto generate name" on. Oddly it decided to do nothing but generate the name and not bring any other details in. Also, if you have put a prefix in, you cant remove it. If you delete it, save the record and go back in, the prefix is still there. Maybe some bugs there? 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