EspMethodCall::invoke: Operation[data::entityAddRecord] A database or query error occurred while inserting the primary record data into the database.

[Mark (ESC)]

Testing phase at the moment, trying to add an item to the Asset Database via the upload function.

Just one entry in the csv, but this result in an error being given.  Usually the errors are quite specific, this however seems more DB related.

 

assetComputerPeripheral.csv

[Steve Giller]

That will either mean that you've missed a mandatory field, or you've entered a "friendly" (e.g. text description) value where there should be a numeric value (i.e. the id)

Off the top of my head the operationalState would be a likely candidate, but I'd need to dig into the tables to be sure.

[Mark (ESC)]

@Steve Giller Thanks

Have been searching for instructions with regards to field values such as 0,1 or 2, but have not been very successful.  

[Victor]

@Mark (ESC) if you can send me and/or @Steve Giller a copy of the CSV import file (use private message) then we can look and see where they have wrong values. We can also show you how you can check these going forward.

[Victor]

... and I should be looking better next time to actually see the CSV has already been attached... oh, well...  I have my moments...

So... @Mark (ESC) it's the location type, operational state.... For example, in the CSV the operational state field has the value as "operational". The correspondent field in the assets table needs a numeric value. You can find this info (and other info about field types for assets) in admin tool:

[Mark (ESC)]

@Steve Giller we have lift off

The fields which were creating the errors were h_location_type (Location Type) and h_operational_state (Operational State)

Your help is much appreciated.