2019 Holiday Exchange!
 
A New and Exciting Beginning
 
The End of an Era
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    Looks like I found another pesky bug Frown

    When downloading 2XMT, Double Masters Box Toppers (either from a saved database or from scratch), this error happens immediately:

    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.Data.EvaluateException: Error in Like operator: the string pattern 'SF-2XM+border%3Aborderless_*' is invalid.
    at System.Data.LikeNode.AnalyzePattern(String pat)
    at System.Data.LikeNode.Eval(DataRow row, DataRowVersion version)
    at System.Data.UnaryNode.Eval(DataRow row, DataRowVersion version)
    at System.Data.Select.AcceptRecord(Int32 record)
    at System.Data.Select.GetLinearFilteredRows(Range range)
    at System.Data.Select.SelectRows()
    at System.Data.DataTable.Select(String filterExpression)
    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.8.4341.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
    ----------------------------------------
    Gatherer Extractor
    Assembly Version: 7.0.0.0
    Win32 Version: 7.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Gatherer%20Extractor/Gatherer%20Extractor.exe
    ----------------------------------------
    Microsoft.VisualBasic
    Assembly Version: 10.0.0.0
    Win32 Version: 14.8.3752.0 built by: NET48REL1
    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.8.4300.0 built by: NET48REL1LAST_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.8.4341.0 built by: NET48REL1LAST_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.8.4341.0 built by: NET48REL1LAST_C
    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.8.3752.0 built by: NET48REL1
    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.8.4190.0 built by: NET48REL1LAST_B
    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.8.3752.0 built by: NET48REL1
    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.8.3752.0 built by: NET48REL1
    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.8.4270.0 built by: NET48REL1LAST_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.8.3752.0 built by: NET48REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
    ----------------------------------------
    Microsoft.WindowsAPICodePack.Shell
    Assembly Version: 1.1.4.0
    Win32 Version: 1.1.4.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Gatherer%20Extractor/Microsoft.WindowsAPICodePack.Shell.DLL
    ----------------------------------------
    Microsoft.WindowsAPICodePack
    Assembly Version: 1.1.4.0
    Win32 Version: 1.1.4.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Gatherer%20Extractor/Microsoft.WindowsAPICodePack.DLL
    ----------------------------------------
    Accessibility
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.3752.0 built by: NET48REL1
    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.8.3752.0 built by: NET48REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Data.DataSetExtensions/v4.0_4.0.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll
    ----------------------------------------
    CompactExifLib
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Gatherer%20Extractor/CompactExifLib.DLL
    ----------------------------------------
    netstandard
    Assembly Version: 2.0.0.0
    Win32 Version: 4.8.3752.0
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/netstandard/v4.0_2.0.0.0__cc7b13ffcd2ddd51/netstandard.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.
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    The same issue happens with the Double-Face cards from Strixhaven: School of Mages. GE is showing the ID and Name of the Front of the card, but the Mana Cost, CMC, Power, Toughness, Loyalty, Ability, Color, and Produces of the Back, and visa versa. Oddly enough, it does correctly show the Ruling.

    Something else I found is that the Double-Face cards from Kaldheim Collector Booster are all extracted correctly. The only thing I can think of is there is a difference between how Gatherer and Scryfall have the data (I'm assuming that Gatherer is the main source for data, with Scryfall being used for promotional cards, tokens, and any other cards that aren't in Gatherer)
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    Hey Chaudakh,

    I just updated to version 7, and I'm still having trouble with Kaldheim Double-Face cards...

    It seems like it's extracting the reverse side for each/all of them. For example, all details for Halvar, God of Battle is what is belongs on Sword of the Realms. I've included a screenshot of my Excel export that shows this. I also added a column that shows whether or not the ID column is the same as the ID (back) column, which appears to be the case for most of them. I did check the Options, and in the Double Faced section, it does show that Halvar and Sword belong together. Lastly, I noticed that on Gatherer itself, the Double-Face cards are numbered ##a and ##b, but GE marks them both as ##. Using Halvar as an example again, Gatherer shows him as 15a and Sword as 15b while GE shows them both as 15.

    This happened when I opened a saved export and updated Kaldheim, or when I started from scratch and just downloaded Kaldheim.

    Am I doing something wrong here?

    Thanks!
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    @Chaudakh - Thanks so much! Does this mean that the list will have to be updated for all future double-fece cards?

    Additionally, I noticed that there are some cards from Kaldheim missing from the extraction. They appear to be promo/showcase/special cards that have Collector Numbers higher than the last card in the main set. For example, if I do a full extract, it appears that cards 286, 290-293, 299-300, 302-303, 306-308, 311, 313-314, and 317-318 are missing from the list. I've attached a screenshot showing some of the missing cards.

    Thanks!
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    Hey there! I just downloaded the data for Kaldheim, and it looks like the Back data isn't being pulled for the double-sided module cards. For example, if you look at Halvar, God of Battle, it will show that he has no card on his back, but it should be Sword of the Realms. Interestingly, double-sided module cards appeared to have pulled correctly from Zendikar Rising.

    Thanks!
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    Awesome! You're the best Smile
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    I just tried to download the data for Throne of Eldraine and it appears that GE isn't processing Adventure cards properly. GE is only seeing the creature half of the card, and the Adventure half is completely ignored.

    For example, if you look at the GE data for Brazen Borrower, you'll see that it's a Creature with it's printed abilities and such, but then there is no mention of what the other half of the card does. Also, It's other half, Petty Theft, doesn't show up in the card list at all.

    This is the same for all Adventure cards.

    Thanks!
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    Oh yeah, one other thing I noticed is that the Official Code for Urza's Saga is set to be UDS which is the code for Urza's Destiny and should be USG. I've corrected it on my computer, but it seems it gets overridden each time there is an update to GE.

    Thanks!
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    I just finished a full extraction and found two more crashes...

    Set: Planechase "Planes"
    Code: HOPP
    Card: The AEther Rues

    Set: Planechase 2012 Edition "Planes"
    Code: PC2P
    Card: Chaotic AEther

    Both cards caused the error: System.ArgumentException: Argument 'Length' must be greater or equal to zero. I did just discover though that the crashes do not happen on a fresh download. I noticed that for both cards, when I was simply updating what I had extracted already, Aether showed up as Æther where on a fresh download it showed up as Aether. I was able to get around this issue by opening the CSV file used to save the database and change Æ to Ae in the name for each card. Interestingly enough, Æ does show up in other parts of those and other cards, but doesn't seem to be an issue anywhere other than the English name.

    Thanks!
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    Here are some other cards I've found that are causing the "System.ArgumentOutOfRangeException: startIndex cannot be larger than length of string." crash:
    • Druid of the Cowl from Aether Revolt
    • Fieldmist Borderpost from Alara Reborn
    • Agent of Stromgald from Alliances
    • Llanowar Elves from Dominaria

    I started to see a pattern here... It seems like this crash happens the first time GE comes across a card that produces mana. My guess is it has something to do with the massive errata that happened to change "Add {X} to your mana pool" to "Add {X}". Hope this helps!
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    Hey there! One thing that I just noticed is that Mana Cost for the backside of DFCs may not be pulling correctly. I just downloaded data for From the Vault: Transform and all the backsides had a mana cost of "# <br/><br/>" (where # is the CMC of the card).

    Thanks!
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    I'm running 4.3 and there seems to be an issue with the "Download all scans from the list" button. That button used to respect the filter that was chosen and only worried about the cards that were listed from the filter, but now it seems to process every card that has been loaded. The good thing is that it's not redownloading the images, but the really bad thing is that it's taking 2+ hours to download the images from Ixalan because it has to first process every other card.

    Also, I second pulling images from a source other than magiccards.info as they seem to be quite slow at updating. Scryfall has a very nice looking API here https://scryfall.com/docs/api/images

    Thanks!
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    @chaudakh - One more suggestion. Would it be possible for you to add a "Most Recent" column which would basically be the opposite of "Original"?

    Thanks!
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    I'm running v4.1b and have come across another error that seems to happen with split cards. In this particular case, it was for the card Order // Chaos from Commander 2016, but I noticed it happened with another split card as well.

    Also, just wondering if you would be able to add an additional source for card data in the event that Gatherer and Magiccards.info don't have it...For example, they don't seem to have images for any prerelease cards from Battle for Zendikar, and it looks like that's actually where they have stopped adding prerelease cards. In fact, after looking at some other Promo sets, FNM specifically, it looks like they stopped updating/adding many and/or all promo cards after Battle for Zendikar.

    Thanks!

    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.
    at Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value)
    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.6.1586.0 built by: NETFXREL2
    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:///C:/Program%20Files%20(x86)/Gatherer%20Extractor/Gatherer%20Extractor.exe
    ----------------------------------------
    Microsoft.VisualBasic
    Assembly Version: 10.0.0.0
    Win32 Version: 14.6.1586.0 built by: NETFXREL2
    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.6.1586.0 built by: NETFXREL2
    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.6.1586.0 built by: NETFXREL2
    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.6.1586.0 built by: NETFXREL2
    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.6.1586.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    System.Runtime.Remoting
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1586.0 built by: NETFXREL2
    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.6.1636.0 built by: NETFXREL3STAGE
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
    ----------------------------------------
    System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1586.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1586.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    ----------------------------------------
    System.Numerics
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1586.0 built by: NETFXREL2
    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.6.1586.0 built by: NETFXREL2
    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.6.1586.0 built by: NETFXREL2
    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.
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    You are correct! I did forget that I needed to actually refetch the data to get it corrected... Sorry for the false alarm and thanks for the explanation on "Harmonize Database".
    Posted in: Third Party Products
  • To post a comment, please or register a new account.