masshunter version as below:
template name:Gen_LIMsIntegration.report.xml
when report mode choose Batch, Batch quant report in csv format is copied into our own directory, but csv contents is missing.
when report mode choose single sample, all quant reports in csv format is copied into our own directory, but all csv file size is 0 kb.
Mar 5, 2018 2:29 PM
Hi David, I added tags to increase visibility. Are you using ECM?
Mitch
Hi, we do not use ECM.
Mar 6, 2018 7:47 AM
Hi David - can you send me the post-processing macro you're using? If you've modified the LIMS report template - it would be useful to have a copy of that as well.
You can post it here: https://agilent-my.sharepoint.com/:f:/p/matthew_leyden/Esfou5CxSzVMqZnSPdV9-voBz25YzD7kwzCA4TjxqwNK3A?e=tzfyLK
Best,
Matt
hi hexatriene:
QuantReportPostProcess-CopyCSVFile.bat file had been uploaded to your sharepoint.
Thanks for your support.
Best regards
David
Mar 7, 2018 7:03 AM
Hi David,
The script you posted appears to just be the default script which ships with Quant. Though its obvious from your screenshots that you edited this file to write to your S drive - I have not reviewed your edits.
I'd recommend switching it back to the C:\temp\ folder to test this problem.
Is there any issue with copying the CSV file to your C:\temp\ directory (instead of the S drive)?
And can you include a screenshot of your SLIM post-process? Mine looks like this - and it works to the C:\Temp\ directory without issue:
Mar 8, 2018 8:13 AM
Hey David,
I tried your script (even mounting a fake S: drive) and it worked perfectly with my Quant B.07.01 SP2 (build 7.1.524.2)
Both the source .csv and destination .csv were fully intact and identical.
Try removing your Excel template from the report list temporarily (leaving only the CSV report) for testing. Keep it copying to the C:/temp/ location for now.
Are you running with full administrative privileges? Or are you a domain user with limited permissions?
Is the log file being written to the Quant report output location?
Best,
Matt
hi hexatriene :
uploaded 4 new files for your reference.
leaving only the csv report and copy to the c:/temp/
but problem is still.
Mar 12, 2018 7:00 AM
Two thoughts:
1.) I do see that you uploaded a copy of the .csv you're generating - is this file from your C:\temp\ directory or from your D:\MassHunter\Data\2018\201803\20180310\QuantReports\chem-019-br-036415-metaldehyde-C180310-1 directory?
If its from the D drive - can you upload the copy of the file that gets created on the C:\temp\ directory?
2.) I see you're running Quant B.07.01 SP1 - can you install SP2 and give it a try? This is the only version I tested.
You can download B.07.01 SP1 here.
hi hexatriene:
An interesting finding is that： see sreenshot
Quant had upgraded to SP2.
Mar 13, 2018 7:39 AM
Ok - David, one last suggestion.
I've created a new LIMs generating Python code component.
Install instructions:
1.) Download this .py file here.
2.) In Windows Explorer, navigate to your D:\MassHunter\Report Templates\Quant\PDF-Reporting\Codes directory.
3.) Rename the existing LIMsIntegration_gen.py to LIMsIntegration_gen.py.orig.
4.) Copy the new downloaded .py code from step 1 into the Codes directory.
5.) Try again.
Let me know if that works.
Hi Hexatriene:
it is OK after used new .py code.
thanks for your strong support.
