Wrong CRC after editing Datfile with MS-Excel !!!

Discuss here anything related to ECC, emulators, ect!
User avatar
Vicman
PLATINUM member
Posts: 1233
Joined: 17 Jun 2007, 16:12
Location: Germany,Bochum

Wrong CRC after editing Datfile with MS-Excel !!!

Unread post by Vicman » 19 Mar 2009, 21:31

Hi ECC, Phoenix & CO,

After editing my Vic20-Datfiles with MS-Excel, I've suddenly "missing roms"......
Because the CRC is sometimes wrong, when opening the Datfile in MS-Excel :angry:

I've some Examples :
In case "Apple Panic" the CRC was changed from 00598779 to 598779

and "Astroiders" from crc 324295E8 to 3,24E+13 :nea:

the same for "Assam 2.0" : CRC was changed from 05729671 in 5729671

"Buck Rogers" from 498432E1 to 4,98E+06

please test it yourself with my Datfile, and tell me whats wrong ! (Maybe i make something wrong , by using Excel)
Attachments
ECC-Dats.zip
Datfiles ecc.dat & *.csv
(130.28 KiB) Downloaded 70 times
wrong crc.jpg
wrong crc2.jpg
imagepacks:
Done: Vic20, N64, Philips VG-5000 G7000 G7400, SordM5, Amstrad GX4000, Enterprise 64/128
Progress: Atari 8bit, Dosbox, Exelvision EXL 100
Vicman's eCC-Clips on You Tube

User avatar
Phoenix
ECC Developer 2006-2016
Posts: 9057
Joined: 27 Aug 2006, 01:17
Location: Deventer, The Netherlands
Contact:

Re: Wrong CRC after editing Datfile with MS-Excel !!!

Unread post by Phoenix » 19 Mar 2009, 22:33

Hi Vicman,

I am sorry, but i use MS Office 2007, wich loads csv files like this:
ecc_csv_dat_with_office2007.png
So i cannot help you with this...
Sebastiaan Ebeltjes | ECC Developer 2006-2016 | ECC Forum Admin | Phoenix Interactive WebMaster
[- ECC programs -]
eccUpdate, eccScriptSystem, GtkThemeSelect, DatFileUpdater (DFU), ImagePackCenter (IPC), eccDiagnostics, 3dGallery, iccImageInject
eccKameleonCode, eccCreateStartmenuShotcut, eccThirdPartyConfig (TPC), EmuMoviesDownloader (EMD), eccVideoPlayer
MobyGamesImporter (MGI), ECC Amiga GetGemusConfig.

lordashram
ECC Support
Posts: 188
Joined: 26 Jan 2008, 20:48

Re: Wrong CRC after editing Datfile with MS-Excel !!!

Unread post by lordashram » 20 Mar 2009, 13:30

That's becaue Excell is doing it's job, what I always end up doing is change the column's number format from 'General' to 'Text'.
So if you are importing the eccdat into Excell as a csv, then make sure that before you finish the import wizard to have it specify the column's as 'Text'.

User avatar
Vicman
PLATINUM member
Posts: 1233
Joined: 17 Jun 2007, 16:12
Location: Germany,Bochum

Re: Wrong CRC after editing Datfile with MS-Excel !!!

Unread post by Vicman » 20 Mar 2009, 17:33

Hi lordashram,

I've tried it...but it seems not working :?

Don't know, if I have changed it right.....
"Daten" - "Text in Spalten..." - "Textkonvertierungsassistent" :
Schritt 1 von 3 = I've choosed "Getrennt"
Schritt 2 von 3 = i've choosed "semicolon" and "Texterkennungszeichen" = "kein"
Schritt 3 von 3 = "Datenformat der Spalten" = "Text"

Did you mean this ?....if not, please show me , where i have to make the Changes.... :oops:
Attachments
format-text.jpg
imagepacks:
Done: Vic20, N64, Philips VG-5000 G7000 G7400, SordM5, Amstrad GX4000, Enterprise 64/128
Progress: Atari 8bit, Dosbox, Exelvision EXL 100
Vicman's eCC-Clips on You Tube

User avatar
DerMicha75
ECC2 (java) Developer
Posts: 521
Joined: 05 Feb 2007, 22:14
Location: Germany
Contact:

Re: Wrong CRC after editing Datfile with MS-Excel !!!

Unread post by DerMicha75 » 20 Mar 2009, 18:29

Excel is not the right tool for this! It simply does not work.

If a crc only contains numbers the data gets wrong.... no solution for this. Try OpenOffice, but don't know if this helps.

But... what would you like to do with excel? Maybe there is another solution....

Micha

User avatar
Vicman
PLATINUM member
Posts: 1233
Joined: 17 Jun 2007, 16:12
Location: Germany,Bochum

Re: Wrong CRC after editing Datfile with MS-Excel !!!

Unread post by Vicman » 20 Mar 2009, 21:11

DerMicha75 wrote:Try OpenOffice, but don't know if this helps.
:no: OpenOffice give me also wrong crc's
But... what would you like to do with excel? Maybe there is another solution....
Of course, for editing the Meta-Datas...... :lmfao:

For example the "Rom-Feature-Metas" : ,User-Mod,Multiplayer,Freeware,Intro,Errors...etc....
This way, I can add User-Mod = NO for all roms, without ticking one by one.....same for Freeware.....
Or for some Infos, I used in "Info-ID-Field"

btw.
Andreas has said it's possible to use Excel for editing the Metas :oops:
http://ecc.phoenixinteractive.nl/viewto ... =20&t=1735
imagepacks:
Done: Vic20, N64, Philips VG-5000 G7000 G7400, SordM5, Amstrad GX4000, Enterprise 64/128
Progress: Atari 8bit, Dosbox, Exelvision EXL 100
Vicman's eCC-Clips on You Tube

