Nier weapon data in XML (and LINQ sample query)

  • October 16, 2011
  • James Skemp
Going through the game Nier yet again, I wanted an easier way to track what weapon levels I had already upgraded to, and what items I still needed to unlock weapon items. Phase one towards that goal is creating an XML file with weapon upgrade information which is available online: Nier weapon data. An XML schema document for this information is also available: Nier weapon XSD. Sample LINQ query The following query can be run from LINQPAD, and will either display all items with their counts, or a grouped listing of items with the total quantity needed.

Read More

Interesting feature with parsing XML with jQuery on Safari

  • March 27, 2011
  • James Skemp
I've been playing around with HTML5 quite a bit recently, in particular with offline Web applications. My second experiment (my first is on pause) was with making my video games available, so that I can access the listing when I'm out shopping at used game stores. It's still in progress, but you can see my offline listing of video games now. My main intention is to make this available on my iPod Touch, so I was a bit dismayed when I found that the listing didn't display the title of the game.

Read More

Storing watched movies and Netflix shipping/receiving in XML format

  • March 6, 2011
  • James Skemp
Ever since I started my Netflix subscription in September 2006 I've been keeping track of what movies I receive and when. Unfortunately, as the years have gone by I've found it more and more difficult to easily look through the listings to see when I last watched a movie. Additionally, I've no longer been keeping track of what ratings I give movies, and why. The initial goal was really to track when Netflix shipped and received movies, as well as when I mailed and received.

Read More

Extended iTunes Track class for PHP

  • September 26, 2010
  • James Skemp
In a previous article, I had outlined classes in C# and PHP to handle iTunes Playlists to Xml outputs. Having let it sit on the back burner for long enough, I finally went back to the PHP class and finalized the constructor. I also added two functions for sorting. Below I have the current code for the class (a current version of the Track class for PHP will always be available elsewhere) and then an example implementation.

Read More

The benefits of using a file for Log Parser SQL queries

  • September 26, 2010
  • James Skemp
One of the things I always forget about when I'm using Microsoft Log Parser is that you can define your SQL query in a file and run it, instead of putting it in the command line. For example, the following will run whatever SQL is defined in strivinglife.robots.sql. logparser -i:w3c -o:xml file:strivinglife.robots.sql Where this comes in handy is for something like the Log Parser query I defined today, that parses IIS logs for requests to the robots.

Read More

Shadow Hearts: Covenant leveling information

  • September 6, 2010
  • James Skemp
As I continue to look through my old files I found leveling information for Shadow Hearts: Covenant, from December 2005 to January (1st) 2006. I've converted it from an ODS file to XML, and am making it available. Shadow Hearts: Covenant leveling guide. Since I have a leveling guide for Shadow Hearts: From the New World (previously written about), it almost makes sense to go back and play the original Shadow Hearts to get information for that game as well.

Read More

Importing a custom namespace / custom type into an XSD

  • September 5, 2010
  • James Skemp
