sorting by decade? looking for how to

[vartech]

I am running on a 2 P 733 with 256mb windows xp pro using mamewah and commandline mame machines. I am running hortz on one and vert on another. I would like to have only games from the eighties on both is there a way to sort the games?

[Tiger-Heli]

You can do it with EmuLoader.  And you could do it with EmuLoader, delete the Roms you don't want (within EmuLoader) and the refresh MAMEwah (I think) to have only 80's games.

www.mameworld.net/emuloader/

[screaming]

Using a properly configured listgen, you can use this SQL to create a batch file to move all MAME ROMs newer than 1989 to another directory (change the 2 paths appropriately).  Then re-generate your default list in MAMEWAH.

-----------------------
SELECT 'move c:\mame\roms\' || romname || '.zip c:\mame\oldroms\'
  FROM gamedata
 WHERE year >= '1990'
  ;
-----------------------

-sab

[Craig]

vartech,

Give me your mame version and I will make a batch file for you that will copy all 80's games to a temp folder then you can move them to your machine.

I did a similar thing for my box. I wanted all games up to 1992.

[jcrouse]

-----------------------
SELECT 'move c:\mame\roms\' || romname || '.zip c:\mame\oldroms\'

[vartech]

Using a properly configured listgen, you can use this SQL to create a batch file to move all MAME ROMs newer than 1989 to another directory (change the 2 paths appropriately).

[jcrouse]

listgen is an application that you need to download and install. It uses SQL commands to create gamelist/sort roms. I have never used it. I'm sure someone will jump in. Then again, you could do a SEARCH on "listgen" and probably find everything you need.

 
John

[Buddabing]

listgen is an application that you need to download and install. It uses SQL commands to create gamelist/sort roms. I have never used it. I'm sure someone will jump in. Then again, you could do a SEARCH on "listgen" and probably find everything you need.

 
John

Download ListGen

I developed ListGen to create game lists. The SQL engine within ListGen is capable of much more, as you can see in this example.

Look in the ListGen threads for examples and how to configure.

BTW, screaming's SQL is correct.

Regards,
Buddabing

[vartech]

vartech,

Give me your mame version and I will make a batch file for you that will copy all 80's games to a temp folder then you can move them to your machine.

I did a similar thing for my box. I wanted all games up to 1992.

Thank You

I am using mame95b.  Can you also include instuctions on how to use. make it easy I can use the the one you did for games up to 1992.  Once again thank you

[Craig]

Sorry buddy.

I was using a program called InfoMAME along with another called Sortinfo, then I would output that to a comma seperated file and then run two Perl scripts to add the commands to copy the files.

It seems that the 0.95 version doesn't work with InfoMAME unfortuneatly. Sorry about that. The best I can do is try an ealier version, but there may be some games that have name changes since or maybe not. I'd have to see MAWS http://www.mameworld.net/maws/for game changes. I know 0.92 works with InfoMAME.

[vartech]

Sorry buddy.

I was using a program called InfoMAME along with another called Sortinfo, then I would output that to a comma seperated file and then run two Perl scripts to add the commands to copy the files.

It seems that the 0.95 version doesn't work with InfoMAME unfortuneatly. Sorry about that. The best I can do is try an ealier version, but there may be some games that have name changes since or maybe not. I'd have to see MAWS http://www.mameworld.net/maws/for game changes. I know 0.92 works with InfoMAME.

what if I get mame .92 then sort then go back to mame 95?

[screaming]

how about:

WHERE year < '1990'

Looks a little better but you also nee something like "and year > '1979'". Yours would produce all game form 1990 to date. I'm sure you knew this and it was just a typo.

John

  Actually, John, I was creating a batch file to remove all games newer than 1989.  If my query were as you suggested:

-----------------------
SELECT 'move c:\mame\roms\' || romname || '.zip c:\mame\oldroms\'
  FROM gamedata
 WHERE year < '1990'
  ;
-----------------------

  That would give me a batch file that would remove all ROMs older than 1990 out of the ROMs folder (not what he's looking for). 

  But you're (kind of) right, adding a line like 'AND year < '1980' would be more appropriate to leave me with ROMs only from the 80s, as the original poster asked for.  I guess I assume he just didn't want "newer" ROMs.  My apologies.

 So, here's the SQL you really want:

Code: [Select]

SELECT 'move c:\mame\roms\' || romname || '.zip c:\mame\oldroms\'
  FROM gamedata
 WHERE year >= '1990'
    AND year < '1980'
  ;

-sab

[SirPoonga]

What engine is that SQL statement for?  That's not standard SQL, is it?

I've started using the free Sql Server Desktop from microsoft, nice stuff.

[screaming]

hot to familiar with this. can you give step by step inst? is this something that is run from the command promt?

   It's actually quite easy and you don't need the command prompt.  I wrote out some step-by-step instructions in this thread, but I'll re-itterate them here for the sake of exposure.

1) Download and extract the latest version of listgen.
2) Edit the listgen.ini and change the rompath and mamepath to match your setup.
3) Make sure skip_final_step is set to 1.
4) Save and close listgen.ini
5) Copy filter.sql to filter.sql.backup
6) Edit filter.sql and delete everything in there.
7) Add SQL statements in filter.sql to taste.  It's pretty easy to take an existing SQL statement and change it to output whatever you want.

