News for July 2010

Grand Theft Auto: Chinatown Wars

First release for R* on the Nintendo DS. Worked long and hard, but it was worth the wait. The game is finally here! [Grand Theft Auto: Chinatown Wars Box Art] Here is the latest trailer: I plan to upload a picture of my name in the credits soon!

Posted: July 22nd, 2010
Categories: 9-5
Tags: , ,
Comments: No Comments.

Convert MS Excel to valid XML markup

Hey everyone. I just wanted to share some knowledge that I learned in the past few days that I think may help many others in their quest for a quick simple solution for exporting a Microsoft Excel document to XML.

I was tasked with creating an HTML page that had to display a Microsoft excel document with some 4,500 entries. My boss also wanted it to be XML for quick and easy changes/updates/etc.. There was no way I was going to sit down, and hand code some 12,500 lines of code and spell check it by Friday.

So I figured out how to export the Excel document into XML. and boy did it save me time. I scoured the internet for hours and found little documentation on this, and Microsoft Help was not that explicit in their explanation.

******************This is for Microsoft Excel 2003******************

So Here is my mini tutorial:

  1. Create an XML schema to be used as a map inside Microsoft Excel
    Ex:

    • –Must Use Multiple instances of the Tags if you want
    • –Excel to create multiple Tags ( is created twice for Repetition)

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-------------------------------------------------------------------- --Must Use Multiple instances of the Tags if you want --Excel to create multiple Tags ( is created twice for Repetition) --------------------------------------------------------------------!-->
<CATALOG> <USER> <ID></ID> <COUNTRY></COUNTRY> </USER> <USER> <ID></ID> <COUNTRY></COUNTRY> </USER> </CATALOG>

Once you have your map saved, and named logically such as “myexceldocumentname”_map.xml you are ready to open up Excel.

Once inside Excel open up your spreadsheet that you want converted to XML for use to display in HTML.

  1. Click Data/XML/XML Source from the menu
  2. The XML Source window should open. Click XML Maps on the bottom
  3. Navigate to the .xml file we created and saved earlier
  4. Click OK OK OK to get out of the prompt and back to your document.
  5. Inside the XML source window you will now see a schema/tree diagram of the .xml document we created earlier.
  6. Click and drag the corresponding tags to the correct column/row that has the info associated with it.
  7. Click Data/XML/Export
  8. You should now have an .xml document with the correct values inside of the tags that corresponds with your Microsoft excel document.

I later had to Style the .xml with .xsl to display in a web browser, but .xsl is a beast in and of itself.

Cheers!

Posted: July 8th, 2010
Categories: tutorial
Tags:
Comments: No Comments.

Publish .swf directly to server

A colleague of mine today showed me a neat little trick you can do when working on a flash file. He showed me how you can directly publish a swf to a server. Pretty neat eh? Here’s how it’s done.

  1. Open your ftp client and navigate to the remote view (server side).
  2. Right click on the .swf in question and click view edit.
  3. A browser window will open up that has a temp address in it.
  4. Copy the temp address
  5. Open up your flash document and go to publish settings
  6. Paste the temp address as the location for your .swf
  7. Publish your .fla

Hope you find this mini tutorial useful!

Posted: July 7th, 2010
Categories: tutorial
Tags: ,
Comments: No Comments.

Latest

My latest work includes updating rockstargames.com/IV for Flash detection. I enabled the site to use not only a browser Mobile Detection, but as well as browser detection. What that means is when a user goes to rockstargames.com/IV and their browsers either does not have flash installed, or enabled, the mobile detection kicks in and re-directs the user to the mobile site. Tutorial to come.

Posted: July 1st, 2010
Categories: 9-5
Tags:
Comments: No Comments.