MassHunter custom Excel template not reporting not 'best' from the spectrum ID results section

Question

Hello all, 
 I made a custom excel report template for GC-MS/FID data I'm working with in MassHunter B.10 and I'm having an issue getting the template to report the user selected "best" from the spectrum ID results list. 
 Here is how I've added the table to the template: 
 
 Here is the selected spectrum ID result in MH and saved: 
 
 And here is the report output discrepancy: 
 
 It appears that the 'Best' element under 'SpectralLibrarySearchHit' is always being applied to the top hit from MH, regardless of which is selected as best. I'm wondering if I need to use 'ItemID' under 'SpectralLibrarySearchResult' somehow since it looks like that might be a parent group to the elements that I'm using. 
 Any insight would be much appreciated! 
 Sean

howard_sanford · Answer

Riley-san , 
 I apologize for the delay in getting back to you on this. What I have discovered is that SpectralLibrarySearchHitID will always have Best set to True for the best hit as determined by the search algorithm. If doing a compound workflow report, the selected best hit can be found under 
 CombinedIDResultsPlus->MergedIDHitPlus->Best. 
 But, for a custom report using a manually searched spectrum, this section does not exist in the Report.xml file. Some information regarding the selected best hit for manually searched spectrum does go into the Report.xml file and is used to title plots and structures, but other information on the selected best library entry does not appear to be available. So currently I&rsquo;m not able to suggest a way to report that information for a manually identified spectrum in Navigator view. 
 To see what information is available for Excel reporting for a particular qual report, go to the Configuration menu and select Intermediate Report Files&hellip; It should default to D:\MassHuntereports	emp. Enable the option to Keep intermediate report directories. 
 
 After doing this, whenever a report is generated, the temp report folder will not be deleted and you can examine the generated graphics files and the Report.xml file. 
 Once you have finished your report development work it is best to disable this option again, as large reports with lots of graphics could start to take up a fair amount of disk space.

MassHunter custom Excel template not reporting not 'best' from the spectrum ID results section

Top Replies