Upload CSV Asset Error

[Kelvin]

I am receiving the following error shen trying to upload assets via a CSV file any ideas?

 

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

[James Ainsworth]

Hi Kelvin,

Could you let us know if you are using the CSV Asset Import Tool

or the CSV upload within the Asset Management app

 

Many thanks,

James

[Kelvin]

@James Ainsworth CSV upload within the Asset Management app.

[Daniel]

Hi,

I am getting the same error message when trying to upload csv via "Asset New Assets" in Asset Management:

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

 

Processed records 80/80 from assetmobileDevice.csv

0 records successfully uploaded

80 records failed to upload

 

I am using Hornbill template

 

Thanks

Daniel

[ArmandoDM]

Hi @Kelvin  @Daniel

if you can send an example of your CSV file that fails to upload (even only 1 asset) we can try to replicate the issue and see where the problem is

Regards

Armando

 

[Kelvin]

@ArmandoDM

CSV attached

MobileTest.csv

[Deen]

@Kelvin I take it 25970 doesn't already exist? It may be treating it as a duplicate.  If its not that we'll try and replicate and see what we get.

[Kelvin]

So I have just tried to run the import this morning and although I get the error the asset is now appearing in Asset Manager. 

[Deen]

This suggests that the asset may already been present.  If you change the asset name in the csv file to a unique one it would be interesting to see if it goes through without error.

[ArmandoDM]

Hi @Kelvin

in the CSV file you sent I can see 2 issues:
 

1. the operation state column must be '0', not 'operational', because in the database we save the index of the value selected, not the string

2. the dates must be in the format yyyy-mm-dd, NOT yyyy/mm/dd (there are 4 dates in the CSV file, they all need to be in the format yyyy-mm-dd)

Hope this helps

Regards

Armando

[Kelvin]

@ArmandoDMI think it will be point 1 as excel seems to change the date format each time and we have to change in the csv. 

Thanks for looking at it, I will post back when I get chance to upload another batch.

[ArmandoDM]

@Kelvin

can't you update the excel file to the required date format ?

[Michael Sharp]

I'm getting the same error!

[Michael Sharp]

5 minutes ago, Michael Sharp said:

I'm getting the same error!

Looks like I had issues with using names instead of 0/1/2 for either: Operational state, state, acquired method, location type