Hi Evelyn,

It sounds like you may want to create a "combined compound".  A combined compound is the sum of the results of two or more separate Chem Names.

You can find details on creating Combined Compounds in our online manual here: https://www.ESdat.net/ESdatHelp/index.html?combined_compounds.htm

Thanks,

Nick

Hi Evelyn,

No you can't use the same ChemName for multiple ChemCodes in the same Chemistry Profile.

I'm curious as to what situations you need to do this.  Can you provide an example? 

Are they different analysis methods for the same ChemName?  If this is the case, you wouldn't need multiple ChemCodes, as ESdat can differentiate the results based on the Method Name reported by the lab.  In this situation, ESdat would automatically merge these results into a single row and show a range for the results when exporting using the Desktop interface, or show the maximum concentration when creating a table with the Web interface.

Thanks,

Nick

Hi Evelyn,

That's extremely helpful. Thank you.

What you're looking for is the Consolidate ChemCodes feature.  This feature is specifically for the situation you have described.  The Consolidate ChemCode feature allows you to consolidate ChemCodes for the same compound into a single ChemCode.

The best way to manage these is by using the Web Interface for Server.  Have a look at the Online Manual here: http://ESdat.net/ESdat_Server_Help/index.html?consolidated_chemcodes.htm

Once you have consolidated all the existing data into your preferred ChemCode, these will export on a single row.  You can also review the list of consolidated ChemCodes to ensure that they have been assigned correctly, and modify them if required.

If you are able to import your Lab Reports via the Web Interface, it will also automatically assign the correct ChemCode when importing the data.  The Lab Deliverables need an additional header file as well as the sample and chemistry csv files to be loaded in this manner.  You can see the specifications for the header format on our website here: http://ESdat.net/Lab_Specifications_eFiles_eLabReport.aspx

I would recommend following up with your labs to see if they can provide the data in this format.

Otherwise, if you are importing the data through ESdat Desktop, you can assign results to a different ChemCode using this method: http://ESdat.net/ESdatHelp/index.html?chemistrypreimportutilities.htm

If you do use this method, I would also recommend periodically repeating the Consolidate ChemCode process to ensure all your data is correctly assigned.

Thanks,

Nick

Hi Evelyn,

There is a consolidate feature in Desktop, however it is not as advanced and the version in the Web Interface, so I would recommend consolidating your ChemCodes as described in the previous post. 

Once you've consolidated all the codes and are importing via Desktop, you should then make sure that you select "Require Parent Records" in the import dialogue when adding your lab reports.  This will highlight any ChemCodes that don't have a match in the database, rather than just adding them to the list.  You can then use the "Associate Chem Codes" tool to match the compound to the correct ChemCode that you have selected for your database.

The "Associate ChemCodes" tool is accessed from the lab report import template by clicking the eyedropper button in add-ins. Details on it's use are available in the online manual here:

http://ESdat.net/ESdatHelp/index.html?chemistrypreimportutilities.htm

Thanks,

Nick