FrancoToile

I've put these .xml files into the eXist database for FrancoToile :
prmq1.xml
prmq2.xml
prmq3.xml
prmq4.xml
prmq5.xml
prmq6.xml
vacq1.xml
vacq2.xml
vacq3.xml
fraq1.xml
lsrq1.xml

I've put these .mov files into the media folder in the Francotoile website :
prmq1.mov
prmq2.mov
prmq3.mov
prmq4.mov
prmq5.mov
prmq6.mov
vacq1.mov
vacq2.mov
vacq3.mov
fraq1.mov

These two .mov files are missing, so are not in the Francotoile website:
fraq1.mov
lsrq1.mov

Lines to include in an .htaccess file to cause authentication to check against list of made-up user names first, then valid netlinkID's:

AuthType Basic
AuthName "Restricted to username provided by us or UVic netlink ID"
AuthAuthoritative off
Require user [made-up-user-name]
AuthUserFile [absolute/path/].htpasswd
Require valid-user

third line enables cascading authentication
fourth line lists user name(s) in local authentication file
fifth line specifies local authentication file
sixth line lists user name(s) in default authentication file
lack of line specifying another AuthUserFile causes default authentication to be invoked (ldap against netlinkIDs)

The path to the executable for editing the password file on lettuce is:
/usr/local/apache2/bin/htpasswd

Marie-Claude took a group of videos shot in Quebec on the new Sony camera and imported them in to iMovie. Although the videos played back with audio in QuickTime, iMovie was unable to detect an audio stream. The reason for this is that the video is muxed MPEG-1 (see here: http://docs.info.apple.com/article.html?artnum=42996). As a result of the camera recording in MPEG-1, image quality is not great, and file size is significant (approx. 20MB/minute).

I tried using Quicktime Pro to export a DV stream, but it does not appear to have any explicit capacity for demuxing. I downloaded MPEG Streamclip (from here: http://www.squared5.com/) and exported the video as DV25, de-interlaced video (which swells file size by a factor of about 10). iMovie happily, and quickly, imported the video with audio intact.

modified code in search page to allow user to include an empty search string (e.g. so they can specify all subjects that are male regardless of contents of transcript).

Modified code to show search interface at top of page and search results at bottom of page

In course of doing that, decided to comment out simple search and leave only advanced (which is a superset of the simple).

Also modified code to maintain values previously selected in filters.

Also modified code in the locations field so that all tests are against internationalized string value derived from array ($lang->GetEntry('keyword')) rather than literal strings. Will likely implement same sort of thing in the origin and topics fields when I get values for them from Catherine. Required some modification in code doing testing for creation of search query as well.

Met with Catherine on FranctoToile, she asked about:
- putting a .htaccess file on the site
- limiting access to all netlinkIDs AND 1 made-up user name
- allowing empty search string in the advanced search interface (so users could find e.g. all transcripts of females regardless of what those transcripts contained)
- whether we should break the collection up into subcollections, what the names for each of those sub-collections should be (possibly continents), and whether we'd then want to include an additional field in the xml data files relating with that piece of information in it.
- changing the word "Watch" to "Browse" in the English interface.

I tested the fix further and discovered that the results from a search are as quoted below. So, I pass "true" instead of "false" for the last parameter and predictably the apostrophes now appear as entities, but the search works.

Error Code: 4096
Error Message: Object of class DOMDocument could not be converted to string
File: /home1t/florevid/www/includes/helpers/ajax_search.php
Line: 58

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home1t/florevid/www/includes/helpers/ajax_search.php:47) in /home1t/florevid/www/includes/classes/session.php on line 13

Fatal error: Call to a member function GetVariable() on a non-object in /home1t/florevid/www/includes/classes/lang.php on line 26

The XML data files includes apostrophes. When those files were read in, those were escaped to html entities. Those entities were then rendered by the browser into literal apostrophes on the page. In the case of texts that ended up as strings in javascript variables for display on mouseover, the html entity appeared as a literal string. With Mike's help, figured out the solution to the problem, which was to add another boolean to the def_xml_transform function telling that function whether to treat the output as going to HTML or not (i.e. for javascript), and then modify the call to that function from the ajax_search.php page to pass a value of false for treatAsHtml.

in xmldb.php
function def_xml_transform($xml, $stylesheet, $params = false)
becomes
function def_xml_transform($xml, $stylesheet, $params = false, $asHTML = true)

and
return $xml_result->saveHTML();
becomes
if ($asHTML) {
return $xml_result->saveHTML();
}
else {
return $xml_result;
}

in ajax_search.php

$xml_result = def_xml_transform('<root>' . $xml_result . '', '../xslt/ajax_search.xsl');
becomes
$xml_result = def_xml_transform('<root>' . $xml_result . '', '../xslt/ajax_search.xsl',false,false);

Installed the exist server in the Applications directory. Then had to start it, populate the database with the appropriate collections structure (francotoile folder contains application folder and data folder, data folder contains francotoile folder, francotoile folder contains xml files). Then had to modify the variables in the php for the site to point at localhost:8080/exist/xmlrpc with appropriate user name and pw

To start the eXist server
- open a Terminal window
ssh florevid@lettuce.tapor.uvic.ca '/home1t/florevid/eXist/bin/server.sh'

To shutdown the eXist server
- open a Terminal window
ssh florevid@lettuce.tapor.uvic.ca '/home1t/florevid/eXist/bin/shutdown.sh'

To administer the db:
- open the exist.jnlp client
- URL xmldb:exist://localhost:8080/exist/xmlrpc

Problem is that the def_xml_transform method assumes output is to html, and generates an entity for each literal apostrophe in the data. If the output is in fact to a javascript string, then the ampersand in the entity is escaped to an ampersande entity leaving the hash, numeric value and semicolon as literal characters which appear in the javascript popup.

I had tracked this down and Mike Elkink suggested the easiest way to solve the problem.

To solve the problem, we have to add a new parameter to the def_xml_transform method with a default value of true and then in the call from the ajax_search set the value of that parameter to false.

in xmldb.php:

function def_xml_transform($xml, $stylesheet, $params = false)
becomes
function def_xml_transform($xml, $stylesheet, $params = false, $asHTML = true)

and

return $xml_result->saveHTML();
becomes
if ($asHTML) {
return $xml_result->saveHTML();
}
else {
return $xml_result;
}

in ajax_search.php

$xml_result = def_xml_transform('<root>' . $xml_result . '</root>', '../xslt/ajax_search.xsl');
becomes
$xml_result = def_xml_transform('<root>' . $xml_result . '</root>', '../xslt/ajax_search.xsl','false','false');

[not sure about the apostrophe delimiters around the two instances of false in that last line]