ted.evans
2004-09-28, 08:55 PM
For starters we are using ADT 2005. This will be using an Oracle database. I have created Multi-View blocks of our store fixtures and attached Property Set Definitions (PSD) to them. The fields in the PSD are Fixture number – this is unique to each fixture and is in the database. This is what I am using as a common link with the PSD and database as it will not change. A description field- this will be populated in the PSD from the database. A part number field and cost, these will also be populated from the database. These will appear in a schedule. There will be a Fixture schedule located on our fixture layout sheet and will contain all of the info except for the cost. There will be another schedule that will contain all of the info including the cost, this will be exported for costing. This project is broken down into 3 phases, the first phase has two parts. Phase one part a is our standard store fixtures as described above. Phase 2 part b is scheduling the shelving, pegs and acrylics. The only difference between this and part a is that instead of fixture numbers they have POG numbers, the description and part number are located in one database and the cost is in another. Phase 2 is our electrical and will be similar to phase 1.Phase 3 is for construction. I will have to create a database for this containing demo, new construction, carpet, ceiling etc. I will need to pull information from the wall style to get length, sq footage etc.
I need to know where I can get detailed documentation and possibly sample code to set up what I have explained.
I need to know where I can get detailed documentation and possibly sample code to set up what I have explained.