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)
    In 7.0f when I export to .xls file and try to open it I get the following message from Excel:

    "The file format and extension filename.xls don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it."

    If I try to import this file into MS SQL it will not work. My workaround was the following:

    Open the .xls file, save as an .xlsx file (which corrects another issue with importing into a SQL DB) then I'm able to import after dealing with the Flavor text nvarchar length, and allow Nulls for Legalities (TLC)

    I've also noticed that the ID for the THM2 (and maybe other cards with alpha-numeric ID's are listed as Null when imported because the ID column is listed as a Double / float


    In the previous version I did not have these issue importing into a SQL DB, just figured I would let you know in case it's something that can be corrected.
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    Quote from Chaudakh »
    @Fingersniffer: I have not written a wiki/user manual so far. It is an overwhelming task, but I know I have to.

    I work in software development and QA/Automation so I understand how difficult good documentation is to write
    Quote from Chaudakh »

    1/ New sets are automatically added once those are available on the Gatherer. You have nothing to do. Nonetheless, I invite you to wait for an update, because I specify in this the new booster package, new legalities etc.

    I know this is a question you'll probably hate, but what is your timeline for having an update out for new sets? Do you try and have it out a week early, day of release etc? IE I know the MH2 card list is available on scryfall is why I ask.
    Quote from Chaudakh »

    2/ There are some slight discrepancies between Gatherer database and Scryfall database. The Mana order ({R}{W} vs. {W}{R}) etc. is sometimes different for some cards. Harmonizing the database means for each card extracted from Scryfall, if the same card name exists from the Gatherer source, then the manacost and oracle ability text are overwritten. This ensures to remove all the small typos.

    Ok, that makes more sense
    Posted in: Third Party Products
  • posted a message on MTG Gatherer Extractor v7.0 (Database & Pics Assistant)
    I am trying to find some form of wiki for this and I've not found anything, does a wiki/user guide exist for GE?

    If not, I had a few questions:

    1. How are new sets added (IE Modern Horizons 2), are they something I can create/download, or do I have to wait for an update to the program itself? I see how to add promo sets but not any others.

    2. What is Harmonizing the DB?
    Posted in: Third Party Products
  • To post a comment, please or register a new account.