Hi all,

Still a newbie so be gentle.

Ive just recently re-ordered and relocated analytes into more appropriate chem groups (from an earlier post). Now i want to export the Chemistry_Lookup and Chemistry_Lookup_ChemGroup tables and import them into the EScIS_Hydrogeology_and_Environmental database so all new projects refence the updated tables.

Ive successfully exported both tables, however, when trying to import them i only have success with the Chemistry_Lookup_ChemGroup table. Importing the Chemistry_Lookup table creates an error with the "Validate_OriginalChemNames" column which says "incorrect data type or text too long". The contents of this column are either FALSE or TRUE which is exactly the same (length, they are all in upper case in the tablei am trying to import, they are all in lower case in the original table im trying to update) as the original Chemistry_Lookup table.

Any ideas on how to import this table and save me pulling my hair out!

Brad 

I am having a similar problem

I am trying to create a project template that will work with all future new projects. I copied the default template into a folder where I have write permissions.

When I try to upload the chemistry data, it works fine for almost all the records, but with about 50 of the records, if I try 'Add New' it gives me the error 'record already exists' and if I try 'update record' I get the error message 'can't update, record already exists'.

All of these chemicals are in the chem group TPH. At first I thought the problem was the fact that in my table, the chem codes for these compounds all had TPH in front of them and they didn't in the default lookup table. However, when I manually deleted that, it only helped for 5 of the records. The chem codes in the table now match the ones in the chart but I still can't get it to update.  

 I can just fix it manually but I don't want to run into this error again.

 ... more questions forthcoming. 

Hello Theresa,

Can you clarify if you are trying to update records in the zRef_Chemistry_Lookup table?  Or is it in Chemistry_Results?

If the former, then one possible explanation for that behaviour is that the ChemName being used is already in the table, but with a different ChemCode. I can't explain how that could have happened though, although am happy to take a look at the new project template and the data you are trying to upload if you want to send it through to support.

Alex. 

Hello Theresa,

The compound names are already in the database, but are listed with the new (4.3) version of the TPH codes.  You must be importing into 4.3, but those codes are in the format of an earlier version.

Version 4.3 had to rename the TPH Codes from (for example) TPHC6_C10 to C6-C10 as the term TPH is tending to be dropped in lots of standards.  

Try renaming the codes (drop the TPH on the front and change the underscore(_) to a dash(-).

That should fix it. 

A minor update (4.3.11) adds some extra checks for some issues around the TPH code renaming, so possibly also try updating to that (downloads page of the website) if you have a lower version.

Alex