I got the conversion working and all the code checked in. I used the Ian\/Jim conversion gadget. Initially it looked like a crazy contraption. It turns out to be pretty cool – just undocumented – and the way Jim\/Ian used it in Content was totally Ninja-warrior.
\nLuckily my new conversion code is a *much* better sample to work from – because it is simple. Some documentation should be written.
\nSo it is now off to Tony for testing. More detail below.
\nNow I am off to go get my motorcycle gear from www.ridersdiscount.com. So for the rest of the day – call the cell.<\/p>\n
\nThe first version is up – primarily for testing – I only have a mysql convertor. It runs with mysql and hsql. Here are checkout, compile, and conversion instructions:
\nGrab the following branches:
\nhttps:\/\/source.sakaiproject.org\/svn\/db\/branches\/SAK-13584\/
\nhttps:\/\/source.sakaiproject.org\/svn\/mailarchive\/branches\/SAK-13584\/
\nhttps:\/\/source.sakaiproject.org\/svn\/util\/branches\/SAK-13584\/
\nCompile and deploy
\nRun the conversion
\ncd mailarchive
\nEdit upgradeschema-mysql.config to get the database connection right.
\nRun the script:
\nsh mailarchive-runconversion.sh \\
\n-j “\/Users\/csev\/dev\/sakai-trunk\/apache-tomcat-5.5.23\/common\/lib\/mysql-connector-java-5.1.6-bin.jar” \\
\n-p “\/Users\/csev\/dev\/sakai-trunk\/apache-tomcat-5.5.23\/sakai\/sakai.properties” \\
\nupgradeschema-mysql.config
\nCheck to see if the BODY, SUBJECT, and HTMLBODY columns look reasonable. The conversion can be stopped and started. If you want to undo the conversion simply execute these commands:
\nALTER TABLE MAILARCHIVE_MESSAGE DROP COLUMN SUBJECT;
\nALTER TABLE MAILARCHIVE_MESSAGE DROP COLUMN BODY;
\nALTER TABLE MAILARCHIVE_MESSAGE DROP COLUMN HTMLBODY;
\n–Chuck
\nTest Scenario for this interim version – RUN this test and send me catalina.out
\nHere are the needed clicks – keep track of which ones are dog slow and which ones are fast. I expect that the non-search queries will be quite fast. And even the search queries should be tolerable.
\nGo to the mail tool in a site with lots of messages – do not enter a search value
\nPress next page 2 times
\nPress back page
\nPress last page
\nPress back page twice
\nPress first page
\nEnter a message
\nPress next message twice
\nPress back message once
\nSwitch to Sort by Subject
\nSwitch to Ascending and descending
\nPress back page
\nPress last page
\nPress back page twice
\nPress first page
\nNow put in a search string that is common and repeat the above steps.
\nNow put in a rare search string and repeat the above steps.
\nSend me back the catalina.out – thanks muchly<\/p>\n","protected":false},"excerpt":{"rendered":"
I got the conversion working and all the code checked in. I used the Ian\/Jim conversion gadget. Initially it looked like a crazy contraption. It turns out to be pretty cool – just undocumented – and the way Jim\/Ian used it in Content was totally Ninja-warrior. Luckily my new conversion code is a *much* better […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-501","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/501","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/comments?post=501"}],"version-history":[{"count":1,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/501\/revisions"}],"predecessor-version":[{"id":2602,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/501\/revisions\/2602"}],"wp:attachment":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/media?parent=501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/categories?post=501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/tags?post=501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}