obtain separate table base by electronic sheet

[deep70]

hello to all, I am to expose the following question, which in turn have made me too.
having an imported and encoded assembly, and having to make its tables would be possible by means of an electronic sheet to obtain its distinct material? through some particular macro or any method to me completely unknown?
Thank you all in advance for any given answers and good evening to you.

 

[MassiVonWeizen]

Let's see if I understand:
you have an imported set that therefore has no property
you have excel sheets that contain all the characteristics, which correspond to specific properties of the models, of the details of the assemblies.
you would like the excel sheet to be loaded inside the drawing or the axieme as distinct materials and that each part would connect to the respective row
Did I go close?

 

[deep70]

I guess it's hard, it's something that the client asked me anyway. .

 

[MassiVonWeizen]

bhé is not that the customer must be content regardless, if he asks for something paradoxical he should be informed. you should explain to the customer how the software works, which you will be doing more to do this attempt than to manually fill out the properties of the parts (which however using the tab builder you can streamline a lot of work) and that a cad, any cad, should be used for what he knows and not for what he would like to do.
That said, I don't understand anything about macro, I'd say it's impossible.
in the environment together the only external table you can insert is that data you do nothing with.
in drawing environment you can insert a distinct materials in excel, but if you select a table already compiled and not formatted as it serves solidworks gives error*

*
tests done in this case:
1 from the drawing created a separate and exported to excel; then in the same together imported the table exported previously and by error
2 Imported a generic table of those present in solidworks directories and verified that it worked (automatically complete some parts properties); Open the above-mentioned generating table and copy the parameters of the table exported in point 1 then saved and remade the process discovering so that the parameters are overwritten.

 

[meccanicamg]

Matta answer question.
I realized you have an encoded set and you want an excel telling you that the pieces that are called abc-000123 are in quantity 2 etc.

to make a distinct minimum material just code and quantity.

the additions are description, material, weight and other bales that do not serve a bat but many like to see.

This can be done: insert/table/distinct materials then save it as xlxs and do what you want.

 

[jenuary]

It's a little weird, but you're not the first person I feel like I have a request like that.
who in the past asked me this question had the following need:

prerequisites:
- Imported together makes step\xt files from external cad
- separate materials in excel files from the external cad

request:
- fill out the custom properties to the components contained in the axieme, in fact they codify the individual parts that is the same thing.
- the custom properties are taken from the excel file, the file name must be in the same name with that of the distinct (it is not so discounted, also because in the import stage from some cad that do not yet have the tree but work at levels, the components do not take the name of the level; sometimes instead in phase of import is created a different file for each instance, e.g. the abc-000123 component is present 3 times in the axieme and are created abc-000123_0, abc-000123_1, abc-000123_2 , then 3 different components, in this case should be codified all three in the same way, but it is not what you want)

all this in order to be able to make the puts on the table of the components and to fill the carts and thus have the control of the future changes, but attention, the holes do not recognize the holes as holes of solidworks so that the compilation of their table is rather vague.
another advantage could be the ball of the assemblies and have integrated everything within your cad, in this case solidworks.

to do all this you have to set up a macro that reads the file according to a logic and transfer to the components the properties, obviously it is not a quick thing or an easy thing, but you can do it, you always have to understand if it makes sense and how many times you need.
attention that by "the logic is always the same" I mean that the layout of the separate must always be the same and the import phase must always generate the same type of imported codifca.

but I probably won't have understood your request well, in two experienced users who have read they have transposed two different things, maybe try to explain your need better.

 

[deep70]

bhé is not that the customer must be content regardless, if he asks for something paradoxical he should be informed. you should explain to the customer how the software works, which you will be doing more to do this attempt than to manually fill out the properties of the parts (which however using the tab builder you can streamline a lot of work) and that a cad, any cad, should be used for what he knows and not for what he would like to do.
That said, I don't understand anything about macro, I'd say it's impossible.
in the environment together the only external table you can insert is that data you do nothing with.
in drawing environment you can insert a distinct materials in excel, but if you select a table already compiled and not formatted as it serves solidworks gives error*

*
tests done in this case:
1 from the drawing created a separate and exported to excel; then in the same together imported the table exported previously and by error
2 Imported a generic table of those present in solidworks directories and verified that it worked (automatically complete some parts properties); Open the above-mentioned generating table and copy the parameters of the table exported in point 1 then saved and remade the process discovering so that the parameters are overwritten.

I think exactly the same things as myself... thank you for the answer is good day.

 

[deep70]

thanks to all the boys... Now it seems they are about to understand certain things... or rather... what you can and should do and that instead not.. At least so it seems... good day to all and thank you again.