CSV errors & Legacy/Effect cards with no text

[BAgate]

Quiet Contemplation

[Aswan jaguar]

Hibernation Sliver
Mindlash Sliver
Screeching Sliver
Magma Sliver (already entered)
Psionic Sliver
Darkheart Sliver
Victual Sliver

Added legacy text for all entries containing 'All slivers have/gain'

Homura, Human Ascendant
Mercurial Pretender
Nafs Asp
Ring of Ma'ruf
Dimensional Breach
Victual Sliver
Floral Spuzzem
Bösium Strip

Done.

Cards that have wrongly title and text in effect card slots instead of legacy slots so the text doesn't show up:
Acidic Sliver
Hibernation Sliver
Spectral Sliver
Victual Sliver
Sedge Sliver
the same applies at least to the slivers listed above.

Phelddagrif - for flying and trample abilities.

[Aswan jaguar]

Quiet Contemplation has no effect title & text.

[Sonic]

Kalastria Highborn
Spiny Starfish
Figure of Destiny
Recoup
Shinka, the Bloodsoaked Keep
Three Wishes
Act on Impulse
Lifeline
Falkenrath Noble
Molting Snakeskin
Singing Bell Strike
Mnemonic Sliver
Volrath's Dungeon
Quiet Contemplation
Phelddagrif

Done.

Moved Sliver Effects entries to Legacy fields

[Aswan jaguar]

Howl of the Horde no text no title:
viewtopic.php?f=86&t=16935#p175587

edit 23/March:
Otherworldly Journey no title & text

[Korath]

Is this still the right place for general csv woes?

Whole bunches of cards are missing exclamation marks from their flavor text, as of current Manalink.csv. I first noticed these when comparing Shandalar cards1.dat and Portals to Theros cards.dat (which are what I had handy for dumping), but they turn out to be an error in the source data from Gatherer, and they're all still in the most-recently committed version. Anyone know a different source than Gatherer that we can pull from, if only for comparison's sake?

Differences between Shandalar cards1.dat and manalink.csv (all also in Gatherer, except where noted)

• Ali Baba: missing !
• Barktooth Warbeard: missing !
• Craw Giant: missing two !
• Dwarven Weaponsmith: missing two !
• Elven Riders: "Elven" misspelled as "Eleven" (only in Legends printing in Gatherer)
• Elvish Archers: missing !
• Emerald Dragonfly: "unknown" misspelled (not in Gatherer)
• Feldon's Cane: missing . (only in Antiquities printing in Gatherer)
• Flying Carpet: missing !
• Giant Strength: missing !
• Goblin Balloon Brigade: missing !
• Goblin Digging Team: missing !
• Goblin Hero: "attacked" misspelled, second "on" missing (only in The Dark printing in Gatherer)
• Holy Day: missing ! and "calm" misspelled (the latter only in Legends printing in Gatherer)
• Keepers of the Faith: extra - (only in Legends printing in Gatherer)
• Kobold Overlord: missing ! (mangled even worse in Gatherer, in different ways depending on which printing)
• Lifeblood: missing !
• Pearled Unicorn: missing !
• Pyrotechnics: missing four !
• Remove Soul: "fell" misreplaced with "felt" (only in Master's Edition III and Legends printings in Gatherer)
• Roc of Kher Ridges: "sprouted" misreplaced with "spread"
• Rust: missing !
• Segovian Leviathan: missing !
• Sir Shandlar of Eberyn: missing two !
• Syphon Soul: missing !
• Transmutation: missing !
• Urza's Power Plant: "required" misreplaced with "requires" (only Antiquities and Master's Edition IV printings in Gatherer)
• Visions: missing !
• Wall of Air: missing !
• Wall of Caltrops: missing three !
• Winter Blast: missing three !

Every single card in the Shandalar file with an exclamation mark in the flavor text has had it gone missing. I suspect that every card, up until fairly recent times, is similarly missing them in Gatherer. Thundersong Trumpeter from Ravnica is the most recent card I was able to find (Warren Instigator from Zendikar, for example, is ok). I stopped looking when I realized they were wrong in Gatherer, too, not just our csv, though.

The flavor texts that mirror only the earliest version of Gatherer are particularly perplexing, since we seem to use the latest printing's flavor text in most cases, so far as I can tell. How are they chosen? (If it's manual, consider this a vote for the Alpha/Arabian Nights/Legends/8th-edition text for Bog Wraith/Aladdin's Ring/Boomerang/Flying Carpet, respectively. Or at least, anything except the silly Wheeeeeee! on the 7th-edition Flying Carpet.)
edit: all fixed

[stassy]

