What Should I Do About Missing Parameters During Import?

During an import, the wizard checks to see if all the parameters are in the Parameters table. If a match for the parameter is not found with one of the above options, Enviro Data then displays the parameter match screen to assist with assigning valid parameter names, if that option is selected.

Enviro Data allows you to specify alternate spellings, or aliases, for parameter names for use during import and output. These values are specified the same way as other lookup values, using the Parameter Aliases button on the MANAGE LOOKUPS form. The intention of this feature is to handle situations where the laboratory is required (for example, by regulations) to report the parameter using a different spelling from the one in the Parameters table. An example would be an alias of 1,2-Benzanthracene for Benz(a)anthracene. It is not intended to intercept misspellings, although it is sometimes used this way. Entries in the ParameterAliases table can either have a site associated with them, in which case the alias is used only for that specific site, or can have a site number of zero, in which case it is used for all sites.

This check is done by spelling (or CAS number if that options has been checked).Just be careful as in some cases, the CAS number may not be unique or standard. You can also import by Outher Parameter ID (such as STORET) if you are using this field.

Parameters section of the Import Wizard form

If some parameters could not be found in your database, you will be presented with a list of these. You are given the option to either match the "new" parameter to an existing one, add the parameter, or create an alias for an existing parameter.

It may be best at this point to take a screen shot of this list and then cancel out of the import. Using this list, you can research to determine if each is already in the Parameters table under a different name. If so, you can then create an alias for that parameter either during your import or using the PARAMETER ALIAS form accessed from Manage Lookups

Parameter Alias Form

If you find new parameter that is not in your database, it needs to be added either manually or during the import.

#44