MantisBT - Hall D Online
View Issue Details
0000352Hall D OnlineDatabasespublic2013-06-07 14:592013-06-13 08:48
wolin 
sergpozd 
normalfeatureN/A
acknowledgedopen 
No
12
0
0
0000352: Upgrade JInventory database system
Develop conventions and update/upgrade database and php code to implement them. Create and implement procedure to add electronics information to database from Fernando's spreadsheets. Purchase and install barcode labels on as much equipment as possible and update database appropriately. Add power hierarchy information to database.
Dave L's SQLite database may be useful for getting at electronics information. Some items already have barcode labels. Use label printer to make large labels for selected equipment. Work with Mark Stevens on power hierarchy.
No tags attached.
Issue History
2013-06-07 14:59wolinNew Issue
2013-06-07 14:59wolinWork by outside group for Hall D => No
2013-06-07 14:59wolinEstimated man-weeks => 12
2013-06-07 14:59wolinPercentage complete => 0
2013-06-07 14:59wolinActual man-weeks => 0
2013-06-07 14:59wolinStatusnew => assigned
2013-06-07 14:59wolinAssigned To => sergpozd
2013-06-07 15:07sergpozdStatusassigned => acknowledged
2013-06-13 08:48wolinNote Added: 0000523

Notes
(0000523)
wolin   
2013-06-13 08:48   
We've decided to add front-end boards using the CLAS convention of a fixed five-layer housing hierarchy. Serguei P will port the CLAS gui's that implement this into the system and modify them to use the housing hierarchy instead of location tables. These gui's restrict the fields shown to those relevant for front-end electronics boards. The full item gui will be used for other items.