Mardu Scout Dash effect (seems to be card specific because Alesha's Vanguard display a non empty Dash effect)
Flamerush Rider

[stassy]

Face down cards under the manifest effect
Arashin War Beast
Arbiter of the Ideal
Cloudform
Ethereal Ambush
Fierce Invocation
Formless Nurturing
Ghastly Conscription
Jeskai Infiltrator
Lightform
Mastery of the Unseen
Qarsi Deceiver
Qarsi High Priest
Rageform
Reality Shift
Soul Summons
Sultai Emissary
Temur War Shaman
Whisperwood Elemental
Wildcall
Write into Being

[stassy]

Wild Slash

[Sonic]

Is this still the right place for general csv woes?

Whole bunches of cards are missing exclamation marks from their flavor text, as of current Manalink.csv. I first noticed these when comparing Shandalar cards1.dat and Portals to Theros cards.dat (which are what I had handy for dumping), but they turn out to be an error in the source data from Gatherer, and they're all still in the most-recently committed version. Anyone know a different source than Gatherer that we can pull from, if only for comparison's sake?

Differences between Shandalar cards1.dat and manalink.csv (all also in Gatherer, except where noted)

• Ali Baba: missing !
• Barktooth Warbeard: missing !
• Craw Giant: missing two !
• Dwarven Weaponsmith: missing two !
• Elven Riders: "Elven" misspelled as "Eleven" (only in Legends printing in Gatherer)
• Elvish Archers: missing !
• Emerald Dragonfly: "unknown" misspelled (not in Gatherer)
• Feldon's Cane: missing . (only in Antiquities printing in Gatherer)
• Flying Carpet: missing !
• Giant Strength: missing !
• Goblin Balloon Brigade: missing !
• Goblin Digging Team: missing !
• Goblin Hero: "attacked" misspelled, second "on" missing (only in The Dark printing in Gatherer)
• Holy Day: missing ! and "calm" misspelled (the latter only in Legends printing in Gatherer)
• Keepers of the Faith: extra - (only in Legends printing in Gatherer)
• Kobold Overlord: missing ! (mangled even worse in Gatherer, in different ways depending on which printing)
• Lifeblood: missing !
• Pearled Unicorn: missing !
• Pyrotechnics: missing four !
• Remove Soul: "fell" misreplaced with "felt" (only in Master's Edition III and Legends printings in Gatherer)
• Roc of Kher Ridges: "sprouted" misreplaced with "spread"
• Rust: missing !
• Segovian Leviathan: missing !
• Sir Shandlar of Eberyn: missing two !
• Syphon Soul: missing !
• Transmutation: missing !
• Urza's Power Plant: "required" misreplaced with "requires" (only Antiquities and Master's Edition IV printings in Gatherer)
• Visions: missing !
• Wall of Air: missing !
• Wall of Caltrops: missing three !
• Winter Blast: missing three !

Every single card in the Shandalar file with an exclamation mark in the flavor text has had it gone missing. I suspect that every card, up until fairly recent times, is similarly missing them in Gatherer. Thundersong Trumpeter from Ravnica is the most recent card I was able to find (Warren Instigator from Zendikar, for example, is ok). I stopped looking when I realized they were wrong in Gatherer, too, not just our csv, though.

The flavor texts that mirror only the earliest version of Gatherer are particularly perplexing, since we seem to use the latest printing's flavor text in most cases, so far as I can tell. How are they chosen? (If it's manual, consider this a vote for the Alpha/Arabian Nights/Legends/8th-edition text for Bog Wraith/Aladdin's Ring/Boomerang/Flying Carpet, respectively. Or at least, anything except the silly Wheeeeeee! on the 7th-edition Flying Carpet.)

The issue dates back to the very first incarnation of the manalink3 csv, when Mok and I first imported the data from the Oracle/Gatherer in late 2011.
For example: I manually had to change all the dashes in the text, as the Oracle was using still using the minus symbol at the time. Even today I have to manually change the " quote symbol to “ and ” for every new expansion.
But at least it's better than the old days when we had to enter all the card data manually with all the endless text corrections we had to make to the csv subsequently.

When I get the time I'll make the corrections to the csv you've pointed out. But to be honest, I really haven't got time to check the flavor text of every new expansion when doing an update - these errors will have to be dealt with in this thread.

[Korath]

Some inconstencies between the ct_all.csv "Color xxx" columns (which should always be the card's color, as usually determined from the casting cost); manalink.csv "Color" column (weird hardcoded numbers from 0 to 8, mostly only used for card display in the deckbuilder); and manalink.csv "Mana Source Colors" (for mana generation).

I've omitted lands and most mana-producing artifacts; many places assume that the card color and mana source colors should be the same. It should be mostly harmless to change the artifacts, e.g. for Horn of Ramos to lose Color Green in ct_all.csv and gain Color Colorless; but changing the lands definitely will break.) The things I'm currently working on that choke on the cards below all have workarounds for lands and artifacts; and it's not currently worth the effort to fix the back end; so it's a fight for another day.

Abattoir Ghoul

• Proper colors: Black
• Color columns in ct_all.csv: Color Black, Color Colorless
• Color column in manalink.csv: 1 (Black)
• Mana Source Colors column in manalink.csv: irrelevant
• TO FIX: ct_all.csv: -Color Colorless

Advice from the Fae

• Proper colors: Blue
• Color columns in ct_all.csv: Color Blue, Color Colorless
• Color column in manalink.csv: 2 (Blue)
• Mana Source Colors column in manalink.csv: irrelevant
• TO FIX: ct_all.csv: -Color Colorless

Armed // Dangerous

• Proper colors: Red, Green
• Color columns in ct_all.csv: Color White, Color Red
• Color column in manalink.csv: 4 (Multicolored)
• Mana Source Colors column in manalink.csv: irrelevant
• TO FIX: ct_all.csv: -Color White; +Color Green

Ayesha Tanaka

• Proper colors: White, Blue
• Color columns in ct_all.csv: Color White, Color Blue, Color Black
• Color column in manalink.csv: 4 (Multicolored)
• Mana Source Colors column in manalink.csv: irrelevant
• TO FIX: ct_all.csv: -Color Black

Barkshell Blessing

• Proper colors: Green, White
• Color columns in ct_all.csv: Color Green
• Color column in manalink.csv: 4 (Multicolored)
• Mana Source Colors column in manalink.csv: irrelevant
• TO FIX: ct_all.csv: +Color White

Blanket of Night

• Proper colors: Black, producing Black
• Color columns in ct_all.csv: Color Black
• Color column in manalink.csv: 1 (Black)
• Mana Source Colors column in manalink.csv: 0 (None)
• TO FIX: manalink.csv: Mana Source Colors 2 (Black)

Boreal Druid

• Proper colors: Green, producing Colorless
• Color columns in ct_all.csv: Color Green, Color Colorless
• Color column in manalink.csv: 5 (Green)
• Mana Source Colors column in manalink.csv: 1 (Colorless)
• TO FIX: ct_all.csv: -Color Colorless

Fire // Ice

• Proper colors: Blue, Red
• Color columns in ct_all.csv: Color Red, Color Blue
• Color column in manalink.csv: 7 (Red)
• Mana Source Colors column in manalink.csv: irrelevant
• TO FIX: manalink.csv: Color 4 (Multicolored)

Grand Architect

• Proper colors: Blue, producing Artifact
• Color columns in ct_all.csv: Color Blue
• Color column in manalink.csv: 2 (Blue)
• Mana Source Colors column in manalink.csv: 1 (Colorless)
• TO FIX: manalink.csv: Mana Source Colors 64 (Artifact)

Increasing Devotion

• Proper colors: White
• Color columns in ct_all.csv: Color White, Color Colorless
• Color column in manalink.csv: 8 (White)
• Mana Source Colors column in manalink.csv: irrelevant
• TO FIX: ct_all.csv: -Color Colorless

Midnight Ritual

• Proper colors: Black
• Color columns in ct_all.csv: Color Black, Color Colorless
• Color column in manalink.csv: 1 (Black)
• Mana Source Colors column in manalink.csv: irrelevant
• TO FIX: ct_all.csv: -Color Colorless

Rite of Flame

• Proper colors: Red, producing Red
• Color columns in ct_all.csv: Color Red
• Color column in manalink.csv: 7 (Red)
• Mana Source Colors column in manalink.csv: 10 (Black and Green)
• TO FIX: manalink.csv: Mana Source Colors 16 (Red)

Shrine of Boundless Growth

• Proper colors: Colorless, producing Colorless
• Color columns in ct_all.csv: Color Green
• Color column in manalink.csv: 3 (Artifact)
• Mana Source Colors column in manalink.csv: 1 (Colorless)
• TO FIX: ct_all.csv: -Color Green; +Color Colorless

Valleymaker

• Proper colors: Red, Green, producing Green
• Color columns in ct_all.csv: Color Red, Color Green
• Color column in manalink.csv: 4 (Multicolored)
• Mana Source Colors column in manalink.csv: 6 (Black, Blue)
• TO FIX: manalink.csv: Mana Source Colors 8 (Green)

edit: all fixed

[Sonic]

The flavor texts that mirror only the earliest version of Gatherer are particularly perplexing, since we seem to use the latest printing's flavor text in most cases, so far as I can tell. How are they chosen? (If it's manual, consider this a vote for the Alpha/Arabian Nights/Legends/8th-edition text for Bog Wraith/Aladdin's Ring/Boomerang/Flying Carpet, respectively. Or at least, anything except the silly Wheeeeeee! on the 7th-edition Flying Carpet.)

Sorry, missed this.
I can't actually remember how the flavor text was sorted when it was originally imported from the Oracle. Although, I do remember M12 was the most current release at the time.
Since then, however, any new cards imported will have the flavor text of the expansion/core set they were first included in.

[stassy]

Temporal Trespass

[Aswan jaguar]

Warden of the First Tree.though it should be invisible.
Kolaghan, the Storm's Fury.

edit: Laccolith Grunt

[BAgate]

Ashen Powder