-
Re: why csv file size is 0 kb or contents missing after be copied by "post processes"
m4estiMar 5, 2018 2:29 PM (in response to david_zhou)
Hi David, I added tags to increase visibility. Are you using ECM?
Mitch
-
Re: why csv file size is 0 kb or contents missing after be copied by "post processes"
david_zhou Mar 5, 2018 4:49 PM (in response to m4esti)Hi, we do not use ECM.
-
-
Re: why csv file size is 0 kb or contents missing after be copied by "post processes"
hexatrieneMar 6, 2018 7:47 AM (in response to david_zhou)
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
-
Re: why csv file size is 0 kb or contents missing after be copied by "post processes"
david_zhou Mar 6, 2018 4:53 PM (in response to hexatriene)hi hexatriene:
QuantReportPostProcess-CopyCSVFile.bat file had been uploaded to your sharepoint.
Thanks for your support.
Best regards
David
-
Re: why csv file size is 0 kb or contents missing after be copied by "post processes"
hexatrieneMar 7, 2018 7:03 AM (in response to david_zhou)
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:
-
Re: why csv file size is 0 kb or contents missing after be copied by "post processes"
david_zhou Mar 8, 2018 12:05 AM (in response to hexatriene)1.adjusted script had been uploaded to your sharepoint, please have check, thanks2. back to c:\temp\, problem is still there.3. post process be edited in my site like below:-
Re: why csv file size is 0 kb or contents missing after be copied by "post processes"
hexatrieneMar 8, 2018 8:13 AM (in response to david_zhou)
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
-
Re: why csv file size is 0 kb or contents missing after be copied by "post processes"
david_zhou Mar 11, 2018 11:33 PM (in response to hexatriene)hi hexatriene :
uploaded 4 new files for your reference.
leaving only the csv report and copy to the c:/temp/
but problem is still.
-
Re: why csv file size is 0 kb or contents missing after be copied by "post processes"
hexatrieneMar 12, 2018 7:00 AM (in response to david_zhou)
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.
-
-
Re: why csv file size is 0 kb or contents missing after be copied by "post processes"
hexatrieneMar 13, 2018 7:39 AM (in response to david_zhou)
1 person found this helpfulOk - 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.
-
-
-
-
-
-
-
-