in MassHunter workstation software
use PDF report template to generate report
Previously when I had been working with postprocessing I found out that spaces give shipping script hard time to locate the file. Below you'll find few notes I made to get it working properly. Let me know if this is enough of if you require more help on this topic.
By default this script works on batch reporting mode. In Single Run reporting mode naming of CSV files are bit different and thus we need to enable script to find file to be copied forward. By default script copies filed to C:\Temp\.
-Edit script by selecting right-click>edit.
-Locate line: copy %filename%.csv c:\temp\ /y /v >>PostReportProcess.log 2<&1
-Change %filename%.csv to "*.csv*
When you have done this change the script will copy all csv files it finds inside reporting folder forward. Note that when you create this post process in MH Quant and you're using spaces in data folder or data file names you will need to insert quotes around "$(DestinationFilePath)" argument.
I update the tags on this post to improve visibility.
Would you be able to provide more information on the version of MassHunter you are using?
below for your information.
Please look over the below video and document. These outline some of the basics of of using the Post Process functionality in MassHunter Quant.
Excel Custom Reporting - LIMs post processing - Wizard
Introducing PDF Style Reporting and Copy to LIMS
thanks for your support.
Reference to "introducting PDF style reporting and copy to LIMS.",
find new issue, need your help.
Chose PDF report template:
Edit post process as below:
Results set as below:
one error prompted as below: the system cannot find the file specified.
where it goes wrong?
Can you double check that the QuantReportPostProcess-CopyCSVFile.bat file is located at that path on your PC? Maybe you have it located on your C drive instead?
execultable file path was be changed to C drive,
but also no CSV file can be copy to C:/Temp
Is it because I use PDF reporting template?
only PDF file will be created, so no CSV file can be copy by execultable file.
I suspect that this is the problem. This post process executable was written for an older version of Quant when PDF reporting was not available.
Where can get new version post process execultable?
to meet below requirements:
automatically copy CSV or TXT file to specified path when generated PDF quantiative report.
Simply navigate in Windows explorer to the location of the .bat script.
By default - it is D:\MassHunter\Scripts\Quant\Report
Right-click on it and choose 'edit'. It will open in notepad.
Review the 'description' text at the top of the script. It describes what you must edit to make the script work. Currently it only moves a .csv file - change the .csv to .xls or .pdf, whatever is appropriate. You also need to define the final report folder location - currently it's set to C:\temp\. Modify the C:\temp\ to the directory you want.
I have found and used this .bat script in post process.(see previous communcation)
My requirements is :
Is it possible use post process automatically copy CSV or TXT file to specified path when generated PDF format quantiative report?
I think only PDF file can be generated when use PDF report template, what do you think?
Hi David - actually the 'PDF Reporting' is really a misnomer. 'PDF Report Templates' are actually just Python code which can generate any type of file the template is programmed to generate. Currently - all the shipping PDF Report Templates generate PDF output - except for:
Example Report Templates in Quant B.09 which outputs non-PDF output:
You can tell that these produce non-PDF output when you add them to your Quant report method and look at the "destination file" field:
The 4 templates are all in the 'PDF-Reporting' folder. However - their outputs differ, the first is a PDF, the second an XML, the third and fourth are CSVs. And all of these templates are in the same reporting method. So when I generate a report using this reporting method - all 4 reports will be generated and all 4 files will be produced. Any of them can have a post-process script attached to it to copy it to another location.
There are some videos in the Quant videos collection (on the Quant shipping disks/USB) which show how to modify report templates. One of them shows how to use the new PDF Report Builder tool - which can also produce report templates that generate CSV outputs.
Hope this answers your question.
I forgot to address this question:
"Is it possible use post process automatically copy CSV or TXT file to specified path when generated PDF format quantiative report?"
Yes - absolutely. As long as the "PDF Reporting" template generates the output you want (CSV, TXT, XML), the batch script we've discussed can be edited to copy that output to whatever location you specify. The important thing is the report template itself. What is it programmed to write? If it writes a PDF - it must be modified to produce a CSV or XML. I'd recommend starting with one of the existing CSV/XML outputting templates and modifying it to suit your needs. The new PDF Report Builder tool can also be configured to generate CSV type reports (and Quant ships with some example CSV outputting PDF Report Builder templates, as well).
one key point is we can add one and more templates for generated report !!!!!
before , I`ve been confused in how generated PDF report and CSV file at the same time when use one PDF report template.
thank you again for your strong support !
According to your instructions,
I have already succeeded generated PDF and CSV at the same time, and automatically copy CSV file to specified path.
but found one new question:
one batch will be split for several generated report in operation.
the corresponding folder will be created for save output files (PDF ,CSV, Log),see below screenshot: 0918-01-1,0918-01-2,0919-01-3
but CSV file name has always been same name:"Gen_LIMsIntegration.csv",each copy of CSV file to specified path, new copies are saved over old.
I hope all CSV files can be saved in this specified path for LIMS processing.
Can you help me to solve this quesion?
thank you for your support!
My question has been resolved base on your feedback.thank you very much!
ryoboylehexatriene Thank you all for your patience and constructive feedback.
Thank you. Could you mark my post as being the one answering your question. Then it will appear right after your question at top of this thread.
Retrieving data ...