Change Log
(Dev Manual)
July 11, 2011
- Added filter to media tab on trench, su, phase and report phase layouts to remove images that are marked as unused.
July 9, 2011
- Changed AuditTrail to record host name instead of user name
- Cleaned up the rest of the import scripts and tested them
- Added a new clean information footer to many layouts with dates and computer names created and modified, whether they were synced, modified since the last sync, and the timestamp of the last sync.
July 8, 2011
- Changed some scripts to make the iPads open the databases more smoothly.
- Added script Prepare Database for Children to reset the syncing fields after the database has been used without the iPads for some time. This script can only be used by the Admin user so I altered some of the database users/groups to provide for more granular control over who can do what scripts.
- Added fields and relationships to check for duplicate records in the MediaLink and AuditTrail tables.
July 6, 2011
- Realized a problem with syncing. Ignoring the iPads, if records are created while connected to the networked database, they show up as not synced. Then when they are copied to the iPads and synced, they show up as unsynced and are imported. This is solved by work described on July 8.
July 5, 2011
- Added fields in Fauna table for counting and weighing what is collected from flotation: QuantityFlot, WeightFlot, TotalCountFlot, and TotalWeightFlot.
- Added a field, script and relationship for assigning a fragment number to bones that will be drawn and/or photographed. Field: BoneFragNum; Relationship: a self-joining relationship with SU as the linking field, inverse sorted by BoneFragNum; script: Assign Fauna Frag Num.
- Added these fields onto the N Science-Fauna layout. Added a button to assign the number to the current record.
- Rearranged the iPad-Fill layout to move the Finds to the bottom. This allows more rows to be visible without using the scroll bar. Some people had problems with the scroll bar.
- Added the open and close dates to the SU-List layout
July 1, 2011
- Changed step in 6_1. When the database imports the images table from the child database it no longer imports the thumbnail and large thumbnail fields. That should speed up the image part of the syncing scripts.
- Changed step in 6_3. If the thumbnails are not going to be imported into the shadow table, they can’t be imported into the Media table when updates happen on the child database. Otherwise the thumbnail fields will be overwritten with empty images.
June 30, 2011
- Changed step in 4_4. It was searching for ‘Finds Shadow::ModifiedAfterSync = “i” instead of ‘Finds Shadow::Synced’ = “i”
June 29, 2011
- Fixed the relationship from Trench to Find. It was filtering by the word ‘artifact’ which isn’t used anymore.
June 13, 2011
June 7, 2011
- Database renamed PS_11_parent.fp7 because of the internal database import script steps.
May 31, 2011
May 26, 2011
- Changed the CreationDate and ModificationDate of the Shadow tables to no longer auto enter data.
- Added a field SameRecordasShadow to Shadow tables to help deal with the ‘first record issue’.
- Standardized names CreationDate and ModificationDate across all tables
- The first record issue: The database syncs by first importing the data from a child database into a shadow table of the parent database. The records in the two tables are then compared. Records that are new in the child database are imported, records that have been edited in the child since the last sync but not the parent are imported as matching, so the data from the child database replaces the data in the parent database. Then records that have been edited in both databases since the last sync are compared and fixed by hand. This works mostly by comparing the modification date with the date of the last sync, but before things are synced, there is no last sync, and nothing in that field. That meant some records were being imported that were already in the table. Some if statements in the syncing scripts fixed that.
- Fixed the script for importing the auditTrail data from the child database.
May 24, 2011
- Got rid of some fields that were leftovers from the 8_7 database that had only one table for artifacts:
- Got rid of the Finds fields that I don’t use anymore (their data will be entered into the Finds Attributes table instead): CoinSerialNum, Note, Type, Weight Unit, CompleteCt, DateonObject, LocalSumItemCt, Weight, WeightTotal, Width, DescriptionNotes, QuantDate, QuantWho, ReasonforDating, Sorted.
- Added syncing support for the Finds table
- Added syncing support for the Finds Attributes Table (although I don’t think we need it in the field)
- Added syncing support for the Media table
- Added syncing support for the MediaLink table
- Added syncing support for the Ceramics table
- Added syncing support for the QuantPottery table
- Added syncing support for the ReportPhases table
- Need to also add syncing to Conservation, Conservation Link
May 21, 2011
- The following fields have to be added to all tables that need to sync
- UUID (Text) Auto-Enter the calculation value from the UUID.New function
- Synced (Text) Auto-Enter ’n’, changes to ‘y’ after syncing, and sometimes to ‘i’ (for ignore) during the scripts
- LastSyncTimestamp (Timestamp) a global field. This might not work on networked databases, but it should work with locals and syncing
- ModifiedAfterSync (calculation) If ( _ModificationDate > LastSyncTimestamp ; "y" ; "n" ).
- _ModificationDate has to be changed from a date field to a timestamp field.
- A table has been added for the records that need to sync. These are exact duplicates of the data tables. So far I have auditTrail shadow, SU Shadow, and Trench Shadow.
- Relationships have to be established between the table and its shadow table based on the UUID field
- Scripts have been added to perform the sync. They all exist in the sync subfolder and are numbered x_1 through x_6. They are split to allow easy editing.
- Fixed the scripts to write data to the auditTrail file. It wasn’t including a serial number to link it to the original record. The script now uses the UUID field found in every new record to allow me to search for the records.
- New script for the auditTrail named ‘show history of this field’ which is accessed through the Scripts menu. There is a new layout to go with this script.
- Added a couple of scripts to the Nav subfolder.
May 18 2011
- Changed opening script to isolate the records according to the name of the iPad. Since the iPads for trench 53000 are named 53000-1 and 53000-2, now when the database is opened on those iPads, the database will show only records for 53000, sort them in reverse order, and go to the top of the list
- Added some custom functions for getting UUIDs working for record and table level. There is one for UUID creation, one for extracting the time from that UUID and one for extracting the MAC address of the creating device from the UUID. (UUID.New, UUID.GetTimeStamp, and UUID.GetNICAddress).
Mar 10 2011
- Changed serial number fields to RecID fields and made those relational instead of natural names
- Added MarkSignificant to SU table for reports
Mar 7 2011
- Removed filter on Artifacts that relied on outdated 'Kind' field
Mar 3 2011
- Added iPad layouts
- Scripted the new record creation for SUs for the iPads
- Added a script step to the open database script to ope to the iPad-SUList layout when opened on an iPad
- Added an extended privilege to keep the database open after the home button is used on the iPad
Mar 2 2011
- Cleaned up the Color table appearances on the relationship chart
- Fixed the bibliography linking to validate across all necessary tables
- Cleaned up some layout ordering issues and made the Raw Tables layout folder visible by default
- Deleted some unnecessary layouts
- Removed Attributes Reference table: too confusing. Moved items to value list.
Mar 1 2011
- Fixed Phase/RPhase relationships. SUs can now be entered directly in the Context-Report Phases-Info layout.
- Added table and scripts for Audit trail. It now records when most fields change in most layouts.
- Fixed Report Phase and SU table's links to photos.
- Some more navigation fixes.
- Removed three duplicate table occurrences (SUs to Media).
Feb 28 2011
- Fixed BiblioLink layout
- Added fields in BiblioLink for Page, Plate, CatNum, and FigNum
- Fixed navigation links from Bib layouts
- Fixed tab order on Q Pottery layout
Feb 27 2011
- Fixed Pot Quant Entry form which was entering data into Finds and not quantified pottery
- Added tooltips to RPhase and SU fields in Finds-Q Pottery
- Made Reports folder visible
- Added charts for MI in Fauna (same now as 8_7)
- Added two faunal reports: Parts by Genus, with totals of knowns and unknowns; and Known Genus. They are linked to the Science-Fauna layout.
Feb 25 2011
- Added charts for Find Classes by SU and Find Classes by RPhase