Jump to content

Database Asset Import – csv – unable to import State and Substate

Recommended Posts

I've been trying to use the Database Import tool, using a csv, but I am unable to import the State and Substate information into Asset Management. I have CSV and an json file that works as long as no attempt is made to sync information to the state field (h_record_state according to the conf_example_csv.json example file provided with the tool). If I include a mapping to a CSV field in in the h_record_state or h_operational_state fields, then the import fails with the error

[ERROR] Unable to add asset: A database or query error occurred while inserting the primary record data into the database. (table=h_cmdb_assets, pk=XXX)
[DEBUG] API Call XML: <params><application>com.hornbill.servicemanager</application><entity>Asset</entity><returnModifiedData>true</returnModifiedData><primaryEntityData><record><h_class>computer</h_class><h_type>2</h_type><h_last_updated>[a date]</h_last_updated><h_last_updated_by>Import - Add</h_last_updated_by><h_used_by>[user details]</h_used_by><h_used_by_name>[user details]</h_used_by_name><h_used_by_name>[user details]</h_used_by_name><h_name>[laptop info]</h_name><h_asset_tag>[]asset tag]</h_asset_tag><h_description>[laptop info]</h_description><h_record_state>Active</h_record_state></record></primaryEntityData><relatedEntityData><relationshipName>AssetClass</relationshipName><entityAction>insert</entityAction><record><h_type>2</h_type><h_dsc_cf_fingerprint>[fingerprint info]</h_dsc_cf_fingerprint><h_name>[laptop info]</h_name><h_model>[model info]</h_model><h_manufacturer>[laptop manufacturer]</h_manufacturer><h_description>[description info]</h_description><h_serial_number>[serial number]</h_serial_number></record></relatedEntityData></params>

I have made sure that the values in the CSV match the State, and as it stands I cannot find the database field to sync for Substate - though these bit of information are key to making this import worth it. I don't fancy setting the state and substate on a few thousand assets :( I've attached a text file which is the JSON i've been using (with sensitive info removed).

Help much appreciated!


Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...