I have a custom type that I use in a couple of my documents. Unfortunately, in the past I was adding this to each xsd, as I needed it. However, I've now figured out how to import it into xsd files as needed. Original schema Currently I'm adding the following at the top of each xsd: <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:simpleType name="customDateType"> <xs:restriction base="xs:string"> <xs:annotation> <xs:documentation><![CDATA[Allows for a year, a year and a month, or a year, month, and day, to be defined.

Read More

Onimusha: Dawn of Dreams data

  • September 3, 2010
  • James Skemp
From the archives, I've created an XML Schema and XML data file for Onimusha: Dawn of Dreams, for the Playstation 2. Currently the data only includes armor leveling information, from level 1 to 100. The data comes from an OpenDocument Spreadsheet (OnimushaDawnofDreams.ods) from way back in May of 2006. My characters and core weapons being completely maxed (not to mention souls), I may decide to replay the game to track this information as well, or just upgrade weapons.

Read More

XML standards - personal suggestions

  • September 3, 2010
  • James Skemp
As I prepare to create another XML data file, I started looking at the standards I use to create XML files, and what the recommendations are. Elements In the past I've used camel case, but on a recent file used Pascal case instead. I think this was more becauase I've started to using Pascal case for public items (variables), and camel case for private items, as that's fairly standard in development.

Read More

ASP.NET charts example: Odin Sphere: Part 3 - Creating the chart

  • August 15, 2010
  • James Skemp
In part one of this series we covered what we'd be doing, and what data model we'd be using. In part two of this series we used LINQ to XML to query the XML file with the data we want to display. This time we'll be doing the heavy lifting of actually creating the chart and displaying it to the user. For ease, I'll be implementing very basic caching. Preliminary requirement Before you can use the charting functionality you need to have a reference to System.

Read More

ASP.NET charts example: Odin Sphere: Part 2 - Parsing the XML

  • August 14, 2010
  • James Skemp
In part one of this series we covered what we'd be doing, and what model we'd be using for the data. This time we'll parse the XML file that contains the data we need, and populate the objects. Loading the XML file The XML file we'll be loading is located at http://jamesrskemp.com/files/OdinSphere.xml, and to keep it simple, we'll load it in assuming we're on a different server/domain. First we'll need to add the following so we can make use of XDocument.

Read More

ASP.NET charts example: Odin Sphere: Part 1 - Introduction and model

  • August 13, 2010
  • James Skemp
For a while now I've been meaning to work with ASP.NET 4's built-in charting functionality. While I was going to use it alongside my gas tracking, I think I'm instead going to use my Odin Sphere leveling guide, so I don't have to create an XSLT for the output. In this part of the series I'll outline the data model I'll be using, and preliminary setups. Method So that this can easily be deployed anywhere, I'm going to opt not to use the control itself, but rather programmatically create the charts/graphs.

Read More

Vehicle gas DTD .NET objects and XML parsing with LINQ

  • June 10, 2010
  • James Skemp
The code contained below is a rough draft, and will eventually be moved into an assembly, and the code posted. At some point in 2007 I started keeping track of my gas mileage in an XML file, with a custom DTD for validation (and intellisense in oXygen). I present below the code necessary to create an rough object from the XML, and the LINQ to parse it out. C# objects public class Vehicle { public int Id { get; set; } public String Make { get; set; } public String Model { get; set; } public int Year { get; set; } public IEnumerable Fillups { get; set; } }

Read More

iTunes Playlists to Xml - version 1.6 released

  • May 8, 2010
  • James Skemp
Version 1.6 of iTunes Playlists to Xml is now available for download. Download iTunes Playlists to Xml 1.6. Installing and more information If you're new to iTunes Playlists to Xml, I've created a 'product page' for iTunes Playlists to Xml with all the information needed to get started. Upgrading To upgrade from any version of 1.4 or 1.5 you need to replace the following files with those in the above archive:

Read More

iTunes Playlists to Xml - version 1.5.3 released

  • January 10, 2010
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Version 1.5.3 of iTunes Playlists to Xml is now available for download. Download iTunes Playlists to Xml 1.5.3. Installing and more information If you’re new to iTunes Playlists to Xml, I’ve created a ‘product page’ for iTunes Playlists to Xml with all the information needed to get started. Upgrading To upgrade from any version of 1.

Read More

Determine BlogEngine.NET comments that haven't been published - with LINQPad

  • December 31, 2009
  • James Skemp
At the beginning of the month I wrote a post on how to find BlogEngine.NET comments that had not yet been published/approved. Having purchased a copy of LINQPad a short while ago (autocompletion costs, the program with all other functionality does not; give it a try if you develop in .NET - it's very cool), and having got slammed this morning with some spammer who had an hour to kill, I decided to adapt my code for LINQPad.

Read More

XML Schema Definition creation: Journal - Part 3: XSLT sample

  • December 27, 2009
  • James Skemp
Having created an overview of how I wanted to craft a simple journal in XML, I next created an XML Schema Definition for the simple journal to validate against. Having now crafted a Web application to create the XML files I'm able to move onto the prettier aspects of display for the XML files. I've created a sample simple journal that uses an XSLT (XSL Transforms, or extensible stylesheet language transformations) to make the display a little prettier.

Read More

XML Schema Definition creation: Journal - Part 2: XSD file with <oXygen/> XML Editor

  • December 23, 2009
  • James Skemp
In the first part of this series I had outlined a sample layout that I wanted to use for a series of XML files that I would be creating over the course of 2010. This time I'm going to create the actual XML Schema Definition file with <oXygen/> XML Editor, version 11.1. I've been using <oXygen/> since January 2008, and wouldn't trade it for any other XML editor. If you don't have <oXygen/> you can still follow along.

Read More

XML Schema Definition creation: Journal - Part 1: Primary layout

  • December 21, 2009
  • James Skemp
In a previous series, I went over the process of creating a new XML document to store my video games. (Although in that case I used a DTD.) This time I’m going to work on a schema to store quasi-journal entries, which I’m hoping will help with my goal to write every day. What I hope to accomplish Ultimately I want to store a bit of text for any particular day.

Read More

Determine BlogEngine.NET comments that haven't been published

  • December 6, 2009
  • James Skemp
Unfortunately, BlogEngine.NET doesn't currently have a very good way to determine, at a glance, all of the comments that haven't been approved. While this will certainly be coming in a future release, or as an extension, I figured writing something simple to do this would be a good LINQ to XML test for me. You can download the built executable, or play with the code, which is included below. Download the executable (7-Zip format).

Read More

iTunes Playlists to Xml - version 1.5.1 released

  • November 14, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Version 1.5.2.1 is available for download, which fixes an issue with version 1.5.2. Thanks to Pierre for bringing this to my attention. Version 1.5.2 is available for download, which adds the -output argument. Version 1.5.1 of iTunes Playlists to Xml is now available for download. Download iTunes Playlists to Xml 1.5.1.

Read More

iTunes Playlists to Xml - version 1.5 released

  • November 13, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Version 1.5 of iTunes Playlists to Xml is now available for download. Download iTunes Playlists to Xml 1.5. Installing and more information If you’re new to iTunes Playlists to Xml, I’ve created a ‘product page’ for iTunes Playlists to Xml with all the information needed to get started. Upgrading To upgrade from any version of 1.

Read More

iTunes Playlists to Xml - version 1.4.1 released

  • October 30, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Version 1.4.1 of iTunes Playlists to Xml is now available for download. Download iTunes Playlists to Xml 1.4.1. Installing and more information If you’re new to iTunes Playlists to Xml, I’ve created a ‘product page’ for iTunes Playlists to Xml with all the information needed to get started. Upgrading To upgrade from version 1.

Read More

Project page for iTunes Playlists to Xml now created

  • September 7, 2009
  • James Skemp
For releases of iTunes Playlists to Xml I've just been creating new posts with details, but that doesn't make all that much sense. So, I've created an actual project/product page for the application. View the project page for iTunes Playlists to Xml. Comments appreciated.

Read More

iTunes Playlists to Xml - version 1.4 released

  • July 22, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Version 1.4 of iTunes Playlists to Xml is now available for download. Download iTunes Playlists to Xml 1.4. What it does While iTunes has an Xml export option, it will export only those tracks from your computer, doesn’t allow you to choose what data to export (unless you play with the view), uses a bulky Xml format, and won’t export from other sources (like iPods).

Read More

iTunes Playlists to Xml - version 1.3 released

  • July 4, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Version 1.3 of iTunes Playlists to Xml is now available for download. Download iTunes Playlists to Xml 1.3. What it does While iTunes has an Xml export option, it will export only those tracks from your computer, doesn’t allow you to choose what data to export (unless you play with the view), uses a bulky Xml format, and won’t export from other sources (like iPods).

Read More

Muenchian Method grouping in XSLT

  • July 1, 2009
  • James Skemp
I owe a deal of thanks for figuring out the Muenchian Method of grouping in XSLT (1.0) to Jeni's article Grouping Using the Muenchian Method. It took, however, a while for me to get my mind around the method completely, and some experimentation, which I'm sharing below. Specifically I was looking to get a listing of tracks, from my iTunes Playlists to Xml application's output, and group them by album.

Read More

iTunes Playlists to Xml - version 1.2 released

  • June 13, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Version 1.2 of iTunes Playlists to Xml is now ready for download. Download iTunes Playlists to Xml version 1.2. This update should correct issues when the playlists are changed, as well as when the source is ejected. Instead of immediately connecting to iTunes, the application now allows (and requires) that you manually begin that process.

Read More

iTunes Playlists to Xml - version 1.1 released

  • May 15, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Update: Version 1.1.1 is available for download, which corrects the progress bar bug, noted in the comments below. To upgrade, simply replace your executable with the one in the above zip file. Version 1.1 of iTunes Playlists to Xml has been released. Download iTunes Playlists to Xml version 1.1. This update now appends the saved xml file with the current date and time, for ease.

Read More

jQuery: Query an Xml document and output data

  • May 3, 2009
  • James Skemp
I back-dated my first piece of jQuery code, but have decided not to with my second. Anyways, I had a hard time finding code, written in jQuery, to pull data from an Xml file and add it to a page. Combining a couple of tutorials online, I created the following (on April 27). This was for a message, so I started out with the Xml file, creating something like this:

Read More

iTunes Playlists to Xml - version 1.0 released

  • March 29, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Version 1.0 of iTunes Playlists to Xml has been released. Download iTunes Playlists to Xml version 1.0. Unlike the previous versions, this includes an installer (setup.exe in the zip file). Comments/suggestions welcome. New program icon will, naturally, be accepted; I know mine isn’t very good, but …

Read More

iTunes Playlists to Xml - version 0.6b released

  • March 5, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. iTunes Playlists to Xml, version 0.6b, is now available for download. Download iTunes Playlists to Xml - version 0.6b. This version now handles the bug where playlists could be out of date, by alerting the user. This version also includes functionality to save the Xml file, as well as configure the name the application will use when generating the Xml file.

Read More

iTunes Playlists to Xml - version 0.4b released

  • March 2, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Having just released version 0.3b of iTunes Playlists to Xml, I’ve got yet another release. This release includes menus, the ability to select what data you want in the Xml, and a schema for validation. Unfortunately, I’ve discovered one bug (that would have existed before) with playlists getting updated in iTunes, between the refresh in this application, and the time it was clicked on.

Read More

iTunes Playlists to Xml - version 0.3b released

  • February 27, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Having just released version 0.2b of iTunes Playlists to Xml, I’ve done some updates, bringing it up to version 0.3b. This release fixes all of the known issues, from version 0.2b. There are no known issues with version 0.3b. Download iTunes Playlists to Xml - version 0.3b. iTunes Playlists to Xml requires .NET Framework 2.

Read More

iTunes Playlists to Xml - version 0.2b released

  • February 26, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Previously I discussed an iTunes application that I was working on, in C#. That application has been fixed up a bit, and is now available for download. Download iTunes Playlists to Xml - version 0.2b. To run the application extract the contents of the zip to a directory. Then open iTunesApplication.exe. If iTunes is not running, it will start before this application does.

Read More

XML-based CD library: Draft layout

  • January 9, 2009
  • James Skemp
Following close on the heels of my XML-based book library draft (and release), below is a draft layout for keeping track of my CDs. Here's what I currently track: Artist CD Name Date bought Place bought Bought price Number of songs Time (which I don't fill in very often) Misc info/notes Following the iTunes standard, each CD has a main artist.

Read More

XML-based book library: Draft layout

  • January 3, 2009
  • James Skemp
01/03/2009 @ 10:39 CT: The current version of the XML Schema I came up with is available for public use at http://media.jamesrskemp.com/xsd/MyBooks.xsd Currently I have a SQL database (converted from an Access database) of all of the books that I own, as well as when I read them, how much I paid, etcetera. Since I'm moving a good deal of information into XML, I figured I'd attempt to move this into XML as well.

Read More

Shadow Hearts: From the New World leveling information

  • December 27, 2008
  • James Skemp
A leveling 'guide' for Shadow Hearts: From the New World is now available; Shadow Hearts: From the New World leveling. Not only should it have been written up and posted a while ago, it gave me a good chance to use XSD (XML Schema Definition). I tried creating one for my tracking my vehicles' gas usage, but failed. Having worked through the issues on this one, I think I now know what I did wrong.

Read More

Domain name XML

  • June 15, 2008
  • James Skemp
In XML creation: Part 1, I went about creating an XML document, with both a CSS and XSLT, that was used to store my video game information. Yesterday I was going through my domains, and realized that it would be pretty helpful to have an XML document where I could store domain name information, since I've got too many to keep track of in my head. The layout Using lists, this the version 1 that I came up with yesterday:

Read More

Making oXygen XML Editor (9.1) portable

  • January 21, 2008
  • James Skemp
The below information is correct for version 9.1. Comments on other versions are appreciated. With flash drives becoming more and relevant, it's always good to find programs that can be run on these powerful drives. <oXygen/> XML Editor is one such program. Making <oXygen/> portable On the official site, there's a post regarding making <oXygen/> portable. However, what does it really involve? Easily enough, it doesn't involve much more than is stated in the post.

Read More

XML Schema article coming soon

  • January 9, 2008
  • James Skemp
The other day, after a deal of research, I decided to pick up a copy of <oXygen/>, which is "a complete cross platform XML editor providing the tools for XML authoring, XML conversion, XML Schema, DTD, Relax NG and Schematron development, XPath, XSLT, XQuery debugging, SOAP and WSDL testing." This provided to be the key to finally understanding XML Schema, or at least getting a working Schema for an XML file.

Read More

XML creation: Part 8

  • January 1, 2008
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part eight I'll be expanding upon our XSLT to group games based upon the system they belong to, as well as modify our XSLT to use xsl:appy-templates. This time ... I won't be going into a recap of what I've done in all seven of the previous parts.

Read More

XML creation: Part 7

  • December 31, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part seven I'll be expanding upon our XSLT to remove elements that are empty, and change the sort order, for our existing XML file. Last time ... Up until now we've decided what we want to store, and how we want to store it, in an XML file.

Read More

XML creation: Part 6

  • December 30, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part six I'll be using XSLT to modify the display of the XML document's contents so that it looks like the CSS-based output. Last time ... Up until now we've decided what we want to store, and how we want to store it, in an XML file.

Read More

XML creation: Part 5

  • December 29, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part five I'll be using CSS to modify the display of the contents of the XML document. Last time ... Up until now we've decided what we want to store, and how we want to store it, in an XML file.

Read More

XML creation: Part 4

  • December 28, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part four, I'll be adding a DTD so our XML document validates. Last time ... Up until now we've decided what we want to store, and how we want to store it, in an XML file.

Read More

XML creation: Part 3

  • December 27, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part three, I'll be adding the actual data that we'll start with. Last time ... In part one, I went over what kind of data would be stored in our XML document.

Read More

XML creation: Part 2

  • December 26, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part two, I'll be creating the layout, that I think will work. Last time ... If you recall, in part one, I went over the idea of what the XML file would store, and what layout I thought it might need.

Read More

XML creation: Part 1

  • December 25, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part one, I'll be going over the idea and a layout that I think will work. The idea The XML file that I want to create should be able to store all of my Playstation games.

Read More

2007 VW Rabbit - 10,000 miles

  • December 13, 2007
  • James Skemp
A while ago, I posted a link to an XML file that contained my vehicle's gas information. Since my vehicle recently turned over its 10,000 mile, I figured it was time to post the link again. View my vehicle's gas information.

Read More

Where have all the XML validators gone?

  • August 7, 2007
  • James Skemp
It seems the XML Validation service is down/unavailable/what-have-you, and many of the other XML validators just don't seem to work. However, Validome has a pretty good service. You have to make sure you grab the right language, but, other than that ... I've got my XML file - http://jamesrskemp.net/vehicle_gas.xml - validating with a DTD, but my attempts at getting a schema to work failed pretty hard .

Read More