Starting a new project > Starting a new project (SQL Server Version)

General instructions for starting a new site/project are as follows, you may like to expand this with internal proceedures

1. Starting a new Site / Project

•Start ESdat. Click on the ‘New’ icon, then

•If this is to be a new Project at a new Site click 'New Site and New Project'

•If this is a new Project at an existing Site select the Site, and click New Project

•If this is an additional Site for an existing Project select the Project and click New Site.

•Fill in the Site / Project details

2. Loading Location data (optional)

•From the ESdat menus select Import – Templates - Data Tables,

•In the white Listbox double click on the ‘Location’ table

•A template will open in Excel. Enter the data.

•Select the Import button () on the Excel toolbar, click Import.

•Fix any problems and reimport.

3. Loading Lab Data

•From the ESdat menus select Import, Laboratory File.

•Navigate to the laboratory file. (The laboratory file must be in the ESdat format)

•Select the ‘Sample’ file. The file should then open up in Excel.

•Specify the field duplicates and blanks and import as described in the tutorials

*When a field duplicate is imported, it is important that the sample type is changed from Normal to Field_D under the Sample Type column, similarly Interlab Duplicates must be changed to Interlab_D. The parent sample will need to be assigned in the Parent Sample column. Details on this can be obtained from the field person/sampler.

4. Loading Environmental Standards

•From the ESdat menus select Import, Environmental Standards.

•Navigate to the Environmental Standards file. (The file must be in the ESdat format,

•Select the file that relates to the standards you want. The file should then open up in Excel.

•The file may contain multiple sheets which need to be imported if the standard requires evaluation of a summation of compounds.