PDA

View Full Version : Populating database from the TYP field



Data Wrangler
12-05-2006, 07:56 AM
I'm looking into adding the ability to auto-fill in some database fields based on the XTYP field that the designer enters when inserting an object onto a P&ID. I see no reason I cannot fill out an IO field, a description field and maybe an area field, based on the drawing it is placed on. Has anyone else done this kind of thing before?

Derek

dave
12-05-2006, 08:09 AM
you mean like "if dwg_no >= 100 then area =1" kind of thing?

Data Wrangler
12-05-2006, 10:42 AM
We actually put the area description in an attribute of our titleblock, so this would be a 'grab that attribute text and stick it in the SERVICE field' kind of thing.

Have you tried doing this? I was thinking of adding a 'populate' field to the catt dialog to get all of the code working, and a look-up table with the associated values in it.

Derek

PeterJ
12-05-2006, 01:05 PM
Derek, sut thing can be achieved by small lisp-routines that run whe creating an object in p&id or when it is refreshed (after catt or during 'regen all data').
I've developed such things (and far more complex) stuff for lots of clients. This is however as a service and nor as support, meaning that there will be a price to pay.
Contact me directly if you want me to take this further.

dave
12-05-2006, 04:07 PM
how much would something like that cost? (ballpark)

PeterJ
12-05-2006, 11:52 PM
I would need to see the exact spec for this, but from experience i Would say 2 to 4 hours.
I'll need to ask the consultancy price for the specisfic region.