Q15000 Lab Import Interface imports Lab EDD files (CSV, XLSX) to the WIMS LabImportRecs table and to variable data tables.  The LabImportRecs table stores the meta data in the EDD including Method, MDL, RL, analysis dates...  In WIMS the Lab Import Review form allows users to review records not imported, update mappings to locations and analytes and reimport the records if needed.

1. Setup your client/Facility Aliases.
2. Map the columns

1. SampleLocationID
2. Analyte
3. CollectionDate
4. Result
5. Units

3. Create Table, works with the Facility Alias and creates the LabImportRecs table
4. Filters – Hide

insert into LOcation_ALIAS SELECT 'JC',GETDATE(),LOCID,LOCATION FROM LOCATION

insert into LC_TEST_ALIAS SELECT 'JC',GETDATE(),ID,NAME FROM LC_TEST