Data is populated from ESdat to the WinLog Database Columns as controlled in the template file WinLog.gedta (Access versions), or WinLog.gedts (SQL Server versions). The file can be opened in Notepad or any other editor and customised. The GEDT format is described here.
When developing or troubleshooting exports to WinLog the recommended approach is as follows:
1.Ensure you are familiar with the layout of the GEDT format. The GEDT format is described here.
2.Locate and open the WinLog Project database in MS Access.
3.Determine the table in the WinLog database that you think should be receiving the data from ESdat by following the logic in the GEDT file.
Generally, the default GEDT file provided with ESdat (unless modified) sends data to the following WinLog database tables:
▪Borehole (Location Information)
▪Samples (Lab Samples)
▪Sample_Text (less preferred method for chemistry results, but is provided)
▪Remarks & Remarks_Text (preferred method for chemistry results and other depth dependent text data)
▪Lithology
▪WellType3 (all tables) - well construction information
4.Once you have determined that the data is exporting to the WinLog database, but is still not showing in WinLog it is probable that the WinLog column you are expecting it to show in is either:
•of the wrong type (note, the remark column in the WinLog log view is of a type "Text" in the Template view), or
•has the wrong name (Note the "RemarkType" column in Remarks must match the column name in the Template View).