Global changes to values in lab sheet

Question

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

Jesse Greenwald · Answer

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.

Phil Wade · Answer

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.