Checklist
Moderators: cataclysm80, hammr7, l0qii, Apocalypse2K, berkumps, dragsamou, mystical_tutor, pp
- AzureWinter
- Legendary Flying Green Mana Bird
- Posts: 296
- Joined: Tue Feb 17, 2004 5:30 pm
- Location: Toronto Ontario
what the set that has tempest and ice age and other old sets that is black border but it's in white border?
Global Birds of Paradise Project
http://www.magiclibrarities.net/forum/v ... php?t=5020
http://www.magiclibrarities.net/forum/v ... php?t=5020
- mystical_tutor
- Legendary Old Fart Magic Player
- Posts: 3056
- Joined: Mon Dec 10, 2007 3:02 am
- Location: Colorado Springs
Do you have a problem copying the checklists from http://magiccards.info/sitemap.html ? I do but I'm sure some have figured out a good way to do it.AzureWinter wrote:I also want to know if anyone have a checklist for Promos, Vanguard.
I am working on a "Promo's Checklist" The problem is that there are so many "catagories" of promos and the present sources (this board, Magiccards.info, WotC, and the online dealers) are not the same. I have a checklist that I will send you that mostly follows the organization of magiccards.info. It will be one list with different set designations for the different catagories (ie. DCI-Are is Arena, DCI-PR is player reward, etc.). It is not polished and has only been checked twice but seems to be working well.
I may have finished Vanguard too, I'll check.
Gary Adkison
Father of a former Wizards of the Coast janitor.
Knowledge is proud because it thinks it knows so much; wisdom is humble because it realizes it knows so little.
Father of a former Wizards of the Coast janitor.
Knowledge is proud because it thinks it knows so much; wisdom is humble because it realizes it knows so little.
I just did a straight up copy and paste onto excel. Popped on a filter and it looks pretty decent.mystical_tutor wrote:Do you have a problem copying the checklists from http://magiccards.info/sitemap.html ? I do but I'm sure some have figured out a good way to do it.AzureWinter wrote:I also want to know if anyone have a checklist for Promos, Vanguard.
I am working on a "Promo's Checklist" The problem is that there are so many "catagories" of promos and the present sources (this board, Magiccards.info, WotC, and the online dealers) are not the same. I have a checklist that I will send you that mostly follows the organization of magiccards.info. It will be one list with different set designations for the different catagories (ie. DCI-Are is Arena, DCI-PR is player reward, etc.). It is not polished and has only been checked twice but seems to be working well.
I may have finished Vanguard too, I'll check.
- mystical_tutor
- Legendary Old Fart Magic Player
- Posts: 3056
- Joined: Mon Dec 10, 2007 3:02 am
- Location: Colorado Springs
I didn't try that with Access. An idea though. I don't use Excel much but if I got it into Excel then I could import it to Access.mwagee wrote: I just did a straight up copy and paste onto excel. Popped on a filter and it looks pretty decent.
Thanks, I'll work on that.
Gary Adkison
Father of a former Wizards of the Coast janitor.
Knowledge is proud because it thinks it knows so much; wisdom is humble because it realizes it knows so little.
Father of a former Wizards of the Coast janitor.
Knowledge is proud because it thinks it knows so much; wisdom is humble because it realizes it knows so little.
just the opposite here.mystical_tutor wrote:I didn't try that with Access. An idea though. I don't use Excel much but if I got it into Excel then I could import it to Access.mwagee wrote: I just did a straight up copy and paste onto excel. Popped on a filter and it looks pretty decent.
Thanks, I'll work on that.
i cant work access at all.
luckily i dont handle data sets with greater than 60k+ lines usually :)
- AzureWinter
- Legendary Flying Green Mana Bird
- Posts: 296
- Joined: Tue Feb 17, 2004 5:30 pm
- Location: Toronto Ontario
For some reason, i get different result every time i use it. Sometimes it breaks it down nicely, sometimes everything just goes into 1 column. The ones I need i get the "everything in 1 column" resultmystical_tutor wrote:Do you have a problem copying the checklists from http://magiccards.info/sitemap.html ? I do but I'm sure some have figured out a good way to do it.AzureWinter wrote:I also want to know if anyone have a checklist for Promos, Vanguard.
I am working on a "Promo's Checklist" The problem is that there are so many "catagories" of promos and the present sources (this board, Magiccards.info, WotC, and the online dealers) are not the same. I have a checklist that I will send you that mostly follows the organization of magiccards.info. It will be one list with different set designations for the different catagories (ie. DCI-Are is Arena, DCI-PR is player reward, etc.). It is not polished and has only been checked twice but seems to be working well.
I may have finished Vanguard too, I'll check.
Global Birds of Paradise Project
http://www.magiclibrarities.net/forum/v ... php?t=5020
http://www.magiclibrarities.net/forum/v ... php?t=5020
- mystical_tutor
- Legendary Old Fart Magic Player
- Posts: 3056
- Joined: Mon Dec 10, 2007 3:02 am
- Location: Colorado Springs
Well, the file I sent may help. There are 624 records. That is not all the promo cards. I know my list of 9th Edition Box Top Cards is not complete. I do not have all the Japanese catagories--player reward and one other. The list is only as up to date as the web sites as far as 2009 cards--which means there aren't many.AzureWinter wrote:For some reason, i get different result every time i use it. Sometimes it breaks it down nicely, sometimes everything just goes into 1 column. The ones I need i get the "everything in 1 column" result
I have included the "special use" field that gives the dates, card numbers, and occasion for the card. I put all Arena cards in the same "set" (DCI-Arena), both large and regular size. If that creates a problem let me know and I'll send a file which specifies which ones are 6x9. Set names are somewhat brief, DCI-PR is player reward, DCI-PreR is pre-release. If you have any trouble with others just PM me.
Enjoy.
OBTW. If you have extra Japanese Promo cards that you are willing to trade or sell, please let me know.
Gary Adkison
Father of a former Wizards of the Coast janitor.
Knowledge is proud because it thinks it knows so much; wisdom is humble because it realizes it knows so little.
Father of a former Wizards of the Coast janitor.
Knowledge is proud because it thinks it knows so much; wisdom is humble because it realizes it knows so little.
- mystical_tutor
- Legendary Old Fart Magic Player
- Posts: 3056
- Joined: Mon Dec 10, 2007 3:02 am
- Location: Colorado Springs
60K records is getting to be a respectable DB and probably needs to be relational. Years ago I got into dBase III and was able to program in it. I used it in the Army before they standardized to MS Office. Some of our supply DBs were kinda large. I can't program Access (to lazy to learn VB) but I seem to be warped toward DB instead of spreadsheets. Sometimes when I want to do a mass update of one field I export to Excel, update, and import back to Access.mwagee wrote:just the opposite here.
i cant work access at all.
luckily i dont handle data sets with greater than 60k+ lines usually :)
Gary Adkison
Father of a former Wizards of the Coast janitor.
Knowledge is proud because it thinks it knows so much; wisdom is humble because it realizes it knows so little.
Father of a former Wizards of the Coast janitor.
Knowledge is proud because it thinks it knows so much; wisdom is humble because it realizes it knows so little.
Who is online
Users browsing this forum: No registered users and 57 guests