Build Your Own Arcade Controls Forum

Main => Software Forum => Topic started by: SirPoonga on May 27, 2005, 11:54:33 am

Title: Any of you dev has a listxml to access 2000 utility right now?
Post by: SirPoonga on May 27, 2005, 11:54:33 am
I could write one but I want to see if someone else has and will let me use it.
Title: Re: Any of you dev has a listxml to access 2000 utility right now?
Post by: SirPoonga on May 27, 2005, 02:55:53 pm
bah, I think I will just write my own vb app with domdocument to grab the info I need from listxml.  If I had office 2003 this would be alot esier to do....

controls.dat will be updated as soon as I finish writing this :)
Title: Re: Any of you dev has a listxml to access 2000 utility right now?
Post by: screaming on May 27, 2005, 05:38:34 pm
Uhm, ListGen and ListGen.NET can export any data you want in anything-you-want-including-tabs-or-commas-delimited format, which should import nicely into any database.

-Steve
Title: Re: Any of you dev has a listxml to access 2000 utility right now?
Post by: SirPoonga on May 29, 2005, 09:40:34 pm
Hmmmm.  now I have to learn to use it.  Says I needc to select a platform and none are listed :(  I need to find docs :)
Title: Re: Any of you dev has a listxml to access 2000 utility right now?
Post by: Silver on May 29, 2005, 09:59:21 pm
Yes give listgen a try - should be fine if its a one off transfer you want....

If you end up writing a VB app, I would avoid the Domdocument approach if you are using the mame xml info (ie very big). Its extremely slow. Use a Sax parser to pull the info you want into an array or something (assuming you know what you want from the XML file first of course).
Title: Re: Any of you dev has a listxml to access 2000 utility right now?
Post by: SirPoonga on May 29, 2005, 10:27:42 pm
I need these fields tab delimited
romname                  
description               
category              
romof          
cloneof          
tilt         
cocktail

where tilt and cocktail are 0 for no and 1 for yes.  All this info is in listxml.
Title: Re: Any of you dev has a listxml to access 2000 utility right now?
Post by: SirPoonga on May 31, 2005, 02:11:25 pm
I decided to write my own, unless the makers of listgen want to talk to me about what I am trying to do.  DOM isn't that bad.  Expecially since all I need is selectSingleNode with the right XPath.  I made a quick parser over lunch that grabs the needed info from listxml.  Take less than a minute to run.

I don't think I use category anymore.  I think it is in the database from when I didn't want mahjong games in it.  I will have to verify.  Otherwise the rest of those fields come directly from listxml.
Title: Re: Any of you dev has a listxml to access 2000 utility right now?
Post by: screaming on May 31, 2005, 02:21:23 pm
I need these fields tab delimited
romname            
description            
category            
romof        
cloneof        
tilt        
cocktail

where tilt and cocktail are 0 for no and 1 for yes. All this info is in listxml.

  ListGen and ListGen.NET (the released one anyway) do not parse the dipswitch settings, so they don't know anything about cocktail mode or tilt unless it's defined elsewhere (gamelist, catver, etc).

  Getting an output in tab delimited of any of those fields is elementary to both applications though.

-Steve
Title: Re: Any of you dev has a listxml to access 2000 utility right now?
Post by: SirPoonga on May 31, 2005, 02:34:42 pm
Well then, I will just have to make my own thing.  I need the tilt attribute form the input element and the cocktail dipvalue.