For example,

Code: [Select]

--   /-Y means "prompt before overwrite"
--   will output a textfile with a bunch of lines
--   like
--   move /-Y c:\mame\roms\11beat.zip c:\mame\oldroms\
--   
--   rename xxx.txt to moveroms.bat, then run moveroms.bat from the commandline
SELECT 'move /-Y c:\mame\roms\' || romname || '.zip c:\mame\oldroms\'
  FROM gamedata
WHERE year >= '1990'
    AND year < '1980'
  ;

8 ) Rename xxx.txt to moveroms.bat
9) type moveroms.bat

Just take it slow and easy and you'll be alright Post here if you have any trouble and we'll walk you through this terrible command-line thing

-sab

[screaming]

What engine is that SQL statement for?  That's not standard SQL, is it?

I've started using the free Sql Server Desktop from microsoft, nice stuff.

   aaaaaaaaaaaaaaaaaahahahahahahahahahahahah

-sab

edit:   ahem.  Sorry, I just found that incredibly funny for some reason. *giggle*

edit2:   Okay, I'm over it.   Yes it's "standard" SQL, which is to say, it's follows SQL92 spec (that's what listgen supports).  SQL92 is the essentially the litmus that everyone uses when implementing an SQL engine. MS SQL Server (just like every other vendor) supports a subset of SQL92, but they added their own spice to it (again, just like everyone else).
 
  That exact SQL command should work in any SQL engine, including MS's.

[Buddabing]

What engine is that SQL statement for?

[JoyMonkey]

Vartech:

Here's a batch file you can use.
Just copy the attached file to your roms folder and rename it 80s-roms.bat (it needs to have the .bat extension)

Double-click on it and it will create a folder called c:\80s-roms and then it will copy every pre 1990 rom into the new folder.

This is based on Mame 0.95 listinfo. I used SortInfo, Excel and a text editor (CrimsonEditor).

[vartech]

Vartech:

Here's a batch file you can use.
Just copy the attached file to your roms folder and rename it 80s-roms.bat (it needs to have the .bat extension)

Double-click on it and it will create a folder called c:\80s-roms and then it will copy every pre 1990 rom into the new folder.

This is based on Mame 0.95 listinfo. I used SortInfo, Excel and a text editor (CrimsonEditor).

Thank you I will try it when I get home.  Would it be too much to ask for a how to so I can learn how to do it myself?  I am very greatfull for everyones help.  but I believe in learning and asking.


Remember give a man a fish feed him for a day.  Teach him how to fish and feed him for life.

[screaming]

Hello wall, how are you today?

[Tiger-Heli]

Remember give a man a fish feed him for a day.  Teach him how to fish and feed him for life.

There's always "Build a man a fire, keep him warm for a night.  Set a man on fire, keep him warm for the rest of the night."

Sorry, been reading to much of Drew's stuff in the Everything Else board!

[SirPoonga]

What engine is that SQL statement for?

[vartech]

listinfo.xml
-Generate your listinfo.xml from mame using the command line: mame -listxml > listinfo.xml


SortInfo ~ The MAME ListInfo Sorting Tool Version 1.1 is a useful tool when planning the control panel layout, rom selection etc. Freeware by EmuMannen


MS EXCEL


Crimson Editor is a professional source code editor for Windows.
This program is not only fast in loading time, but also small in size (so small that it can be copied in one floppy disk).

While it can serve as a good replacement for Notepad, it also offers many powerful features for programming languages such as HTML, C/C++, Perl and Java.


Well I have all the software needed to do this now I need the how.

[SirPoonga]

What engine is that SQL statement for?

[JoyMonkey]

Well I have all the software needed to do this now I need the how.

This is an old and round-about method of doing this, but anyhow...
1. In Windows open the Command Prompt.
2. Go to your Mame folder
3. Generate your listinfo.xml by typing mame -listxml > listinfo.xml
4. Convert the xml to the old listinfo format by typing xml2info < listinfo.xml > listinfo.dat
5. Run SortInfo and go File>Import>Mame Listinfo File, import the listinfo.dat file you just generated.
6. Give it a minute and it will show you all the info from the listinfo file.
7. Go File>Expot>Comma Seperated Value File and save it somewhere
8. Open the CSV file in Excel and sort it to whatever games you want.
9. Once you've got a list of the games you want, select all the rom names and copy them into a text editor (I like to use CrimsonEditor).
10. Edit it to look like the text file I attached to the above post and save it as a BAT file.