Jump to content

Asset import - CSV File


Recommended Posts

Good Afternoon, Can any one advise how I update an Asset Substate when importing from CSV file, I have tried numerous options, but nothing seems to work... unable to find the correct naming convention on the wiki / import details..

 

 

image.png

 

Also on description, keep getting the <no Value> <no value>.... I have tried to remove (bold) info from this line, however it then brings up error.. "h_description":"{{.Description}}\n\n{{.Manufacturer}} {{.Model}}",image.thumb.png.7acd94a6964c065f609c92d82a08154a.png

Link to comment
Share on other sites

h_operational_state is an Integer value, currently valid for 0, 1, or 2
image.png

I'm not sure where you're getting h_operational_substate from, that's not a column in the h_cmdb_assets table (see the Entity Explorer under Service Manager Admin and select Database Schema Viewer for details of each table, including ENUM values)

Substates are user-defined, and are stored in the h_substate_id and h_substate_name fields

image.png

  • Like 1
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...