ALEG

What I've done

• Dataloading

  SA Women Bib: Finished manually checking periodical details for the minor publications, and wrote program to create the necessary new periodicals (324) and periodical issues (1449). Then, the minor pubs with journal sources were finally linked to their source - 2203 new sources were created, 1073 existing sources where matched (and not duplicated). There were 148 minor pub sources which could not be handled (no author or source title typically) which have been passed to Anne. The SAWW minor pubs database had additional sources in a note, but these are too difficult to parse so have just been added as a note on the work.

• Many new miscellaneous queries and adhoc data analysis reports, mainly associated with 11,000+ works without worktype/form/genre classification and other cleanup issues.

• Changed agent detail display to separate work counts for an agent where there role was not creator or author. Hence, now shows "As editor", "As translator" (etc) counts.

• Changed agent detail display for agents using other writing names (formerly known as "pseudonyms") so that the entire output of an agent using multiple writing names is shown by default, and details for just that one writing name can be displayed.

  This was a significant change because it meant creation events could not be searched just against the agent, but had to be searched for the agent and their "pseuds". This caused some performance problems which were finally addressed by introducing a new hidden agent attribute which links an agent to all its pseuds as well as to itself (making the SQL join as simple as possible).

• Mounted Megan's doco and linked it to the agent maintenance help prompts.

• Data cleanups:
  1. Changed [and] in titles to & (123)
  2. Removed [by] and trailing string from (most - 3174) titles
  3. Removed single-work attribute from anthologies, collected works, selected works (few dozen)
  4. Changed creators of anthologies (16) to editors
  5. Changed creators of bibliographies (298) to compilers
  6. Changed single creators of single works to authors (hundreds of thousands of these)
  7. Moved public notes for WA authors without a bio to a bio attribute (421), hid public notes for WA Authors with a bio (32)

• System

  Applied Oracle software patch (8.1.7.1.0) with a few (but fewer than expected!) problems.

  Performed tuning to identify and fix some antisocial database access statements (SQL).

• To Do list. Work through the (mostly) minor issues on the to-do list provided by Annette/Kerry/Marie-Louise.

• More time on planning session on the new user interface with Marie-Louise and Annette.

• The new thesaurus arrived on last week - start processing it and converting current subject terms.

• First known dates.

• Pick up the ball I dropped regarding the Z39.50 interface to NLA holdings.