[Xerte] Re: Import an Exported Xerte File into XOT

Adam Read aread at marjon.ac.uk
Wed Jul 31 09:40:32 BST 2013 

And if I echo the array
echo $row_play[0];
echo $row_play[1];
echo $row_play[2];
echo $row_play[3];
echo $row_play[4];
echo $row_play[5];
echo $row_play[6];
echo $row_play[7];

I get the following:

Nottinghamareadxerte351Publicengine=javascript

Not sure if that helps.

Adam Read BA (Hons) PG Cert ODE (Open)
Senior e-Learning Technologist
University of St Mark & St John
Tel: 01752 636700 Ext: 5673 | Room: 108
aread at marjon.ac.uk
www.marjon.ac.uk

Please consider the environment before printing this email

________________________________________
From: xerte-bounces at lists.nottingham.ac.uk [xerte-bounces at lists.nottingham.ac.uk] on behalf of Adam Read [aread at marjon.ac.uk]
Sent: 31 July 2013 09:26
To: Xerte discussion list
Subject: [Xerte] Re: Import an Exported Xerte File into XOT

Morning all, thanks for helping so far.

So, I went ahead and stuck a load of echos in play.php and this is what I've worked out.

The script runs all the way down to where it works out what the security is and that the template is indeed set to public access. It seems to run the db_query (below), but the call to show_template() must crash the script as the last echo is not printed.

FYI, $row_play outputs "Array". Is that right? I'd expect an ID number or something.

>From my Play.php
/*
* Public - Increment the number of users and show the template
*/

echo "here adam2";

db_query("UPDATE {$xerte_toolkits_site->database_table_prefix}templatedetails SET number_of_uses=number_of_uses+1 WHERE template_id=?", array($safe_template_id));
echo "here ran query";
echo $row_play;
show_template($row_play);
echo "here show template";

On screen I see:

here adam2here ran queryArray



Adam Read BA (Hons) PG Cert ODE (Open)
Senior e-Learning Technologist
University of St Mark & St John
Tel: 01752 636700 Ext: 5673 | Room: 108
aread at marjon.ac.uk
www.marjon.ac.uk

Please consider the environment before printing this email

________________________________________
From: xerte-bounces at lists.nottingham.ac.uk [xerte-bounces at lists.nottingham.ac.uk] on behalf of Smith, John [J.J.Smith at gcu.ac.uk]
Sent: 30 July 2013 18:42
To: xerte at lists.nottingham.ac.uk
Subject: [Xerte] Re: Import an Exported Xerte File into XOT

Yeah sorry me on phone now too...

Will send an updated file when i get home...

Regards

John Smith
Learning Technologist
School of Health and Life Sciences

Sent from Samsung Galaxy SII



"Pat @ Pgogy" <xerte at pgogywebstuff.com> wrote:


Sorry, reading on phone

Try putting some echos in play?

On 30 Jul 2013, at 16:27, "Smith, John" <J.J.Smith at gcu.ac.uk<mailto:J.J.Smith at gcu.ac.uk>> wrote:

He did…

http://elearning.net.marjon.ac.uk/xerte2/play.php?template_id=1

There’s no source being sent at all… last time I saw that was with the person who had bad xml (an ASCII(1) pasted from Word or some similar app) which was breaking the XML parser which extracts the title… wondering if we should allow xenith to do this and alter title from jQuery…

Anyway… I’ve checked the XML and it’s fine… so it’s unlikely to be that… but it’s happening before the opening HTML tag is sent…

Regards,

John Smith
Learning Technologist
School of Health & Life Sciences
Glasgow Caledonian University

From: xerte-bounces at lists.nottingham.ac.uk<mailto:xerte-bounces at lists.nottingham.ac.uk> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat @ Pgogy
Sent: Tuesday, July 30, 2013 4:21 PM
To: Xerte discussion list
Subject: [Xerte] Re: Import an Exported Xerte File into XOT

