There is basically no need to use cascading for that.
Please have a look into the generic haas.cps post and look for this code:
function onTerminate() {
var outputPath = getOutputPath();
var programFilename = FileSystem.getFilename(outputPath);
var programSize = FileSystem.getFileSize(outputPath);
var postPath = findFile("setup-sheet-excel-2007.cps");
var intermdiatePath = FileSystem.replaceExtension(outputPath, "cnc");
var a = "--property unit 0"; // use 0 for inch and 1 for mm
if (programName) {
a += " --property programName \"'" + programName + "'\"";
}
if (programComment) {
a += " --property programComment \"'" + programComment + "'\"";
}
a += " --property programFilename \"'" + programFilename + "'\"";
a += " --property programSize \"" + programSize + "\"";
a += " --noeditor --log temp.log \"" + postPath + "\" \"" + intermdiatePath + "\" \"" + outputPath + ".xlsx\"";
execute(getPostProcessorPath(), a, false, "");
}
You can add this function to your post processor and it should generate the desired setup sheet during post processing.
Make sure that the setup sheet post processor is located into the same folder as the post processor itself.
Achim.N
Principal Technology Consultant
Thanks for your feedback, just seen that the sample code does not support latest features.
Please use this code instead:
function onTerminate() {
var outputPath = getOutputPath();
var programFilename = FileSystem.getFilename(outputPath);
var programSize = FileSystem.getFileSize(outputPath);
var postPath = findFile("setup-sheet-excel-2007.cps");
var intermdiatePath = getIntermediatePath();
var a = "--property unit 0"; // use 0 for inch and 1 for mm
if (programName) {
a += " --property programName \"'" + programName + "'\"";
}
if (programComment) {
a += " --property programComment \"'" + programComment + "'\"";
}
a += " --property programFilename \"'" + programFilename + "'\"";
a += " --property programSize \"" + programSize + "\"";
a += " --noeditor --log temp.log \"" + postPath + "\" \"" + intermdiatePath + "\" \"" + outputPath + ".xlsx\"";
execute(getPostProcessorPath(), a, false, "");
}
Note that the post is looking for the
setup-sheet-excel-2007.cps
but you can change it to any other setup sheet of course.
The resulting setup sheet will be located into your nc output folder.
Please let me know if it works now on your end as well.
Achim.N
Principal Technology Consultant
This should give you a better file name:
replace this:
a += " --noeditor --log temp.log \"" + postPath + "\" \"" + intermdiatePath + "\" \"" + outputPath + ".xlsx\"";
with this:
a += " --noeditor --log temp.log \"" + postPath + "\" \"" + intermdiatePath + "\" \"" + FileSystem.getFolderPath(outputPath) + "\\" + programName + ".xlsx\"";
The setup sheet gets generated in the background, if you like to have excel open it automatically please look into the setup-sheet-excel-2007.cps and change this last line:
// executeNoWait("excel", "\"" + getOutputPath() + "\"", false, "");
to this:
executeNoWait("excel", "\"" + getOutputPath() + "\"", false, "");
Achim.N
Principal Technology Consultant
@rbraddock thanks for your feedback.
Issue is already fixed into the latest posts which will show up on the library shortly.
I did place the new code into your post processor, see attached.
I have attached the updated setup sheet as well.
Please try again with the new post + new setup sheet and provide feedback.
Thanks.
Achim.N
Principal Technology Consultant
This line is disabled by default into the generic setup sheet.
I´ve changed your Haas post which calls the setup sheet to open excel after it created the setup sheet.
So there is no need anymore to change anything into the setup sheet post itself, all handled by your haas post processor.
With the new sample code which is included into the generic haas.cps people can easily activate or copy/paste that code into any post and it will just work with the generic setup sheet.
Achim.N
Principal Technology Consultant
@rbraddock yes this is possible, you can pass that information to the setup sheet as well.
The code in onTerminate() into your haas post needs to get changed for that, this is the updated function:
function onTerminate() {
var outputPath = getOutputPath();
var programFilename = FileSystem.getFilename(outputPath);
var programSize = FileSystem.getFileSize(outputPath);
var postPath = findFile("setup-sheet-excel-2007.cps");
var intermediatePath = getIntermediatePath();
var postDate = "";
if ((typeof getHeaderDate == "function") && getHeaderDate()) {
postDate = getHeaderDate();
}
var postVersion = "";
if ((typeof getHeaderVersion == "function") && getHeaderVersion()) {
postVersion = getHeaderVersion();
}
var a = "--property unit " + ((unit == IN) ? "0" : "1"); // use 0 for inch and 1 for mm
if (programName) {
a += " --property programName \"'" + programName + "'\"";
}
if (programComment) {
a += " --property programComment \"'" + programComment + "'\"";
}
a += " --property programFilename \"'" + programFilename + "'\"";
a += " --property programSize \"" + programSize + "\"";
a += " --property " + "\"" + "postDescription" + "\"" + " " + "\"'" + description + "\"'";
a += " --property " + "\"" + "postDate" + "\"" + " " + "\"'" + postDate + "\"'";
a += " --property " + "\"" + "postVersion" + "\"" + " " + "\"'" + postVersion + "\"'";
a += " --noeditor --log temp.log \"" + postPath + "\" \"" + intermediatePath + "\" \"" + FileSystem.replaceExtension(outputPath, "xlsx") + "\"";
execute(getPostProcessorPath(), a, false, "");
executeNoWait("excel", "\"" + FileSystem.replaceExtension(outputPath, "xlsx") + "\"", false, "");
}
It now passes the properties called "postDescription" , "postDate" and "postVersion" with the execute command.
You can get these new properties in you setup sheet post by using eg. properties.myPropertyName.
As a sample, this code pushes these properties to programInfo[ ]:
programInfo["program.postDescription"] = properties.postDescription ? properties.postDescription : "undefined"; programInfo["program.postDate"] = properties.postDate ? properties.postDate : "undefined"; programInfo["program.postVersion"] = properties.postVersion ? properties.postVersion : "undefined";
Now you need to add this information into your setup sheet template:
Finally this will result into this setup sheet:
Achim.N
Principal Technology Consultant
