MC keeps the transcript xml files in a subfolder in the Francotoile user on Endive (e.g. fraf1.xml). I copied those to the /Users/sarneil/Documents/Projects/french/FrancoToile/data_input/francotoile_transcripts folder on StewsSlab. From there I used the Exist client to upload them to the database:
username: admin
password: in usual place for HCMC
URL: xmldb:exist://lettuce.tapor.uvic.ca:8890/xmlrpc
once you're in, go into the francotoile/data/francotoile collection, where you'll see the dozens of XML files in the collection and use the button whose icon is a page with a plus sign to upload the file(s).
MCD reported that in the file lsqr1, the timed transcripts did not appear, but the full text did. After a couple of hours of investigation, I discovered the cause (which had an obvious fix of removing the extra "x"). The file lsqr1 contained this:
<u start="xlsrq1u2" end="lsrq1u3">
and it should have contained this:
<u start="lsrq1u2" end="lsrq1u3">
This error didn't cause a problem with validation (naturally). When the XSLT that creates the javascript for the timelines and events encountered this (get_events.php page calls events.xsl), it wrote out javascript that pointed to a nonexistant object, included no start time and pointed to a non-existant id for the next utterance (all based on the erroneous start value).
Here's the wrong javascript output:
.addEvent('','00:00:29.130',
'utterance', ' UTTERANCE .... ', 'xlsrq1u3');
Here's the javascript generated after the fix:
lsrq1t1.addEvent('00:00:23.520','00:00:29.130',
'utterance', ' UTTERANCE ... ', 'lsrq1u3');
When the page executed that code it threw a syntax error and the movie object was never defined so that's why the transcripts didn't appear.
Uploaded seven .mov files recently modified by MCD and all the data files.
I couldn't find about four data files she edited last summer. I did find earlier versions of those files, and my backups and the server backups all contained those files, as did the archive on the computer she'd used to do the editing, so I don't know where those files went. MCD will re-enter the timestamps for those files.
Also found two files (prmf4 and prmf5) that were virtually identical, including using the same document ID, which caused the site to fail if either of those files were viewed or searched. Fixed the duplicate ID, so the site mechanically works.
Found following oddities in the playback:
sngl1 : video ok, "a suivre" appears for the transcript
sngl2 : video ok, "a suivre" appears for the transcript
lsrq1 : video ok, no transcript appears
prmq1 : video ok, wrong transcript appears
prmq2 : video ok, no transcript appears
prmf5 : duplicate of prmf4
prmf4 : video ok, wrong transcript appears
cltf1 : video ok, no transcript appears
cltf2 : video ok, wrong transcript appears
eduf1 : video ok, wrong transcript appears
mixc1 : video ok, no transcript appears
mixm1 : video ok, no transcript appears
veqf1 : video ok, no transcript appears
Some of these may be data problems and some caching and indexing. MCD will go through and see.