File Path
SPC
DMS
Table Names
Supporting files 1
(if present)
Table/File Contents
Config_path=
in Cms.ini
(path no. 10);
Applies to entire GainSeeker deployment
X
X
HSICFG,
HSIUC
Configuration settings, roles, and user names
X
X
*.stat
Custom Statistics
*.stat files contain Custom Statistics exported from GainSeeker
See also: configuration-specific HSISCRIPTS table
X
X
AuditTrl
Audit.prf
Audit trail
*.prf file contains legacy audit trail table column settings
X
Mtb_spc.txt
Commands to Send To MINITAB via COM
X
Mtb_dms.txt
Commands to Send To MINITAB via COM
X
Mcht_cmd.txt
List of commands for use with MINITAB charts
X
Minitab.db
MINITAB charts configured for use in SPC Charts and Reports
X
WebOut.dat
HTML format file for legacy SPC modules and Enterprise Dashboard
X
tps_used.log
Usage log for Templates and Planned Sessions
X
X
System and conversion information
X
*.gpn
GagePort configuration files
X
X
*.vsf
Version Verify files
X
X
Btrtools.log
BtrTools log file
No Path (database-only)
Different variations of these table names can be set for different configurations.
X
X
HSIRPT
*.rdlx
*.dlx
*.dbz
*.dbx
*.dbrx
*.dtx
*.txt
*.cpz
*.sfz
*.pix
*.cpx
*.xml
Dashboards and Dashboard Retrievals, Desktops, Chart Skins, Dynamic Reports, Inspections, Device Profiles, Priority Lists, Column and Detail Reports, and .Launch settings
*.rdlx files contain exported Dynamic Reports
*.dlx files contain settings exported from the .Launch module
*.dbz files contain full Dashboards exported from the GainSeeker Charts module versions 8.5 and newer (Dashboard Designs, Retrievals, Filters, etc.)
*.dbx files contain Dashboard Designs exported from the GainSeeker Charts module prior to version 8.5
*.dbrx files contain Dashboard Retrievals exported from the GainSeeker Charts module
*.dtx files contain Desktops exported from the GainSeeker Charts module
*.txt files contain exported Data Column Reports, Data Grid Header and Detail Reports, Chart Skins, and DMS Detail Reports used by the GainSeeker Charts module
*.cpz files contain full Inspections exported from GainSeeker versions 8.5 and newer (Inspection, Device Profiles, and Python Designs)
*.sfz files contain exported Python script folders
*.pix files contain exported planned inspections
*.cpx files contain exported Inspections (versions 8.3 and 8.4)
*.xml files contain exported Inspections (prior to version 8.3) or exported Import/Export/Delete settings
X
X
Table stores Unique IDs for GainSeeker Inspections
X
X
Control table
Table is used by the PC Collect module and GS Console Manager module but can also be used in templates and elsewhere as a generic control table
SPC Standards
(path no. 0)
Different variations of these table names can be set for different configurations.
X
Vstds
Vstdfile.prf,
Vproc.prf
SPC standards
*.prf files contain report formats for printing standards and process specifications
X
VPri
Priority list of SPC standards
X
*.std,
*.tab,
*.ps,
*.xml
Import/export files for SPC standards and process specifications
*.xml and *.ps are file formats from legacy SPC Standard Utility module
SPC Data
(path no. 1)
Different variations of these table names can be set for different configurations.
The
SPC Data table should correspond to a single instance of the tables
for SPC Event, SPC Cause, and SPC Action Taken. These tables use
an internal code or number to log these values, so having two
configurations that point to the same Data table but different
corrective action tables will produce unexpected results.
X
Vdata
De_mtb.prf,
Dt_spc.prf,
Dt_despc.prf
SPC data
*.prf files contain data table column settings for displaying in SPC Data Entry and legacy SPC Charts and Reports and for sending to MINITAB
X
Vdat_aux
Additional SPC data
X
Vmon
Dt_both.prf,
Dt_red.prf,
Dt_green.prf
SPC monitor
*.prf files contain data table column settings for the three types of Monitor windows
X
Vmon_aux
SPC monitor
X
Vnote
Note_spc.prf
SPC notes
*.prf file contains report format for printing notes from legacy Note Manager module
X
X
DashSW
*.eds, *.edf
Legacy Enterprise Dashboard windows
*.edf files contain DMS statistical filter definition
X
X
DashDT
*.edd
Legacy Enterprise Dashboard desktops
X
X
DashRet
*.edr
Legacy Enterprise Dashboard retrievals
X
dt_dbf.prf
Column settings used when viewing failures from real-time failure dashboards in the legacy Enterprise Dashboard module
X
dt_dbd.prf
Data table column settings for SPC dashboards in the legacy Enterprise Dashboard module
X
dt_ddbd.prf
Data table column settings for DMS dashboards in the legacy Enterprise Dashboard module
X
Session
(Pervasive.SQL)
SessionList
(Oracle, SQL Server
and MySQL)
*.dss
SPC stored sessions
X
Filter
*.vf
SPC filters
X
Sfilter
*.sf
SPC statistical filters
X
Mfilter
*.mf
SPC monitor filters
X
Report
*.rp
SPC report formats in the legacy SPC Charts and Reports module
X
Statlist
*.st
SPC statistics lists
X
Desktop
*.dt, *.dtm
SPC desktops in the legacy SPC Charts and Reports module
X
VPri_Dt
SPC desktop priority list for the legacy SPC Charts and Reports module
X
X
RTF*.rtf,
HTM*.htm
Desktop Notes in the legacy SPC Charts and Reports and Enterprise Dashboard modules
X
X
DTNote.rtf,
DTNote.htm
Default Desktop Note for the legacy SPC Charts and Reports and Enterprise Dashboard modules
X
Spc_dt.gmm,
Spc_mdt.gmm,
Spc_dedt.gmm
MINITAB macro files
Different variations of these table names can be set for different configurations.
X
Template
*.dev, *.gpc
SPC data entry templates
DMS Standards
(path no. 2)
Different variations of these table names can be set for different configurations.
X
Dstds
DStds.prf
DMS standards
*.prf file contains legacy report format for printing standards
X
Dproc
Dproc.prf
DMS process information
*.prf file contains legacy report format for printing process specifications
X
Dprocdl
DMS process defect list
X
Dmdl
DMS master defect list
X
DPri
Priority list of DMS standards
Different variations of these table names can be set for different configurations.
The
DMS Data table should correspond to a single instance of the tables
for DMS Event and DMS Master Defect List. These tables use an
internal code or number to log these values, so having two configurations
that point to the same data table but different Event and/or defect
master list table will produce unexpected results.
X
Ddata
Dt_dms.prf,
Dt_dedms.prf,
Ddetail.prf
DMS data
*.prf files contain data table column settings for displaying in legacy DMS Charts and Reports and DMS Data Entry modules, as well as the defect detail table column settings for these legacy modules
X
Ddat_aux
Additional DMS data
X
Dnote
Note_dms.prf
DMS notes
*.prf file contains report format for printing notes from legacy Note Manager module
X
Dstats
*.st
DMS statistics lists
X
Dfilter
*.df
DMS filters
X
Ddt
*.dt
DMS desktops in legacy DMS Charts and Reports module
X
DPri_Dt
DMS desktop priority list for the legacy DMS Charts and Reports module
X
RTF*.rtf,
HTM*.htm
Desktop Notes in legacy DMS Charts and Reports module
X
DTNote.rtf,
DTNote.htm
Default Desktop Note in legacy DMS Charts and Reports module
X
Format.rpt
DMS Report Writer report format in legacy DMS Charts and Reports module
X
Dms_dt.gmm,
Dms_def.gmm
MINITAB macro files
Traceability
(path no. 6)
Different variations of these table names can be set for different configurations.
X
X
Trace1
Trace2
Trace3
Trace4
Trace5
Trace6
Traceability lists 1 - 6
X
X
TraceMst
Traceability 7-48
X
TrPriMst
Traceability priority list
X
EventCA
SPC Event list
X
Cause
SPC Cause list
X
Action
SPC Action Taken list
X
Event
DMS event list
X
SchFile
*.psu
SPC planned session names
X
Plan_Val
SPC planned session contents
X
Plan_Aux
SPC planned session contents
X
Rtmsg.prf
*.prf file supports user-defined text for SPC real-time failure messages
X
X
ChtFonts.prf,
TblFonts.prf
*.prf files support font and color settings for charts and tables in SPC Data Entry and legacy modules
Import/Export
(path no. 8)
Different variations of these table names can be set for different configurations.
X
*.iet
SPC templates from legacy Import/Export module
X
*.ied
DMS templates from legacy Import/Export module
Archive
(path no. 4)
Different variations of these table names can be set for different configurations.
X
V*.arc,
N*.arc
SPC archive files from legacy Import/Export module
X
D*.arc
DMS archive files from legacy Import/Export module
X
X
*.xml,
*.tab,
*.csv,
*.qsv
Export files for GainSeeker data
*.csv and *.qsv are file formats from legacy I module
User Documents
1
(path no. 5)
Different variations of these table names can be set for different configurations.
GainSeeker Collect Mobile App stores photos and videos in this folder
Different variations of these table names can be set for different configurations.
X
X
*.fiw
*.pydash
All Python scripts except for Custom Statistics - including scripts for inspections and GS Console, dashboards, scripted External Data, and Dynamic Desktops
*.fiw files contain File Import Configuration files created in GainSeeker Inspections
*.pydash files contain Python Designs exported from GainSeeker
See also: master HSISCRIPTS table
X
X
Archived versions of Python scripts
GainSeeker Collect Mobile App retrieves photos used in an Inspection from this folder
(For example, C:\Windows\ or
C:\Users\user_name\AppData\
Local\VirtualStore\Windows\)
X
X
Cms.ini
(required)
Workstation-specific settings
X
X
*.prf
When you choose to "save as default... for this workstation only", a .prf file is created or updated in this folder. See above for individual names of .prf files.
ProgramData\Hertzler Systems\ folder
(For example, C:\ProgramData\Hertzler Systems\
or
C:\Users\user_name\AppData\
Local\VirtualStore\ProgramData\Hertzler Systems\)
X
X
Workstation-specific settings
LocalAppData\Hertzler_Systems\ folder
(For example, C:\Users\user_name\AppData\Local\Hertzler_Systems\)
X
X
Collectui.settings
Gscharts.settings
Inspectioneditor.settings
Launchpad.settings
Workstation-specific settings
path referenced by Redirect.hsi
X
X
Settings.hsi
(required)
System settings such as serial number and database connection strings