The "2000 limit no more" CSV

[gmzombie]

here is the only problem i see with this current csv production, if you just take the manalink.xls and try and convert it to manalink.csv you get a comma delimited file, BUT it is not the comma delimited file like the original manalink.csv. every letter or name or whatnot has its own column and that is simply not the same one as the current manalink.csv. also i know it was just talked about but what about that extra column for the set expansion so we could use that in the deck builder and game for sorting of cards. This is just what i found while doing some testing.

@Sonic i dont think you have been wasting your time as this current xls file cannot be changed to the correct comma delimited file unless im missing something?

[Mok]

I only hope "set" order doesn't mean that current magic numbers will just become new magic numbers in the code That's why I proposed cids to be autogenerated from the final csv and not set in stone.

And quite a lot of entries is duplicated: Angelic Arbiter, Armored Pegasus, Awakener Druid, Befoul, Citizen, Cloud Elemental, Dread Reaper, Elf Warrior, Gallantry, Gold Myr, Graven Cairns, Hollow Dogs, Infest, Izzet Chronarch, Kithkin Soldier, Mana Cylix, Maniacal Rage, Manic Vandal, Mistmeadow Skulk, Moon Sprite, Owl Familiar, Palace Guard, Phosphorescent Feast, Polymorph, Prized Unicorn, Prosperity, Python, Reverberate, Saproling, Siege-Gang Commander, Smash, Solemn Offering, Sowing Salt, Spirit, Spurnmage Advocate, Steadfastness, Stitch Together, Sylvan Basilisk, Tetravite, Time Reversal, Timid Drake, Trumpet Blast, Utopia Tree, Vendetta, Venomous Breath, Voja, Whiptail Wurm, Worldslayer, Zombie Goliath, Armadillo Cloak... and a lot more... not sure if that's intended??

[Gargaroz]

@ Sonic : No time wasted for you, but you need to adjust your file following the Master List I created. If you do that, we'll only need to add that new columns for "rarity" and then I assume we've the final CSV in our hands, right ? If you haven't time to modify the order you set, just post your CSV file and the others will do the work

@ Mok : As soon as I have that enum, I'll begin the long work of fixing magic numbers in the C code.

[Mok]

@ Sonic : No time wasted for you, but you need to adjust your file following the Master List I created.

The master list is full of duplicates like I stated above... what about these?

[0rion79]

Hem.... "waste" is a bad word!
"My" CSV lists all cards following Gàrgaroz's requested order but has data only for the ones marked in green.
If you did further progresses and the order is the same, then you can merge the job done until now and then let the others help you completing it! Just preserve the very 2 first columns since they may be of aid in traking cards by their first-print set.

[Aswan jaguar]

As Mok already said in Gargaroz's master list-Orion excell there are duplicates and triplicates because of card reprints,so 3 different slots for Gold Myr it should be like that in the csv,or 1 slot with all 3 sets mentioned?

Now it is


1213 /Gold Myr /Manalink2.0
6492 /Gold Myr /Mirrodin
10747 /Gold /Myr Scars of Mirrodin

or it should be
1213 Gold Myr / (Manalink2.0),Mirrodin,Scars of Mirrodin

or smt else?

[0rion79]

Gargaroz, I've created the list accordingly with your order: if it is so important, maybe the best choice is to keep the line where each card with a duplicate appears first and can delete the extra strings.
But the hardest part is to identify which card has duplicates: without a program that will do the job,checking all 12,000+ values is an impossible job!

[Aswan jaguar]

I found most of the missing tokens we have so far(29)and put them down, no text or values though.(sorry I saw that later).

[Gargaroz]

I thought I had removed all the duplicates, but it seems it wasn't enough. Since I did it all "by hand", you'll surely forgive me.
As Orion said, doing it manually is an hell of work, however Mok please report the others you found, I've already removed the ones you posted.

[Mok]

Here, but I'm not sure I found all of them, so I'll recheck again when you post a fixed version.

[Sonic]

@Mok - Would it be possible for you to adapt the MakeNewCsv.exe to handle more than 9999 entries?

I'm still in the process of creating my card resource file - essentially it consists of each cards basic info (taken from the gathering oracle), converted into the manalink.csv format.
I have a blank manalink.csv template which to paste the corrected card list into and was hoping to use the MakeNewCsv.exe to inject the entries from the resource.csv file into the template.

Problem being - nearly 12,000 cards and the MakeNewCsv.exe will only output a manalink.csv if it has less than 10000 entries.

[0rion79]

@ Aswan Jaguar, why is your file so big? 9 mb!!! I'm having troubles at downloading it.

[Mok]

@Mok - Would it be possible for you to adapt the MakeNewCsv.exe to handle more than 9999 entries?

Sure, here you go... I didn't expect that tool to be used on anything other than old files This version should be able to find a couple more duplicates too.

BTW: Some things like rarity can probably be added to csv automatically without long and boring manual work. I'll download current gatherer and see if it's doable.

[foolosopher]

Heres the duplicates from Orion-aswan xls
heres how I did it in case you want to check if it's correct
http://www.cpearson.com/excel/duplicates.aspx

check topic: Highlighting Duplicate Entries

[Sonic]

@Mok - Would it be possible for you to adapt the MakeNewCsv.exe to handle more than 9999 entries?

Sure, here you go... I didn't expect that tool to be used on anything other than old files This version should be able to find a couple more duplicates too.

BTW: Some things like rarity can probably be added to csv automatically without long and boring manual work. I'll download current gatherer and see if it's doable.

I've done most of it now - Full Name,Name,Color,Card Type,Rarity,Req Colorless,Req Black,Req Blue,Req Green,Req Red,Req White,Power,Toughness,Subtype,Subtype 2,Type Text,Rules Text,Flavor Text.

Some entries needed to be done manually, but were fairly easy when sorted in ascending/descending values.

Thanks for the tool.