Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 44 Next »

The initial sql script for the IU webserve MySQL database is attached here.

The test script with dummy data is attached here.

The daily cron log sql scripts are located in the comics webserve "backups" file.

 

Web interface to do:

  • fix issue (series) situation (for other than letters)

  • Make guide for training (David)
  • Add helpful hints - as HTML divs pulled in from HTML guide? (David)
  • Autocomplete changes (for all autocomplete fields like person):
    • selected person, input box disappears, replaced by an non-editable box with selected person's info (and X in the corner which takes user back to blank input box in case they select the wrong person)
    • after creating a new person, have that person already selected (as above) when the person clicks out of the pop-up form
  • Finish styling all detail pages (submit, Hello + Log Out header, etc)
  • Clean in-line styling, tables to divs - page after submit - button to return to main form
  • CSS for mobile (tablet, at least)

Database to do:

  • Finish data dictionary explaining each entity and attribute, and ER diagram to reflect
  • Add triggers for modifications into audit table
  • Change to real NULL on db for values that are blank
    • Query builder based on non-empty fields?

 

Fall 2015 major to dos:

  • Usability tests with form & input - make sure everything is inserting into the db correctly and form is intuitive
  • Input spreadsheet data - does Will have suggestions for this automatically or would it be easier to put people on the case?
  • Connect source_dim to GCD and location_dim to Getty
  • Data entry for DVDs and Michigan images
  • Data analysis - quantitative & qualitative (narrative abt interesting letters)
  • Apply for grants:
    • Collab Research - due Dec 9th 2015 --> arrange meeting with collaborators
    • DH Implementation - due Feb 17, 2016
    • Community/Public... - due June 2016
    • Humanities Collections & Reference Resources - due July 2016

 

 

Done:

  • Connect source_of_source table (as a "snowflake")
  • Reverse engineer script to build diagram of database tables
  • Include location_dim table for city, state, country data in while loop in getautoname.php file
  • Constrain issue data by value entered in series name form in source autocomplete files
  • Finish autocomplete integration in all forms
  • Add page number to source table (if from an issue)
  • Style forms
  • make basic ER Diagram for San Diego
  • Fix nested form issue
  • Reconcile form interface fields with database attributes - process files
  • Added mutable attribute tables to SQL script, models
  • Reconcile "mutable" fields to new tables
  • Add physical location fields to web interface
  • Link autocomplete value (person, location, source, physical location) with database value, insert into activity_fact as one new record, with activity
  • Object orient forms & processes 
  • Parameterize SQL queries to hinder SQL injection attacks
  • Change "create new" links to buttons
  • Parameterize autocompletes
  • Reconcile Issue Autocomplete bug (issue_number search works but not pub_date search...weird)
  • Add fields to physical location - end up separating this from location?? YES! Became new table connected to both location_dim and activity_fact
    • Collection name
    • Collection ID number
    • repository (ex. Bodlein Library)
    • institution (ex. U of Oxford)
      (we decide how to insert private collections)
  • Add note field to letter & review (look at Richard's "notes" in spreadsheet)
  • Upon main form submission, return to index.php
  • Delete sex & gender mutable tables, replace with m_f and gender_note attributes in person_dim table
  • Add password protection - connect to DB in config file (as parameters)
  • Add created insert statements from members table (into one audit table)
  • Link everything to one config file
  • Add php secure permission to currently html forms
  • Add John's office phys loc for training
  • cron script for db backup/dumps (nightly (3am))
  • hire people - work with them to input data - add them as DB users

Done (Usability):

  • Put Source/Physical Location sections first on forms

  • Make letter page title autocomplete so data entry students don't have to type in every time

  • Make login button on keyboard "enter"

 

As of 8/31/2015

 

 

  • No labels