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
Stathol (Guild Admin) 4/8/2003 7:51 AM EST : Working XSLT for EQ roster
Stathol
Posts: 235
Fingers of Fury!

For those of you who might be interested in this sort of thing, I banged away at the W3 Consortium XSLT standards and finally got a functional transform of my guild's roster. There's still room for improvement (ex. adding user image thumbnails), but I think it produces a much cleaner table view of the guild roster than the default Guildportal roster (no offense).

Advantages:
  • It took a while to get the <xsl:sort/> statements to do exactly what I wanted, but ultimately I got a roster that sorts the officers to the top, then users with character data, then users who haven't entered any info about their character at the bottom. All subsets are sorted alphabetically.
  • The mail link by each name is fully functional, as in the original roster.
  • If a user has a "More Info" link, their name will link to the appropriate location.
  • Hovering your mouse over their name will show you their last login date and time.
  • Users who have character names are listed by character name instead of account name. I can't tell you how much that bugged me about the original roster.
  • If the user doesn't have any character data, their name comes from their account name, it's italicized, and the name field spans the entire table, my not-so-subtle attempt to remind people that they haven't finished the registration process.

Problems:
  • The first sort criterion is if the user is an officer; the second is to sort alphabetically by the officer title. There is no attempt to sort by the actual officer heirarchy because fortunately, "Leader" comes before "Officer" alphabetically. This produces the desired order, but it's a kludge.
  • I haven't fiddled around with XSLT enough to figure out if there's a way to subtract dates from one another so that I get something like "4 days ago" for the last log-in instead of a literal date.
  • IE doesn't render the final column of the table correctly for users without a title. The "empty-cells" property is set to "on" for the table. I don't know why it does this. Works fine in Mozilla.
  • The XMLGetGuildRoster function (or whatever it's called) doesn't cough up the user's ativity rating, so I can't include it in the roster. I'll have to see if the admin staff would be willing/able to change this.
  • The HTML created by the XSL transform uses some "style=" attributes and other non-HTML 4.01/XHTML compatible methods. I couldn't get <fo:.../> statements to work in the Guildportal environment, but frankly they don't strike me as being very XHTML-compatible either, even if it's the prefered method.
  • Most other problems are just cosmetic. One of our members decided to enter more than just a number for their season, so I can't shrink that column down to a small width without it looking really bizarre.


XML roster file
XSL transform file

TopBottom

Deleted User (New Admin) 4/8/2003 8:58 AM EST : RE: Working XSLT for EQ roster

Deleted User
Posts: 0

Good job on the roster and a fery "clean" looking site. I know how painful it was to pound away thru W3C documentation to get my roster working.

With the new release of Guild Dumps announced in todays EQ patch, I will be looking into an XML merge possibility too. Will keep you all up to speed in the XML help forum.
TopBottom

Deleted User (New Admin) 4/8/2003 9:16 AM EST : RE: Working XSLT for EQ roster

Deleted User
Posts: 0

Very nice! Every one of your advantanges is like a breakthrough or something .. I am definilty looking forward to combing through your xsl, Thank you for posting your work, it is definitly a leap forward in building a better mousetrap

Oh btw, your boximages are perfection.
TopBottom

Stathol (Guild Admin) 4/8/2003 10:41 AM EST : RE: Working XSLT for EQ roster
Stathol
Posts: 235
Fingers of Fury!

Hehe, thanks for the compliments. I've been acussed of being "overly rangerly" whatever that means


With the new release of Guild Dumps announced in todays EQ patch, I will be looking into an XML merge possibility too. Will keep you all up to speed in the XML help forum.


Yeah, I noticed that too. I've been dumping this stuff out into Excel by hand <rant>since a fat number of people in my guild won't get off their rears and register on guildportal.</rant> Just having it in a text file will be a big improvement, but I hope they finally put all this XML interface stuff to work like DaoC.

Oh, and I forgot to mention it earlier, feel free to use or modify the XSL file I linked since that was kind of the whole point of this post. I'm sure there are ways I could streamline it a little more, but it's a heck of a lot better than it was on the first pass.

By the way, when did marking up documents get to be like writing a compiler?

TopBottom

Deleted User (New Admin) 4/9/2003 12:52 PM EST : RE: Working XSLT for EQ roster

Deleted User
Posts: 0

Very Impressive work Stathol!! Good Job!! I look forward to reading through your xsl and working on our own roster.

And yes, the new Dump feature is gonna come in handy. It's a pain to keep track of members to make sure they are all signed up on our website. In helping with that, we've even gone to the point that people have to sign up on our website first before they get an invite in game and we've found that 9 out of 10 recruits don't mind doing that.

Anyway, again..good job on the xsl roster!!
TopBottom

Stathol (Guild Admin) 4/10/2003 4:42 AM EST : RE: Working XSLT for EQ roster
Stathol
Posts: 235
Fingers of Fury!

Ooh, I got a sticky thread.

I took a look at your roster, Hirnol. Color me impressed. I was just aiming for something simple and functional that had a decent sorting order for my first attempt. But, you've really done a good job coming up with a sensible layout for each user, especially dealing with alternates in a graceful manner.

I think I may adopt a similar layout, though a bit more tabularized...is that a word?...*shakes head*. Anyway, you've given me some ideas on how to put the underlying structure to good use. I like a "clean" look as you put it, but a plain table is pretty boring, really.

TopBottom

536985018_Inactive (New Admin) 9/17/2004 4:54 AM EST : RE: Working XSLT for EQ roster
536985018_Inactive
Posts: 329
Fingers of Fury!

I am unfamilliar with the XMLGetGuildRoster function you referenced above.  My assumption is you put a function name into the XML source URL field, and it loads the data from GP instead of from a remote site?  Is this accurate?  Where can I learn more about this?
TopBottom

*Greenwood* (New Admin) 9/18/2006 11:54 PM EST : RE: Working XSLT for EQ roster
*Greenwood*
Posts: 230
Fingers of Fury!

The new roster for XML noobs

Hi there, I am desperately trying to find a way to configure my GP Roster: at the moment the basic info that it shows bears very little relation to what our guild members actually want to know. For example, we can't add guild ranks, and since some of us have many alts the member list is very confusing.

I know a bit about HTML and I've tried to edit the Roster in this way, but I can never quite get it right. I don't really understand XML etc., but would love to try your new Roster as it sounds like a definite improvement.

So I was hoping you could list the baby steps I need to take to get this working on my GP site?

Huge thanks!

TopBottom

DagotharCoH (New Admin) 5/17/2007 3:39 PM EST : RE: Working XSLT for EQ roster
DagotharCoH
Posts: 437
Fingers of Fury!

*Greenwood* said:

The new roster for XML noobs

Hi there, I am desperately trying to find a way to configure my GP Roster: at the moment the basic info that it shows bears very little relation to what our guild members actually want to know. For example, we can't add guild ranks, and since some of us have many alts the member list is very confusing.
...
So I was hoping you could list the baby steps I need to take to get this working on my GP site?

Huge thanks!



Ditto here!
Unfortunately, it looks like not much's been done on this wonderful sticky since 2003.

Gonna try a GuildPortal support ticket.
TopBottom

Mottie (MVP) 3/13/2010 5:12 PM EST : RE: Working XSLT for EQ roster
GuildPortal MVP
Mottie
Posts: 3884
Zomgawsh Poster

Since this post is really really outdated, but still sticky, I've added a post on how to add both the EQ and EQ2 Roster to your site. But in order to do so, you will have to have a paid subscription site here on GuildPortal.

EQ Roster
EQ2 Roster
TopBottom

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