Modified BOM table to add blank cells

[filmp]

<DIV>Let assume, I have a drawing composed of 100 items. I am in the process of deleting item 3 and 6. Pro-E will automatically reorder index number, so all items are collapsed down from 1 to 98. This requires me to update all manufacturing procedures. ....Changing all documentis the major task.

</DIV>
<DIV></DIV>
<DIV>Is there any way that I can only leave item 3 and 6 blank, so that all balloons stay the same?</DIV>
<DIV></DIV>
<DIV>Thanks</DIV>
<DIV></DIV>
<DIV>Filmp</DIV>

 

[sip]

repeat region>fix index.


Sip

 

[filmp]

<DIV>I don't think fix index will work. Fix index only rearrange item number but BOM still won't allow a blank part number in the table. I would like item #4,5,etc stay the same. So there won't be any balloon on item #3 and 6. </DIV>
<DIV></DIV>
<DIV>Thanks,</DIV>

 

[sip]

filmp,


If you start a new drawing, and put ina bom, and fix all the indexes, doesn't it work like this that when there are changes like you describe, the indexes stay the same as originally laid out;if there are items missing, they are skipped, so you will have item 1, 2, 4, 5, 7 if items 3 and 6 are deleted from the assembly. I thought that's what fix index was for? That may not help your current problem though.


Sip
Edited by: sip

 

[florinfaur]

You can hide the part you want to delete. In this way, you'll not have
the part in the assembly. To alter the part's quantity in the BO table,
use Relations in Repeat Region


Use this solution is only if you don't like Sip's solution.


Edited by: florinfaur

 

[csusie]

<DIV>I don't think fix index will work. Fix index only rearrange item number but BOM still won't allow a blank part number in the table. I would like item #4,5,etc stay the same. So there won't be any balloon on item #3 and 6. </DIV>
<DIV></DIV>
<DIV>Thanks,</DIV>

Filmp,


Did you actually try using fix index before you deleted the models or are you just stating what you think happens? fix index is the correct command for what you described in your first post.

 

[florinfaur]

<div>I don't think fix index will work. Fix index only rearrange item number but BOM still won't allow a blank part number in the table. I would like item #4,5,etc stay the same. So there won't be any balloon on item #3 and 6. </div>
<div></div>
<div>Thanks,</div>

Filmp,


Did you actually try using fix index before you deleted the models or are you just stating what you think happens? fix index is the correct command for what you described in your first post.

You are right. You can have an assembly with two parts one with number 78 and the second one 314. But, you will not have an empty row for missing part/number.
My understanding is that he wants to have that empty row.

Edited by: florinfaur

 

[csusie]

<DIV>I don't think fix index will work. Fix index only rearrange item number but BOM still won't allow a blank part number in the table. I would like item #4,5,etc stay the same. So there won't be any balloon on item #3 and 6. </DIV>
<DIV></DIV>
<DIV>Thanks,</DIV>

Filmp,


Did you actually try using fix index before you deleted the models or are you just stating what you think happens? fix index is the correct command for what you described in your first post.

You are right. You can have an assembly with two parts one with number 78 and the second one 314. But, you will not have an empty row for missing part/number.
My understanding is that he wants to have that empty row.

I may be wrong, but I was thinking he had a bom with items and balloons already created. Those items already had index numbers, and he wants to delete certain things out of the assembly without having index numbers change on the remaining components. I didnt gather that he wanted a blank line left.


If you want a blank line left you may be able to fix index, remove comps, add a comment line with no inputted values in the cells, that is just a theory.


However, I dont think he wants an "empty row", I think he just wants the index values to stay constant. Can you confirm this filmp

 

[filmp]

