Jump to content
guitarguy1685

Database of Details

Recommended Posts

guitarguy1685

Hello again.

 

I was recently asked to look in to creating some sort of database for typically used details.

 

Ideally these details would be able to be searched on some database by keywords and then details would appear. Has anyone tried anything similar?

 

I used to work at an architectural firm that had a database accessible via a web browser. You'd type in whatever criteria you wanted and certain details would show up.

 

I'm not thinking of anything that fancy at this time. I'm wondering if Microsoft Access would be an appropriate program to use to create such a database. Currently I don't really know Access, so I'm not sure of it's capabilities.

Share this post


Link to post
Share on other sites
ReMark

Have you looked into drawing management systems?

Share this post


Link to post
Share on other sites
maratovich

The main problem is how to store the details.

We use - one file = one part.

The main folder of the database files. Located on the server.

Inside the subfolder with details.

A special program shows a tree of files.

Select the desired file in the tree, the program inserts the part from the file.

Do not use Access, this is superfluous.

There is a second option - many details in one file.

The program shows the miniatures of the parts.

Select the part and paste it into the drawing.

 

You need

1. decide how to store the items.

2. how to show the list of details.

3. how to insert into the drawing.

Share this post


Link to post
Share on other sites
BIGAL

I would not throw out Access with the bath water just yet.

 

Its a database engine the dwg management progrm we use is based on access and has a huge quantity of features wrapped around a database. The obvious thing is that you think its a special program graphical interface buttons, pull down menus etc create reports, search and so on. But we could just open the the underlying database as a normal Access file. Its currently 101Mb in size. One of the advantages of going down a true database direction is the use of indexes ie instant searches this is built into them. Its another world of programming and search for SQL. You can do database link to another database using a key ie part number. There is I am sure a huge amount of info about writing front end programs for Access. But as a start you can use Access out of the box its excel look and feel makes people happy to enter data creating search macro's would be next step. The step after that is to hide Access altogether.

 

Lastly like Excel->Autocad you can interrogate Access via Autocad just something I have not needed.

Share this post


Link to post
Share on other sites
guitarguy1685
The main problem is how to store the details.

We use - one file = one part.

The main folder of the database files. Located on the server.

Inside the subfolder with details.

A special program shows a tree of files.

Select the desired file in the tree, the program inserts the part from the file.

Do not use Access, this is superfluous.

There is a second option - many details in one file.

The program shows the miniatures of the parts.

Select the part and paste it into the drawing.

 

You need

1. decide how to store the items.

2. how to show the list of details.

3. how to insert into the drawing.

 

Maybe I'm being too simplistic. I imagine it would go like this

 

1. At project close out we would select details that worked very well on the the project.

2. Somone would be tasked with creating an individual dwg of that detail.

3. We would need some naming system

4. We would then enter that file name in to the data base and all the keywords that would call that detail up

5. I would be able to access the database and enter some keywords and some detail file names would show up.

6. I'm guessing the name would be clickable to open the file.

 

A thumbnail would be incredibly useful. I have not thought about how to accomplish that.

Share this post


Link to post
Share on other sites
guitarguy1685
I would not throw out Access with the bath water just yet.

 

Its a database engine the dwg management progrm we use is based on access and has a huge quantity of features wrapped around a database. The obvious thing is that you think its a special program graphical interface buttons, pull down menus etc create reports, search and so on. But we could just open the the underlying database as a normal Access file. Its currently 101Mb in size. One of the advantages of going down a true database direction is the use of indexes ie instant searches this is built into them. Its another world of programming and search for SQL. You can do database link to another database using a key ie part number. There is I am sure a huge amount of info about writing front end programs for Access. But as a start you can use Access out of the box its excel look and feel makes people happy to enter data creating search macro's would be next step. The step after that is to hide Access altogether.

 

Lastly like Excel->Autocad you can interrogate Access via Autocad just something I have not needed.

 

Yes, another language to learn. I'll have to give access a shot. I usually learn best when I have a task in mind.

 

I'm not sure what you mean by "interrogate Access via autocad".

Share this post


Link to post
Share on other sites
guitarguy1685
Have you looked into drawing management systems?

 

Is there one in particular you are thinking of?

Share this post


Link to post
Share on other sites
BIGAL

You can get at the Access database like excel a row:column type answer. You may even be able to use SQL.Autocad has database querry as an option this may only be in Autocad MAP. As an example we could querry our GIS system but IT does not let us, Autocad would become the screen display but all the information is from our GIS database.

Share this post


Link to post
Share on other sites
maratovich

A thumbnail would be incredibly useful. I have not thought about how to accomplish that.

Here are some examples:

 

Example tree elements:

Share this post


Link to post
Share on other sites
Organic
I would not throw out Access with the bath water just yet.

 

Its a database engine the dwg management progrm we use is based on access and has a huge quantity of features wrapped around a database. The obvious thing is that you think its a special program graphical interface buttons, pull down menus etc create reports, search and so on. But we could just open the the underlying database as a normal Access file. Its currently 101Mb in size. One of the advantages of going down a true database direction is the use of indexes ie instant searches this is built into them. Its another world of programming and search for SQL. You can do database link to another database using a key ie part number. There is I am sure a huge amount of info about writing front end programs for Access. But as a start you can use Access out of the box its excel look and feel makes people happy to enter data creating search macro's would be next step. The step after that is to hide Access altogether.

 

Lastly like Excel->Autocad you can interrogate Access via Autocad just something I have not needed.

 

Do you have a GUI though for users to use?

 

Is the database more for storing drawings relating to a project (e.g. kerbing of Smith Street etc) or is it more of a block library database?

 

We use a few databases (some in house developed, others off the shelf and the main problem I find with them is not the database but users and the details chosen (or not chosen...) to enter.

Share this post


Link to post
Share on other sites
BIGAL

Organic whilst I have done GUI in past for a database Knowledgeman it was purpose written, I am sure if I had a go looking at the crystal ball for guidance it would open a can of worms with can you add this we dont use that. It really comes down to what the end user wants and trying to meet those needs. Do we tag certain blocks against a dwg much like a car manufacturer does a recall.

 

It would make sense to have more than one database but have them linked, so like the other question what blocks make a part.

 

The biggest problem is the key word search as mentioned above the user decides what words to use, this needs to be set from day 1, with a list of key words.

 

Just a quick snap shot of a few of the items in our database

Dwg number

Description 1

Description 2

Proj Manager

Proj cost code

Request code

We also enter all charges into this database getting cost reports.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×