Can you share a URL?

On 30 Jul 2013, at 15:48, Adam Read <aread at marjon.ac.uk<mailto:aread at marjon.ac.uk>> wrote:
Set $development to true in config.php. Not seeing any errors on screen when logging in/creating/editing/previewing/playing.


From: xerte-bounces at lists.nottingham.ac.uk<mailto:xerte-bounces at lists.nottingham.ac.uk> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat @ Pgogy
Sent: 30 July 2013 15:11
To: Xerte discussion list
Subject: [Xerte] Re: Import an Exported Xerte File into XOT

Turn on development?

On 30 Jul 2013, at 14:04, Adam Read <aread at marjon.ac.uk<mailto:aread at marjon.ac.uk>> wrote:
Nope, play and play_html do the same thing: http://elearning.net.marjon.ac.uk/xerte2/play.php?template_id=1

I’m getting nothing back of any use from the POST response, so don’t know what settings to check. Any advice?

The only thing that looks different in the site details table between my old XOT install and this one is the import_path value:

old XOT: C:Inetpubwwwrootloimport/
new XOT: C:/Inetpub/wwwroot/xerte2/import/
But I suspect that’s the old XOT with a rubbish/wrong value.

Adam Read BA (Hons) PG Cert ODE (Open)
Senior e-Learning Technologist
University of St Mark & St John
Tel: 01752 636700 Ext: 5673 | Room: 108
about.me/adamread<http://about.me/adamread>
<image001.jpg><http://moodle.marjon.ac.uk/>

From: xerte-bounces at lists.nottingham.ac.uk<mailto:xerte-bounces at lists.nottingham.ac.uk> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat @ Pgogy
Sent: 30 July 2013 13:57
To: Xerte discussion list
Subject: [Xerte] Re: Import an Exported Xerte File into XOT

Does play work?

500 suggests php error which suggests a missing setting?

On 30 Jul 2013, at 12:03, Adam Read <aread at marjon.ac.uk<mailto:aread at marjon.ac.uk>> wrote:
Right, ignore my previous query as I’ve decided to forget about the Frankenstein installation and start with a fresh XOT install on IIS.

I’ve successfully run through all of the setup, following the new guide (which is great btw) and installed without error. I had to go back and insert LDAP settings in to the database, and can login fine.

I’ve created a new learning object using the Nottingham template. The edit window works fine, however, when I preview it I get nothing but a blank screen. There’s a HTTP 500 error in the console, but it’s not particularly helpful, I think it’s on the play.php?template= script.

I’ve checked the site details and all the import paths look OK to me:

<?xml version="1.0" encoding="utf-8" ?>
<!--
-
- phpMyAdmin XML Dump
- version 2.11.7.1
- http://www.phpmyadmin.net
-
- Host: localhost
- Generation Time: Jul 30, 2013 at 11:57 AM
- Server version: 5.0.51
- PHP Version: 5.2.6
-->

