Category: Tasks

31/10/07

Permalink 03:14:59 pm, by sarneil, 31 words, 640 views   English (CA)
Categories: Tasks; Mins. worked: 0

TC tasks to do

filter by topic code, in particular second and subsequent code of records which contain more than one topic code

process data for 1896 and 1897 and upload into database - done Dec. 2007 / Jan 2007

31/05/07

Permalink 08:37:10 am, by sarneil, 57 words, 717 views   English (CA)
Categories: Tasks; Mins. worked: 0

topics data

I need to:
- renumber the remaining topics
- in the database do a number of search and replaces so that the values in the "topic" field for each record are correct
- put the text for each topic into the appropriate table.
Then ready to go back to code for query and reporting on this field.

20/04/07

Permalink 02:02:54 pm, by sarneil, 35 words, 737 views   English (CA)
Categories: Tasks; Mins. worked: 0

establish plan for Hums site with CC

Claire Carlin has taken over as contact person for Humanities site. Need to meet with her and set out plan for how to proceed. She is reviewing existing site and my prototype for new site.
Permalink 01:59:07 pm, by sarneil, 54 words, 406 views   English (CA)
Categories: Tasks; Mins. worked: 0

stage 2 of GUI for TC index

Still to do:
improve text search (case-insensitivity for highlighting)
filter by topic code
process results to xhtml or tab delimited text for export
there are also anomalies in the data introduced by the proofers that will have to be removed, and John has a couple more years of data for the general index coming.

03/04/07

Permalink 09:54:28 am, by sarneil, 60 words, 335 views   English (CA)
Categories: Tasks; Mins. worked: 0

process TC proofed data and subject codes

Get data from John. Get conventions on topic codes for John and normalize data with those. Process data into files suitable for upload to sql db. As of end of March, waiting for 3 of 4 datasets and information from John Lutz on subject codes etc. which I'll need before I can proceed any further. Written to him to get that information.

05/02/07

Permalink 01:07:52 pm, by sarneil, 69 words, 415 views   English (CA)
Categories: Tasks; Mins. worked: 0

web front-end for TC

Create GUI to allow:

text search OR records with subject code OR all records

restrict date range for any of above queries

return results in xhtml table.

By mid-April, had basic and advanced text search, date range and filter by paper name or collection done.
Still to do: improve text search (case-insensitivity for highlighting) filter by topic code and process results to xhtml or tab delimited text for export.

Permalink 01:05:00 pm, by sarneil, 26 words, 350 views   English (CA)
Categories: Tasks; Mins. worked: 0

create sql database back end for TC

Get db account from sys admins Create table for each dataset (or maybe one big table for all the datasets). Task completed last week of February.
Permalink 01:02:54 pm, by sarneil, 63 words, 376 views   English (CA)
Categories: Tasks; Mins. worked: 0

write code to transform other data sets to common data format

Add field to TC main index to include name of paper.

Look at structure of data files for other datasets and write code to transform them to same data structure.

By end, should have one file for each dataset, ready to be imported into an sql table - one table for each dataset.

Got data from John early April and finalized procedures then.

Times Colonist Transcript Database

The goal of this project is to take a collection of transcripts of new stories from early editions of the Times Colonist newspaper which are currently in text files containing special codes for various bits of information, normalize the records, put them into an SQL database and then write a querying front-end.

Reports

Categories

August 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