<DIV>All,</DIV>
<DIV> Sorry to get back to you late. I want the index values to stay constant, with item # 3 and 6 have no part or meaning. The purpose is to not having update manufaturing procedures.</DIV>
<DIV> I used fix index before. And it is not working. Fix index will always collapse rows. Item#3 and 6 are filled with other parts from the table. </DIV>
<DIV></DIV>
<DIV>I want Tableto look like this</DIV>
<DIV>------------------------------</DIV>
<DIV>Q'ty Description Item</DIV>
<DIV> 1Block 1</DIV>
<DIV>1 Gasket 2</DIV>
<DIV> 3</DIV>
<DIV> 1Handle&nbsp ; 4</DIV>
<DIV>2 Screw& nbsp; 5</DIV>
<DIV> 6</DIV>
<DIV>2 Washer 7</DIV>
<DIV></DIV>
<DIV>and so on to item 100</DIV>
<DIV></DIV>
<DIV>--------------------------</DIV>
<DIV></DIV>
<DIV>Automatic table balloon must work, I don't want to create symbolic ballloon and manually key in.</DIV>
<DIV></DIV>
<DIV>Thanks,</DIV>
<DIV></DIV>
<DIV>Filmp</DIV>

 

[florinfaur]

<div>I want the index values to stay constant, with item # 3 and 6 have no part or meaning.</div><div>[...]
Item#3 and 6 are filled with other parts from the table. </div>
<div></div>
<div>I want Tableto look like this</div>
<div>------------------------------</div>
<div>Q'ty Description Item</div>
<div> 1Block 1</div>
<div>1 Gasket 2</div>
<div> 3</div>
<div> 1Handle&nbsp ; ; 4</div>
<div>2 Screw& amp; nbsp; 5</div>
<div> 6</div>
<div>2 Washer 7</div>
<div></div>
<div>and so on to item 100</div>
<div></div>
<div>--------------------------</div>
<div></div>
<div>Automatic table balloon must work, I don't want to create symbolic ballloon and manually key in.</div>

Filmp,

The only solution I see is to hide the undesired parts instead of deleting them (or you can create bogus parts that contain nothing). In the BOM table you will have in this moment the parts and the quantity as usual. Then, in the Repeat Region create relations that make the parts to show what you want, in your case, nothing.

It is not an elegant solution, but I have tested it and it works. I've got a table with an empty row.

If I wasn't clear enough (English is not my mother's language), please tell me and I'll send you an example.

 

[filmp]

Thanks Florin, I understand what u mean. Hiding part is ok in certain case, but most of the time it is not.

 

[florinfaur]

Filmp, for learning purpose, please tell me what is the solution you chose.

 

[contour]

1. DELETE PARTS.


2. ADD EMPTY (NO GEOMETRY) PARTS NAMED "DUMMY_1, .._2, ..._3 OR ANY.


3. FIX FOR DYMMY PARTS INDEXES OF DELETED PARTS.


4. FILTER DUMMY PARTS OUT FROM BOM.


YOU WILL HAVE "EMPTY INDEX", BUT NOT "EMPTY ROW"



Edited by: contour

 

[filmp]

Contour's solution seem to be the best, I will go with this one. Thanks

 

[csusie]

In what way is that better than using fix index alone. You do not get an empty row with his methodology

 

[florinfaur]

Contour's solution seem to be the best, I will go with this one. Thanks

This is what I said in my previous post:

The only solution I see is to hide the undesired parts instead of deleting them (or you can create bogus parts that contain nothing).
In the BOM table you will have in this moment the parts and the
quantity as usual. Then, in the Repeat Region create relations that
make the parts to show what you want, in your case, nothing.

I'm glad that Contour put the solution in a more inteligent way.

 

[contour]

To get empty rows:


(See my post above)


Do not filter out "dummy..." parts


Add relations:


IF extract(asm_mbr_name,1,5)=="DUMMY"
NAME=" "
qty="-"
else
NAME=asm_mbr_name


In repeat region replace parameters "&asm.mbr.name" by "&rpt.rel.NAME"; "&rpt.qty" by "&rpt.rel.qty"