Sign Up! Login: Password: New User? Forgot? Support
Top Mods!
Wowhead Search
by sonofsamedi
Digital Clock
by Wolfar15
Admin Forums
Welcome to the GuildPortal Help Community! These forums are for admin-to-admin help.
Available Forums
Forums : Voodoo Tech and Scripter's Den of Scriptniquity > XML/XSL Transformation works only if both XML and XSL are on a remote site?
BarnesGilrain (New Admin) 7/31/2009 7:13 AM EST : XML/XSL Transformation works only if both XML and XSL...
BarnesGilrain
Posts: 39
Becoming Adept!

Did anyone else get the problem where the XML/XSL transformation would work only if both the XML and XSL were on a remote site (with the XSL Source set to Use XSL URL),
however if the XSL file content was copied into the XSL Content box and XSL Source was set to Use XSL Content, the transformation wouldn't work.
I get the"Either the XML or XSL Sources (or both) provided for this content areinvalid, pointing at a document that does not comply with XML standardsor is not an XML document at all. Rendering terminated."message.

This is driving me crazy, I tried posting a support request, but I'm guessing that due to their policy that they can't help in case of XML/XSL content problems they just chucked the request in the bin.
Anyone got a clue?

The funny thing is, that if I leave the XSL Url set and switch the XSL Source to Use XSL Content, it still gets the remote XSL file instead of the one in the content window.

I hope anyone can help.

Barnes




XML source is http://www.codemasters.com/microsites/server_xml.php

XSL code I used:


<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output indent="yes" method="html">
  <xsl:template match="/">
    <xsl:for-each select="serverstatus/game">
      <xsl:if test="@name = 'lotro'">
        <xsl:for-each select="server">
          <xsl:if test="@name = 'Gilrain'">
            GILRAIN server is
            <xsl:choose>
              <xsl:when test="status = 'up'"><span style="font-weight: bold; color: green;">UP</span></xsl:when>
              <xsl:otherwise><span style="font-weight: bold; color: red;">DOWN</span></xsl:otherwise>
            </xsl:choose>
            <br />
            <span style="font-size: 10px;">Last checked:<br />
            <xsl:value-of select="formatteddate"> GMT</xsl:value-of></span>
          </xsl:if>
        </xsl:for-each>
      </xsl:if>
    </xsl:for-each>
  </xsl:template>
</xsl:output>
</xsl:stylesheet>

TopBottom

Mottie (MVP) 7/31/2009 1:55 PM EST : RE: XML/XSL Transformation works only if both XML and...
GuildPortal MVP
Mottie
Posts: 3884
Zomgawsh Poster

Hi BarnesGilrain!

Yes, I believe setting the XSL source to the box that is provided has been broken for some time now. I remember spending a lot of time trying to get the XSL content box to work =(

I never really got around to learning XSL very well and it has been a long time since I messed with this, but if you peek over at this thread (it's for WoW, but I bet you can adapt it), I know that method works.




TopBottom

BarnesGilrain (New Admin) 7/31/2009 2:30 PM EST : RE: XML/XSL Transformation works only if both XML and...
BarnesGilrain
Posts: 39
Becoming Adept!

Hi Mottie,

thanks for the link. I didn't know that GuildPortal offered File Hosting through the Control Panel
I uploaded the XSL file, pasted the URL into XSL URL source, and now it works without me having my web server running all the time.
Although this doesn't solve the problem, it proves to be a good enough workaround.

Thanks again
Barnes
TopBottom

Mottie (MVP) 7/31/2009 10:30 PM EST : RE: XML/XSL Transformation works only if both XML and...
GuildPortal MVP
Mottie
Posts: 3884
Zomgawsh Poster

Hey BarnesGilrain!

It's not a problem!

If you start to run out of room in your files area (GuildPortal only provides 5Mb), I found a free hosting site with 2Gb of storage and unmetered bandwidth at http://www.myotherdrive.com/
TopBottom

Calamar Sidhe (New Admin) 9/26/2009 5:22 AM EST : RE: XML/XSL Transformation works only if both XML and...

Calamar Sidhe
Posts: 310
Fingers of Fury!

Hi there,


After using EQ roster dump for to long I have treid following this thread to get the Roster via a XML link from EQplayers the Guild link is here 


http://eqplayers.station.sony.com/guild_profile.vm?guildId=438086664245


 following your guide linked above I tried doing linking the XML feed to my website

http://www.guildportal.com/Guild.aspx?GuildID=107262&TabID=917143

In the content box The XML url is http://eqplayers.station.sony.com/guild_roster_xml.vm?guildId=438086664245

I then clicked on the XML link and then copied and saved the data to this file

http://www.axiomfiles.com/Files/107262/rosterxsl.doc

I have used Word to do so and also notepad but i get this Error meesage on the Roster page

Error parsing XML/XSL, details as follows: Invalid character in the given encoding. Line 1, position 1.

Any help that you can give would be greatly appreciated as the only other way to get Roster working in Everquest is to do a EQroster dump then find that file and then upload it .

Which of course needs some one to keep doing it manually, if they remember and this way should be automatic ?

Thanks for your help  in advance

TopBottom

Mottie (MVP) 9/26/2009 1:25 PM EST : RE: XML/XSL Transformation works only if both XML and...
GuildPortal MVP
Mottie
Posts: 3884
Zomgawsh Poster

Hi Calamar Sidhe!

The XML file you saved to your computer needs to be processed by an XSL file, the XSL file needs to be written specifically for the data (look at the one in the first post, it's specially for the server status for the Gilrain LOTRO server).

I tried to look at the EQ Guild Roster built into GP as a reference, but I don't know where to get the guild dump from... is it something the game itself does?

Honestly, I'd put in a feature request form to GP since I believe the uploading the dump file method may have been made when an XML feed wasn't available. I can look into working with the roster (either by XSL or some other method) when I have more time.
TopBottom

Calamar Sidhe (New Admin) 9/28/2009 4:59 PM EST : RE: XML/XSL Transformation works only if both XML and...

Calamar Sidhe
Posts: 310
Fingers of Fury!

Hi there

Thanks for the fast reply ) I was away after i posted  /grins

I was unsure about the file saved so thanks for clearing it up I have never done any XSL but i can see what you mean looking at that example

You need to be ingame ( EQ) and use the Guild manager feature to do a guild dump which gives you the file

Example is here http://www.axiomfiles.com/Files/107262/crimsonfist-20090207-142946.txt 

Ths is then read by the EQguild roster and converts to a HTML page. ( i think )

I will take your advice and do a Feature Request Form.

Thank you for taking your time to look at this in the future.

TopBottom

Admins Online
There are   members online.
So-and-so has logged on!
%title%
%message%