Community Forum     Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Nj_young  
#1 Posted : Tuesday, February 23, 2021 12:42:54 PM(UTC)
Nj_young
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 83

Thanks: 2 times

We need to update site specific standards anually for landfill monitoring sites. However, when I have tired to do this I am getting duplicate standrds entries(i.e., criteria already in ESdat are not updating). Is it possible to do this or will I need to delete existing stantrds before importing updated standards every year?

fdoolan  
#2 Posted : Friday, March 12, 2021 12:56:47 PM(UTC)
fdoolan
Rank: Newbie

Reputation:

Groups: Registered
Posts: 2
Australia
Location: Melbourne

Hi NJ,

I believe you need to select "update existing" instead of "add new" when importing the updated standard.

Hope that helps.

Nick Tumney  
#3 Posted : Friday, March 12, 2021 2:13:37 PM(UTC)
Nick T
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 234
Australia

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

Hi Nick,

Unfortunately the "Update" option is not available for Enviro Standards.

This is related to conditional standards.  Because you could potentially have two (or more) entries in a single standard for one ChemCode (say arsenic if it has different standards depending on depth or maybe conditional on hardness), this makes it basically impossible to update exisiting entries in bulk (the required table key would be far too complex). 

As you suggested, to achieve what you want, you will need to delete the exisiting standard from ESdat before importing your modifications.  This should be relatively simple, as I'm sure you've determined that you can export the existing standard to Excel first, and use this file as the source for the new import template.

Thanks,

NT

Nj_young  
#4 Posted : Sunday, March 14, 2021 2:58:48 AM(UTC)
Nj_young
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 83

Thanks: 2 times

Thanks for confirming.  ​​​​​​​

nick 

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.