rules text of cards in ct_all.csv possible?

[Aswan jaguar]

It would be of great assistance if we had the rules text of cards in ct_all.csv as reference as well. This is very convenient when searching, testing, making comparisons and many other tasks. Sonic provided me with such a csv with each patch but unfortunately he is not around and while I have tried to follow his instructions to be able to make such the file myself I can't handle it. This is not the best way of course as I would need help with each update (unfortunately very long time since that happened - new update ) while if the rules text is inserted in the official ct_all.csv which gets released there would be no need for such a task with every update.

[foolosopher]

Can you post the instructions? I will try to help.

[Aswan jaguar]

Thanks for the offer to help. Unfortunately I don't have the directions possibly I deleted his post with them by accident.
I am attaching the last CT_ALLRULES.xls I have to see how it is. It has manalink in the first file and rules text in the other file which is what I want. The first 3 columns are the ones imported from manalink but with the ct_all numbering: Full Name (Manalink), Type Text (Manalink), Rules Text (Manalink). Then begin the ct_all columns.
Edit: The file is too big I will upload it to mediafire.
http://www.mediafire.com/file/2ahm4do4v ... s.rar/file

[foolosopher]

Can you upload the manalink and ct_all files that you want to combine?

[Aswan jaguar]

These are the ones:
http://www.mediafire.com/file/jz36gup9p ... ll+dev.rar

[foolosopher]

OK took a better look and below is what I found.
manalink.csv: 17523 rows, JZ columns, which is 32 more columns/expansions after "Duel Decks: Speed vs. Cunning" and different ordering of cards than ct_allrules.xls[Manalink]

ct_allrules.xls:
[Manalink]: 14511 rows, IT columns, at row 14206 the rules engine cards start,
these columns each have a number in the last row: CODED CARD equal to sum, Num Pics equal to sum+1, dunno why but in the manalink.csv the sums are wrong.
[Card Types]: 12000 rows, DI columns

indentation is different in some cells, although I think this does not affect anything.

I copied the same number of rows(14206)/ columns (IT) from manalink.csv to ct_allrules.xls[Manalink] and seems to work.
Also in ct_allrules.xls[[Manalink] at line 14206 start rules engine and card types until the end of the file.
vice versa in ct_allrules.xls[Card Types] until line 278 special cards are put and after that the rest cards in alphabetical order, if I noticed correctly.

So we can try to reverse engineer a bit, but it would be best if someone finds/remembers how this file is properly made.

[Aswan jaguar]

I made again an effort on this but tokens and other cards (some of them real cards - which seem to give error about 10000+) give errors with this function that mostly works(it is the function that worked for previous files made by Sonic).
Above is the function for "Angel" the first entry to give an error:
"=VLOOKUP($F404;Manalink!$B$2:$AJ$15000;1;FALSE)" which used to work for "Angel" in Sonic files but now gives an error. Any idea why this is happening?
I forgot to mention that also the functions for types column and for rules text column doesn't work for the same entries like "Angel" one.

[Korath]

You're just looking to get a copy of ct_all.csv with the corresponding "Rules text" column from Manalink.csv stuck onto the end?