VGCollect Forum
VGCollect Site Stuff => Site Feedback => Topic started by: xpokorkb on November 07, 2014, 03:32:38 pm
-
I was about to necro-post this thread (http://vgcollect.com/forum/index.php/topic,3539.msg36587.html), but decided against it, as what I'm asking is slightly different!
I have a MySQL database that contains the following structure:
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`system` enum('PS1','PS2','XBOX','XBOX360','N64','Wii') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`UPC-A` varchar(20) NOT NULL,
`price_level` enum('used_price','complete_price','new_price') NOT NULL,
`own` bit(1) NOT NULL DEFAULT b'1',
`item-count` tinyint(4) NOT NULL DEFAULT '1',
`imguri` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`reprint` bit(1) NOT NULL DEFAULT b'0',
`notes` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`paid-value` decimal(4,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`)
I've gone through great lengths to ensure the UPC-A is correct, and was wondering if you could bring back the import feature that matches against UPC-A as opposed to names.
-
Hmm the only issue I'd see here is that our UPC data is far from complete. There is a good chance the import wouldn't be able to match up most of the games. Are you looking at this as a one time import or something to use over and over?
-
For me personally, over and over, but I wouldn't have any issues bombing my catalog on the site, and then re-uploading it.
Now I see why title matching is so important; most video game api's use that for UPC lookups.