creation of drawing databases

[Stefano_GS]

Good morning.
in the company the name of the drawings we create follows a non-speaking encoding that does not allow to deduct from the name to what that design refers to.
I was thinking about creating my own database that made my life easier.
my idea was to transform some fields of the cartiglio from simple notes to properties (for example customer - product description - product family) and here comes a problem.
I don't know how to export this data to an incremental excel file.
the option perhaps easier is to fill out these data in the excel file and import them into the drawing

 

[LaboratorioDieci]

Good morning.
in the company the name of the drawings we create follows a non-speaking encoding that does not allow to deduct from the name to what that design refers to.
I was thinking about creating my own database that made my life easier.
my idea was to transform some fields of the cartiglio from simple notes to properties (for example customer - product description - product family) and here comes a problem.
I don't know how to export this data to an incremental excel file.
the option perhaps easier is to fill out these data in the excel file and import them into the drawing

un pdm!

 

[MassiVonWeizen]

create a distinct material with a cell where you concatenate these 3 entries by equation.

I don't know how to export this data to an incremental excel file.

better explain this part

the option perhaps easier is to fill out these data in the excel file and import them into the drawing

Why do you want to insert properties into excel and then import them into solidworks if you can insert them directly into the part?

maybe you can do with the tab builder, but you have to clarify well what you want to get

 

[Stefano_GS]

I would like to get a database so that I can search the drawings made more easily.
in these months I saved them in folders with the names of customers but besides that from the name of the file I do not go back to anything else if not looking for the email I had maybe attached them or opening the preview.

The pdm speech for now is to be excluded as it seems to be more mine than other colleagues do not support, although I hope to make him change his mind if I can set up something working.

by incremental database I mean that I create my part, my design and then I would like to be able to export data to the same file that contains the data of previous drawings. I carry an image to give the idea

 

[MassiVonWeizen]

to export the properties of the single file I believe it serves a macro; here are some discussionhttps://forum.solidworks.com/thread/70738https://forum.solidworks.com/thread/207207https://forum.solidworks.com/thread/44957to import them from a list made in excel you can use tab builder. this procedure:
Open tab builder
from the left select the list entry and drag it into groupbox in the central area
select the newly inserted list entry and view the right column
enter the property name in Nameimposture typeset the path of the excel file containing the property list
enter the range containing the list related to that property as the example shown
repeat for all properties to be inserted
save the file in the folder indicated in custom property file paths http://help.solidworks.com/2018/ita....html?id=23e9577739964cf9822c43900b321132#pg0when you open a 3d file open the bread task and select the custom property tab
select the appropriate template in the drop-down menu and fill it
applyhttp://help.solidworks.com/2018/ita...h.htm?id=31a36f78d86e4d49a3c4c714d79f226b#pg0

 

[Stefano_GS]

as always, in the next few days I try

 

[cacciatorino]

have you tried to index from windows the folder where you hold the drawings and then do a search by inserting into the search field of explorer any anagraphic propitiage of the model?

 

[Jaberwok]

I would like to get a database so that I can search the drawings made more easily.
in these months I saved them in folders with the names of customers but besides that from the name of the file I do not go back to anything else if not looking for the email I had maybe attached them or opening the preview.

The pdm speech for now is to be excluded as it seems to be more mine than other colleagues do not support, although I hope to make him change his mind if I can set up something working.

by incremental database I mean that I create my part, my design and then I would like to be able to export data to the same file that contains the data of previous drawings. I carry an image to give the ideaView attachment 54161

I exploit a table made within a set, which then amount in a database access. import is made simply by respecting the import order of the column a) internal code column b) external code, ... ....

 

[MassiVonWeizen]

by table do you mean different materials?
So if he wants to make a database of all parts of his archive he has to create a fictitious set in which to insert them all (obviously as a simple container)? Wouldn't it become too heavy even to open it?
Shouldn't you always export the database to access or remain connected and automatically update?

 

[Jaberwok]

The database is managed in these relationships. customers / design / model.

