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 : Monday, March 16, 2020 11:34:22 PM(UTC)
Nj_young
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 84

Thanks: 2 times

I am trying to set default colors/shading in ESdat web directly using MS SSMS. It appears this is controlled in dbo.zx_ChemTable_EnvironmentalStandard_Settings; however, this table does not list all of the Action Level Sources that listed in dbo.zRef_Environmental_Standards_Config, which seems to control the defaults for ESdat Desktop.

How do I get the rest of the Action Level Sources in the ESdat Web table?

Warwick Wood  
#2 Posted : Tuesday, March 17, 2020 11:13:29 AM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

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

Hi Nick,

That's not the way to do it, you are bound to run into problems.  In general you shouldn't try to access application or cofiguration tables that are hidden from the user in ESdat Desktop, there is a reason those tables are hidden!  

The only way to set the exceedance colours is via the user interface.  It may be a bit painful specifying it for each if you want to set it for a lot, but it's very straightforward and fast for each one.

Warwick

Nj_young  
#3 Posted : Wednesday, March 18, 2020 1:55:57 AM(UTC)
Nj_young
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 84

Thanks: 2 times

So if I set it in ESdat Web it will carry through all new projects for all user accounts?

Warwick Wood  
#4 Posted : Wednesday, March 18, 2020 1:20:36 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

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

Hi Nick,

Yes.  The colours etc.. are saved as a "Layout", which can be used by mulitiple projects / users.  See https://www.ESdat.net/ESdat_Server_Help/chem_table_layout.htm  

Regards,

Warwick

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.