User avatar
DerMicha75
ECC2 (java) Developer
Posts: 521
Joined: 05 Feb 2007, 22:14
Location: Germany
Contact:

Re: Wrong CRC after editing Datfile with MS-Excel !!!

Unread post by DerMicha75 » 20 Mar 2009, 21:46

So I tested it.... it works if you choose the format while importing (have excel2007).

Micha
Attachments
1.jpg
2.jpg
3.jpg

User avatar
Vicman
PLATINUM member
Posts: 1233
Joined: 17 Jun 2007, 16:12
Location: Germany,Bochum

Re: Wrong CRC after editing Datfile with MS-Excel !!!

Unread post by Vicman » 20 Mar 2009, 22:34

Thank you, Micha !
I'll test it tomorrow ;)
imagepacks:
Done: Vic20, N64, Philips VG-5000 G7000 G7400, SordM5, Amstrad GX4000, Enterprise 64/128
Progress: Atari 8bit, Dosbox, Exelvision EXL 100
Vicman's eCC-Clips on You Tube

User avatar
Phoenix
ECC Developer 2006-2016
Posts: 9057
Joined: 27 Aug 2006, 01:17
Location: Deventer, The Netherlands
Contact:

Re: Wrong CRC after editing Datfile with MS-Excel !!!

Unread post by Phoenix » 20 Mar 2009, 23:07

Nice work Micha, where can i find the import function in Excel 2007??
Sebastiaan Ebeltjes | ECC Developer 2006-2016 | ECC Forum Admin | Phoenix Interactive WebMaster
[- ECC programs -]
eccUpdate, eccScriptSystem, GtkThemeSelect, DatFileUpdater (DFU), ImagePackCenter (IPC), eccDiagnostics, 3dGallery, iccImageInject
eccKameleonCode, eccCreateStartmenuShotcut, eccThirdPartyConfig (TPC), EmuMoviesDownloader (EMD), eccVideoPlayer
MobyGamesImporter (MGI), ECC Amiga GetGemusConfig.

User avatar
DerMicha75
ECC2 (java) Developer
Posts: 521
Joined: 05 Feb 2007, 22:14
Location: Germany
Contact:

Re: Wrong CRC after editing Datfile with MS-Excel !!!

Unread post by DerMicha75 » 21 Mar 2009, 13:11

Simply when you open the file via "round bubble on top left" and "Open"... and the file extension is not xlsx or xls...

Micha

User avatar
Phoenix
ECC Developer 2006-2016
Posts: 9057
Joined: 27 Aug 2006, 01:17
Location: Deventer, The Netherlands
Contact:

Re: Wrong CRC after editing Datfile with MS-Excel !!!

Unread post by Phoenix » 21 Mar 2009, 13:35

Hi Micha,

It doesn't work for me, excel doesn't show any CSV files for opening, only when i select 'all files' it shows all files (including the CSV) :?, and when opened it like my screen above....,maybe it's my settings somewhere, i have to google this...
Attachments
excel01.png
excel02.png
Sebastiaan Ebeltjes | ECC Developer 2006-2016 | ECC Forum Admin | Phoenix Interactive WebMaster
[- ECC programs -]
eccUpdate, eccScriptSystem, GtkThemeSelect, DatFileUpdater (DFU), ImagePackCenter (IPC), eccDiagnostics, 3dGallery, iccImageInject
eccKameleonCode, eccCreateStartmenuShotcut, eccThirdPartyConfig (TPC), EmuMoviesDownloader (EMD), eccVideoPlayer
MobyGamesImporter (MGI), ECC Amiga GetGemusConfig.

lordashram
ECC Support
Posts: 188
Joined: 26 Jan 2008, 20:48

Re: Wrong CRC after editing Datfile with MS-Excel !!!

Unread post by lordashram » 21 Mar 2009, 14:11

Lol, it does work I've done this plenty of times, let me quote myself:
make sure that before you finish the import wizard to have it specify the column's as 'Text'.
This is what I do:
1) Open up the eccdat in your favorite text editor (notepad2, notepad+,....)
2) Remove all data from [ECC] to [ECC_MEDIA] so that the first line starts with eccident;name;extension;crc32;.....
3) Save as a csv file
4) Open up Excel
5) (2003): Data, Import External Data, Import Data
5) (2007): Data, From Text
6) During the Import Wizard:
Delimited [next], Semicolon [next], change crc32 column from 'General' to 'Text' [Finish]

There ya go, hope this helps.

User avatar
Vicman
PLATINUM member
Posts: 1233
Joined: 17 Jun 2007, 16:12
Location: Germany,Bochum

Re: Wrong CRC after editing Datfile with MS-Excel !!!

Unread post by Vicman » 21 Mar 2009, 19:31

the "first-save-eccDat to csv, and load this in Excel" don't work for me (always wrong crc's) :toobad:


But for me, it works this way : (I have MS-Excel 2002 :oops: )
1. open .eccDat in Editor
2. delete the "header"
3. select all & copie
4. open excel
5. paste the copied text in Excell
6. make the options in the "Textkonvertierungsassistent"

the crc's are correct, now :yes:

7. edit your datfile
8. save it as *.csv
9. open *.csv in Text-Editor - copie and paste back the "header"
10. save it as *.eccDat

Works fine :yes_head:
imagepacks:
Done: Vic20, N64, Philips VG-5000 G7000 G7400, SordM5, Amstrad GX4000, Enterprise 64/128
Progress: Atari 8bit, Dosbox, Exelvision EXL 100
Vicman's eCC-Clips on You Tube

Locked

Who is online

Users browsing this forum: No registered users and 1 guest