you create a table for the product where it is populated through the bom of the furniture (pannelli, ferrametna), oò table of the furniture is inserted in the order, connected to the customer.

If I had to do it only for excel, I would create a "bom of assembly" with defined fields: "clients" "project", "revision", "number of together" , without inserting the parts.

the system included the parts, I need for counting material, creations of distinct machines and hardware.

I only attach the task image to the main axieme (where I then generate the file that interests me). Of course, except I misunderstood the caller

 

[MassiVonWeizen]

But you didn't answer my questions... could you please answer?
the user, if I have not misrepresented, wants to have a database of all the archives of each project so as to facilitate the search for details. If so, it would not be enough for a distinct standard of materials.
I ask the questions:
- to do something like that, would you create a set to insert all the parts and then get the database?
- the table you insert, which I did not understand if it is a separate material or a neutral table, remains connected to the access file and then if I insert a new part in the axieme the access file is updated?
- wouldn't it be a heavy system, maybe it's hundreds of more or less complex parts to handle?

 

[Jaberwok]

Sorry I didn't answer. Now I try.
- to do something like that, would you create a set to insert all the parts and then get the database?

I work with the project together, then I create the parts, and with a bom I turn it into a table to use for: bubble sawing (material), bubble machines (with drawings), bubble hardware (assembly).
so yes, I create a table with the furniture concerned.

- the table you insert, which I did not understand if it is a separate material or a neutral table, remains connected to the access file and then if I insert a new part in the axieme the access file is updated?

The table is customized, it's not connected to the excel file. I don't have synchronia, if you change the mobile I have to update the table and regenerate the access documentation.

- wouldn't it be a heavy system, maybe it's hundreds of more or less complex parts to handle?

My colleague who manages the access has made sure to connect only parts of the resealing tables.
Is that thinking? Not too much. is it synchronized? Is it better? Probably.

♪

 

[MassiVonWeizen]

I can't make myself understand unfortunately, it's my limit
When I talk about all parts I don't mean those of the single project, but those of the entire archive of parts of all projects. this I understood from the request of the thread.

for my personal interest, what's the advantage of using access instead of doing the classic distinct material in excel?

 

[Jaberwok]

Sorry, I can't understand. I was talking about one project. Obviously the speech must be repeated for each project.

In our case, the access is configured to make different bubbles/different, bind with labels.
In short, have the unique data base and then the user extracts what interests him (who the sawing bubble, who the bubble machines, who paint, who the hardware).

Excuse me again if I wasn't clear.

♪

 

[MassiVonWeizen]

but in your case access is an internal management need.
for the request of the thread, to have only a list of files with properties that identify them so that they have a search facilitated, it would seem excessive, in my opinion obviously.

we wait for the user who opened the thread to have the clearest ideas

 

[Jaberwok]

I agree, the system is complex, I just put it "to throw ideas".

 

[MassiVonWeizen]

Thank you. If I ever need something like that, I know it's possible and who to ask.

 

[Stefano_GS]

interesting as a method but I was talking about a different need.
95% of my designs are of only one part and the remaining 5% assemblies of up to 3 parts (of which I am interested in tracking only the data of the assemblies).
this week if I can try with the method of massivonweizen

 

[jenuary]

If I may put myself in the debate, I would like to propose an alternative.
writing data in an excel file can only be done by a macro, it would be enough to install savabackground 4.0 and connect the macro to the "save" event, this works alone and the operator should not worry about anything.
the macro should be written in such a way as to point to the excel reference file, to each saves the macro verification if the same file exists within the reference file, if it occurs if the properties are identical or overwritten or creates a copy in revision, or creates a new line by inserting the new design.

in parallel the excel file that is implemented (in background) by solidworks can be used in parallel also by other programs such as acces etc.

 

[Stefano_GS]

I am trying with the method of massivonweizen.
I can generate with tab builder the properties that interest me so that I point to my excel file.
Such properties I see them correctly in the part file but do not appear in the drawing file.
I tried to read the guide but I don't understand where the error is.
even if I create properties from the drawing file doesn't change anything, in fact it can't change anything because the "create now" button other just open tab builder