Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Specialt1212]

Is it possible to convert a dat file to a cvs file with tables using clrmamepro i.e.

Rom Name | Size | CRC32 | MD5 | SHA1

[Roman]

Since a dat is a xml file you can use a xslt template to perfom whatever you want to....even exporting to a textfile.

CMPro does not offer this.

[Specialt1212]

Thank you for the quick reply. I'm not familiar with xslt do you know of any tutorials I could reference to help me accomplish converting dat files to tables?

[Roman]

Sorry...no, not at the moment.
May I ask what the purpose is? It's pretty uncommon to have it as csv (especially without any set reference).
To load it into a database? Common DBs usually allow storing clobs and oracle etc allow xml queries...

[Specialt1212]

It's nothing fancy and im probably over complicating work for myself but my thought is to import data from dat files into a spreadsheet to keep track of the following

1. Which roms i have in my set
2. Which roms im excluding from my set

I try to only have 1 rom per game but cant just select US or Europe roms since some were released exclusively in only one region so I was going through each set and selecting which roms to keep.

The problem occurs when a new dat file is released, how do I know what new games were added. Depending on the system, the miss list would be very large due to me only keeping one rom per game so it would be hard to identify what new games were added.

So my plan was to export the data to a table in a spreadsheet use a compare function to look at the crc32 values and indicate any new games that aren't already listed in the previous dat file.

[Roman]

cmpro got a rename wizard which compares 2 dats (profiler->rename wizard)....not used it in years...but it may help you a bit

[Specialt1212]

That actually works perfect, thank you!