distinct material base.... management.

[giuseppe250388]

hello to all, I have a problem with the distinct base of materials, I make a brief introduction to make the problem understand.

I have recently joined a new company that deals with equipment of vehicles with cranes etc..., the company is going through a transitional phase and switch to a management that also takes care of the management of materials of the carpentry. the management to manage everything needs distinct bases to be inserted inside.

from what I understand, I am not an expert in management, the most important information I have to pass is: codes of every single together; the codes of each particular that make up the axieme and in addition a code that I call id (1,2,3,....n; 1.1,1.2,1.3,...n; 1.1.1,1.1.2,1.1.3,...n)

Now I'll explain how I'm going when I make a project: I realize a particular, then I go into options and there I insert a description in the nomenclature part, then I insert a mass-type parameter and a string-type parameter that I will call raw cod.materie and fill it with the material code for the purchase, I close everything and save.

and so I continue for all the details that make up the axieme, I insert all the components in a design assembly, to completed project I go to customize the distinct base inserting what I care about and then save in excel format...

Here I come to the core of the problem, when I see the distinct base I realize that the program while making a distinction between fathers and children etc. not assigns him an id code (but only the code of assemblies and parts), I realized, and on this I have to thank the forum, that there is also another possibility to pull out a distinct and and that to save in assembly design directly in txt format, surely it is a more synthetic but immediately gives you the idea of fathers and children, but not even there and inserted an id...

I make a small example just to be clearer

1. code together
1.1. Special code
1.2. Special code
1.3. Special code
2. code together
2.1. Special code
2.2. code together
2.2.1. Special code

have you encountered similar problems? how do you manage these operations?

I apologize, trying to explain myself in the best possible way, I've been a little too long.

 

[Vittorio]

That sounds weird. should insert it
but did you put your id code in the properties?

 

[giuseppe250388]

but in this case you are putting it manually, putting it manually I had thought about it. . .
but then I realized that I should go to insert every single component into a set in the same sequence of ids that I assigned him, imagine inserting hundreds of parts becomes complicated, I thought something that was directly connected to the logical tree at the time of insertion

 

[Vittorio]

But no.. absolutely. if you add it to sheet excel project table ..quel code is generated automatically
If you're paying attention. in the image I posted you the number part is attached to the excel sheet.. is in grey

 

[giuseppe250388]

victorious excuse my ignorance, can you explain how you can match the excel sheet?? I just don't understand how you do...

 

[Vittorio]

If you're in the first place, it's hard to explain.
starts with this movie on youtubestart with this

 

[giuseppe250388]

thanks for the video, very interesting.
In practice, I connect a sheet of excels to the project, but I did not understand how it could be useful to me, it would only serve me that when I discharge the distinct base I make a numbered distinction of assemblies and subassiems

 

[Vittorio]

I'm trying to help you tomorrow.

 

[giuseppe250388]

Grazie!

 

[Vittorio]

Hi.
to understand your problem and help you.
do you need to fill in the cartilage of your catdrawing with all the necessary data?
Type :
(1) Special code
2) Material
3) treatment
4) etc. etc.

and this data, which you need, must be written also in the catpart or not?

 

[giuseppe250388]

hi vittorio, no the cadrawing cartiglio there the information I can insert is enough.
what I care about and export a file to excel with a coding that distinguishes me fathers and children, I attach you a distinct that I exported to excel, if you look at the yellow columns that id has been inserted by me manually, I can't export it directly from the program, and I can't even put it in the ownership of every single component because it could be reused to make other projects.
that id that distinguishes me axiemi and under axiemi etc... should be something connected directly to the logical tree.

 

[Vittorio]

If it's not a problem for you, do you send me an image of the properties of your catpart?

this by means of

 

[dalmott]

According to me, seeing how the id is built, it is necessary to have from the beginning the structure quite frozen, changes of structure have important effects on the redefinition of the id.
Can components be reused in other projects? a purchase component (e.g. minutery) used in different projects how would it be managed?
are there hypotheses of using a pdm in the future?

 

[Vittorio]

According to me, seeing how the id is built, it is necessary to have from the beginning the structure quite frozen, changes of structure have important effects on the redefinition of the id.
Can components be reused in other projects? a purchase component (e.g. minutery) used in different projects how would it be managed?
are there hypotheses of using a pdm in the future?

mabiglio, ma @ giuseppe 250388 It seems to me to be the first weapons with catia.
that .xls file has been exported with the "different base" command without customizing the variables to export and possibly adding new personal variables

 

[giuseppe250388]

I'll send you what you asked me

 

[dalmott]

mabiglio, ma @ giuseppe 250388 It seems to me to be the first weapons with catia.
that .xls file has been exported with the "different base" command without customizing the variables to export and possibly adding new personal variables

I'm assuming I'm at first with catechism, but maybe I'm wrong.
I was titubante about the encoding system used, I see little flexible to insert level information on the parts (at least for my experience), also according to a transversal use of the components and therefore to think more about a post-processing in excel that insert this information in caia, avoiding to resume everything later.
the company's prediction to use a pdm could further bind the road to choose (always with the idea of not having to turn everything forward), with the "freeze" components small changes could require huge losses of time.

 

[giuseppe250388]

According to me, seeing how the id is built, it is necessary to have from the beginning the structure quite frozen, changes of structure have important effects on the redefinition of the id.
Can components be reused in other projects? a purchase component (e.g. minutery) used in different projects how would it be managed?
are there hypotheses of using a pdm in the future?

Hello Dalmott. As victors say, they are at first arms, even if it's a few years that I only model these problems I've never happened, I answer the questions you asked me:
-Yes, the components can be reused on other projects.
- a purchase component should still have in id, in a given project by inserting a purchase component becomes an integral part of it, so it could be understood below together.
- sincerely I never used a pdm

 

[Vittorio]

definitely a pdm is made for this type of need.
there was or was there.. smarteam by default free but it does very little.
One thing I've noticed, from your last image, is that that code inserts it manually.
you can automatically generate it with a string variable by concatenating it with other specific variables of the catpart in question that as a final result you return the code.
is a rule that applies to all variables

 

[giuseppe250388]

yes the code is entered by me, I have a database with all commodity codes

 

[Vittorio]

yes the code is entered by me, I have a database with all commodity codes

bhe. without writing it by hand you could match the xls file database so you don't miss it.
if you update the xls .. file automatically updates the catpart