Permalink 08:34:24 am, by mholmes, 70 words, 35 views   English (CA)
Categories: Activity log; Mins. worked: 90

Changes to db fields

Per AC, extended the pseudonym field to 100 characters, and renamed the Anonymous field to Allonymous. Tested in dev, done in live, tested again in both. Later bug report came in: the myriad triggers were not handling the change correctly. Deleted the triggers completely as a quick way to get back to a working db, but I will have to rewrite the ones for related poems based on the earlier backups.


Permalink 04:06:35 pm, by mholmes, 80 words, 8 views   English (CA)
Categories: Activity log; Mins. worked: 30

Generation of PDF of images for one year

AC needed to generate a printable document of pages for a specific year, for the encoders to use. Got a list of images from the SQL XML dump like this:

let $images := //table_data[@name='poems']/row[starts-with(field[@name='po_date'], '1820')]/field[@name='po_images']/tokenize(., '\s+')
return string-join($images, '

Then used wget to pull down the images from the server, and generated the PDF:

img2pdf -o 1820.pdf *.jpg

Digital Victorian Poetry Project

This is a blog to track work on the DVPP project. Prior to this blog being created, posts were made in the Depts blog.


XML Feeds