Historical chemistry sample data overwritten when importing

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

Notification

Error

Historical chemistry sample data overwritten when importing

Options

Previous Topic Next Topic

Richard Lamendin		#1 Posted : Monday, February 6, 2023 3:33:02 PM(UTC)
Rank: Member Reputation: Groups: Registered Posts: 21 Thanks: 7 times		Hi, I'm encountering an issue when attempting to import historical samples/chemistry across multiple years using an import template. If I have the same well with data from two different sampling events (eg. 2016 and 2021), ESdat will force me to overwrite the sample data from whichever was imported first. I think this is because the sample code is the same for both samples, despite the different sampling date. Previously, the import template generated from desktop would create a unique sample code ID based on field ID, location, date sampled, matrix, etc. The new import template does not seem to have this function. Can anyone comment on this? Thanks


User Profile View All Posts by User View Thanks


	Wanna join the discussion?! Login to your ESdat Forums forum account or Register a new forum account.

Support		#2 Posted : Monday, February 6, 2023 5:09:32 PM(UTC)
Rank: Administration Reputation: Groups: Registered, Administrators Posts: 259 Location: Ballina Was thanked: 8 time(s) in 8 post(s)		Hello Richard, The issue will be, as you have identified, that the SampleCode for each Sample needs to be unique. If you are re-using the same SampleCode that will indicate it is the same sample, so you should ensure the SampleCode is unique for each Sample. There was an Excel formulae in the Import Templates in ESdat Desktop that users could use as you describe, however that hasn't made it to the web version so you should ensure the SampleCode is unique in Excel before uploading the file to attempt to import. I can add it to the feature requests if you like. Alex


User Profile View All Posts by User View Thanks

Richard Lamendin		#3 Posted : Tuesday, February 7, 2023 10:28:20 AM(UTC)
Rank: Member Reputation: Groups: Registered Posts: 21 Thanks: 7 times		Thanks for confirming Alex. Yes it would be good if that feature could be added as we tend to deal with a lot of historical data. Cheers


User Profile View All Posts by User View Thanks

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.