Kings DB: updates to db structure


Permalink 11:01:40 am, by mholmes, 146 words, 115 views   English (CA)
Categories: Academic; Mins. worked: 60

Kings DB: updates to db structure

Met with PC today, and discussed the db structure. We arrived at the following changes to be made this week:

  • Replace the datePrecision field in multiple tables with a plain text field called dateInfo, in the db, and then in local_classes.php.
  • When that's done, delete the datePrecisions table from the db and from local_classes.php.
  • Add a new multiline text field called sc_citation to the sources table, and include it in local_classes.php.

PC will also send over the latest block of biblio items he's collected into Zotero in MODS output format, which I'll then try running through my mods_to_sql.xsl file to create an import file and get them into the db. It's not clear how well this will work, but if it proves relatively simple it'll be worth doing to eliminate a lot of manual data entry.


No Pingbacks for this post yet...


This blog is for work done for academic departments which does not fall under other categories.



July 2014
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

XML Feeds