Hacking Rominator Database Update info

[Rascal]

Double post, but necessary because it is kind of different subject.

While I was looking at the box art situation, I noticed that I am missing some early box art. Does Rominator pull older game box art from a server or do I need to get caught up on box art? Mine are not sequential before 4180.

EDIT: Nevermind, just tested it out and it is pulling from a server for older box art. Now to see if I can make a script to clean up the non-standard size box art.

 

[Rascal]

Tonight I am going to clean up the numbering to ensure that it matches DS-Scene up to 5160. I will also pull down and resize all boxart from 5047-5160. After that, I want to work on having a team consisting of myself and 1 or 2 others that would like to contribute some time and effort to the manual updates.

Next steps:
1. I want to backfil any missing data, such as MetaCritic
2. I will see if Hank will release the source code to me so that we can get auto updates to work
3. I will see if I can setup a direct feed of DS-Scene data so to make our updates less manual

 

[Rascal]

Wow! That was a lot more work than I thought it would be.

I've corrected the ROM numbers to match DS-Scene for both the DS.ROD and the Box Art up to 5160.

DS.ROD (Latest):
http://filetrip.net/g51608-Rominator--ds-rod.html

Box Art (Latest):
http://filetrip.net/g25123100-Rominator-Boxart-update.html

The database is still needing updates for languages and other fields, but this cleanup took enough hours out of my day. I'll get to the rest in a couple of days. Enjoy!

 

[callmebob]

Thanks for the hard work! Hope you can keep it up. I think once all of that is fixed any new updates won´t be so much work anymore.

 

[Rascal]

Rominator updated to 5170

DS.ROD (Latest):
http://filetrip.net/g51608-Rominator--ds-rod.html

Box Art (Latest):
http://filetrip.net/g25123100-Rominator-Boxart-update.html

Notes:
1. I tried to enter MetaCritic info, but it looks like MetaCritic made a change to their site and without the source code for Rominator, I don't think I will be able to fix it.

2. Recent addition include full language data. Before I add more ROMs, I will be inputting language data for those ROMs that are blank.

 

[cseri]

Hi

Sorry for the mixup, but perhaps a teamwork will begin

I got the idea that we shoud export the database from excel to google docs. And we give rights to edit to those who wants to help. This way whoever have time can update the online doc. After this we can import to ds.rod and share weakly.

Any opinions Rascal? elbaC?

 

[Rascal]

I've found that importing and exporting is too much hassle. This last batch of 10 that I did were edited in SQLite and it was a breeze. With the releases slowing down, I could potentially handle doing weekly updates.

Let me ponder how we can do team work and I'll get back to you.

I would LOVE for it to be based on a central server that we could edit in SQL and allow auto-updating again, but Hank hasn't gotten back to me on source code or central server.

 

[cseri]

Yes, it is easier to continue the update now that we updated the database

 

[Rascal]

All language fields are cleaned up! If you include Region or Multiple Language as part of your rename fields, you may want to auto-rename your ROM collection.

DS Rod 5170 Rev 1 (All language fields filled and scrubbed)

DS.ROD (Latest):
http://filetrip.net/g51608-Rominator--ds-rod.html

Box Art (Latest):
http://filetrip.net/g25123100-Rominator-Boxart-update.html

 

[Rascal]

Corrected some names in Pokemon games and corrected numbering errors in 4831 - 4840 (Thanks for catching the bugs cseri). No changes to BoxArt

DS Rod 5170 Rev 2

DS.ROD (Latest):
http://filetrip.net/g51608-Rominator--ds-rod.html

Box Art (Latest):
http://filetrip.net/g25123100-Rominator-Boxart-update.html

 

[Rascal]

Sorry for the rapid updates, but I am intent on having this database be as good as it can be. elbaC found some ROM names with extra spaces on updates prior to mine. I have searched them all out and corrected them.

DS.ROD (Latest):
http://filetrip.net/g51608-Rominator--ds-rod.html

Box Art (Latest):
http://filetrip.net/g25123100-Rominator-Boxart-update.html

Corrected some trailing and leading spaces in some ROM names.
Mostly in the 5000's, some in the 3000's and 4000's.

Thanks to everyone that is finding the bugs. I commit to correct them as fast as possible.

 

[elbaC]

Blazing fast :-)

Thanks.

 

[Rascal]

I try

BTW people, don't be shy. You can post your problems here instead of PM'ing me. Most of the bugs people are reporting to me are "before my time" as an editor of the Rominator Data. And I'm not too proud to admit to the few bugs that I introduced into the data (and later had to clean up).

I just want to keep Rominator up to date for myself and others. Going forward, after the bugs are all squashed, I will be releasing updates either every week or after 10 additional releases are added. I don't want to commit to a certain day of the week, but based on my activity here in the last week, I hope that you can see that I am serious about keeping the data current.

Lastly, if anybody was given the source code from Hank, please let me know. I would love to make updates automatic again and fix the metacritic linkage.

 

[elbaC]

Hi Rascal,

Regarding my PM

about Rom 5072 it does indeed has 589E157C.
And that's the rom itself and the rod database.
Except the rod has a couple of spaces in front of the crc value.

When you remove those spaces it'll be reported as a clean dump.

 

[Rascal]

DS.ROD (Latest):
http://filetrip.net/g51608-Rominator--ds-rod.html

Box Art (Latest):
http://filetrip.net/g25123100-Rominator-Boxart-update.html

Hi Rascal,

Regarding my PM

about Rom 5072 it does indeed has 589E157C.
And that's the rom itself and the rod database.
Except the rod has a couple of spaces in front of the crc value.

When you remove those spaces it'll be reported as a clean dump.

 

[jaybird]

Replacement Box Art from 4823 to 5160
http://filetrip.net/f12568-Rominator-Boxar...-4823-5160.html

This seems to have messed up some of my boxart matching...

5128
5127
5126
5119
5118
5117
5106

I just have US releases, so some others may be affected as well.

 

[pka4916]

Good luck with the Metacritc stuff.. working on it for days now to get mine fixed for DSRO.
They changed everything on that site.. (all the spaced have a - now instaed of 1 word. and the HTML is changed.

I don't have the source from Rominator. he did not want to release it at that time.

 

[Rascal]

Replacement Box Art from 4823 to 5160
URL REMOVED

This seems to have messed up some of my boxart matching...

5128
5127
5126
5119
5118
5117
5106

I just have US releases, so some others may be affected as well.

I just checked each of the ROMs that you listed in Rominator's DS Game Catalog and they are OK. If you have the latest ROD and the latest Box Art, then the mismatch you are seeing is because you need to refresh your ROM lists in Rominator.

 

[elbaC]

Rascal, I still found some boxart that are the wrong size.

2271
4713 - 4726
4800
4824 - 4851
4966
4999 - 5000

They can easily be found by doing a detailed view of files in the boxart folder and then sort by size.

 

[elbaC]

Rascal,

I only added roms to the rod file (in the DS table) when I released the updates.

One of the things next to metacritic stuff I did not check or update were the other tables, like publisher and Release group.

I do not know if those are up to date, did you update them?