<!--
- Database: 'xerte2'
-->
<xerte2>
<!-- Table sitedetails -->
<sitedetails>
<site_id>1</site_id>
<site_url>http://elearning.net.marjon.ac.uk/xerte2/</site_url><http://elearning.net.marjon.ac.uk/xerte2/%3c/site_url%3e>
<apache>false</apache>
<mimetypes>text/xml,application/msword,application/x-shockwave-flash,image/jpeg,image/pjpeg,image/png,image/gif,image/x-png,audio/mpeg,application/vnd.ms-excel,application/pdf,application/vnd.ms-powerpoint,video/x-ms-wmv,text/html,video/mp4,video/avi,audio/wav,text/plain,video/quicktime,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.openxmlformats-officedocument.wordprocessingml.document,application/vnd.openxmlformats-officedocument.presentationml.presentation</mimetypes>
<site_session_name>XERTE_TOOLKITS</site_session_name>
<LDAP_preference>XXXX</LDAP_preference>
<LDAP_filter>XXXX</LDAP_filter>
<integration_config_path></integration_config_path>
<admin_username>XXXX</admin_username>
<admin_password>XXXX</admin_password>
<site_title>Welcome to Xerte Online Toolkits</site_title>
<site_name>Xerte Online Toolkits</site_name>
<site_logo>website_code/images/xerteLogo.jpg</site_logo>
<organisational_logo>website_code/images/UofNLogo.jpg</organisational_logo>
<welcome_message>Welcome to Xerte online toolkits</welcome_message>
<site_text>Welcome to the toolkits front page, developed by the University of Nottingham~~~</site_text>
<news_text>PHAgY2xhc3M9Im5ld3NfdGl0bGUiPk90aGVyIHJlc291cmNlczwvcD48cCBjbGFzcz0ibmV3c19zdG9yeSI+PGEgaHJlZj0iIj5TaXRlIDE8L2E+PC9wPjxwIGNsYXNzPSJuZXdzX3N0b3J5Ij48YSBocmVmPSIiPlNpdGUgMjwvYT48L3A+PHAgY2xhc3M9Im5ld3Nfc3RvcnkiPjxhIGhyZWY9IiI+U2l0ZSAzPC9hPjwvcD4=</news_text>
<pod_one>PHAgY2xhc3M9Im5ld3NfdGl0bGUiPlJlc291cmNlczwvcD48cCBjbGFzcz0iZGVtbyI+PGEgaHJlZj0iaHR0cDovL3d3dy54ZXJ0ZS5vcmcudWsiPkNvbW11bml0eSBSZXNvdXJjZXM8L2E+PGJyIC8+VGhlIFhlcnRlIHVzZXIgY29tbXVuaXR5IHdlYnNpdGUuPC9wPjxwIGNsYXNzPSJkZW1vIj48YSBocmVmPSJodHRwOi8vd3d3Lm5vdHRpbmdoYW0uYWMudWsvdG9vbGtpdHMvcGxheV81NjAiPkxlYXJuaW5nIE9iamVjdCBEZW1vPC9hPjxiciAvPkEgY29tcHJlaGVuc2l2ZSBkZW1vIG9mIGFsbCB0aGUgcGFnZSB0ZW1wbGF0ZXMuPC9wPg==</pod_one>
<pod_two>PHAgY2xhc3M9Im5ld3NfdGl0bGUiPldhbnQgdG8gc2hhcmUgc29tZSB0aG91Z2h0cz88L3A+PHAgY2xhc3M9ImdlbmVyYWwiPklmIHlvdSBoYXZlIGFueSBxdWVzdGlvbnMsIHJlcXVlc3RzIGZvciBoZWxwLCBpZGVhcyBmb3IgbmV3IHByb2plY3RzIG9yIHByb2JsZW1zIHRvIHJlcG9ydCwgdGhlbiBwbGVhc2UgZ2V0IGluIHRvdWNoLjwvcD48cCBjbGFzcz0iZ2VuZXJhbCI+UGxlYXNlIHVzZSBvdXIgPGEgaHJlZj0iZmVlZGJhY2svIiBzdHlsZT0iY29sb3I6IzAwMCI+RmVlZGJhY2sgRm9ybTwvYT48L3A+</pod_two>
<copyright>Copyright University of Nottingham 2008 - 2013</copyright>
<rss_title>Xerte Online Toolkits RSS Feed</rss_title>
<synd_publisher>University of St Mark</synd_publisher>
<synd_rights>Licensed under a Creative Commons Attribution - NonCommercial-ShareAlike 2.0 Licence - see http://creativecommons.org/licenses/by-nc-sa/2.0/uk/</synd_rights><http://creativecommons.org/licenses/by-nc-sa/2.0/uk/%3c/synd_rights%3e>
<synd_license>Licensed under a Creative Commons Attribution - NonCommercial-ShareAlike 2.0 Licence - see http://creativecommons.org/licenses/by-nc-sa/2.0/uk/</synd_license><http://creativecommons.org/licenses/by-nc-sa/2.0/uk/%3c/synd_license%3e>
<demonstration_page>modules/xerte/training/toolkits.htm</demonstration_page>
<form_string>PGh0bWw+PGJvZHk+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3QiIGFjdGlvbj0iIj48cD5Vc2VybmFtZSA8aW5wdXQgdHlwZT0idGV4dCIgc2l6ZT0iMjAiIG1heGxlbmd0aD0iMTIiIG5hbWU9ImxvZ2luIiAvPjwvcD48cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0icGFzc3dvcmQiIHNpemU9IjIwIiBtYXhsZW5ndGg9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz48L3A+PHA+PGlucHV0IHR5cGU9ImltYWdlIiBzcmM9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR0bl9Mb2dpbk9mZi5naWYiIG9ubW91c2VvdmVyPSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT24uZ2lmJyIgb25tb3VzZWRvd249InRoaXMuc3JjPSd3ZWJzaXRlX2NvZGUvaW1hZ2VzL0J0dG5fTG9naW5DbGljay5naWYnIiBvbm1vdXNlb3V0PSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT2ZmLmdpZiciIC8+PC9wPg==</form_string>
<peer_form_string>PGh0bWw+PGJvZHk+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3QiIGFjdGlvbj0iIj48cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0icGFzc3dvcmQiIHNpemU9IjIwIiBtYXhsZW5ndGg9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz48L3A+PHA+PGlucHV0IHR5cGU9ImltYWdlIiBzcmM9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR0bl9Mb2dpbk9mZi5naWYiIG9ubW91c2VvdmVyPSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT24uZ2lmJyIgb25tb3VzZWRvd249InRoaXMuc3JjPSd3ZWJzaXRlX2NvZGUvaW1hZ2VzL0J0dG5fTG9naW5DbGljay5naWYnIiBvbm1vdXNlb3V0PSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT2ZmLmdpZiciIC8+PC9wPg==</peer_form_string>
<module_path>modules/</module_path>
<website_code_path>website_code/</website_code_path>
<users_file_area_short>USER-FILES/</users_file_area_short>
<php_library_path>website_code/php/</php_library_path>
<import_path>C:/Inetpub/wwwroot/xerte2/import/</import_path>
<root_file_path>C:/Inetpub/wwwroot/xerte2/</root_file_path>
<play_edit_preview_query>c2VsZWN0ICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gIm9yaWdpbmFsdGVtcGxhdGVzZGV0YWlscy50ZW1wbGF0ZV9uYW1lLCAiIC4gJHhlcnRlX3Rvb2xraXRzX3NpdGUtPmRhdGFiYXNlX3RhYmxlX3ByZWZpeCAuICJsb2dpbmRldGFpbHMudXNlcm5hbWUsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gIm9yaWdpbmFsdGVtcGxhdGVzZGV0YWlscy50ZW1wbGF0ZV9mcmFtZXdvcmssICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlcmlnaHRzLnVzZXJfaWQsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlcmlnaHRzLmZvbGRlciwgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAidGVtcGxhdGVyaWdodHMudGVtcGxhdGVfaWQsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscy5hY2Nlc3NfdG9fd2hvbSBmcm9tICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gIm9yaWdpbmFsdGVtcGxhdGVzZGV0YWlscywgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAidGVtcGxhdGVyaWdodHMsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscywgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAibG9naW5kZXRhaWxzIHdoZXJlICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscy50ZW1wbGF0ZV90eXBlX2lkID0gIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAib3JpZ2luYWx0ZW1wbGF0ZXNkZXRhaWxzLnRlbXBsYXRlX3R5cGVfaWQgYW5kICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscy5jcmVhdG9yX2lkID0gIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAibG9naW5kZXRhaWxzLmxvZ2luX2lkIGFuZCAiIC4gJHhlcnRlX3Rvb2xraXRzX3NpdGUtPmRhdGFiYXNlX3RhYmxlX3ByZWZpeCAuICJ0ZW1wbGF0ZXJpZ2h0cy50ZW1wbGF0ZV9pZCA9ICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscy50ZW1wbGF0ZV9pZCBhbmQgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAidGVtcGxhdGVyaWdodHMudGVtcGxhdGVfaWQ9IlRFTVBMQVRFX0lEX1RPX1JFUExBQ0UiIGFuZCByb2xlPSJjcmVhdG9yIg==</play_edit_preview_query>
<error_log_path>error_logs/</error_log_path>
<email_error_list></email_error_list>
<error_log_message>true</error_log_message>
<max_error_size>10</max_error_size>
<error_email_message>10</error_email_message>
<ldap_host>XXXXX</ldap_host>
<ldap_port>XXXX</ldap_port>
<bind_pwd>XXXXX</bind_pwd>
<basedn>XXXXX</bind_dn>
<flash_save_path>modules/xerte/engine/save.php</flash_save_path>
<flash_upload_path>upload.php?path=</flash_upload_path>
<flash_preview_check_path>modules/xerte/engine/file_exists.php</flash_preview_check_path>
<flash_flv_skin>modules/xerte/engine/tools/SteelOverAll.swf</flash_flv_skin>
<site_email_account></site_email_account>
<headers></headers>
<email_to_add_to_username></email_to_add_to_username>
<proxy1></proxy1>
<port1></port1>
<feedback_list></feedback_list>
</sitedetails>
</xerte2>


