[HEADER] Created by Sigma-1 UC-SI Version 1.0.0; Copyright 2009, GEOTAC File Location: C:\Users\Lab\Desktop\UU and UC\18-0568\ File Name: B-04-9'.trx Project: 18-0568 Load Frame Name: Load Frame Date: 10/11/2018 Time: 9:55:09 AM Boring: Boring4 Sample: Sample5 Specimen: Specimen1 Depth (ft): 9 Diameter (inch): 2.76 Height (inch): 5.75 Comments: [SENSORS] Name External Load Cell Load Frame Encoder ID ID1 N/A Module Load Frame ADIO N/A Channel 1 N/A Unit lbs inch Cal. Factor -153659.3986 3940000 Excitation 9.93260192871094 N/A Zero -1.52979007931572E-03 N/A Min. Reading -50 0.0 Max. Reading 500 1.5 [SHEAR] Time External Load Cell Platen Position 10/11/2018 9:55:31 AM -1.85129137609692E-03 -4453467 10/11/2018 9:55:33 AM -2.12776663423938E-03 -4449707 10/11/2018 9:55:34 AM -2.37026581648024E-03 -4443729 10/11/2018 9:55:36 AM -2.7061932550896E-03 -4437747 10/11/2018 9:55:37 AM -3.08362055375255E-03 -4431780 10/11/2018 9:55:39 AM -3.43790507331505E-03 -4425787 10/11/2018 9:55:40 AM -3.81665379609331E-03 -4419841 10/11/2018 9:55:42 AM -4.19522394804517E-03 -4415847 10/11/2018 9:55:43 AM -4.55841319948377E-03 -4409826 10/11/2018 9:55:45 AM -4.90475726963268E-03 -4403872 10/11/2018 9:55:46 AM -5.23597043842528E-03 -4397884 10/11/2018 9:55:48 AM -5.55199318225277E-03 -4391857 10/11/2018 9:55:49 AM -5.87803970180175E-03 -4385850 10/11/2018 9:55:51 AM -6.17397918002098E-03 -4379843 10/11/2018 9:55:52 AM -6.46935913631751E-03 -4373890 10/11/2018 9:55:54 AM -6.75769149733242E-03 -4367880 10/11/2018 9:55:56 AM -7.03564294097305E-03 -4361872 10/11/2018 9:55:57 AM -7.28660638038491E-03 -4357926 10/11/2018 9:55:59 AM -7.51731988808388E-03 -4351936 10/11/2018 9:56:00 AM -7.74978338988149E-03 -4345967 10/11/2018 9:56:02 AM -7.97044931241544E-03 -4340021 10/11/2018 9:56:03 AM -8.19921044574585E-03 -4334068 10/11/2018 9:56:05 AM -8.41035259087221E-03 -4328114 10/11/2018 9:56:06 AM -8.61197095859097E-03 -4324114 10/11/2018 9:56:08 AM -8.82602976054841E-03 -4316131 10/11/2018 9:56:09 AM -9.02311242927681E-03 -4310152 10/11/2018 9:56:11 AM -9.2095879909175E-03 -4306205 10/11/2018 9:56:12 AM -9.39283737296137E-03 -4300252 10/11/2018 9:56:14 AM -9.58020578873402E-03 -4294247 10/11/2018 9:56:15 AM -9.75891947178752E-03 -4288298 10/11/2018 9:56:17 AM -9.92212130238841E-03 -4282348 10/11/2018 9:56:18 AM -1.00971207122529E-02 -4276358 10/11/2018 9:56:20 AM -1.02554416069324E-02 -4270392 10/11/2018 9:56:21 AM -1.04282029291062E-02 -4264440 10/11/2018 9:56:23 AM -1.05821190767347E-02 -4260486 10/11/2018 9:56:25 AM -1.07545946855862E-02 -4254485 10/11/2018 9:56:26 AM -1.09051179875132E-02 -4248535 10/11/2018 9:56:28 AM -1.10548317683606E-02 -4242587 10/11/2018 9:56:29 AM -1.12065455424636E-02 -4236631 10/11/2018 9:56:31 AM -1.13408188991889E-02 -4230627 10/11/2018 9:56:32 AM -1.14778184371971E-02 -4224680 10/11/2018 9:56:38 AM -1.20261142072741E-02 -4202879 10/11/2018 9:56:44 AM -1.25288267977339E-02 -4179013 10/11/2018 9:56:50 AM -1.30113965989767E-02 -4157110 10/11/2018 9:56:56 AM -1.34550974836748E-02 -4135255 10/11/2018 9:57:02 AM -1.38618103978661E-02 -4111396 10/11/2018 9:57:08 AM -1.42550590717474E-02 -4089544 10/11/2018 9:57:14 AM -1.45990102928226E-02 -4065627 10/11/2018 9:57:20 AM -1.49555329000759E-02 -4043769 10/11/2018 9:57:26 AM -1.52689127956728E-02 -4019913 10/11/2018 9:57:32 AM -1.55584237241419E-02 -3998058 10/11/2018 9:57:38 AM -1.58558631973028E-02 -3974200 10/11/2018 9:57:44 AM -1.61023385566114E-02 -3952343 10/11/2018 9:57:50 AM -1.63738614505019E-02 -3928427 10/11/2018 9:57:57 AM -0.016599420213679 -3906398 10/11/2018 9:58:03 AM -1.68440027222277E-02 -3884543 10/11/2018 9:58:09 AM -1.70646686447617E-02 -3860624 10/11/2018 9:58:15 AM -1.72543703859992E-02 -3838652 10/11/2018 9:58:21 AM -1.74727625066771E-02 -3814792 10/11/2018 9:58:27 AM -1.75485717748415E-02 -3792902 10/11/2018 9:58:33 AM -1.78045709115577E-02 -3769077 10/11/2018 9:58:39 AM -1.80231296983402E-02 -3747167 10/11/2018 9:58:45 AM -1.81929029353523E-02 -3723251 10/11/2018 9:58:51 AM -1.83693666259933E-02 -3701281 10/11/2018 9:58:57 AM -1.85131280459609E-02 -3679423 10/11/2018 9:59:03 AM -1.86862227003439E-02 -3655503 10/11/2018 9:59:09 AM -1.88190912999016E-02 -3633532 10/11/2018 9:59:15 AM -1.89765074357274E-02 -3609734 10/11/2018 9:59:21 AM -1.91223521820029E-02 -3587880 10/11/2018 9:59:27 AM -1.92429827275919E-02 -3563986 10/11/2018 9:59:33 AM -1.93914465126545E-02 -3542111 10/11/2018 9:59:39 AM -1.95030294697062E-02 -3518251 10/11/2018 9:59:45 AM -1.96418028112566E-02 -3496399 10/11/2018 9:59:51 AM -1.97593262244663E-02 -3474423 10/11/2018 9:59:57 AM -1.98923733948504E-02 -3450565 10/11/2018 10:00:03 AM -2.00142777456676E-02 -3428639 10/11/2018 10:00:09 AM -2.01113607516163E-02 -3404766 10/11/2018 10:00:15 AM -2.02389198452693E-02 -3382820 10/11/2018 10:00:21 AM -0.020304122006346 -3359020 10/11/2018 10:00:27 AM -2.04509786539711E-02 -3337141 10/11/2018 10:00:33 AM -2.05621806599265E-02 -3313266 10/11/2018 10:00:48 AM -2.08066441212577E-02 -3257460 10/11/2018 10:01:03 AM -2.10395957166475E-02 -3199730 10/11/2018 10:01:18 AM -2.12836067985518E-02 -3143829 10/11/2018 10:01:33 AM -2.14571181181964E-02 -3087984 10/11/2018 10:01:48 AM -2.17107839294476E-02 -3030186 10/11/2018 10:02:03 AM -2.18861642904085E-02 -2974469 10/11/2018 10:02:19 AM -2.20971278647085E-02 -2916797 10/11/2018 10:02:34 AM -0.02227217489346 -2861187 10/11/2018 10:02:49 AM -2.24434957443009E-02 -2803457 10/11/2018 10:03:04 AM -2.26265546507966E-02 -2747750 10/11/2018 10:03:19 AM -0.022770970830461 -2689884 10/11/2018 10:03:34 AM -2.29482559469034E-02 -2634096 10/11/2018 10:03:49 AM -2.30890769005964E-02 -2576250 10/11/2018 10:04:04 AM -2.32525525397978E-02 -2520404 10/11/2018 10:04:19 AM -2.33672902481158E-02 -2462675 10/11/2018 10:04:34 AM -2.35217421082234E-02 -2406888 10/11/2018 10:04:49 AM -2.36476940644388E-02 -2349218 10/11/2018 10:05:04 AM -2.37557294144062E-02 -2293546 10/11/2018 10:05:19 AM -2.38846456463398E-02 -2235818 10/11/2018 10:05:34 AM -2.39793119937713E-02 -2180034 10/11/2018 10:05:49 AM -0.024091883042729 -2124067 10/11/2018 10:06:04 AM -2.41687637358518E-02 -2066335 10/11/2018 10:06:19 AM -2.42531086895178E-02 -2008490 10/11/2018 10:06:34 AM -2.42915847502445E-02 -1952645 10/11/2018 10:06:49 AM -0.024353679778942 -1894914 10/11/2018 10:07:04 AM -2.43730130470794E-02 -1839068 10/11/2018 10:07:19 AM -2.43997272427077E-02 -1783401 10/11/2018 10:07:34 AM -2.44457270875864E-02 -1725733 10/11/2018 10:07:49 AM -2.44658817815252E-02 -1668061 10/11/2018 10:08:04 AM -2.45148339974003E-02 -1612393 10/11/2018 10:08:19 AM -2.45120959113956E-02 -1556547 10/11/2018 10:08:34 AM -2.45146435218521E-02 -1498757 10/11/2018 10:08:49 AM -2.44308342806653E-02 -1443059 10/11/2018 10:09:04 AM -2.44218224062934E-02 -1385240 10/11/2018 10:09:19 AM -2.43686440141937E-02 -1329336 10/11/2018 10:09:34 AM -2.43200608446932E-02 -1271606 10/11/2018 10:09:49 AM -0.02430596565413 -1216000 10/11/2018 10:10:04 AM -0.024158311390147 -1158326 10/11/2018 10:10:09 AM -2.41232043656782E-02 -1140419 10/11/2018 10:10:19 AM -2.40723592990435E-02 -1102714 10/11/2018 10:10:32 AM -2.39536692231013E-02 -1055001 [PEAK POINT] Compressive Stress (psi): 52.1575465368076 Axial Strain (%): 10.7833767380269
Can anybody point me in the right direction.
I include a sample file that the Geotac creates
Thanks
You need to write gINT Rules code to pre-process the data into a gINT compatible csv file, then import it using a script on the command line.
"C:\Program Files (x86)\Bentley\gINTCL\docs\gint_rules_code.pdf"
Phil WadeDatgelBentley Channel Partner and Developer PartnerE: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.
yup, I can code it, but I was not wanting to reinvent the wheel if the wheel had already been made .. Am waiting on reply from equipment manufacturer for info on this matter since, surely, I can't be the only one that is interested in this export/import capability ... Just like gINT can export to many different layouts, so too it would seem that the equipment makers would want to do the same so as to make their equipment attractive so users do not the world over have to create such converters. I can see some potential customers tell a manufacturer, "I like your equipment, but does it export to "xyz" ... or import from ABC." and if the answer is NO, then turning to other suppliers.
Hi Art,
As Phil indicated and you have acknowledged, a gINT Rule needs to be created to import the GeoTac data into gINT.
Yes, the equipment manufacturer could provide this from their end, but it would then need to be modified for each gINT customer so that it matched their own gINT database structure.There is "no one size fits all" example gINT Rule in this case.
Now, a case could be made for using one of the "gINT Std Lab" databases as a starting point. That could be another example gINT Rules Code package put together by Bentley for downloading from their server like a number of other example gINT Rules code packages.
But, which testing machines from GeoTac would be used. I believe that they have several testing machines available.
Regards,
Dave Kyllonen
GeoDatabase Solutions
They do indeed have several machines, I was looking at just one of them at the time I made my post, because that was what one of my colleagues had asked about over lunch, and to me, it appeared as what I call a "new shiny" ( aspect of something that sparked my interest enough that I would start posting forum messages and going down their rabbit hole, lol)
About a converter/importer - I contacted Geotac, and they don't have a tie-in to gINT that will take their data sets and export them to gINT structured (DB) format or, Diggs or AGS, or whatever, and users take the info off the GeoTac output ,and then type it into gINT ( or other log package) OR just print the geoTac data graph and put it into their final report.
The question of course is "OK", but how many of these geoTac tests do they do? If they are bangin out 1000 per year, then maybe it can pay for itself to develop a converter/importer. If they only do 5 a year in comparison to the 5000/year of some other test, then not so attractive except maybe as an intellectual exercise.I agree that it seems that a converter would put their data into a Table structured data scheme e.g. ,Access, or into an Excel workbook with Tab, Rows, and columns, both of which the gINT correspondence utility can handle. I agree that then, the gINT user, could write their own correspondence to get the data into their particular gINT layout. I also agree that an attractive target structure is to put the GeoTac data into a gINT Std Lab and let that be the rosetta stone for further downstream work into other gint layouts. Then again an excel structure seems attractive too because the GeoTac has a limited set of data blocks ( eventual Tabs in an Excel Layout.)