Setup Sheet

[Anonymous]

hi ,
    hi how can I add "Compensation type" parameter in Excel setup sheet as same like as programme parameters are coming in "Operation work sheet"

One Snap is attached.. please have a look...

[Anonymous]

shaji wrote:
hi ,     hi how can I add "Compensation type" parameter in Excel setup sheet as same like as programme parameters are coming in "Operation work sheet" One Snap is attached.. please have a look...

anyone can help to find a solution of this.

[makko74]

can be thats this helps

normally with

if (hasParameter("operation:compensationType") {
  var compType = getParameter("operation:compensationType");
}

[Anonymous]

makko wrote:
can be thats this helps normally with if (hasParameter("operation:compensationType") {   var compType = getParameter("operation:compensationType"); }

I have tried this .it is not working.. I don't know may be I am doing wrong. Can you send one sample template copy with the compensation parameter.... so it will be easy for us.

[makko74]

its hard to say where is the error, i dont use a post processor for excel sheet's.
your post processor must be updated, i dont know your post processor.

[makko74]

my code was only an example to how do get the needed parameter.
is your post processor a generic post, when yes, then can you say me the name of that, then can i have a look

[makko74]

ok i have found it, sorry normally i dont use excel sheets  😉
you must in the setup-sheet-excel-2007-template.xlsx create a new column (look at the pic)

then in the setup-sheet-excel-2007.cps in onSectionEnd add a line (the last line)

function onSectionEnd() {
  var operationParameters = {};
  
  operationParameters["id"] = currentSection.getId() + 1;
  operationParameters["description"] = hasParameter("operation-comment") ? getParameter("operation-comment") : "";
  operationParameters["strategy"] = getStrategy();
  operationParameters["workOffset"] = currentSection.workOffset;
  
  operationParameters["compType"] = hasParameter("operation:compensationType") ? getParameter("operation:compensationType") : "Computer";

[Anonymous]

makko wrote:

ok i have found it, sorry normally i dont use excel sheets  😉 you must in the setup-sheet-excel-2007-template.xlsx create a new column (look at the pic) then in the setup-sheet-excel-2007.cps in onSectionEnd add a line (the last line) function onSectionEnd() {   var operationParameters = {};     operationParameters["id"] = currentSection.getId() + 1;   operationParameters["description"] = hasParameter("operation-comment") ? getParameter("operation-comment") : "";   operationParameters["strategy"] = getStrategy();   operationParameters["workOffset"] = currentSection.workOffset;     operationParameters["compType"] = hasParameter("operation:compensationType") ? getParameter("operation:compensationType") : "Computer";

Thank you for your replay

[Anonymous]

makko wrote:

ok i have found it, sorry normally i dont use excel sheets  😉 you must in the setup-sheet-excel-2007-template.xlsx create a new column (look at the pic) then in the setup-sheet-excel-2007.cps in onSectionEnd add a line (the last line) function onSectionEnd() {   var operationParameters = {};     operationParameters["id"] = currentSection.getId() + 1;   operationParameters["description"] = hasParameter("operation-comment") ? getParameter("operation-comment") : "";   operationParameters["strategy"] = getStrategy();   operationParameters["workOffset"] = currentSection.workOffset;     operationParameters["compType"] = hasParameter("operation:compensationType") ? getParameter("operation:compensationType") : "Computer";

hi ,
  I have tried to add the details as per you suggested. But it is not coming.. more Over that I have no idea about this languages...

I am sending a screen shot...in My post process file it is seeing like this.

in this if you suggest anything I can try once again.

[makko74]

in line 424 you have forget to end the line with an ";" and the solution should be what if, when the condition after the " = " not met (look for example at line 409 )

simplify:

parameter = condition ? what is parameter when condition=true : what is parameter when condition=false;

an simple "if - then - else"

[Anonymous]

makko wrote:
in line 424 you have forget to end the line with an ";" and the solution should be what if, when the condition after the " = " not met (look for example at line 409 ) simplify: parameter = condition ? what is parameter when condition=true : what is parameter when condition=false; an simple "if - then - else"

Hi,
  Thank you very Much for your Help....Now It is working..

[Anonymous]

hi ,
    I am facing an other problem also.. I have a project with 207 tool paths, when I try to create my excel setup sheet.. it is not generating..it is showing error...

But if I select only 125 tool paths it is setup sheet is generating. it I try to add one more tool path it is giving error.

please see the picture of error message

[Laurens-3DTechDraw]

shaji wrote:
hi ,     I am facing an other problem also.. I have a project with 207 tool paths, when I try to create my excel setup sheet.. it is not generating..it is showing error... But if I select only 125 tool paths it is setup sheet is generating. it I try to add one more tool path it is giving error. please see the picture of error message

It runs out of memory.

[makko74]

shaji wrote:
hi ,     I am facing an other problem also.. I have a project with 207 tool paths, when I try to create my excel setup sheet.. it is not generating..it is showing error... But if I select only 125 tool paths it is setup sheet is generating. it I try to add one more tool path it is giving error. please see the picture of error message

Yes Laurens is right, it runs out of memory.
this week i made some tests with this post and had the same error with more than 400 toolpaths.
if you can life without pictures in your setup-sheet then can you try the other generic excel setup sheet post processor, this has not the error.

[Laurens-3DTechDraw]

makko wrote:

shaji wrote: hi ,     I am facing an other problem also.. I have a project with 207 tool paths, when I try to create my excel setup sheet.. it is not generating..it is showing error... But if I select only 125 tool paths it is setup sheet is generating. it I try to add one more tool path it is giving error. please see the picture of error message Yes Laurens is right, it runs out of memory. this week i made some tests with this post and had the same error with more than 400 toolpaths. if you can life without pictures in your setup-sheet then can you try the other generic excel setup sheet post processor, this has not the error.

400 different operations? 😮
What do you guys program?

[makko74]

Laurens-3DTechDraw wrote:
400 different operations? 😮 What do you guys program?

big machine parts laurens  😉
1400x1200mm
five sides machining in one clamping, horizontal/vertical, many threads from M3 to M16 also HeliCoil threads in many sizes. There's a lot coming together

P.S.
oh a little misunderstanding, not 400 operations, over 400 toolpaths and only 256 operations

[Laurens-3DTechDraw]

makko wrote:
big machine parts laurens  😉 1400x1200mm five sides machining in one clamping, horizontal/vertical, many threads from M3 to M16 also HeliCoil threads in many sizes. There's a lot coming together P.S. oh a little misunderstanding, not 400 operations, over 400 toolpaths and only 256 operations

Ah you mean with patterns in them?
But still it feels like more than ever needed. 😛