In the USER-FILES folder the object I’ve created has the following files:


• media/animage.jpg

• media.xml

• data.xml

Here’s the XML from preview.xml:

<learningObject language="en-GB" name="Adam New Test" navigation="Linear" textSize="12" displayMode="default">
<title linkID="PG1375180431689" name="Hurrah?" size="30">
<![CDATA[ Some text
]]>
</title>
<imageViewer linkID="PG1375181533903" name="My image" align="Left" url="FileLocation + 'media/animage.jpg'" moveTip="Move" zoomInTip="Zoom In" zoomOutTip="Zoom Out" selectAreaTip="Select Area" resetImageTip="Reset Image" toggleScreenTip="Toggle Full Screen">
<![CDATA[ Some stuff
]]>
</imageViewer>
</learningObject>

_______________________________________________
Xerte mailing list
Xerte at lists.nottingham.ac.uk<mailto:Xerte at lists.nottingham.ac.uk>
http://lists.nottingham.ac.uk/mailman/listinfo/xerte


This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it. Please do not use, copy or disclose the information contained in this message or in any attachment. Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.

This message has been checked for viruses but the contents of an attachment may still contain software viruses which could damage your computer system, you are advised to perform your own checks. Email communications with the University of Nottingham may be monitored as permitted by UK legislation.


Glasgow Caledonian University is a registered Scottish charity, number SC021474

Winner: Times Higher Education’s Widening Participation Initiative of the Year 2009 and Herald Society’s Education Initiative of the Year 2009.
http://www.gcu.ac.uk/newsevents/news/bycategory/theuniversity/1/name,6219,en.html

Winner: Times Higher Education’s Outstanding Support for Early Career Researchers of the Year 2010, GCU as a lead with Universities Scotland partners.
http://www.gcu.ac.uk/newsevents/news/bycategory/theuniversity/1/name,15691,en.html
_______________________________________________
Xerte mailing list
Xerte at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte
[http://www.marjon.ac.uk/media/marjon/promotions/emailsignature/Email_Signature_Image.jpg]





_______________________________________________
Xerte mailing list
Xerte at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte
[http://www.marjon.ac.uk/media/marjon/promotions/emailsignature/Email_Signature_Image.jpg]

More information about the Xerte mailing list