MassHunter 10.1 SQL Direct Insert

Hi Canadian_Chemist ,

There are two videos included with the quant supplemental information that give a brief overview of using SQL direct insert. Basically you would need to utilize the SDK and make a custom Python based report. The report code would then access your external database and write results there rather than writing them out to a PDF or CSV file.

As I mentioned in another discussion, you may need to go directly to the folder where the videos reside and view them from there. Opening them from the browser page does not work for some of the older video files. 

You will need to load the SDK and follow the instructions to get it set up. Information on setting up the SDK can be found in this discussion.

 https://community.agilent.com/technical/mass-spectrometry-software/f/mass-spectrometry-software-user-forum/721/mass-hunter-sdk 

There is a short example of some code referenced in the shipping template

D:\MassHunter\Report Templates\Quant\PDF-Reporting\LIMsIntegration_ExportResults.report.xml.

The actual code is in the file

D:\MassHunter\Report Templates\Quant\PDF-Reporting\Codes\LIMsIntegration_ExportResults.py.

The SQL portion is commented out by default, as you would need to include the correct database library calls. Again this is just meant as a very simple example of what could be done and how you would begin to start doing this.

Hi Canadian_Chemist ,

There are two videos included with the quant supplemental information that give a brief overview of using SQL direct insert. Basically you would need to utilize the SDK and make a custom Python based report. The report code would then access your external database and write results there rather than writing them out to a PDF or CSV file.

As I mentioned in another discussion, you may need to go directly to the folder where the videos reside and view them from there. Opening them from the browser page does not work for some of the older video files. 

You will need to load the SDK and follow the instructions to get it set up. Information on setting up the SDK can be found in this discussion.

 https://community.agilent.com/technical/mass-spectrometry-software/f/mass-spectrometry-software-user-forum/721/mass-hunter-sdk 

There is a short example of some code referenced in the shipping template

D:\MassHunter\Report Templates\Quant\PDF-Reporting\LIMsIntegration_ExportResults.report.xml.

The actual code is in the file

D:\MassHunter\Report Templates\Quant\PDF-Reporting\Codes\LIMsIntegration_ExportResults.py.

The SQL portion is commented out by default, as you would need to include the correct database library calls. Again this is just meant as a very simple example of what could be done and how you would begin to start doing this.

Hello howard_sanford 

Thank you  for your help and your time.

I have checked our system files and I cannot find this video folder.

Is there a way to watch that video elsewhere or could you send me a link for it?

Thank you for your time and your fast answer.

Canadian_Chemist ,

You can install the supplemental information from the quant installation flash drive. On that drive is a folder named Supplemental. Copy that to your hard drive and then from there run the Supplemental.msi file to install the videos and example data files on your system.  

I will look for that flash drive or DVD.

Thank you very much for your help howard_sanford !