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

Notification

Icon
Error
Standards not Appearing Correctly in Excel - One standard set is not appearing in excel
Options
Go to last post Go to first unread
Previous Topic Next Topic
EPlayle  
#1 Posted : Thursday, March 15, 2018 9:49:02 AM(UTC)
EPlayle
Rank: Member

Reputation:

Groups: Registered
Posts: 17

180314_suface water_v1_ep.xlsm (164kb) downloaded 3 time(s).Hi!

I have one set of standards in the system which seems to be correct within ESdat but when exported into excel it does not appear in the column in the 'Chemistry Output Table' tab. They do appear within the 'Enviro Limits' tab in the excel table. Oddly it seems to be only the one set of standards that is doing this.

I have tried deleting the whole set of standards from the database and reuploading them but that was not effective.

I have attached my excel file. It is the 'BC WQG FW Aqualic Life - Working' set of standards that is not working.

Thanks for the help!

Evelyn
Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
NickT  
#2 Posted : Friday, March 16, 2018 7:23:09 AM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 327
Canada

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

Hi Evelyn,

Do you have the same issue if you try to export a table with only the 'BC WQG FW Aquatic Life - Working' selected and no other standards?

Nick
Back to top
WWW
EPlayle  
#3 Posted : Friday, March 16, 2018 8:47:41 AM(UTC)
EPlayle
Rank: Member

Reputation:

Groups: Registered
Posts: 17

Hi Nick,

Just tried it, same issue expect that only the standard for one parameter (styrene) appears. 

I'm not sure what to try next.

Thanks!

Evelyn
Back to top
EPlayle  
#4 Posted : Tuesday, March 27, 2018 3:39:32 AM(UTC)
EPlayle
Rank: Member

Reputation:

Groups: Registered
Posts: 17

Hi Nick,

I still have not been able to get this to work. 

Do you have any further suggestions?

Thanks!

Evelyn
Back to top
NickT  
#5 Posted : Tuesday, March 27, 2018 3:38:24 PM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 327
Canada

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

Hi Evelyn,

I've had a look at your table, and it appears that there is a space (or two) after the ActionLevelSource name ('BC WQG FW Aquatic Life - Working '), which you can see when clicking into the field in the Enviro Limits tab.  This is not the case for Styrene, which is why it is coming through.

I recommend checking that you don't have any extra spaces after the Enviro Standard Name in the database, as this is likely causing the issue.  If you fix this it should work as expected.

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-2024, Yet Another Forum.NET