SQL database access
I am trying to access the SQL database in order to query some of the data on a bigger scale than can be currently done in Holebase itself. At the company, we don't know how to access the SQL database as it was likely set up by yourselves/Keynetix. Is…
Will an existing installation of HOLEBASE SI be affected if I upgrade SQL 2014 from SP2 to SP3?
Not an experienced user/administrator of this software but the customer I am working for requires SQL to be updated to meet the required compliance level for CE+
Will an existing installation of HOLEBASE SI be affected if I upgrade SQL 2014 from SP2…
Text Tables: Statistics For a Non Key Field
Within the LITHOLOGY table, there is a field .Stratum where each row in LITHOLOGY can be assigned a .Stratum integer 1-9. Suppose they are not necessarily in depth order (interlayered) and several LITHOLOGY rows within a POINT might be assigned the same…
SQL statements and repeating text
I have a repeating text on graph report. The keyset fields are PointID, Depth, Reading, and Reading2. The graph shows up to 5 data sets of Reading2 for reach Reading for each Depth for each PointID. Beneath the graph I have created a table of specimen…
Unable to export Text Table recently using the same Report Design template
I used to export Text Table from gINT to excel through my tailor-made Report Design template.
Recently, I found some of my Report Design templates no longer works. When I tried to export the data, the message of "Reading Report" pops up and the gINT…
Missing Design Application Tabs WITH system properties box unchecked (gINT Pro Plus)
Hello,
I have had the same version of gINT Pro Plus running on a company laptop for some time. Oddly enough, my design application tabs have mysteriously vanished. I am aware of the System Properties > General > Hide Design Application check box, which…
dbo.WH_TableProperties and dob.WH_ColumnProperties
Hello all,
Does anyone have a data dictionary for these tables (gINT CONNECT 10.00.00.69 (gINT Professional Plus) & MS SQL Server 2017 Express) which are created on the SQL database when upsizing a gINT project to an enterprise database?
Some fields…
gINT SQL Sum Quandry
I'm trying to parse some SQL to ultimately export N60 information for soil classifications (line numbers added for discussion sake, not in the code). The trouble is, gINT isn't liking it when I use gINT code inside the SQL other than '<<PointID>>'. It…
gINT: Use NextDepth function inside SQL
Hi All,
For a project, I need to get the difference between current depth and the next depth in SQL. I've tried the following code at it fails. I also tried SQL LEAD and it seems it's not supported by gINT. Any idea how to get both current and next…
How do I plot average water levels for nested piezometers on a log?
Hi
I have a borehole with multiple standpipe piezometers installed. Water level data has been collected over a six month period and recorded in the monitoring group and monitoring data tables (MONG & MOND).
We're reporting detailed monitoring data…
gINT Data in a SQL Environment
Team,
My company is starting to research the use of SQL to host it's gINT data. It is working out very well in our test group. We are able to use the data in a BI software and create boring plans in GIS very efficiently. We are only seeing a few items…
Enterprise Databases Hosted in AZURE
Hi Folks,
I am looking for some insight on if anyone has tried or been successful with using AZURE with gINT. I have been able to get the database created but I am having a few problems.
When trying to upsize I get a timeout error around 30 seconds…
gINT Enterprise User Guide
Product(s):
gINT Professional Plus
Version(s):
V8i and later
Environment:
N\A
Area:
Project Database
Subarea:
N\A
PDF
Enterprise User Guide
…
gINT - Correspondence File SQL Query / Text too long?
I am trying to concatenate a few bits of text into my Hole_Log table.
Basically I want to combine 2 fields within some hand written text e.g.
"Original log produced by " <<HOLE_LOG>> "in" <<HOLE_STAR),yyyy " and digitally reproduced by My Company…
gINT Pro Plus - SQL data
We have been upsizing data into SQL for the past year and are starting to accumulate quite a bit of data. Close to 4000 boring points to be exact. I understand the full process to Upsize and map all this geo-spatially but now here is the question. What…
Upsize error: "enterprise database specified exists, however it is not structurally valid"
Applies To
Product(s):
gINT Professional Plus
Version(s):
8.3.x
Environment:
N/A
Area:
Project Database
Subarea:
Original Author…
Average discontinuities per run
I'm trying to get the fracture frequency based on a fairly normal sample table and a discontinuity table. In the query tool, I can get the correct number of discontinuities (21) if I use the following:
Select Count ([DISCONTINUITY].[Angle]) From [DISCONTINUITY…
Re: combining data from multiple tables in component descriptions
I haven't tried to use <<CompDescChild()>> because its stated function is to bring in children of the components table. Since lab data is a child of sample, it doesn't seem applicable. Do you think there's a way to use it here?
I asked to find out…
Re: gINT Text Reports
Jaffa, the command Max( expression ) will work for most purposes, including a simple list of dates. In that case, the Julian day number of the date that results from (expression) will be evaluated and the maximum value returned. This will be the latest…
Time series graph reports
Dear All,
I am producing a time series graph report and I have two questions:
1. For the independant data axis, is it possible to display a date in a dd/mm/yyyy format or display the calender day rather than a iterative day? I currently display…
Re: sqlrange in output condition
You might be able to handle this with an OUTPUT script with user-entered variables for the filter entries - that would combine the ease and speed of a script with the ability to enter the filter parameters as needed.
I'm not sure why the expression…
SQL Syntax and Logic in gINT
RyanZ asked a good question that illustrates a common issue in using the <<SQL()>> function in gINT reports:
We are working with two separate coordinate systems in our database. One that is describing the lithology of the soil, lab specimen.depth,…
combining data from multiple tables in component descriptions
I have a lithology table with a components child, and a sample table with a lab results child. When I try to combine the components and lab results in one log column, I get repeated component descriptions every time that the lab test's depth doesn't match…
Prompt in SQL list
Hi all, I don't know if I'm being terminally stupid (very probably) but...
I have a Graphic Table Report to output Concrete Cube Test Results, tested on a date specified at output via a Report Var. CUBEDATA being the parent table with data about the…
Re: Missing legends on graphs plots from Sql
Thanks, Phil!
I suspect the problem may be the shift from single project to multiple project. RecordItem, as you have noted, works with the single-project GPJ or SQL Server instance. It's only when you are trying to specify data by RecordItem from…