Kelvin Posted May 18, 2020 Share Posted May 18, 2020 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 Link to comment Share on other sites More sharing options...
James Ainsworth Posted May 18, 2020 Share Posted May 18, 2020 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 Link to comment Share on other sites More sharing options...
Kelvin Posted May 20, 2020 Author Share Posted May 20, 2020 @James Ainsworth CSV upload within the Asset Management app. Link to comment Share on other sites More sharing options...
Daniel Posted May 20, 2020 Share Posted May 20, 2020 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 Link to comment Share on other sites More sharing options...
ArmandoDM Posted May 20, 2020 Share Posted May 20, 2020 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 Link to comment Share on other sites More sharing options...
Kelvin Posted May 20, 2020 Author Share Posted May 20, 2020 @ArmandoDM CSV attached MobileTest.csv Link to comment Share on other sites More sharing options...
Deen Posted May 20, 2020 Share Posted May 20, 2020 @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. Link to comment Share on other sites More sharing options...
Kelvin Posted May 21, 2020 Author Share Posted May 21, 2020 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. Link to comment Share on other sites More sharing options...
Deen Posted May 21, 2020 Share Posted May 21, 2020 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. Link to comment Share on other sites More sharing options...
ArmandoDM Posted May 21, 2020 Share Posted May 21, 2020 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 Link to comment Share on other sites More sharing options...
Kelvin Posted May 21, 2020 Author Share Posted May 21, 2020 @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. Link to comment Share on other sites More sharing options...
ArmandoDM Posted May 21, 2020 Share Posted May 21, 2020 @Kelvin can't you update the excel file to the required date format ? Link to comment Share on other sites More sharing options...
Michael Sharp Posted June 17, 2020 Share Posted June 17, 2020 I'm getting the same error! Link to comment Share on other sites More sharing options...
Michael Sharp Posted June 17, 2020 Share Posted June 17, 2020 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 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