logo
    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
EPlayle  
#1 Posted : Friday, May 11, 2018 9:47:53 AM(UTC)
EPlayle
Rank: Member

Reputation:

Groups: Registered
Posts: 15

Hi!

I am looking to include some additional options in the list which displays for the 'Location/Sample Data' when creating Chemistry Output Tables.

In the help (http://www.ESdat.net/ESdathelp/index.html?customising_geology_columns.htm) it says:

The fields listed here are all the Sample, Chemistry, and other fields at the Sample level or higher which are included in the chemistry output queries.  You can select and re-order as you need.  Additional fields can be added to the query/view by an admin user by modifying the query/view in Access or SSMS.

I have not been able to find the view where this list can be modified. Could you please tell me where it is?

Thank you!

Evelyn

Warwick Wood  
#2 Posted : Tuesday, May 15, 2018 3:21:29 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

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

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

Hi Evelyn,

The link given is to alter the fields in the Geology import templates.  Is that the link you intended to give?

In terms of creating custom views for the chemistry views so you can return additional fields.  The Chemistry Views are as at http://www.ESdat.net/ESdathelp/index.html?outputs.htm.  They can't be modified in ESdat, they can only be modified in SSMS (SQL Server Management Studio) if you are using the Server version (which Hemmera are).  You would need to contact your database admin to add additional fields.

Warwick

Warwick

Similar Topics
Lab Dups in Chemistry Output Tables (ESDAT)
by tomb64 9/27/2012 5:40:43 PM(UTC)
Adding Additional Location/Sample Data to Chemistry Output Tables (ESDAT)
by EWatson 9/8/2012 12:26:41 AM(UTC)
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.