Greetings! I've been using your excellent software for a long time now (I think I started somewhere in version 2?) and it's great!
Some items I've found:
Missing cards:
SF-PGPX_2018a Plains GPX
2021 Judge Gift Program cards are all missing:
SF-PJ21_1 Morophon, the Boundless JGP
SF-PJ21_2 K'rrik, Son of Yawgmoth JGP
SF-PJ21_3 Edgar Markov JGP
SF-PJ21_4 Ezuri, Claw of Progress JGP
SF-PJ21_5 The Gitrog Monster JGP
SF-PJ21_6 Grand Arbiter Augustin IV JGP
SF-PJ21_7 Karlov of the Ghost Council JGP
SF-PJ21_8 Mizzix of the Izmagnus JGP
SF-PJ21_9a Nicol Bolas, the Ravager JGP
SF-PJ21_9b Nicol Bolas, the Arisen JGP
SF-PJ21_10 Zacama, Primal Calamity JGP
Jumpstart: Historic Horizons (Scryfall set code J21) has been mixed into Judge Gift Program (set code JGP).
These all have Gatherer IDs, but are coming up with only their Scryfall IDs:
538393 Arlinn, the Pack's Hope MID 279a
538394 Arlinn, the Moon's Fury MID 279b
538495 Jerren, Corrupted Bishop MID 316a
538496 Ormendahl, the Corrupter MID 316b
538497 Dennick, Pious Apprentice MID 317a
538498 Dennick, Pious Apparition MID 317b
538501 Ludevic, Necrogenius MID 320a
538502 Olag, Ludevic's Hubris MID 320b
538679 Enduring Angel MID 327a
538680 Angelic Enforcer MID 327b
538689 Malevolent Hermit MID 336a
538690 Benevolent Geist MID 336b
538693 Poppet Stitcher MID 339a
538694 Poppet Factory MID 339b
538700 Curse of Leeches MID 345a
538701 Leeching Lurker MID 345b
538714 Smoldering Egg MID 358a
538715 Ashmouth Dragon MID 358b
538736 Hostile Hostel MID 379a
538737 Creeping Inn MID 379b
The "Ampersand" promos from AFR have an "a" in the Scryfall ID tag and their #.
Example:
SF-PAFR_261a Treasure Vault RLS Artifact Land R 261a
vs
SF-PAFR_261 Treasure Vault RLS Artifact Land R 261
For some reason, the 15th Anniversary cards are not showing up. They are set P15A on Scryfall.
When I tried to download them, they said they completed, set is green, I got no errors, but the cards were not added to the database.
After successfully saving those downloaded sets to CSV, when attempting to reload that database, same error received as when trying to Export:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.InvalidCastException: Operator '=' is not defined for type 'DBNull' and type 'Boolean'.
at Microsoft.VisualBasic.CompilerServices.Operators.ConditionalCompareObjectEqual(Object Left, Object Right, Boolean TextCompare)
at Gatherer_Extractor.FenetrePrincipale.Perform_Test_Fully_Handled_Sets()
at Gatherer_Extractor.FenetrePrincipale.BGW_OpenBDD_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)
Error with Release Promo Brisela, Voice of Nightmares:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.ArgumentException: Argument 'Start' must be greater than zero.
at Microsoft.VisualBasic.Strings.InStr(Int32 Start, String String1, String String2, CompareMethod Compare)
at Gatherer_Extractor.Extract_Fct.Get_Logs_side(String Logs, String websource)
at Gatherer_Extractor.Extract_Fct.Get_Data(DataRow TempRow, String Logs, String LogsSF, String websource, String lang)
at Gatherer_Extractor.FenetrePrincipale.Treatment_MAJ(Int32 nbre_tache, BackgroundWorker worker, DoWorkEventArgs e)
at Gatherer_Extractor.FenetrePrincipale.BWkMAJ_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
For those getting errors downloading, you need to start from an empty database.
I have successfully downloaded all sets except Release Promos, which fails at Brisela (separate post coming for that).
Note: I skipped all the "online" sets (cube, masters edition, vintage masters, tempest remastered), as I am using GEx to maintain my inventory spreadsheet.
When attempting to open the "Export" menu, unhandled exception error:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.InvalidCastException: Operator '=' is not defined for type 'DBNull' and type 'Boolean'.
at Microsoft.VisualBasic.CompilerServices.Operators.ConditionalCompareObjectEqual(Object Left, Object Right, Boolean TextCompare)
at Gatherer_Extractor.FenetrePrincipale.ExporterToolStripMenuItem_DropDownOpening(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripDropDownItem.OnDropDownShow(EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnDropDownShow(EventArgs e)
at System.Windows.Forms.ToolStripDropDownItem.ShowDropDownInternal()
at System.Windows.Forms.ToolStripMenuItem.OnMenuAutoExpand()
at System.Windows.Forms.MenuTimer.OnTick(Object sender, EventArgs e)
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
Standard legality is off.
It has Battlebond and Shadows Over Innistrad included.
Also, the Standard Banned list is just Rampaging Ferocidon, since the sets with the other cards all rotated out.
I am getting the error on trying to export, too.
I was able to pull down from scratch GRN, GK1, and MED.
I hit an error on the Release promos (RLS) (issue with Brisela; V17 and EMN did not have a problem with her).
The feel is completely different, but I'd say the fact they are obviously different at the most cursory of glances due to the color differences means one could not use them together in the same deck.
[Progress report] I finished the update of GEx. It is now fully oriented towards Scryfall.com for promos, data in foreign languages and pricing. I still need to intensively test the new version before releasing it, to make sure it works smoothly again. I should be able to provide the release this weekend or next week.
Thanks for your support
Thank you so much! Was just coming to report on the wacky errors, but you are already all over it (I was wondering what impact the closing of magiccards.info would do to GEx).
Note in the color category: Colorless is not the same as Artifacts. Colorless non-artifacts, non-lands, like Eldrazi (see ROE) and Planeswalkers (see Ugin in FRF), are numbered before White, while Artifacts are after Split cards.
So, order is:
01 - Colorless non-Artifact non-Land
02 - White
03 - Blue
04 - Black
05 - Red
06 - Green
07 - Multicolored
08 - Multicolored Hybrid
09 - Multicolored Split
10 - Colorless - Artifact
11 - Colorless - Non-Basic Land
12 - Colorless - Basic Land
I like the layout and descriptions of the frame changes (Legacy Core, Modern Core, Holo Core).
20575 Spite // Malice INV
20577 Pain // Suffering INV
107259 Trial // Error DIS
109704 Assault // Battery TSB
205409 Assault // Battery HOP
205384 Order // Chaos HOP
247159 Fire // Ice CMD
259266 Rise // Fall DDH
430837 Farm // Market HOU
430845 Refuse // Cooperate HOU
446223 Will Kenrith BBD
446224 Rowan Kenrith BBD
456821 Fire // Ice UMA
476131 Ral's Vanguard CMB1
482840 Find // Finality C20
496040 Struggle // Survive ZNC
SF-PLG20_1 Reliquary Tower MDI
SF-PLG20_2 Hangarback Walker MDI
SF-MPR_1 Wasteland MPRP
SF-P03_1 Voidmage Prodigy MPRP
SF-P04_1 Powder Keg MPRP
SF-PW22_1 Consider WPN
SF-PW22_2 Fateful Absence WPN
SF-PW22_3 Atsushi, the Blazing Sky WPN
SF-PDP15_1 Soul of Ravnica DPA
SF-PDP15_2 Soul of Zendikar DPA
479393 Faerie Rogue Token SLD
479394 Faerie Rogue Token SLD
479395 Faerie Rogue Token SLD
479396 Faerie Rogue Token SLD
479390 Cat Token SLD
479391 Cat Token SLD
SF-SLD_060 Storm Crow SLD
SF-SLD_061 Goblin Snowman SLD
SF-SLD_062 Mudhole SLD
SF-SLD_100 Plains SLD
SF-SLD_101 Plains SLD
SF-SLD_102 Island SLD
SF-SLD_103 Island SLD
SF-SLD_104 Swamp SLD
SF-SLD_105 Swamp SLD
SF-SLD_106 Mountain SLD
SF-SLD_107 Mountain SLD
SF-SLD_108 Forest SLD
SF-SLD_109 Forest SLD
SF-SLD_119 Swamp SLD
SF-SLD_120 Sower of Temptation SLD
SF-SLD_121 Damnation SLD
SF-SLD_122 Enchanted Evening SLD
SF-SLD_123 Hallowed Fountain SLD
SF-SLD_124 Watery Grave SLD
SF-SLD_125 Blood Crypt SLD
SF-SLD_126 Stomping Ground SLD
SF-SLD_127 Temple Garden SLD
SF-SLD_128 Godless Shrine SLD
SF-SLD_129 Steam Vents SLD
SF-SLD_130 Overgrown Tomb SLD
SF-SLD_131 Sacred Foundry SLD
SF-SLD_132 Breeding Pool SLD
SF-SLD_138 Anguished Unmaking SLD
SF-SLD_139 Assassin's Trophy SLD
SF-SLD_140 Decimate SLD
SF-SLD_141 Dreadbore SLD
SF-SLD_142 Thraximundar SLD
SF-SLD_154 Admonition Angel SLD
SF-SLD_155 Roil Elemental SLD
SF-SLD_156 Zulaport Cutthroat SLD
SF-SLD_157 Warren Instigator SLD
SF-SLD_158 Avenger of Zendikar SLD
SF-SLD_159 Demonlord Belzenlok SLD
SF-SLD_160 Griselbrand SLD
SF-SLD_161 Liliana's Contract SLD
SF-SLD_162 Kothophed, Soul Hoarder SLD
SF-SLD_163 Razaketh, the Foulblooded SLD
SF-SLD_173 Balance SLD
SF-SLD_174 Brainstorm SLD
SF-SLD_175 Counterspell SLD
SF-SLD_176 Birds of Paradise SLD
SF-SLD_177 Howling Mine SLD
SF-SLD_178 Wasteland SLD
SF-SLD_185 Wrath of God SLD
SF-SLD_186 Preordain SLD
SF-SLD_187 Decree of Pain SLD
SF-SLD_188 Gamble SLD
SF-SLD_189 Nature's Lore SLD
SF-SLD_190 Soul-Scar Mage SLD
SF-SLD_191 Dryad of the Ilysian Grove SLD
SF-SLD_192 Sakura-Tribe Elder SLD
SF-SLD_193 Spell Queller SLD
SF-SLD_194 Metallic Mimic SLD
SF-SLD_195 Chatter of the Squirrel SLD
SF-SLD_196 Krosan Beast SLD
SF-SLD_197 Squirrel Mob SLD
SF-SLD_198 Squirrel Wrangler SLD
SF-SLD_199 Swarmyard SLD
SF-SLD_200 Squirrel Token SLD
SF-SLD_201 Arcane Signet SLD
SF-SLD_202 Chromatic Lantern SLD
SF-SLD_203 Commander's Sphere SLD
SF-SLD_204 Darksteel Ingot SLD
SF-SLD_205 Gilded Lotus SLD
SF-SLD_206 Exquisite Blood SLD
SF-SLD_207 Night's Whisper SLD
SF-SLD_208 Phyrexian Tower SLD
SF-SLD_209 Elesh Norn, Grand Cenobite SLD
SF-SLD_210 Jin-Gitaxias, Core Augur SLD
SF-SLD_211 Sheoldred, Whispering One SLD
SF-SLD_212 Urabrask the Hidden SLD
SF-SLD_213 Vorinclex, Voice of Hunger SLD
509365 Goblin Token SLD
SF-SLD_226 Path to Exile SLD
SF-SLD_227 Well of Lost Dreams SLD
SF-SLD_228 Frantic Search SLD
SF-SLD_229 Intruder Alarm SLD
SF-SLD_230 Shelldock Isle SLD
SF-SLD_231 Gravecrawler SLD
SF-SLD_232 Liliana, Death's Majesty SLD
SF-SLD_233 Rise of the Dark Realms SLD
SF-SLD_234 Brazen Borrower // Petty Theft SLD
SF-SLD_235 Vindictive Lich SLD
SF-SLD_236 Meandering Towershell SLD
SF-SLD_237 Ohran Frostfang SLD
SF-SLD_238 Thragtusk SLD
SF-SLD_251 Dack Fayden SLD
SF-SLD_252 Teferi, Time Raveler SLD
SF-SLD_253 Karn, the Great Creator SLD
SF-SLD_254 Plains SLD
SF-SLD_255 Island SLD
SF-SLD_256 Swamp SLD
SF-SLD_257 Mountain SLD
SF-SLD_258 Forest SLD
SF-SLD_259 Michiko Konda, Truth Seeker SLD
SF-SLD_260 Kami of the Crescent Moon SLD
SF-SLD_261 Toshiro Umezawa SLD
SF-SLD_262 Heartless Hidetsugu SLD
SF-SLD_263 Reki, the History of Kamigawa SLD
SF-SLD_268 All Is Dust SLD
SF-SLD_269 Artifact Mutation SLD
SF-SLD_270 Drown in the Loch SLD
SF-SLD_271 Fire Covenant SLD
SF-SLD_272 Fractured Identity SLD
SF-SLD_273 Fracturing Gust SLD
SF-SLD_274 Ob Nixilis Reignited SLD
SF-SLD_275 Sire of Insanity SLD
SF-SLD_276 Sliver Hivelord SLD
SF-SLD_277 Spellskite SLD
SF-SLD_278 Sanctum Prelate SLD
SF-SLD_279 Carpet of Flowers SLD
SF-SLD_280 Sphere of Safety SLD
SF-SLD_281 Karmic Guide SLD
SF-SLD_282 Mesa Enchantress SLD
SF-SLD_283 Archaeomancer SLD
SF-SLD_284 Bloom Tender SLD
SF-SLD_285 Meteor Golem SLD
SF-SLD_286 Azorius Signet SLD
SF-SLD_287 Dimir Signet SLD
SF-SLD_288 Gruul Signet SLD
SF-SLD_289 Rakdos Signet SLD
SF-SLD_290 Selesnya Signet SLD
SF-SLD_291 Boros Signet SLD
SF-SLD_292 Golgari Signet SLD
SF-SLD_293 Izzet Signet SLD
SF-SLD_294 Orzhov Signet SLD
SF-SLD_295 Simic Signet SLD
SF-SLD_296 Mother of Runes SLD
SF-SLD_297 Mother of Runes SLD
SF-SLD_298 Mother of Runes SLD
SF-SLD_299 Mother of Runes SLD
SF-SLD_300 Ancient Den SLD
SF-SLD_301 Seat of the Synod SLD
SF-SLD_302 Vault of Whispers SLD
SF-SLD_303 Great Furnace SLD
SF-SLD_304 Tree of Tales SLD
SF-SLD_305 Ravenous Chupacabra SLD
SF-SLD_306 Managorger Hydra SLD
SF-SLD_307 Pathbreaker Ibex SLD
SF-SLD_308 Temur Sabertooth SLD
SF-SLD_309 Winding Constrictor SLD
SF-SLD_310 Unbreakable Formation SLD
SF-SLD_311 Whir of Invention SLD
SF-SLD_312 Hero's Downfall SLD
SF-SLD_313 Impact Tremors SLD
SF-SLD_314 Primal Vigor SLD
SF-SLD_315 Commander's Sphere SLD
SF-SLD_316 Fleet Swallower SLD
SF-SLD_317 Goblin Trashmaster SLD
SF-SLD_318 Ilharg, the Raze-Boar SLD
SF-SLD_319 Protean Hulk SLD
SF-SLD_320 Gishath, Sun's Avatar SLD
SF-SLD_321 Dismember SLD
SF-SLD_322 Blasphemous Act SLD
SF-SLD_323 Beast Within SLD
SF-SLD_324 Grafdigger's Cage SLD
SF-SLD_325 Snow-Covered Plains SLD
SF-SLD_326 Snow-Covered Island SLD
SF-SLD_327 Snow-Covered Swamp SLD
SF-SLD_328 Snow-Covered Mountain SLD
SF-SLD_329 Snow-Covered Forest SLD
SF-SLD_330 Aether Gust SLD
SF-SLD_331 Counterspell SLD
SF-SLD_332 Fabricate SLD
SF-SLD_333 Fact or Fiction SLD
SF-SLD_334 Mystical Tutor SLD
SF-SLD_340 Mind Flayer, the Shadow SLD
SF-SLD_341 Chief Jim Hopper SLD
SF-SLD_342 Dustin, Gadget Genius SLD
SF-SLD_343 Eleven, the Mage SLD
SF-SLD_344 Lucas, the Sharpshooter SLD
SF-SLD_345 Max, the Daredevil SLD
SF-SLD_346 Mike, the Dungeon Master SLD
SF-SLD_347 Will the Wise SLD
SF-SLD_348 Clue Token SLD
SF-SLD_349 Moorland Haunt SLD
SF-SLD_350 Vault of the Archangel SLD
SF-SLD_351 Nephalia Drownyard SLD
SF-SLD_352 Desolate Lighthouse SLD
SF-SLD_353 Stensia Bloodhall SLD
SF-SLD_354 Grim Backwoods SLD
SF-SLD_355 Kessig Wolf Run SLD
SF-SLD_356 Slayers' Stronghold SLD
SF-SLD_357 Gavony Township SLD
SF-SLD_358 Alchemist's Refuge SLD
SF-SLD_359 Plains SLD
SF-SLD_360 Island SLD
SF-SLD_361 Swamp SLD
SF-SLD_362 Mountain SLD
SF-SLD_363 Forest SLD
SF-SLD_364 Swords to Plowshares SLD
SF-SLD_365 Grim Tutor SLD
SF-SLD_366 Blood Moon SLD
SF-SLD_367 Cut // Ribbons SLD
SF-SLD_368 Teferi's Puzzle Box SLD
SF-SLD_369 Generous Gift SLD
SF-SLD_370 Chain Lightning SLD
SF-SLD_371 Kodama's Reach SLD
SF-SLD_372 Heirloom Blade SLD
SF-SLD_373 Mulldrifter SLD
SF-SLD_374 Mulldrifter SLD
SF-SLD_375 Craterhoof Behemoth SLD
SF-SLD_376 Craterhoof Behemoth SLD
SF-SLD_377 Metalwork Colossus SLD
SF-SLD_378 Metalwork Colossus SLD
SF-SLD_379a Zndrsplt, Eye of Wisdom SLD
SF-SLD_379b Zndrsplt, Eye of Wisdom SLD
SF-SLD_380a Okaun, Eye of Chaos SLD
SF-SLD_380b Okaun, Eye of Chaos SLD
SF-SLD_381a Propaganda SLD
SF-SLD_381b Propaganda SLD
SF-SLD_382a Stitch in Time SLD
SF-SLD_382b Stitch in Time SLD
SF-SLD_383a Krark's Thumb SLD
SF-SLD_383b Krark's Thumb SLD
SF-SLD_384 Swamp SLD
SF-SLD_477 Path to Exile SLD
SF-SLD_478 Rhystic Study SLD
SF-SLD_479 Duress SLD
SF-SLD_480 Seize the Day SLD
SF-SLD_481 Krosan Grip SLD
SF-SLD_482 Counterflux SLD
SF-SLD_483 Thran Dynamo SLD
SF-SLD_484 Plains SLD
SF-SLD_485 Island SLD
SF-SLD_486 Swamp SLD
SF-SLD_487 Mountain SLD
SF-SLD_488 Forest SLD
SF-SLD_501 Karn, the Great Creator SLD
SF-SLD_502 Ugin, the Ineffable SLD
SF-SLD_503 Gideon Blackblade SLD
SF-SLD_504 Teyo, the Shieldmage SLD
SF-SLD_505 The Wanderer SLD
SF-SLD_506 Jace, Wielder of Mysteries SLD
SF-SLD_507 Kasmina, Enigmatic Mentor SLD
SF-SLD_508 Narset, Parter of Veils SLD
SF-SLD_509 Davriel, Rogue Shadowmage SLD
SF-SLD_510 Liliana, Dreadhorde General SLD
SF-SLD_511 Ob Nixilis, the Hate-Twisted SLD
SF-SLD_512 Chandra, Fire Artisan SLD
SF-SLD_513 Jaya, Venerated Firemage SLD
SF-SLD_514 Sarkhan the Masterless SLD
SF-SLD_515 Tibalt, Rakish Instigator SLD
SF-SLD_516 Arlinn, Voice of the Pack SLD
SF-SLD_517 Jiang Yanggu, Wildcrafter SLD
SF-SLD_518 Nissa, Who Shakes the World SLD
SF-SLD_519 Vivien, Champion of the Wilds SLD
SF-SLD_520 Ajani, the Greathearted SLD
SF-SLD_521 Domri, Anarch of Bolas SLD
SF-SLD_522 Nicol Bolas, Dragon-God SLD
SF-SLD_523 Ral, Storm Conduit SLD
SF-SLD_524 Sorin, Vengeful Bloodlord SLD
SF-SLD_525 Tamiyo, Collector of Tales SLD
SF-SLD_526 Teferi, Time Raveler SLD
SF-SLD_527 Angrath, Captain of Chaos SLD
SF-SLD_528 Ashiok, Dream Render SLD
SF-SLD_529 Dovin, Hand of Control SLD
SF-SLD_530 Huatli, the Sun's Heart SLD
SF-SLD_531 Kaya, Bane of the Dead SLD
SF-SLD_532 Kiora, Behemoth Beckoner SLD
SF-SLD_533 Nahiri, Storm of Stone SLD
SF-SLD_534 Saheeli, Sublime Artificer SLD
SF-SLD_535 Samut, Tyrant Smasher SLD
SF-SLD_536 Vraska, Swarm's Eminence SLD
SF-SLD_537 Tibalt, the Fiend-Blooded SLD
SF-SLD_538 Evolving Wilds SLD
SF-SLD_539 Swamp SLD
SF-SLD_540 Plains SLD
SF-SLD_541 Plains SLD
SF-SLD_542 Plains SLD
SF-SLD_543 Plains SLD
SF-SLD_544 Plains SLD
SF-SLD_545 Plains SLD
SF-SLD_546 Plains SLD
SF-SLD_547 Plains SLD
SF-SLD_548 Island SLD
SF-SLD_549 Island SLD
SF-SLD_550 Island SLD
SF-SLD_551 Island SLD
SF-SLD_552 Island SLD
SF-SLD_553 Island SLD
SF-SLD_554 Island SLD
SF-SLD_555 Island SLD
SF-SLD_556 Swamp SLD
SF-SLD_557 Swamp SLD
SF-SLD_558 Swamp SLD
SF-SLD_559 Swamp SLD
SF-SLD_560 Swamp SLD
SF-SLD_561 Swamp SLD
SF-SLD_562 Swamp SLD
SF-SLD_563 Swamp SLD
SF-SLD_564 Mountain SLD
SF-SLD_565 Mountain SLD
SF-SLD_566 Mountain SLD
SF-SLD_567 Mountain SLD
SF-SLD_568 Mountain SLD
SF-SLD_569 Mountain SLD
SF-SLD_570 Mountain SLD
SF-SLD_571 Mountain SLD
SF-SLD_572 Forest SLD
SF-SLD_573 Forest SLD
SF-SLD_574 Forest SLD
SF-SLD_575 Forest SLD
SF-SLD_576 Forest SLD
SF-SLD_577 Forest SLD
SF-SLD_578 Forest SLD
SF-SLD_579 Forest SLD
SF-SLD_582 Brainstorm SLD
SF-SLD_583 Fblthp, the Lost SLD
SF-SLD_584 Wrexial, the Risen Deep SLD
SF-SLD_585 Terramorphic Expanse SLD
SF-SLD_587 Spellskite SLD
SF-SLD_588 Sphere of Safety SLD
SF-SLD_589 Arcane Signet SLD
SF-SLD_591 Crash Through SLD
SF-SLD_597 Persistent Petitioners SLD
SF-SLD_598 Persistent Petitioners SLD
SF-SLD_603 Eldrazi Monument SLD
SF-SLD_604 Ornithopter SLD
SF-SLD_605 Panharmonicon SLD
SF-SLD_606 Swiftfoot Boots SLD
SF-SLD_607 Rogue's Passage SLD
SF-SLD_608 Darksteel Citadel SLD
SF-SLD_609a Hawkins National Laboratory SLD
SF-SLD_609b The Upside Down SLD
SF-SLD_670a Plains SLD
SF-SLD_670b Battlefield Forge SLD
SF-SLD_696 Spore Frog SLD
SF-SLD_697 Command Tower SLD
<removed the commander deck reprints that I can't figure out the numbers on yet>
Some items I've found:
Missing cards:
SF-PGPX_2018a Plains GPX
2021 Judge Gift Program cards are all missing:
SF-PJ21_1 Morophon, the Boundless JGP
SF-PJ21_2 K'rrik, Son of Yawgmoth JGP
SF-PJ21_3 Edgar Markov JGP
SF-PJ21_4 Ezuri, Claw of Progress JGP
SF-PJ21_5 The Gitrog Monster JGP
SF-PJ21_6 Grand Arbiter Augustin IV JGP
SF-PJ21_7 Karlov of the Ghost Council JGP
SF-PJ21_8 Mizzix of the Izmagnus JGP
SF-PJ21_9a Nicol Bolas, the Ravager JGP
SF-PJ21_9b Nicol Bolas, the Arisen JGP
SF-PJ21_10 Zacama, Primal Calamity JGP
Jumpstart: Historic Horizons (Scryfall set code J21) has been mixed into Judge Gift Program (set code JGP).
These all have Gatherer IDs, but are coming up with only their Scryfall IDs:
538393 Arlinn, the Pack's Hope MID 279a
538394 Arlinn, the Moon's Fury MID 279b
538495 Jerren, Corrupted Bishop MID 316a
538496 Ormendahl, the Corrupter MID 316b
538497 Dennick, Pious Apprentice MID 317a
538498 Dennick, Pious Apparition MID 317b
538501 Ludevic, Necrogenius MID 320a
538502 Olag, Ludevic's Hubris MID 320b
538679 Enduring Angel MID 327a
538680 Angelic Enforcer MID 327b
538689 Malevolent Hermit MID 336a
538690 Benevolent Geist MID 336b
538693 Poppet Stitcher MID 339a
538694 Poppet Factory MID 339b
538700 Curse of Leeches MID 345a
538701 Leeching Lurker MID 345b
538714 Smoldering Egg MID 358a
538715 Ashmouth Dragon MID 358b
538736 Hostile Hostel MID 379a
538737 Creeping Inn MID 379b
The "Ampersand" promos from AFR have an "a" in the Scryfall ID tag and their #.
Example:
SF-PAFR_261a Treasure Vault RLS Artifact Land R 261a
vs
SF-PAFR_261 Treasure Vault RLS Artifact Land R 261
For some reason, the 15th Anniversary cards are not showing up. They are set P15A on Scryfall.
When I tried to download them, they said they completed, set is green, I got no errors, but the cards were not added to the database.
RLS successfully downloaded. Woot!
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.InvalidCastException: Operator '=' is not defined for type 'DBNull' and type 'Boolean'.
at Microsoft.VisualBasic.CompilerServices.Operators.ConditionalCompareObjectEqual(Object Left, Object Right, Boolean TextCompare)
at Gatherer_Extractor.FenetrePrincipale.Perform_Test_Fully_Handled_Sets()
at Gatherer_Extractor.FenetrePrincipale.BGW_OpenBDD_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.ArgumentException: Argument 'Start' must be greater than zero.
at Microsoft.VisualBasic.Strings.InStr(Int32 Start, String String1, String String2, CompareMethod Compare)
at Gatherer_Extractor.Extract_Fct.Get_Logs_side(String Logs, String websource)
at Gatherer_Extractor.Extract_Fct.Get_Data(DataRow TempRow, String Logs, String LogsSF, String websource, String lang)
at Gatherer_Extractor.FenetrePrincipale.Treatment_MAJ(Int32 nbre_tache, BackgroundWorker worker, DoWorkEventArgs e)
at Gatherer_Extractor.FenetrePrincipale.BWkMAJ_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Gatherer Extractor
Assembly Version: 3.8.0.0
Win32 Version: 3.8.0.0
CodeBase: file:///F:/Gatherer%20Extractor/Gatherer%20Extractor.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 10.0.0.0
Win32 Version: 14.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3160.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Data.DataSetExtensions
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.DataSetExtensions/v4.0_4.0.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
I have successfully downloaded all sets except Release Promos, which fails at Brisela (separate post coming for that).
Note: I skipped all the "online" sets (cube, masters edition, vintage masters, tempest remastered), as I am using GEx to maintain my inventory spreadsheet.
When attempting to open the "Export" menu, unhandled exception error:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.InvalidCastException: Operator '=' is not defined for type 'DBNull' and type 'Boolean'.
at Microsoft.VisualBasic.CompilerServices.Operators.ConditionalCompareObjectEqual(Object Left, Object Right, Boolean TextCompare)
at Gatherer_Extractor.FenetrePrincipale.ExporterToolStripMenuItem_DropDownOpening(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripDropDownItem.OnDropDownShow(EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnDropDownShow(EventArgs e)
at System.Windows.Forms.ToolStripDropDownItem.ShowDropDownInternal()
at System.Windows.Forms.ToolStripMenuItem.OnMenuAutoExpand()
at System.Windows.Forms.MenuTimer.OnTick(Object sender, EventArgs e)
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Gatherer Extractor
Assembly Version: 3.8.0.0
Win32 Version: 3.8.0.0
CodeBase: file:///D:/Gatherer%20Extractor/Gatherer%20Extractor.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 10.0.0.0
Win32 Version: 14.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3160.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
System.Data.DataSetExtensions
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Data.DataSetExtensions/v4.0_4.0.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
It has Battlebond and Shadows Over Innistrad included.
Also, the Standard Banned list is just Rampaging Ferocidon, since the sets with the other cards all rotated out.
I am getting the error on trying to export, too.
I was able to pull down from scratch GRN, GK1, and MED.
I hit an error on the Release promos (RLS) (issue with Brisela; V17 and EMN did not have a problem with her).
Error reports will come tomorrow.
Thank you so much! Was just coming to report on the wacky errors, but you are already all over it (I was wondering what impact the closing of magiccards.info would do to GEx).
Anxiously awaiting the next release.
So, order is:
01 - Colorless non-Artifact non-Land
02 - White
03 - Blue
04 - Black
05 - Red
06 - Green
07 - Multicolored
08 - Multicolored Hybrid
09 - Multicolored Split
10 - Colorless - Artifact
11 - Colorless - Non-Basic Land
12 - Colorless - Basic Land
I like the layout and descriptions of the frame changes (Legacy Core, Modern Core, Holo Core).