<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;
mso-fareast-language:EN-US;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas","serif";
color:black;
mso-fareast-language:EN-US;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1013261970;
mso-list-type:hybrid;
mso-list-template-ids:771137760 134807569 134807577 134807579 134807567 134807577 134807579 134807567 134807577 134807579;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=EN-GB link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Thanks, I’m glad I’m not the only one who can fat-finger this kind of data!<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>I can’t find anything in the basic.sql code, however, that CREATEs a ‘user’ table. Could this be a problem?<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>I’ve also run into a problem exporting LOs now, possibly because the temporary directory isn’t defined? Could be default to /tmp – that’s supposed to have write privileges for all users, isn’t it. I’m not sure what the equivalent is in Windows, however.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Kindest regards, Thomas<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='color:windowtext;mso-fareast-language:EN-GB'>From:</span></b><span lang=EN-US style='color:windowtext;mso-fareast-language:EN-GB'> xerte-dev-bounces@lists.nottingham.ac.uk [mailto:xerte-dev-bounces@lists.nottingham.ac.uk] <b>On Behalf Of </b>Tom Reijnders<br><b>Sent:</b> 04 May 2013 11:12 AM<br><b>To:</b> For Xerte technical developers<br><b>Subject:</b> [Xerte-dev] Re: Xerte Install<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>I fixed issue 2 yesterday evening. Too many people ran into that one.<br><br><span style='font-size:12.0pt;mso-fareast-language:EN-GB'><o:p></o:p></span></p><div><p class=MsoNormal>Op 4-5-2013 11:21, Pat @ Pgogy schreef:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>2 is simple enough to fix<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>3 is a problem - would want want the maximum size to be a php ini limit, or a XOT specific limit? Different sites on the same server?<o:p></o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><br>On 3 May 2013, at 22:09, "Thomas Rochford" <<a href="mailto:thomas.rochford@jiscadvance.ac.uk">thomas.rochford@jiscadvance.ac.uk</a>> wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>Good Evening Tom,<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>First of all a Big Thank you for your work. As a small gesture of appreciation I have produced a document describing how to upload Learning Objects directly, via FTP, webDav etc. If you think it will be useful, please put it somewhere appropriate on the Community web site. It would be good if you (and others?) looked it over, in case I have made some mistakes or you feel things could have been explained a little better.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>It was an ‘interesting’ experience, and I learnt a number of lessons that may help others.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo2'><![if !supportLists]><span style='mso-list:Ignore'>1)<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>My website is hosted in Germany (I believe) by 1&1 Internet. They offer quite a restricted interface compared with some others that I have seen and I think that there is a ridiculously long period in which pages are cached by the server. For no reason that I can think of, Tom’s new code (replacing the ‘fault’ occasioned by not having a temporary upload file specified in php.ini with a ‘warning’) did not seem to work. Furthermore any changes that I made (e.g. trying to FORCE it to go to page1.php by commenting out just about everything else), didn’t work either, so I suspect the output had been cached by the server (I flushed the browser cache). So I just went straight to page1.php. It might be a good idea to add a link to this at the bottom, rather than using the ‘submit’ button.<br>In any event generating a fault or warning of this kind is probably not necessary. Because I wanted to do a clean installation in order to test it out, I had to re-import my existing LOs as .zip files and they all worked well, provided they were less than the ridiculously low level set by 1&1. But of that more anon…<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo2'><![if !supportLists]><span style='mso-list:Ignore'>2)<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>The next problem I encountered was to do with database.php. 1&1 do not allow you to choose the name of your database and give it a thoroughly unmemorable and easily mistyped name and the same for the managing account. I tried to copy and paste them from the web page but, in doing so, inadvertently copied an extra space at the end of the database name. Although I went back via the browser and re-entered it correctly, the installer still had the pesky space and I had to get rid of it by editing database.php. Would it be possible to overwrite any existing database.php with a new one every time the data is re-submitted , because I’m sure other users could also make this mistake.<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo2'><![if !supportLists]><span style='mso-list:Ignore'>3)<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>The final problem I had was uploading some LOs. I’m sure it was size related, but the generic failure message about only accepting zip files threw me for a few minutes. I would like to suggest that the upload script checks to make sure that the size of the object to be uploaded is less than ‘max_file_uploadsize’ (or whatever the php variable is called), before attempting the upload and warns the user that they will have to transfer the data manually if it is.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Because of problem #3 I documented the process of FTP’ing data directly up to Toolkits as described in the attached document.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>I should point out that this could be quite an issue because many smaller organisations are either using the free JANET-hosted web servers, or other commercially hosted ones which have locked down php.ini files which they will not change, so some or all of these points may have relevance to a significant number of other users.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Apologies for the length.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Kindest regards, Thomas<o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><br><br><o:p></o:p></span></p></div></blockquote><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><Manual Uploads to Xerte.docx><o:p></o:p></span></p></div></blockquote><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'>_______________________________________________<br>Xerte-dev mailing list<br><a href="mailto:Xerte-dev@lists.nottingham.ac.uk">Xerte-dev@lists.nottingham.ac.uk</a><br><a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev">http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev</a><o:p></o:p></span></p></div></blockquote><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><br><br><br><br><br><br><o:p></o:p></span></p><pre>_______________________________________________<o:p></o:p></pre><pre>Xerte-dev mailing list<o:p></o:p></pre><pre><a href="mailto:Xerte-dev@lists.nottingham.ac.uk">Xerte-dev@lists.nottingham.ac.uk</a><o:p></o:p></pre><pre><a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev">http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev</a><o:p></o:p></pre></blockquote><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><br><br><o:p></o:p></span></p><pre>-- <o:p></o:p></pre><pre>--<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Tom Reijnders<o:p></o:p></pre><pre>TOR Informatica<o:p></o:p></pre><pre>Chopinlaan 27<o:p></o:p></pre><pre>5242HM Rosmalen<o:p></o:p></pre><pre>Tel: 073 5226191<o:p></o:p></pre><pre>Fax: 073 5226196<o:p></o:p></pre><pre><o:p> </o:p></pre><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><br><br><o:p></o:p></span></p></div></body></html>