eCC-Datfile for Commodore C64

[Vicman]

Hi all,
in addition to the imagepacks for several Platforms, I'm working on a eCC-Datfile for the Commodore C64
I use the Dumps from the brand new Gamebase GB64v7.
It contains about 20.000 Games.

Allready added :
- The right Game-Names (All Games, first Disk/Tape)
- The Year (btw. it would be nice, if we could also use a Questionmark : 198? , 19??, and 4 x "????" )
- The Languages (Country flag, all Games exept some, we don't have in eCC)
- EDIT :all publisher added
- Gamebase ID-Number for each Game
- EDIT :all Programers added
- EDIT :all Genres added
- EDIT :all Musican added

to do :
- Developer....etc..

Actually Datfile = Attachment

Look at Platform Hunting-Section , for the c64-dumps

[Vicman]

Update :

all Publisher added (based on the GB64v7.mdb)
Look at the Attachment on the First post !

[Vicman]

Update :
All (new) Genres added
Datfile = First Post

[Vicman]

Update :
all Programers added (based on the GB64v7.mdb)
Look first post.

@Phoenix :
It's time to add Publisher, Programer, Graphics, Musican, Medium, Languages, running etc. to the eCC-ListView

[Gruby]

Thanks for your HARD work Vicman!

[Phoenix]

@Phoenix :
It's time to add Publisher, Programer, Graphics, Musican, Medium, Languages, running etc. to the eCC-ListView

Hi Vicman,

Thanks for your work, and i'll see what i can do

[Vicman]

Last Update : (for the next Time)
Musicans also added to the Metainfo. (look first Post)

Now, I'm back on the Dosbox-Imagepack & Datfile....(UG-DosCollection)
When i've finished Dosbox and my other open projects, i'll maybe start the C64-Imagepack.

@Phoenix :
Can you add this Datfile to the RomDB ? - I don't want to upload 20100 Dumps via eCC
(or is this still Andreas' job ? )

[Phoenix]

@Phoenix :
Can you add this Datfile to the RomDB ? - I don't want to upload 20100 Dumps via eCC
(or is this still Andreas' job ? )

Hi Vicman,

Sadly....i also cannot reach the eccDB , this is Andreas his job....whenever he comes back... is it possible to do this through ECC anyway?

[Vicman]

this is Andreas his job....whenever he comes back...

Die Hoffnung stirbt zuletzt.....

sorry phoenix, this is impossible.......
'cause i've edited the meta-infos with excel, eCC didn't noticed, that there are any metas to upload to the romdb
any idea ?

[DerMicha75]

Go directly into the database and set the field cdate :-) This is the date ecc thinks you edited the metas. And if this is set, the data is exported...

Micha

[Vicman]

Hi Micha,
which programm should i use, to edit the file "database" (117 MB)
Or do you mean the c64-datfile....
and where to set this "cdate" ?....can you show me a screenshot, what you mean ?

[Vicman]

HEY MICHA !!! WAKE UP

[DerMicha75]

Huch...

here for all of you editing metas withe excel the solution. But be careful and backup your database file!!!

- download sqlitexplorer and extract it to any place (I have mine in ECC folder), (zip will unpack 2 files )
- start sqliteexplorer.exe
- click on "file - open database" and go to the "ecc-system/database" folder
- switch to "all files" and open the "eccdb" file
- type in the upright field

Code: Select all

 update mdata set cdate = 1 where eccident = 'c64' 

You can replace the eccident with any you want :-)
- Press the "execute" button in toolbar
- Ready, now Ecc will upload the meta and clear the field cdate. If you manually save in ECC this field is filled with the actual date and time (large number value), but setting 1 (which the sql script above does) also works.

Micha

[Vicman]

Hi Micha,
it seems, i've made something wrong
When uploading the edited database i get errors...
Is this the correct field for typing the command ?

[Vicman]

maybe this is correct ?

EDIT :
hmm...also Errors when uploadling to romdb.....(also dosbox-metas)
are there again any problems with the romdb...or are my settings wrong....or both (romdb problems & settings wrong) ?
i think, it's me.... :-"

[DerMicha75]

Hmmmmmm. seems to be correct. If I just do ist... it works.

ZIP the DB and let me see how big it is. Or just export as eccdatfile, send it to me and I try it...

Micha

[Vicman]

Here's the eccdb (zipped 24 MB - unzipped 121 MB) [not edited]
http://rapidshare.com/files/359915628/eccdb.zip

And the complete eCC-Datfile : (all platforms)
http://rapidshare.com/files/359919406/e ... eccDat.zip

As Attachment: c64-eccdatfile

btw.
with "correct", you mean the picture in my last post ? - So this one ?

[DerMicha75]

Noooooooooooooooo! the field above these table (upper right). like in first screen.

You can try for instance: "select cdate from mdata where crc32='ABAB3456'" (where you should add an valid crc32. In the lower table you see the result.

Or simply "select * from mdata where eccident='c64'" and you will see all metas.

Micha, just DL the db and trying....

[DerMicha75]

I found it!

The problem is the category. You can not add to romDB entries with the new categories. So Andreas has to fix it :-(

The other thing is that ECC eliminates the questionmarks in year field when manually edit the entries. So this has to be fixed by phoenix, but this seems not be a problem for uploading.

Micha

[Vicman]

Thanks for support, Micha.
so, waiting for Andreas' comeback....
or.....
We should make a new ROMDB