Program specific results folder location

[[Jo...]]

Hello All,

Is there a way to change the folder where the results are held for a specific program?

I know you can go into setting/environment and change the global path that way. I am looking to change the results location for a specific program. 

Edit: I am specifically looking to export the Excel report. 

TIA!

Edited February 13

[[Jo...]]

To add, I do have PCM, and I cannot use a batch file to transfer files to a new location. 

[[Pa...]]

I've been through this but not for a long time.  Best I could come up with was the following:

Excel report outputs are handled as "results files" and thereby will be stored wherever results files are pointed

- Extras/settings/environment/paths *can only be changed by the Master account*

I was unable to isolate Excel outputs from other "results files" so it's not a complete solution.

 

[[Jo...]]

Please sign in to view this quote.

Appreciate the response. Unfortunately, this is the "global" method I mentioned in the OP. 

I am looking to change this location for an individual program. This can likely be done with PCM in the post setting, I just don't know the best method to proceed. 

[[Lu...]]

Hi Joseph,

Have you tried Resources > Name for Output Files > For This Measurement Plan?

With this function, you can specify the folder in which your results output to. This KB article explains in more detail - https://portal.zeiss.com/knowledge-base?id=587888.

[[De...]]

For storing excel outputs in a specific file location, you can add VBA to ReportINI.xls file to reference fields in the output file and automatically save based on those field.  

[[Lu...]]

Please sign in to view this quote.

I'm sorry, I missed the EXCEL file clarification. This would not apply to those.

[[Jo...]]

Please sign in to view this quote.

Yeah, this is something I might mess around with.

 

I was looking at a PCM option, but am not getting the Syntax correct, keep getting errors. I found the section below in the help menu. Any PCM gurus able to help?

[[Jo...]]

Please sign in to view this quote.

I did mess with this originally, but came to the same conclusion. 😞

[[Je...]]

In your inspection_start_pcm.txt, to get the actual partnumber incemental, because it changes after calculation:

vPNb=getRecordHead("partnbinc")

in your calculation_end_pcm.txt:

vXLSfile=getRecordHead("planid")+"_"+vPNb+".xls"
vXLSpath="C:\Users\Public\Documents\Zeiss\CALYPSO\workarea\results\"+vXLSfile
vCOPYfile="yourFilename.xls" //or vXLSfile
vCOPYpath="yourCopypath\"+vCOPYFile
copyFile(vXLSpath,vCOPYpath)
deleteFile(vXLSpath)  //if you want to delete origin

 

[[Ra...]]

filePathExcel = directoryPath("results") + "\" + getRecordHead("planid") + "_" + getRecordHead("partnbinc") + ".xls"
scriptPath = "Wscript " + directoryPath("results") + "\deleteFile.vbs"
newFolder="C:\Temp\"  + getRecordHead("planid") + "_"  + getRecordHead("partnbinc") + ".xls"


//wait(10)    //if the file is not copying, uncomment this delay to give it more time
if fileExists(filePathExcel) then
  copyFile(filePathExcel,newFolder)
  deleteFile(directoryPath("results") + "\temp.txt")
  addToFile(directoryPath("results") + "\temp.txt",  filePathExcel)
  systemCallWithWait(scriptPath)
endif

From this knowledge base article.

 

https://portal.zeiss.com/knowledge-base?id=722231

[[Jo...]]

Please sign in to view this quote.

I am not 100% sure it will work in my scenario. We currently use a report_end.bat to move files from the results folder to a server location.

I will still test this out to confirm. 

 

[[Ra...]]

I suppose it would depend on if the report_end.bat initializes before the post settings of the program. I'm not sure off the top of my head. I would do a test with just copying the program from the default folder. If it doesn't copy, the .bat had already moved it. You could then change the directory of the top line, filePathExcel, to your server location instead of the default results location.