Posted By | Message |
BigEd76
Posts: 4,029
Joined: Nov 2016
|
Saturday, May 23, 2020 6:56 PM | |
Just noticed the site defaults to a college's baseball team ID (or whatever it finds next down the line) when assigning a college Team to a card in a multi-sport set or a set classified as single sport featuring players from other sports, so just be aware you'll need to adjust the ID to the correct one after. I'm running into this issue with the multi-sport sets right now and have found other players assigned to the wrong sports (e.g. Muggsy Bogues assigned to Wake Forest Baseball).
Example:
North Carolina Baseball = 2866
North Carolina Basketball = 1165
North Carolina Football = 263
North Carolina Misc. Sports = 3636
Edited on: Jun 23, 2020 - 12:43PM -------------------------------
* Ed * L8 * Cards in my personal Collection are unavailable *
|
|
|
|
FreehanSolo
Posts: 1,121
Joined: Nov 2017
|
Saturday, May 23, 2020 7:05 PM | |
Thanks for the heads up, I never knew this!
|
|
|
|
Shaw Racing
Posts: 1,771
Joined: Feb 2019
|
Saturday, May 23, 2020 9:18 PM | |
Thats good to know, Thanks for the heads up
|
|
|
|
BigEd76
Posts: 4,029
Joined: Nov 2016
|
Saturday, May 23, 2020 9:53 PM | |
Wow, just looking at my North Carolina example and I had to move dozens of basketball players off the football team back to the basketball team. I understand having separate team IDs for each college team/sport, but oh man this is a site-wide headache
-------------------------------
* Ed * L8 * Cards in my personal Collection are unavailable *
|
|
|
|
Brendan Barrick
Posts: 435
Joined: Dec 2019
|
Sunday, May 24, 2020 12:13 AM | |
I have noticed that too while I was working on the 1993 Classic Four Sport set.
-------------------------------
|
|
|
|
ravensray52
Posts: 307
Joined: Apr 2020
|
Sunday, May 24, 2020 3:24 AM | |
Thats probably not even a decision the database designer made, the database engine needed to make a desicion and went alphabetically. Could a warning be put on the screen?
|
|
|
|
jasongerman9
Posts: 1,905
Joined: Jan 2015
|
Sunday, May 24, 2020 5:31 AM | |
I have spent hours on and off on the project of sorting things out. It gets worse, trust me (check "Alabama football" if you want to see). But yes, an excellent reminder and word of caution to those working on multi-sport college sets
-------------------------------
I'll never quit collecting entirely, but I am downsizing. Check out my COMC store and help me thin out what I don't want so I can buy cards that I do want. See something you like? Send me a message on here, and we can knock the price down quite a bit. I'll even take a bit of a loss if it means getting you a card you really want.
|
|
|
|
Lea DeFoote
Posts: 1,535
Joined: Jul 2012
|
Sunday, May 24, 2020 6:51 AM | |
It is not just college teams either. You have to pay attention to the pro teams as well when working in Multi-Sport. While I was working on 95 5-Sport I found the New York Giants cards were linking to the baseball team even though I was choosing the one labeled football from the team list.
-Tom
Edited on: May 24, 2020 - 8:27AM -------------------------------
Ted Musgrave card collection 98.9% Complete: Cards Known: 1013, Cards Owned: 1002 I prefer the company of people who disagree with me for the right reasons over the company of those who agree with me for the wrong reasons.
|
|
|
|
Brimose
Posts: 269
Joined: Mar 2015
|
Sunday, May 24, 2020 7:08 AM | |
Good to know. I'll tackle the Buckeyes this week so nobody else has to work on them
|
|
|
|
vrooomed
Posts: 14,985
Joined: Dec 2012
|
Sunday, May 24, 2020 8:08 AM | |
If I didn't already have several users lists of "things to do" on the site, I would create a list of the multi-sport sets that need to be verified, then once verified, move to a "done" list and ensure those sets get locked (to then ensure the hard work peple put in doesn't get lost). Anybody want to head this one up? (I think a set by set approach would be much more helpful to the site than a school by school approach.)
-------------------------------
-- Dan -- Note: Please see my profile for more info regarding trading (section updated 3/4/2024). I have added a large portion of my inventory to the site, and currently have trading turned on (details are in my profile).
|
|
|
|