SCT_DB Omnis Application Updates SCT_DB v 5.66 ------------- Add new licences for Glasgow (2) and Cambridge. Bugs Fixed ---------- The detector status report failed to recognise 'Fail*' as a failed test when computing the overall status. SCT_DB v 5.65a 23/3/01 ------------- ** Need a way of printing sheets of serial number barcodes as a report using a local sequence to ensure unicity. User option to enable Insert with barcodes? ** Should strengthen integrity checks in C_Assemble/CheckAssmLinks to check that item CTYPE matches CTYPE in ASSM_ITEMS for both assembly and component. New C_SQL/$ValidateInsertItem method called from Wassemblies, Witems, Wdetectors. Assure that only detector manufacturers can insert detector items from now on. ** Test methods to import assembly records from text file. Put file format on the web. Add CERN System Test, CERN Barrel Baseboards to institute list. Shipments window: Add Manufacturer's serial number to attributes displayed in the 'Items in Shipment' panel. New option to find tests done on all items in a shipment from the Navigate menu. New detector test summary report for all detectors in a shipment from the Reports menu. Bugs Fixed ---------- Wildcard find was not working for list fields like 'Item Type' and 'Location'. In the Assemblies window, Location name was not set correctly during Insert from the Assemblies window. Also, the user was allowed to alter the generated serial number during insert. Detector defects did not show up correctly in the 'Test Results' window when the data was entered using the Java application. SCT_DB v 5.64 31/1/01 ------------- Add support for importing test DetModIV (IV scan for detectors which are assembled on a module) from standard text files. Bugs Fixed ---------- Integrity check during merge checks for local PERSON record for 'gab', and deletes it to make room for the new one for 'GAB'. Supply missing report format for data integrity check log. SCT_DB v 5.63 1/12/00 ------------- Extra control over record OWNER for master user. Raw data plots menu enables only plots which are valid for the current test type. Allow user to logon as a 'guest' at an institute other than his own. Any records entered belong to the institute where the database installed, not the user's institute. Allow user to enter tests on an item which is not owned by his institute, but issue a warning. Bugs Fixed ---------- In the People window, typing in the institute name during 'Find' did not work. SCT_DB v 5.62 8/11/00 ------------- Added 'Assembly Tests', 'Component Tests', 'Assembly Shipments', 'Component Shipments' to Assemblies window Find Related menu. Bugs Fixed ---------- Navigate/Find Again sometimes ignored the 'remembered' value of the active field on the window. Ensure that datafile version is checked and optionally updated, even when the user first opens a new skeleton datafile, then the old. Ensure that the test raw data window updates along with the Tests window when doing Next, Previous, etc. To Do ----- Put institutes list in alphabetical order? SCT_DB v 5.61 1/11/00 ------------- Add dynamic test status to Tests window. All Si detector test windows now have dynamic test status calculated from FDR acceptance criteria. Add find Test Limits to Tests window 'Find Related' menu. Add a new window for 'DetModIV' test, IV scan for detectors which are mounted on a module. IV and CV plots are available by selecting from a menu on the test raw data window. Bugs Fixed ---------- The array of module survey Z measurements was truncated when imported from a text file. Add checks on validity of user initials and test_name vs. item_type when importing test data from text file. Problems Remaining ------------------ * Changing TESTS.TEST_NAME could give inconsistencies where special test data exist for that test. * Omnis SQL problems with 'SELECT ... WHERE MAX(SER_NO)< @[lvmax] for 14 digit serial numbers interferes with C_SQL.$GetLastSerNo. Execute it on Master Server for now. * Omnis SQL problems with case-insensitive string searches. * Links not working to EDMS from ITEM_DESCR, TEST_DESCR. * Should define assemblies for module0. Define fmSpine assembly for module-1. * Can't get tabs to display correctly in window fields on PCs. Neither can Omnis tech support. It is ok on Macs. * Remaining problems with multi-user access to Local Cache: Shortcut to .df1 doesn't work any more on PCs. Access via 'DAVE' software on Mac is not supported by Omnis. * Need reports for special tests, including detector data summary. * No report defined for Stocks. * Need a window for Gif and JPEG images. SCT_DB v 5.60 16/10/00 ------------- Add new ITEMS.TRASHED attribute to Items to flag items which have been discarded. Add new Nominal Value attribute to TEST_LIMITS. TEST_LIMITS has a single link to TEST_LIST now, rather separate links to ITEM_DESCR and TEST_DESCR. Create a window for handling TEST_LIMITS. Detector IV scan and depletion voltage test windows now display dynamic test pass/fail status using TEST_LIMITS. New routines to update data file structure without having to rebuild it from the skeleton version. Added C_Test/ImportFromFile method! It is called from Wtests/UplTest_RawData. Bugs Fixed ---------- Don't allow an item to be added to more than one shipment at a time. SCT_DB V 5.52 ------------- Call data integrity checking routines at start of merge local-->master. Bugs Fixed ---------- Merge Local-->Master: UpdRemTable call to ValidateInsert now returns lvValidateResult, not lvResult. Add remote OWNER check. Rollback session if anything fails. Add Set Transaction Mode Generic to C_Sessions/_MasterServer SCT_DB v 5.51a 15/9/00 Bugs Fixed ---------- An error in the Omnis TEST_IMAGES table primary and foreign keys prevented test images from merging. Remove 'Send to Trash' option from Items window Send/Receive menu. In future this will be flagged by a new boolean attribute: ITEMS.TRASHED. SCT_DB v 5.51 8/9/00 -------------- New navigation options for detector tests to simplify comparison of manufacturer's and institute's test results. Leakage currents on manufacturer's detector test and institute's IV test windows are displayed as measured and also corrected to 20 C. New 'Send/Receive' menu on Shipment window for inserting, checking and receiving shipment items quickly. Should 'Flash Insert' skip asking for confirmation of each item? New 'Send/Receive' menu on Items, Detectors, Assemblies windows to send items to 'Trash' and recover them later and also to send selected items to the current shipment. Any discarded item that ever really existed should be sent to Trash, rather than deleted from the database. Speed up window response a bit by streamlining $ConfigFields and $IsComplete methods. User is no longer allowed to change 'Assembled?' or 'Passed Tests?' attributes of items by hand. This is done only by automatic procedure. Bugs Fixed ---------- On the shipment window 'To Institute' and 'Senders Initials' fields were active when they should not have been. On all windows 'Find', then 'Cancel' did not empty the results list from the previous 'Find'. Drag and drop component entry did not work in the Assembly window because the component serial number list was empty. Disassembling the first component in the list on the Assembly window also deleted that line in the list, instead of just setting the serial number to 0. Items and Detectors windows now all call the same $ValidateDelete method to enforce uniform constraints. Items can't be deleted if they appear in disassembly records. Assemblies with components linked can only be deleted from the Assemblies window, and then only if there are no disassembly records. Deleting assembly items from the Assembly window corrupted the local serial number sequence. Items window sometimes demanded a valid manufacturer even when that field had a value in it. Problems Remaining ------------------ * Changing TESTS.TEST_NAME could give inconsistencies where special test data exists for that test. * Omnis SQL problems with 'SELECT ... WHERE MAX(SER_NO)< @[lvmax] for 14 digit serial numbers interferes with C_SQL.$GetLastSerNo. Execute it on Master Server for now. * Omnis SQL problems with case-insensitive string searches. * Links not working to EDMS from ITEM_DESCR, TEST_DESCR. * Should define assemblies for module0. Define fmSpine assembly for module-1. * Can't get tabs to display correctly in window fields on PCs. Neither can Omnis tech support. It is ok on Macs. * Remaining problems with multi-user access to Local Cache: Shortcut to .df1 doesn't work any more on PCs. Access via 'DAVE' software on Mac is not supported by Omnis. * Need reports for special tests, including detector data summary. * No report defined for Stocks. * Need a more convenient way of plotting IV and CV curves from test raw data. * Need a window for TEST_LIMITS, and procedures for setting TESTS.PASS and ITEMS.PASSED. * Need a window for Gif and JPEG images. SCT_DB v 5.50 14/7/2000 -------------- Add support for module X-Y and Z survey data. Add tables for GIF or JPEG images linked to Items or Tests. No window to display then yet. Merge Master-->Local gets items in shipments to/from your institution even if you don't own them. It gets all tests for items shipped to you, but only basic item information for items shipped to others. OWNER attributes of class 2 tables on the master server are indexed for faster response. Disassembly now deletes the ASSM_ITEMS record on master server as well as local cache, and also fills DISASSMLOGS. Comment and special test windows remember their last postion on the screen when opening. Bugs Fixed ---------- Sometimes got a 'Datafile full' message on Macs because of corruption of the 'skeleton' datafiles disributed with each release. Skeleton datafiles are now created from scratch for each platform. The Import menu on the Tests window was incorrectly enabled for definition level users. Assembly description window now displays all item types with number of components >= 1. LAST_MOD date was sometimes set incorrectly for local tables. Some new and updated records could be overlooked by Merge Master-->Local. Problems Remaining ------------------ * Changing TESTS.TEST_NAME could give inconsistencies where special test data exists for that test. * Omnis SQL problems with 'SELECT ... WHERE MAX(SER_NO)< @[lvmax] for 14 digit serial numbers interferes with C_SQL.$GetLastSerNo. Execute it on Master Server for now. * Omnis SQL problems with case-insensitive string searches. * Links not working to EDMS from ITEM_DESCR, TEST_DESCR. * Should define assemblies for module0. Define fmSpine assembly for module-1. * Can't get tabs to display correctly in window fields on PCs. Neither can Omnis tech support. It is ok on Macs. * Remaining problems with multi-user access to Local Cache: Shortcut to .df1 doesn't work any more on PCs. Access via 'DAVE' software on Mac is not supported by Omnis. * Need reports for special tests, including detector data summary. * No report defined for Stocks. * Need a more convenient way of plotting IV and CV curves from test raw data. * Need to streamline 'receiving' large numbers of shipped items. * Need a window for TEST_LIMITS, and procedures for setting TESTS.PASS and ITEMS.PASSED. * Need a window for Gif and JPEG images. SCT_DB v 5.46 (Not released) -------------- Import test data batch mode improvements: Change name from 'Upload' to 'Import' - less confusing. New Import menu option to create a batch file from the names of text files in a chosen directory. Move successfully imported files into 'ImportedFiles' directory. If there is an error during import, just fix it and try again - no need to edit the batch file. Dragging and dropping item serial numbers onto Assembly and Shipment windows now inserts the detail record without waiting for the user to hit . Bugs Fixed ---------- Dragging item serial number onto Shipment window detail panel did not look up the item type correctly. The Insert button on the Assembly window Components panel was not enabled/disabled correctly. Dragging items of the wrong type onto Assembly window Components panel did not always give sensible error messages. Dropped call to UpdTblLastMod from DloadRecords. It could have lead to overlooking Item or Shipment records which had been updated on the Master server. Log files for merging databases and shipments are now always written in the same directory as the datafile. SCT_DB v 5.45a 8/6/00 -------------- Bugs Fixed ---------- The 'Receive' button was sometimes incorrectly disabled on the Shipment window. SCT_DB v 5.45 19/5/00 -------------- Added 'This Mfr Serial No.' item to Item and Detector 'Find Related' menues. This finds all items which have the same manufacturer's serial number as the current item on the window. Merge Master-->Local now deletes local class 1 records with no corresponding master copy. In the Detector Items window, 'Find' with scratch pads set to nn but Manufacturer empty returns detectors with mod(ser_no,1000000)=nn for any manufacturer. Bugs Fixed ---------- Displaying 'Detail n/N' on window status bars was misleading when details panel was hidden. 'Navigate/Repeat Find' menu item is now enabled even when no records have been found. Drag + drop into 'Item Serial Number' did not work when the Tests window was first opened. Fixed a problem in the initialisation. Ask user to continue/stop when changing an item's type if that item has tests. The 'Receive' button on Shipment window is now correctly disabled after all items have been received. Problems Remaining ------------------ * Changing TESTS.TEST_NAME could give inconsistencies where special test data exists for that test. * Omnis SQL problems with 'SELECT ... WHERE MAX(SER_NO)< @[lvmax] for 14 digit serial numbers interferes with C_SQL.$GetLastSerNo. Execute it on Master Server for now. * Omnis SQL problems with case-insensitive string searches. * Links not working to EDMS from ITEM_DESCR, TEST_DESCR. * Should define assemblies for module0. Define fmSpine assembly for module-1. * Can't get tabs to display correctly in window fields on PCs. Neither can Omnis tech support. It is ok on Macs. * Remaining problems with multi-user access to Local Cache: Shortcut to .df1 doesn't work any more on PCs. Access via 'DAVE' software on Mac is not supported by Omnis. * Need reports for special tests, including detector data summary. * No report defined for Stocks. * Merge Master-->Local should copy Tests for each Item even when they were performed somewhere else. It should also check if the tested item exists on the local cache. * Merge Master-->Local ignores Shipment Item records from home institute where shipment has been confirmed. SCT_DB v 5.44a 20/4/00 -------------- Add some diagnostics to institute's test upload routine. Bugs Fixed ---------- A logic bug disabled all 'Insert', 'Edit', 'Delete' buttons for class 2 users. Inserting shipment items in the local cache sometimes failed with Oracle errors from the master server. Problems Remaining ------------------- SCT_DB v 5.44 19/4/00 -------------- Add 'Detail n/N' to status bars. Add 'Ship Selected Items' to Items and Detector window 'Reports' menu. The selected items are added to the shipment in the Shipment window. Checks are done of item locations, owners, etc. You are prompted to accept ('OK') or reject ('Cancel') each item. Bugs Fixed ---------- Corrected some help texts for 'Owner' and 'Last Mod' fields. Problem with Assemblies window loading details: strange behaviour of $ConfigButtons call to 'Do inherited'. This called the inherited $LoadDetails instead of $ConfigButtons! Shipments FROM home institute which had been confirmed were overlooked by Merge Master-->Local. 'Find' works with scratch pads on Detectors window now. Some 'Find Related' operations were failing even when the target record existed. Initialise lists after Merge Master-->Local. Problems Remaining ------------------ * Changing TESTS.TEST_NAME could give inconsistencies where special test data exists for that test. * Omnis SQL problems with 'SELECT ... WHERE MAX(SER_NO)< @[lvmax] for 14 digit serial numbers interferes with C_SQL.$GetLastSerNo. Execute it on Master Server for now. * Omnis SQL problems with case-insensitive string searches. * Links not working to EDMS from ITEM_DESCR, TEST_DESCR. * Should define assemblies for module0. Define fmSpine assembly for module-1. * Selecting serial numbers with scratch pads = nn but mfr empty should return detectors with mod(ser_no,1000000)=nn. * Can't get tabs to display correctly in window fields on PCs. Neither can Omnis tech support. It is ok on Macs. * Remaining problems with multi-user access to Local Cache: Shortcut to .df1 doesn't work any more on PCs. Access via 'DAVE' software on Mac is not supported by Omnis. * Need reports for special tests, including detector data summary. * No report defined for Stocks. * Merge Master-->Local should copy Tests for each Item even when they were performed somewhere else. It should also check if the tested item exists on the local cache. * Merge Master-->Local ignores Shipment Item records from home institute where shipment has been confirmed. * Merge Master-->Local should delete local class 1 records with no corresponding master copy. * 'Receive' button on Shipment window still enabled after all items have been received. * 'Navigate' menu should be enabled even when no records have been found. SCT_DB v 5.43 7/4/2000 -------------- Fix a problem with the password checking routine. SCT_DB v 5.42 4/4/2000 -------------- Implement the same test parameter range constraints on Omnis as on master server, so that illegal values are flagged sooner. Bugs Fixed ---------- Usernames (Owner names) were limited to 8 characters, resulting in 'HAMAMATS' instead of 'HAMAMATSU'. The 'IV Raw Data' button on special test windows did not find the raw data. The default Test Number was not set correctly when inserting a raw data record. Improve linkage between test window and raw data, web link, defects windows. Store only encrypted password information. Upload routines do additional checks on NULL numeric fields. Test raw data records do not get their 'last modified' date reset correctly when they are edited on the master server. Omnis now does this when they are merged from the local cache. There is still a problem if someone edits a raw data record using the web interface. Problems Remaining ------------------ * Changing TESTS.TEST_NAME could give inconsistencies where special test data exists for that test. * Omnis SQL problems with 'SELECT ... WHERE MAX(SER_NO)< @[lvmax] for 14 digit serial numbers interferes with C_SQL.$GetLastSerNo. Execute it on Master Server for now. * Omnis SQL problems with case-insensitive string searches. * Links not working to EDMS from ITEM_DESCR, TEST_DESCR. * Should define assemblies for module0. Define fmSpine assembly for module-1. * Selecting serial numbers with scratch pads = nn but mfr empty should return detectors with mod(ser_no,1000000)=nn. * Can't get tabs to display correctly in window fields on PCs. Neither can Omnis tech support. It is ok on Macs. * Remaining problems with multi-user access to Local Cache: Shortcut to .df1 doesn't work any more on PCs. Access via 'DAVE' software on Mac is not supported by Omnis. * Need reports for special tests, including detector data summary. * No report defined for Stocks. * Merge Master-->Local should copy Tests for each Item even when they were performed somewhere else. It should also check if the tested item exists on the local cache. SCT_DB v 5.41 20/3/2000 -------------- New routines to insert Si detector manufacturer's test sheets from text file. If the detector Item record already exists, just insert the test data. Decode detector Item Type and Manufacturer from ATLAS serial number. For format see http://dpnc.unige.ch/atlas/atlaspage/db/doc/mfr_upload/specifications.html. New routines to insert institute's detector tests from text file. For format see http://polux0.unige.ch/sctprd/doc/otherlinks/java_app/test_data/teststruct.html Detector window now allows to insert new production-level detector items, where the serial number is read from the detector package. Default detector type and manufacturer are decoded from the serial number. Extra layer of site-dependent password protection. New window for Web Links from Tests. Don't copy items at Location='Unknown' when doing Merge Master-->Local. Add manufacturer name to the Items/Detectors window 'Export serial numbers' report. You can now delete any Item or Test record that has not been merged to the master server. Previously you could only delete the last record entered. Total defective channels displayed on Si detector manufacturer's test window. Bugs Fixed ---------- Removed 'Optimize method' from some routines where it caused odd behaviour. For example, W_DE_Simple.$IsComplete complained about a faulty Switch construct if it was optimised. Table method T_DE_Simple.$IsComplete didn't run at all if optimised. W_DE_Detail.$insert1 did not return lvResult correctly if it called an optimised routine. (Which one?) Fixed a problem which sometimes stopped more than one block of records being fetched from a single 'Find'. Each window now maintains its own 'select table' and fetches blocks of 256 records as needed. The Copy button on the Test Rawdata window works now. Fixed a problem where the Defects details panel on the Test Defects window was sometimes disabled. Also, the Defect list on the Defects detail window was incorrectly disabled. Fixed a logic error in the routine which connects to the master server. Problems Remaining ------------------ * Changing TESTS.TEST_NAME could give inconsistencies where special test data exists for that test. * Omnis SQL problems with 'SELECT ... WHERE MAX(SER_NO)< @[lvmax] for 14 digit serial numbers interferes with C_SQL.$GetLastSerNo. Execute it on Master Server for now. * Omnis SQL problems with case-insensitive string searches. * Links not working to EDMS from ITEM_DESCR, TEST_DESCR. * No report defined for Stocks. * Should define assemblies for module0. Define fmSpine assembly for module-1. * Some PCs don't display ARIAL 8, 9, 10 fonts, only ARIAL >= 12. Wassemblies/insertdetail crashes when ctype is truncated by field too small for 12 pt. font. SOLUTION: Set 'Small Fonts' on PC's Display Properties window. * Selecting serial numbers with scratch pads = nn but mfr empty should return detectors with mod(ser_no,1000000)=nn. * Can't get tabs to display correctly in window fields on PCs. Neither can Omnis tech support. It is ok on Macs. * Remaining problems with multi-user access to Local Cache: Shortcuts to .df1 doesn't work any more on PCs. Trying to logon to .df1 on PC from Mac via 'Dave' causes Omnis to crash with Omnis 2.1. It worked with Omnis 2.0. Hopefully, Omnis 2.3 will fix this. It works when the datafile is on the Mac and you logon from a PC. * Need reports for special tests, including detector data summary. * No report defined for Stocks. * Merge Master-->Local should copy Tests for each Item even when they were performed somewhere else. SCT_DB v 5.40 26/1/2000 -------------- Increase serial number lengths from 9 to 14 digits in line with ATLAS Part Identification scheme. Serial numbers can now be dragged from Items window into Tests window in insert a new test on that item. Dragging a serial number into the list on the Shipment window inserts the item into the shipment list. Dragging a serial number into the list on the Assembly window inserts the item as a component at the highlighted position. Changing an Item's item type is not allowed if it is assembled, if it has components mounted, or if it has tests on it. Allowing changes could lead to inconsistencies in those cases. Bugs Fixed ---------- The local sequences for Item comments and Test comments could be initialised incorrectly to 99000000. There was a muddle with lSessionLocn and lThisLocn. 'lSessionLocn' should be the Locn code returned by _localCache or _MasterServer. 'lThisLocn' is the Locn code of the local cache only. Found a bug in OMNIS SQL which stopped $GetLastSerial number working on local cache. Now, local sequences are initialised as part of Merge Master-->Local and $GetLastSerial number executes on the master server. Problems Remaining ------------------ * There is a problem in some windows that stops more than 1000 records being fetched from the server in one 'Find'. * No WEB_LINKS window for tests. * Links not working to EDMS from ITEM_DESCR, TEST_DESCR. * No report defined for Stocks. * Should define assemblies for module0. Define fmSpine assembly for module-1. * Some PCs don't display ARIAL 8, 9, 10 fonts, only ARIAL >= 12. Wassemblies/insertdetail crashes when ctype is truncated by field too small for 12 pt. font. SOLUTION: Set 'Small Fonts' on PC's Display Properties window. * Selecting serial numbers with scratch pads = nn but mfr empty should return detectors with mod(ser_no,1000000)=nn. * Can't get tabs to display correctly in window fields on PCs. Neither can Omnis tech support. It is ok on Macs. * Remaining problems with multi-user access to Local Cache: Shortcuts to .df1 doesn't work any more on PCs. Trying to logon to .df1 on PC from Mac via 'Dave' causes Omnis to crash with Omnis 2.1. It worked with Omnis 2.0. Hopefully, Omnis 2.3 will fix this. It works when the datafile is on the Mac and you logon from a PC. * Need reports for special tests. * Site-dependent passwords for data entry? SCT_DB v 5.32 (Not released) ---------------------- Prepare for 14 digit serial numbers by converting all serial number data types from 'long integer' to 'number 0dp'. Modify Sessions/_Master_password to leave lbThisPrefix = 0 for now. Activate it later, when the conversion is completed. SCT_DB v 5.31 7/1/2000 ---------------------- Bugs Fixed ---------- Got an error message if Items, Tests or Shipment window was opened for the first time while connected to master server, before initialising local sequences. Owner of Shipment detail (SHIP_ITEMS) records was not correctly updated by 'Confirm Send'. Problems Remaining ------------------ SCT_DB v 5.30 15/12/99 ---------------------- Data structure changes to accomodate Pixels. Only relevant records will be visible to Pixel/SCT users. Added a new SUBSYST ('subsystem') attribute for all class 1+2 tables except special tests. Record locking implemented for multiple users connected to the same local cache. Created LOCALSEQS table to hold current values of last serial number, comment number, test number etc. for multiple users. This is locked during Insert so each user gets a different ID number. Created a new window for viewing Disasssembly logs. Automatic disassembly logging is not enabled for now. Improved installation procedure in STARTUP method. The list of institutes is filled automatically from the master server, and once 'Where am I?' has been completed the rest of the local data is merged. New password for 'definition' user. Bugs Fixed ---------- In Shipment window, Find didn't work for 'From Institute' or 'Senders Initials'. Problems Remaining ------------------ * Should not allow Item Type to be changed for assemblies with components, otherwise the assembly description might be wrong. * No WEB_LINKS window for tests. * Links not working to EDMS from ITEM_DESCR, TEST_DESCR. * No report defined for Stocks. * Should define assemblies for module0. Define fmSpine assembly for module-1. * Some PCs don't display ARIAL 8, 9, 10 fonts, only ARIAL >= 12. Wassemblies/insertdetail crashes when ctype is truncated by field too small for 12 pt. font. SOLUTION: Set 'Small Fonts' on PC's Display Properties window. * Selecting serial numbers with scratch pads = nn but mfr empty should return detectors with mod(ser_no,1000000)=nn.