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

Notification

Icon
Error
gedts Site City and Site Town field - is there a way to pull site table field city into the gedts file to be used in ESLog
Options
Go to last post Go to first unread
Previous Topic Next Topic
DCook  
#1 Posted : Friday, January 28, 2022 8:34:58 AM(UTC)
DCook
Rank: Newbie

Reputation:

Groups: Registered
Posts: 5

Thanks: 1 times

i have had success pulling data in the gedts file for additional fields in locations and boreholes table. when I try to do this to pull information from the site table I get SID errors. 

there are other site table data that get passed through to the gedts file but seems to be called by the project_out_information  1. is there a way to query out the site data from the site data explicitly for use in the header info section

or 

2. is there a way to adjust the project_out_information to include more site table fields ​​​​​​​thanks in advance

Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
Kimberley_Support  
#2 Posted : Friday, February 18, 2022 3:56:32 PM(UTC)
Kimberley_Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 64
Australia
Location: Sydney

Thanks: 1 times
Was thanked: 7 time(s) in 7 post(s)

Hi DCook,

you will get an SID error because the borehole SID needs to match the site table ID.

You can do this by performing and inner join on the boreholes table and the site table

[Boreholes] inner join  Sites On Sites.ID = Boreholes.SID 

Then specify which fields from the sites table you would like to display.
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