Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
'Record Already Exists' & 'ChemCode not in Look Up table' - 'Record Already Exists' error in chem look up table, when no record actually already exists.
Options
Go to last post Go to first unread
Previous Topic Next Topic
Alex_96  
#1 Posted : Wednesday, November 25, 2020 11:33:19 AM(UTC)
Alex_96
Rank: Newbie

Reputation:

Groups: Registered
Posts: 2
Australia
Location: Hawthorn

Hi all, I've been having problems with importing my Chem Look Up table into ESdat. When I do, a number of analytes turn purple and have the error 'Record Already Exists' on the chem code. When searching to see if the record actually does already exist, it seems that this is not the case. 

Furthermore, when I import my lab results, some analytes which had this error in the Chem Look up table now have an error saying 'Chem code is not in the Chemistry Look Up Table'.

How can I fix this?

Thanks!
Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
Nick Tumney  
#2 Posted : Wednesday, November 25, 2020 11:51:20 AM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 329
Canada

Was thanked: 29 time(s) in 29 post(s)

Hi Alex,

Can you confirm that the import error is referring to the Chem Code cell?

Is it possible that you are using a Chem Name that already exists?  This could cause the same error as you can't have two different Chem Codes that use the same Chem Name.

I would try changing the Chem Name in your import template and see if this resolves the issue.

Thanks,

Nick
Back to top
WWW
Alex_96  
#3 Posted : Thursday, November 26, 2020 8:03:17 AM(UTC)
Alex_96
Rank: Newbie

Reputation:

Groups: Registered
Posts: 2
Australia
Location: Hawthorn
Yes the error is referring to the Chem Code cell. I did take your advice and checked that Chem Names are not duplicated, and that does not seem to be the case. I'm still getting these errors on the same few analytes.
Back to top
Nick Tumney  
#4 Posted : Friday, November 27, 2020 12:12:39 PM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 329
Canada

Was thanked: 29 time(s) in 29 post(s)

Hi Alex,

What happens if you add the ChemCode directly into ESdat without using an import template?

When you're on the zRef table, if you click the red plus icon from the left hand menu you can enter the values directly.

Thanks,

Nick

Back to top
WWW
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2025, Yet Another Forum.NET