It's happening pretty consistently on the Prerelease Event (PRE) set. If it is an issue on *insert site name* here, can we not trap for these errors and retry them, or fail more gracefully? Would be nice to have a better error reporting screen perhaps, that shows the current card, the pulled HTML/HTTP status codes, so that you can locate the cause for these errors. I've tried 3 times to download the [PRE] set, and in all cases, it failed.
Could you try release 4.0e ? I improved robustness of the extraction from magiccards.info by adding tests on codes and string length before extracting...
Please let me know.
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 'Length' must be greater or equal to zero.
at Microsoft.VisualBasic.Strings.Mid(String str, Int32 Start, Int32 Length)
at Gatherer_Extractor.Extract_Fct.PowerToughness(String logs, String multiverse_id, String websource)
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)
Same error, Window 10, additional adds are up to date
Error occur on Download all data and All data with images
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)
************** 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 the Commander 2016 bug, this is due to Order // Chaos. Wizards has changed the way dual cards are managed on the gatherer with Commander 2016. It is adjusted in Release 4.0g.
For the running issue with promos, I will look into it, but everything goes smoothly when I extract data from promos; it is pretty hard to track bugs I cannot reproduce...
I get the following error when trying to "Download all data" from some sets. I was going through them one at a time after trying to do a batch to single the problem one's out. Unfortunately, magiccards.info is down right now and the program doesn't run unless both connections are available so I can't give a full list right now. I'll edit this post later once everything is running.
Problem Sets
Friday Night Magic
Media Inserts
Prerelease Events
System.ArgumentException: Argument 'Length' must be greater or equal to zero.
at Microsoft.VisualBasic.Strings.Mid(String str, Int32 Start, Int32 Length)
at Gatherer_Extractor.Extract_Fct.PowerToughness(String logs, String multiverse_id, String websource)
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)
I'd be fine skipping these promo sets normally (they seem to be the problem one's) but according to the program I need a full list if I want to get the legality info. I've had another error come up whenever I tried to get that info without having all the sets. I'll also post that error later.
Legalities error message:
System.NullReferenceException: Object reference not set to an instance of an object.
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)
Processing legalities seems to now work with 4.0i even without having all sets processed. Downloading data for the previously mentioned sets still causes an error, but those sets are so niche that I personally wouldn't call them a priority. I only thought they were needed to properly get the legality info.
@ Babayaga79: It seems this is a "false positive". There are no intentional malicious inside.
Starting the file scan:
Begin scan in 'Gatherer Extractor Installer v4.0i_Nov.-30th-2016.exe'
Used time: 00:00 Minute(s)
The scan has been done completely.
0 Scanned directories
34 Files were scanned
0 Viruses and/or unwanted programs were found
0 Files were classified as suspicious
0 Files were deleted
0 Viruses and unwanted programs were repaired
0 Files were moved to quarantine
0 Files were renamed
0 Files cannot be scanned
34 Files not concerned
2 Archives were scanned
0 Warnings
0 Notes
Date de l'analyse: 02/12/2016
Heure de l'analyse: 21:52
Version: 2.2.1.1043
Base de données de programmes malveillants: v2016.12.02.11
Base de données de rootkits: v2016.11.20.01
Système d'exploitation: Windows 7 Service Pack 1
Processeur: x64
Système de fichiers: NTFS
Type d'analyse: Analyse des menaces
Résultat: Terminé
Objets analysés: Gatherer Extractor Installer v4.0i_Nov.-30th-2016.exe
Temps écoulé: 2 min, 28 s
Processus: 0
(Aucun élément malveillant détecté)
Modules: 0
(Aucun élément malveillant détecté)
Clés du Registre: 0
(Aucun élément malveillant détecté)
Valeurs du Registre: 0
(Aucun élément malveillant détecté)
Données du Registre: 0
(Aucun élément malveillant détecté)
Westvale Abbey shows "Flying, lifelink, indestructible, haste" as the card text. It should be:
Tap: Add Colorless to your mana pool.
5, Tap, Pay 1 life: Create a 1/1 white and black Human Cleric creature token.
5, Tap, Sacrifice five creatures: Transform Westvale Abbey, then untap it.
Hi,
Is there any way to extract the market price metric that tcgplayer adopted last year? I know magiccards.info pulls data from their API, but I don't know to what extent.
I just downloaded v4.0j and GE is crashing when downloading the data for Masterpiece Series: Kaladesh Inventions. Both times it crashed when it got to AEther Vial, so I would imagine that it's having a problem with the character AE.
Here is the crash text and I've attached a screenshot:
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)
************** 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.
ATTACHMENTS
Screen Shot 2017-01-10 at 8.38.50 PM
Private Mod Note
():
Rollback Post to RevisionRollBack
--
Reliquary for iOS
Your Magic Collection Anywhere You Go reliquaryapp.com
It should be fixed with the latest release (4.1), as well as the crash for AErathi Berserker in the Legends set.
May you please confirm it? Thanks in advance.
One thing that I have also noticed is that DFC for Eldritch Moon (EMN) still aren't being downloaded correctly. The front side isn't getting the "ID (back)" field filled in, and the back side has the same information as the front. I know in the past you had mentioned that DFC issues are related to magiccards.info having not been updated yet, but as of now, two full sets have been released (not to mention the supplementary sets) and they still have not fully updated their site. This leads me to think that the site likely will not be updated to properly include Eldritch Moon's DFC. Is there another source you can use for it? I'm assuming that Gatherer returns the front side's information when using the back side's Oracle ID...
Thanks!
Private Mod Note
():
Rollback Post to RevisionRollBack
--
Reliquary for iOS
Your Magic Collection Anywhere You Go reliquaryapp.com
@nickman55 : Are you sure you are using the latest release on a fresh extraction ? Because those bugs (missing back IDs and {13} mana symbol) were corrected months ago.
Concerning "Harmonize Database", it checks if all promotionals have the same Oracle texts as cards extracted from the Gatherer, and overwrites if different. Accordingly, the final whole database is consistent even if magiccards.info promotionals have sometimes outdated textboxes (e.g. Create a token vs. Put a token onto the battlefield)
@jenjia : as soon as it is available on magiccards.info. Please wait until the set is officially released.
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".
Private Mod Note
():
Rollback Post to RevisionRollBack
--
Reliquary for iOS
Your Magic Collection Anywhere You Go reliquaryapp.com
This Gatherer Extractor is amazing! I had been looking for something like this.
Are the ID numbers for the cards unique as in overlaps? How are you generating what ID goes to what card? Also do you have documentation on what the columns are? Most of the columns are pretty straight forward but some are unclear like what is the column Nboosterpack_nE or Nboosterpack_pPM?
Also it would be nice to have a tooltip appear when you hover over a yellow arrow in the Stat column in Gatherer Extractor because I'm assuming the green arrow means success but I'm not sure what the yellow arrow implies.
All in all awesome work!
EDIT: Also I may have found a bug. After putting everything into a SQL database I was looking through the rows and noticed that the NBoosterpack_listExtra1 column has numbers in it. I've attached a screenshot as reference.
I've noticed that this program has some major issues when you increase Windows txt scale. I've posted some pics of the issue below cause I have my Windows set to 125% scale. I've had to revert back to 100% inorder to use this program because not only is the orientation of the txt off, but it essentially won't function because you can't even put anything in the checkboxes at that scaled txt size.
Issue 1
This seems to happen only on: Booster Packaging, Card Scans and Export. However Legalities, Extract Data and General are fine as you can see in the example below...
I get a NullPointerException and crash whenever it tried to process Aether Storm, out of 5E/Homelands/Masters Edition II. This just me?
UPDATE:
Looks like the problem with the Fifth Ed Aether Storm was it somehow was not saving the collector number, and that was causing the program to blow up. Manually added it into the .csv file, and now it seems to be going strong. Tomorrow, I will investigate the other cards which are giving me problems, and will list issues/observations/solutions here for each one.
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)
************** 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.
Private Mod Note
():
Rollback Post to RevisionRollBack
--
Reliquary for iOS
Your Magic Collection Anywhere You Go reliquaryapp.com
Minor bugs in extraction are fixed in 4.1c.
Display bugs with non-100% scale is a known issue. I will see what I can do.
The addition of a "Most Recent" column is in my "to do" list
Private Mod Note
():
Rollback Post to RevisionRollBack
To post a comment, please login or register a new account.
Please let me know.
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 'Length' must be greater or equal to zero.
at Microsoft.VisualBasic.Strings.Mid(String str, Int32 Start, Int32 Length)
at Gatherer_Extractor.Extract_Fct.PowerToughness(String logs, String multiverse_id, String websource)
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)
Died on [FNM] Icy Manipulator
Error occur on Download all data and All data with images
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.1586.0 built by: NETFXREL2
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.
Standard Deck
:symw:UW Humans:symu:
Legacy Deck
:symu::symr::symg:RUG Delver:symu::symr::symg:
For the running issue with promos, I will look into it, but everything goes smoothly when I extract data from promos; it is pretty hard to track bugs I cannot reproduce...
I was going through them one at a time after trying to do a batch to single the problem one's out. Unfortunately, magiccards.info is down right now and the program doesn't run unless both connections are available so I can't give a full list right now. I'll edit this post later once everything is running.
Problem Sets
Friday Night Magic
Media Inserts
Prerelease Events
I'd be fine skipping these promo sets normally (they seem to be the problem one's) but according to the program I need a full list if I want to get the legality info. I've had another error come up whenever I tried to get that info without having all the sets.
I'll also post that error later.Legalities error message:
Thank you!
Starting the file scan:
Begin scan in 'Gatherer Extractor Installer v4.0i_Nov.-30th-2016.exe'
Used time: 00:00 Minute(s)
The scan has been done completely.
0 Scanned directories
34 Files were scanned
0 Viruses and/or unwanted programs were found
0 Files were classified as suspicious
0 Files were deleted
0 Viruses and unwanted programs were repaired
0 Files were moved to quarantine
0 Files were renamed
0 Files cannot be scanned
34 Files not concerned
2 Archives were scanned
0 Warnings
0 Notes
Malwarebytes Anti-Malware
www.malwarebytes.org
Date de l'analyse: 02/12/2016
Heure de l'analyse: 21:52
Version: 2.2.1.1043
Base de données de programmes malveillants: v2016.12.02.11
Base de données de rootkits: v2016.11.20.01
Système d'exploitation: Windows 7 Service Pack 1
Processeur: x64
Système de fichiers: NTFS
Type d'analyse: Analyse des menaces
Résultat: Terminé
Objets analysés: Gatherer Extractor Installer v4.0i_Nov.-30th-2016.exe
Temps écoulé: 2 min, 28 s
Processus: 0
(Aucun élément malveillant détecté)
Modules: 0
(Aucun élément malveillant détecté)
Clés du Registre: 0
(Aucun élément malveillant détecté)
Valeurs du Registre: 0
(Aucun élément malveillant détecté)
Données du Registre: 0
(Aucun élément malveillant détecté)
Dossiers: 0
(Aucun élément malveillant détecté)
Fichiers: 0
(Aucun élément malveillant détecté)
Secteurs physiques: 0
(Aucun élément malveillant détecté)
Tap: Add Colorless to your mana pool.
5, Tap, Pay 1 life: Create a 1/1 white and black Human Cleric creature token.
5, Tap, Sacrifice five creatures: Transform Westvale Abbey, then untap it.
thanks for having reported!
Is there any way to extract the market price metric that tcgplayer adopted last year? I know magiccards.info pulls data from their API, but I don't know to what extent.
Here is the crash text and I've attached a screenshot:
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.
Reliquary for iOS
Your Magic Collection Anywhere You Go
reliquaryapp.com
May you please confirm it? Thanks in advance.
One thing that I have also noticed is that DFC for Eldritch Moon (EMN) still aren't being downloaded correctly. The front side isn't getting the "ID (back)" field filled in, and the back side has the same information as the front. I know in the past you had mentioned that DFC issues are related to magiccards.info having not been updated yet, but as of now, two full sets have been released (not to mention the supplementary sets) and they still have not fully updated their site. This leads me to think that the site likely will not be updated to properly include Eldritch Moon's DFC. Is there another source you can use for it? I'm assuming that Gatherer returns the front side's information when using the back side's Oracle ID...
Thanks!
Reliquary for iOS
Your Magic Collection Anywhere You Go
reliquaryapp.com
Also, could you explain what "Harmonize Database" does?
Thanks!
Reliquary for iOS
Your Magic Collection Anywhere You Go
reliquaryapp.com
Concerning "Harmonize Database", it checks if all promotionals have the same Oracle texts as cards extracted from the Gatherer, and overwrites if different. Accordingly, the final whole database is consistent even if magiccards.info promotionals have sometimes outdated textboxes (e.g. Create a token vs. Put a token onto the battlefield)
@jenjia : as soon as it is available on magiccards.info. Please wait until the set is officially released.
Reliquary for iOS
Your Magic Collection Anywhere You Go
reliquaryapp.com
Are the ID numbers for the cards unique as in overlaps? How are you generating what ID goes to what card? Also do you have documentation on what the columns are? Most of the columns are pretty straight forward but some are unclear like what is the column Nboosterpack_nE or Nboosterpack_pPM?
Also it would be nice to have a tooltip appear when you hover over a yellow arrow in the Stat column in Gatherer Extractor because I'm assuming the green arrow means success but I'm not sure what the yellow arrow implies.
All in all awesome work!
EDIT: Also I may have found a bug. After putting everything into a SQL database I was looking through the rows and noticed that the NBoosterpack_listExtra1 column has numbers in it. I've attached a screenshot as reference.
Issue 1
This seems to happen only on: Booster Packaging, Card Scans and Export. However Legalities, Extract Data and General are fine as you can see in the example below...
Normal
I'm on Win7 X64 Pro Build 7601
UPDATE:
Looks like the problem with the Fifth Ed Aether Storm was it somehow was not saving the collector number, and that was causing the program to blow up. Manually added it into the .csv file, and now it seems to be going strong. Tomorrow, I will investigate the other cards which are giving me problems, and will list issues/observations/solutions here for each one.
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!
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.
Reliquary for iOS
Your Magic Collection Anywhere You Go
reliquaryapp.com
Thanks!
Reliquary for iOS
Your Magic Collection Anywhere You Go
reliquaryapp.com
Minor bugs in extraction are fixed in 4.1c.
Display bugs with non-100% scale is a known issue. I will see what I can do.
The addition of a "Most Recent" column is in my "to do" list