Archives for: April 2012, 19


Permalink 06:10:51 pm, by mholmes, 8 words, 94 views   English (CA)
Categories: Activity log; Mins. worked: 120

TEI Council work

Work on tickets arising out of Michigan meeting.

Permalink 06:10:16 pm, by mholmes, 6 words, 89 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 161 + 2 = 163 hours G&T

Catching up after trip to Michigan...

Permalink 02:56:25 pm, by mholmes, 17 words, 44 views   English (CA)
Categories: Activity log; Mins. worked: 120

Catching up after trip

415 emails to get through on my return from TEI Council meeting. Also completed expenses claim for trip.

Permalink 02:53:51 pm, by mholmes, 6 words, 150 views   English (CA)
Categories: Activity log; Mins. worked: 20

Updates to reviews

Bio and keywords added (from HT).

Permalink 01:39:10 pm, by sarneil, 188 words, 81 views   English (CA)
Categories: Activity log; Mins. worked: 180

etcl : problem with links in etcl theme in wp3.x

Reviewed the situation with the ETCL site and the fact that none of the links work. Some generate a 404 error, others display a "What's New" page with banner and right column, but no page-specific content. Compared the production site UI and wp-admin settings with my dev site. Did a bunch of playing around with URLs and fiddling with configuration settings in the wp-admin in the dev site. Made no changes at all to the production site.

The problem seems to be an incompatibility between the WP3.1 environment (specifically the way links are handled) and code somewhere in the ETCL theme.

I will next compare the ETCL theme against the twentyten theme in the dev environment as the twentyten theme supports navigation that the ETCL theme doesn't.

I'm still not sure whether I should start with the ETCL theme and modify the php in it as needed to work with the WP3.1 API for links, (which is my preference) or whether I should start a generic theme and modify it to produce the look and feel similar to the current ETCL (except of course that the links would work).

Permalink 11:49:30 am, by FJ, 103 words, 123 views   English (CA)
Categories: Activity log; Mins. worked: 10


So while reading the Apollodorus text I was looking at the events in section 3.10.2 and saw that the place xml:id=pylos was showing up on the site as "pylospylus"; "pylus" is the "AKA" for "pylos".
After discussing this with Greg we established that it's a coding error. The "placeName" is being pulled for both and seeing as "pylus" is under "placeName" too it's getting attached to "pylos". We looked at other places and saw that "corinth" and "ephyra" is doing the same thing because "ephyra" is under the "placeName" "AKA" too.

Greg is going to look into it and fix the coding.

Permalink 11:29:55 am, by mholmes, 347 words, 70 views   English (CA)
Categories: Activity log; Mins. worked: 45

First new task done: enhanced transaction view

One task from the meeting the other day was to create a new view of transactions which adds a number of financial fields. I've now done that, using the following SQL:

DROP VIEW IF EXISTS VW_trans_composite_eth_prop_2;

CREATE VIEW VW_trans_composite_eth_prop_2 AS


seller_titles.ttl_title_id AS seller_title_id, 
seller_titles.ttl_date AS seller_title_date, 
seller_titles.ttl_title_code AS seller_title_code,
seller_titles.ttl_consideration AS seller_title_consideration,
seller_titles.ttl_declaredvalue AS seller_title_declaredvalue,
seller_titles.ttl_marketvalue AS seller_title_marketvalue,
buyer_titles.ttl_title_id AS buyer_title_id, 
buyer_titles.ttl_date AS buyer_title_date, 
buyer_titles.ttl_title_code AS buyer_title_code,
DATEDIFF(buyer_titles.ttl_date, seller_titles.ttl_date) as seller_duration_days,
buyer_titles.ttl_consideration AS buyer_title_consideration,
buyer_titles.ttl_declaredvalue AS buyer_title_declaredvalue,
buyer_titles.ttl_marketvalue AS buyer_title_marketvalue,
sellers.concat_owners AS concat_sellers, 
sellers.concat_ethnicities AS seller_ethnicities, 
sellers.total_owners AS total_sellers,
sellers.munged_ethnicity AS seller_munged_eth,
sellers.total_institutional AS institutional_sellers,
buyers.concat_owners AS concat_buyers, buyers.concat_ethnicities AS buyer_ethnicities, buyers.total_owners AS total_buyers,
buyers.munged_ethnicity AS buyer_munged_eth,
buyers.total_institutional AS institutional_buyers

FROM titles AS buyer_titles
LEFT JOIN titles_to_prectitles ON buyer_titles.ttl_title_id = titles_to_prectitles.ttp_title_id_fk
LEFT JOIN titles AS seller_titles ON seller_titles.ttl_title_id = titles_to_prectitles.ttp_prectitle_id_fk
LEFT JOIN VW_titles_composite_eth AS sellers ON seller_titles.ttl_title_id = sellers.ttl_title_id
LEFT JOIN VW_titles_composite_eth AS buyers ON buyer_titles.ttl_title_id = buyers.ttl_title_id

LEFT JOIN props AS props ON seller_titles.ttl_property_id_fk = props.prp_property_id
LEFT JOIN census_tracts ON props.prp_census_tract_id_fk = census_tracts.census_tract_id

ORDER BY seller_titles.ttl_title_id

All HCMC Blogs




All HCMC Blogs

Transformer blog

Work on this blogging tool

Image Markup Tool blog

HCMC Project Management

Nxaʔamxcín (Moses) Dictionary Blog







Scandinavian-Canadian Studies



Image Markup and Presentation

Update of Humanities Sites


Vacation, Hours and Sickday Log

Times Colonist Transcript Database


CMC Research Collective


Humanities Project Showcase

Peter's blog



Professional Development

Colonial Despatches

Coup De Des - GUI for concrete poem

Capital Trials at the Old Bailey

Agenda Class Timetabling

Lansdowne Lectures

German Medical Exams

Canadian Mysteries

Map Of London


Canadian Journal of Buddhist Studies

Adaptive Database

Myths on Maps





History of the Philosophy of Language

A City Goes to War

Landscapes of Injustice

April 2012
Sun Mon Tue Wed Thu Fri Sat
 << < Current> >>
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          

XML Feeds