How do I debug MultiQuant Queries


日付: 12/22/2015
カテゴリー: MultiQuant Software

0 投票
   印刷する    記事を評価する:

For research use only. Not for use in diagnostic procedures.
Answer 

  1. Ensure that MultiQuant is closed.
  2. Open Notepad as an Administrator.
    1. Open the start menu in Windows and type notepad in the search box

  1. Right Mouse click on the notepad entry at the top and select ‘Run As Administrator’

  1. In notepad go to ‘File’ > ‘Open’
  2. Change the filter at the bottom right to ‘All Files (*.*)’ and then navigate to ‘C:\Program Files\AB SCIEX\MultiQuant <Version Number>\bin’.

  1. Select ‘MultiQuant.exe.config’ (if you do not have file extensions displayed it will be shown as ‘MultiQuant.exe’ but will have icon.  Press open to open the file.
  2. Once opened the 4th line should read ‘<add key="DebugExcelQueries" value="false" />’.   In order to perform query debugging we need to change this value to ‘true’
  3. Using the text editor exchange the word ‘false’ for ‘true’

  1. Press ‘File’ > ‘Save’ to save the modified file and then close notepad.
  1. Open MultiQuant again and Query some data.
  2. Once the query has completed Press ‘Window Key’ + R or use the Start > Search ‘Run’

  1. Enter %temp% into the run box and press OK.

  1. This will take you to your Temp directory where the Query Output files are stored.
  2. To open them in excel Right Click on one of them and select ‘Open With’

  1. Select Microsoft Excel from the list of programs (you may need to browse to your MS Office install path and select EXCEL.exe

  1. Ensure that ‘Always use the selected program to open this kind of file’ is checked and click OK
  2. Once Excel has opened it will present this message – Click Yes

  1. You will now be able to view all of the calculations made in the query within the excel file.
  2. The temp directory will create a ‘QueryOutput’ file for each compound and they will be named <Query Name>.Compound<number>.QueryOutput


RUO-MKT-18-3000