Created tabel com level

[dmillani]

Hello.

I'm trying to create a table in 2D drawing where it should appear the level of assemblies and materials.

Ex.

Item level code description
1 1 033 assembly
2 2 044 piece
3 3 055 sheet steel 3.0mm

I can not find the correct parameter for this problem.

[MartinHanak]

Hi,

please upload your files (drawing, assembly, parts) zipped in one file, if you can.

Use How to Attach a File to a Discussion Reply procedure.

My guess of Repeat region parameters:

1st column ... &rpt.qty

2nd column ... &rpt.level

3rd column ... &asm.mbr.code_param

4th column ... &asm.mbr.desc_param

MH

[dmillani]

Hello

@

To put - & rpt.level

It does not conform to the image it sends it repeats the top level of the table.

I want the level to conform to the image. Piece level 2 and material level 3.

[MartinHanak]

Hi,

maybe repeat region attributes are not set properly.

MH

[MartinHanak]

Or repeat region is not defined properly. Try to create single line repeat region.

[dmillani]

In this case I passed, I have a one-piece assembly, where it joins 3 pieces. When creating a line, it just does not do what I'm trying to do.

[dmillani]

You have to pass me which scheme of codes I should use correctly. He's getting this way when I use the way you said it.

[MartinHanak]

Hi,

I cannot help you if I do not have your data.

MH

[dmillani]

How can we do to pass the data and you try to do?

[MartinHanak]

Use How to Attach a File to a Discussion Reply procedure.

[dmillani]

Hi M.H I'm sending the data to study. I need to make sure that when the material list of the assembly is taken it conforms to the attached worksheet. Then this table is exported to a control application. I would be grateful if I could do this, because I have already tried in various ways and nothing.

[MartinHanak]

Hi,

test attached drawing with your arquivo-teste.rar

MH

[mbonka]

Hello,

what if you need same part use in different "levels" of main assembly? Than parameter "level" will be pointless and final table confusing.

l think, that so called "nested repeat regions" are much better for this.

See attached files:

Note:

Column with * is for transition to excel.

1. Save table as text (in Creo)

2. Import table to excel

3. During import proces select - column separator as *

Best regards

Milan Bonka

[dmillani]

Hello, Milan Bonka

The system we use to import CREO lists takes into account the item levels.
He understands that a level 1 piece has inside it a level 2 feedstock and so throughout the assembly.

Without the parts levels the system will not understand. I am trying to facilitate the work we have today in the sector to do excel in this work of the levels.

And make CREO send direct already ready list.

A simple assembly would look the way below the assembly levels.

[dmillani]

HELLO, M H

The parameters sent for testing did not work.

Follows an image of how it was.

The items in the list did not pull the material from the part or even the level.

[MartinHanak]

Hi,

I can see this picture ...

I attached complete file list. Try it again.

MH

[dmillani]

OK.

The problem of this table is not pulling the description of the material only the description of the part and code of the material.

The correct would be

Level 1 part code and description
Level 2 material code and description

[MartinHanak]

Hi,

8-010-10987-00.asm assembly contains four part components, only. Therefore the assembly has rpt.level=1 and four part components have rpt.level=2.

I am not sure if rpt.level values is OK from your point of view, because you want:

Level 1 part code and description
Level 2 material code and description

---

Maybe your real assembly contains sub-assemblies, too.

If you send me new assembly containing parts and sub-assemblies (that means rpt.level value will be 1,2,3), then I can prepare repeat region, which:

• displays part name + part description for rpt.level=2
• displays material name + part description for rpt.level=3

This repeat region will contain relations.

Also I can filter rows which represent assemblies from repeat region.

MH

[dmillani]

Hi

So our part is configured to have the material tied to it. As shown below.

Entering the properties of the part we can insert a material in the part. That stuff would like it to be on the list as part level.

In the picture item 3-105-00018 is part material.

This item I can not get out of the table as the level of my piece when I take a table of the whole set.

[dmillani]

example:

The wheel is made of steel material.

The wheel in the list is level 1

The wheel material in the list is level 2

[MartinHanak]

Hi,

I am sorry I do not understand your explanation of levels. Please explain what is level.

Level (rtp.level) in repeat region terminology informs, how deep is part located in assembly structure.

Example: All parts in 8-010-10987-00.asm assembly have level=2.

MH

[dmillani]

Hi

Example: All parts in 8-010-10987-00.asm assembly have level.

Yes The example is correct. Inside each part of the assembly still has a level down.

The figure below shows the assembly with the levels of each part.

I am not able to leave the CREO table in this configuration. 

(Rpt.level) does not find the material of each part of the assembly as a level..

[MartinHanak · Accepted solution]

Hi,

I am sending new version of repeat region.

1. I added relation into all models definining parameter MATERIAL_DESC
2. I defined couple of relations in repeat region
3. I defined filter in repeat region (only parts are displayed)
4. I do not know how to get QTY value for material

MH

[dmillani]

It was really good, that's what I was trying to do.

I just can not make the assembly code appear in the list

I could do it?

[dmillani]

1. I do not know how to get QTY value for material

&asm.mbr.peso

[MartinHanak]

Hi,

this means that you can put &asm.mbr.peso in appropriate table cell by yourself.

MH

[MartinHanak]

Hi,

go on and investigate, how my repeat region is created. Investigate its filter and its relations. Investigate the content of cells.

Do not remove filter removing assembly from repeat region. You cannot display assembly, because it needs 1 row and parts need 2 rows.

Suggestion: Create new table with 4 rows.

1st row ... column header

2nd row ... define 1st repeat region for displaying assembly information, only (filter asm.mbr.type==ASSEMBLY)

3rd+4th rows ... define 2nd repeat region for displaying part information, only (filter asm.mbr.type==PART)

I can prepare such table for you, but it does not make any sense. You have to understand, how repeat region works.

MH

[dmillani]

If I have an assembly with two sets.

Is it possible to make the filter to appear also the code of the set or not?

[dmillani]

I can not put the filter you did. I would have you prepare one for me again with this filter. I will continue to study and try to equal your explanation.

[MartinHanak]

Hi,

to see filter defined in my table, click Repeat Region button, then Filter command in menu, select repeat region in table and click Edit command.

MH