create updated "catalogue" of the machine types

[reggio]

Good morning to all,
excuse the title but I didn't know how else to explain the problem and what I'm trying to do.

preamble: we are fixing the types of machines produced and their abbreviations;
often the machines resemble but have some customizations that differentiate them, other times we have parts of machine a and b that are innestate in the machine c,
Therefore we find ourselves with machines that look like all and are differentiated only from a progressive number (not speaking code...) in short to find/remember if we have already made that machine or part of machine or accessory is a big mess. . .

Currently we have created a single dwg file (sigle-macchine.dwg) which contains many rectangles, in each rectangle (which represents an "interesting machine") we insert:
- text with machine acronym e.g. nps11 500x2000 or nps13 600x2500 - or nps16...ecc
- copied and pasted by the original dwg a typical section or a view
- copied and glued by the original dwg strawci of interesting accessories or to remember
- text with orders relating to that machine
In this way we have the possibility to "see" what the acronym of the machine/accessory means, it helps us to remember if, and in which machine we have already implemented a certain solution or shape or accessory, unfortunately however the file becomes soon heavy and has become a "sheet" so great that it is difficult to consult, moreover if the original dwg changes or is updated, that part copio/collata in "sigle-macchine remains not updated. . . .

we then created a table of excels where we transferred
- text with an acronym of the machine e.g. npr05 400x2100 or ncs08 800x4500 - or nts17...ecc
- typical section (creating by copying and pasting the image from the dwg ....)
- strawberries of interesting accessories or to remember (creating by copying and pasting the image from the dwg ....)
- text with orders relating to that machine

In this way we can look for "name" the machine or accessory, and we can filter.. . However, the fact remains that they are never updated drawings/images, and that at each excel line insert you are likely to move or mess up the list here... In short, it is also unmanageable.

I was therefore wondering if autocad can help us solve this problem in a somewhat safer and automatic way, for example, you can create a "galleria/libreria" (with a larger preview of the classic autocad) to which you can attach/tag/. more information?
For example I was wondering if you could connect to a excel cell directly a window of a dwg or at least the image of a dwg so you can point directly to the original dwg file and avoid making copies or even images of the dwg design...

I mean, what would you recommend?

 

[Cristallo]

Well what you want to do is the juice of a database program (such as access for example), but with some help and some sacrifice, you can get something from autocad.

1) do not copy portions of dwg and/or interesting parts, put us a xrif, off scale of course. this allows you 2 fundamental things, one of having the image of the catalog always updated, the other that with double click on the magginetta opens its file

2) to the newly attacked xrif, you can tie a hiperlink (activable then by using control+click on the object) that bets that I know to a excel file, to a word file rather than a photo

for the code.. You must be the one to make up an efficient one.
to call them with the theme nc and a progressive number, makes little sense. I would split the code into subcodes to which to draw the subsets of the machines.

a thing like t01 s02 d01
(iflattering module tErmosald 01 module solleva 02 module ddisplay 01)

when you need to search, in the dwg, just give _find insert the text to search (e.g. s02) and search.
autocad will find the text portion zooming auomatically to scermo where it finds it. you will double-click on the xrif and will open its dwg (always added to the last rescue).

There's only a little work to fix the general design, but then you find it: