Working with glNTVBi SS2Version 08.30.04.286 (!IINTW Professional)
Hello,
We have a contractor that delivered sieve data to us. Sieve data is fine. However, split spoon lengths (under main_Group/Sample) is in inches but we needed it in feet. The reason is we created a post-processing package that needs the data in feet. I need to know is there a way to globally change these values or do I need to go into all 24-100 foot borings and change them manually. I can make the changes manually but it takes time. Also, I can't change the column title either (from in. to ft).
Ideas or thoughts on this?
Steve
Hi Steve, one option is to export the data to Excel, recalculate split spoon lengths in feet, and import back into gINT to overwrite the original values. I'd make a backup file of your GPJ first in case something goes wrong during the import. Here's a video on Excel Export, and more can be found in the Data Entry tutorial.
You can change the units in the column header by right-clicking on the column>Report Properties. You'll want to update your Data Template (Tools>Make Data Template) if you want this change in future projects.
Hi Jesse,
Thanks for the response. This is going to work, I exported it , changed the parameter and tried to import it. It is giving me some choices but I want to replace the values. See below. Also, I am not familiar with what a "Correspondence File "is? Any ideas on what overwrite options I should choose? We are very close. Just don't want to do damage to the file.
Hi Steve, you can search gINT Help for more info on the Overwrite Options, but Named fields should work for your case.
A Correspondence File isn't needed in this case. That would be used in a scenario where you need to map data between 2 different data structures, but both the Excel and GPJ have the same structure.
The best technical approach is to run an UPDATE SQL against the database. That could be done using MS Access. I would do it using an Add-In I wrote we call the SQL Tool.
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.
Good Morning Phil, Thanks for responding. I was in a hurry so I did it the way Jesse Greenwald (previous post) suggested and it worked. I was able to run our post processor on the data and it worked successfully. Thanks for your input.