With the release of WIMS Client 7.7.0 a database upgrade was required.  The upgrade is automatically applied when logging into a Facility Database for the first time with the WIMS 7.7.0 client. 

This database upgrade added columns to the EXPORTHDR table to support narrow format export (see Utilities>Export>Export to Excel ).

Tech Notes:

SQL Server Scripts:

ALTER TABLE EXPORTHDR ADD EXPORTFORMAT NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD01 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD02 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD03 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD04 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD05 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD06 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD07 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD08 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD09 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD10 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD11 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD12 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD13 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD14 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD15 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD16 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD17 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD18 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD19 NVARCHAR(50) NULL DEFAULT (NULL)

 Oracle Scripts

ALTER TABLE EXPORTHDR ADD EXPORTFORMAT NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD01 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD02 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD03 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD04 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD05 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD06 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD07 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD08 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD09 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD10 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD11 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD12 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD13 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD14 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD15 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD16 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD17 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD18 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD19 NVARCHAR2(50) DEFAULT NULL