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
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.
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.
Powered by vBulletin® Version 4.1.7 Copyright © 2012 vBulletin Solutions, Inc. All rights reserved.