1,105,344 Community Members

navicat, MySQLand import wizard

Member Avatar
teedoff
Practically a Master Poster
605 posts since Jul 2010
Reputation Points: 3 [?]
Q&As Helped to Solve: 60 [?]
Skill Endorsements: 0 [?]
 
0
 

I am new to MySQL and navicat as well. I have been creating a database in Access and now adding records. I added about 50 records earlier and then saved them to my flashdrive to import the new data in navicat using the import wizard. The reason I have to save to FlashDrive is I dont have Access on the pc at work, and I dont have Navicat on my laptop. Complicated I know. Anyway, the first time I imported, I selected "Copy: Delete all records from destination and repopulate the source..Woked fine. Next time I tried to add more records, it completes and says unsuccessful. Tried many times. Can someone tell me what causes the Unsuccessful error?? Thanks for any help!

Member Avatar
pritaeas
mod_pritaeas
11,315 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 156 [?]
Moderator
Featured
Sponsor
 
0
 

What is in Navicat's log at the bottom of the import wizard ? Can you post all the lines that are in there ?

Member Avatar
teedoff
Practically a Master Poster
605 posts since Jul 2010
Reputation Points: 3 [?]
Q&As Helped to Solve: 60 [?]
Skill Endorsements: 0 [?]
 
0
 

here is the log file. Wow it's long! lol. I did notice something it says about duplicate primary keys. I'm very new to MySQL and databases in general, so not sure what all of this means. Thanks for the help!

[2010-07-23 08:03:05] [Msg] Import start
[2010-07-23 08:03:05] [Msg] Import type - MS Access database
[2010-07-23 08:03:05] [Msg] Import from - C:\ColdFusion8\wwwroot\rlb\rlb.mdb
[2010-07-23 08:03:05] [Msg] Import table [rlbbrand]
[2010-07-23 08:03:05] [Err] 1062 - Duplicate entry '1' for key 'PRIMARY'
[2010-07-23 08:03:05] [Err] INSERT INTO `rlbbrand` (`brandID`,`brandName`) VALUES ('1','Philips')
[2010-07-23 08:03:05] [Err] 1062 - Duplicate entry '2' for key 'PRIMARY'
[2010-07-23 08:03:05] [Err] INSERT INTO `rlbbrand` (`brandID`,`brandName`) VALUES ('2','Eiko'),('3','Donar'),('4','Sylvania'),('5','Hikari'),('6','GE'),('7','Osram'),('8','Kandolite'),('9','Ushio'),('10','Westinghouse'),('11','Unknown'),('12','Demo'),('13','Generic'),('14','Thorn')
[2010-07-23 08:03:05] [Err] 1062 - Duplicate entry '15' for key 'PRIMARY'
[2010-07-23 08:03:05] [Err] INSERT INTO `rlbbrand` (`brandID`,`brandName`) VALUES ('15','Halco'),('16','Perko'),('17','Narva'),('18','CEC'),('19','Import'),('20','Orbitech'),('21','Prism'),('22','Plus'),('23','EYE'),('24','Plusrite'),('25','Hosobuchi'),('26','Wagner'),('27','Carley'),('28','Welch Allyn'),('29','Nikon'),('30','Topcon')
[2010-07-23 08:03:05] [Msg] Import table [rlbbulbs]
[2010-07-23 08:03:05] [Err] 1062 - Duplicate entry '1' for key 'PRIMARY'
[2010-07-23 08:03:05] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('1','60K19/DL','1','60W, 120V, 1150 Hours, Director, E26 Medium Screw Base, 2K19/60K19/DL','1','1.88','2','10','60w','120v','AC','E26 Medium Screw','K19, 2.375\" Diameter Reflector','N/A','1150 hrs','N/A','http://replacementlightbulbs.com/lamp60K19DL.html','60 watt, watts, 120 volt, volts, Director light from Philips K19 60K19DL-120V replacement light bulb, lamp GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs lamp lamps bulb, 100K19/DL lihgt ligth lightbulb, 100K19/DL lightbulbs, 100K19/DL lamp, 100K19/DL bulb','60K19DL.jpg')
[2010-07-23 08:03:05] [Err] 1062 - Duplicate entry '2' for key 'PRIMARY'
[2010-07-23 08:03:05] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('2','100K19/DL','1','100W/120V (Med Scr) (Director) 22491-5 224915 2K19/100K19/DL-120V 1150 Hours','1','1.88','2','10','100w','120v','AC','E26 Medium Screw','K19, 2.375\" Diameter Reflector','N/A','1150 hrs','N/A','http://replacementlightbulbs.com/lamp100K19DL.html','Your light bulb resource. Lamps in stock now! Specialty Projector Lamp Resource GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs lamp lamps bulb, 100K19/DL lihgt ligth lightbulb, 100K19/DL lightbulbs, 100K19/DL lamp, 100K19/DL bulb','100KPhilips.jpg'),('3','13165','3','14V, 35W, GZ4, MR11, Dental','4','5.95','1','10','35w','14v','DC','GZ4, G4','35 DICH, MR11, MR-11','N/A','50 hrs','WD-26.5','http://replacementlightbulbs.com/lamp13165.html','13165, 14V, 35W, GZ4, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, 13165, lihgt, ligth, lightbulb, 13165 lightbulbs, 13165 lamp, 13165 bulb Philips 13165 14V 35W GZ4 Dental Lamp','bulb13165.gif'),('4','125T10P-120V','2','125W 120V T10 P28s Medium Prefocus Base 500 Hours SM-SD10 8000357 1740 Lumens C-13 BD MOL 5.75\"/146.1mm MOD 1.26\"/32mm 125T10/P LCL 2.188\"/55.6mm 125T10-P SMSD10 SM SD10 SM/SD10 Clear, SD-10','8','10.68','1','10','125w','120v','DC','P28s Medium Prefocus Base, 28mm Diameter','T-10, T10, Clear, 1¼\" Diameter','C-13, C13','500 hrs','N/A','http://replacementlightbulbs.com/lamp125t10p.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs lamp lamps bulb, 125T10P lihgt ligth lightbulb, 125T10P lightbulbs, 125T10P lamp, 125T10P bulb, 125W, 120V, T10, P28s, Medium Prefocus Base, 500 Hours, SM-SD10, 8000357, 1740 Lumens, C-13, BD, 125T10/P, 125T10-P, SMSD10, SM SD10, SM/SD10, Clear 125W 120V T10 P28s Medium Prefocus Base 500 Hours SM-SD10 8000357 125T10/P Clear','eikoTP.jpg'),('5','75K19/DL','1','75W 120V 22487-3 224873 Director Light Bulb Reflector','0.75','1.88','2','10','75w','120v','AC','E26 Medium Screw','K19, 2.375\" Diameter Reflector','N/A','1150 hrs','N/A','http://replacementlightbulbs.com/lamp75K19DL.html','digital poster posters ink jet inkjet fast laminate laminating mount mounted mounting 35mm film processing greensboro nc processed discount quality print photos develop process processing 35mm film developing image prints hour one hour process develop develope development developement image imaging imaging print color color 75 watt, watts, 120 volt, volts, Director light from Philips K19 75K19DL-120V replacement light bulb, lamp print Your light bulb resource. Lamps in stock now! Specialty Projector Lamp Resource GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs lamp lamps bulb, 100K19/DL lihgt ligth lightbulb, 100K19/DL lightbulbs, 100K19/DL lamp, 100K19/DL bulb','75K19Philips.jpg')
[2010-07-23 08:03:05] [Err] 1062 - Duplicate entry '6' for key 'PRIMARY'
[2010-07-23 08:03:06] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('6','35T3Q/CL-12V','5','G-4 12V 35W JC12V35W-G4 JC5033 Halogen','0.75','1.99','1','10','35w','12v','AC','G4, G-4, 2-Pin 4mm Apart','T-3, T3 Clear','N/A','N/A','N/A','http://replacementlightbulbs.com/lamp35T3QCL12V.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, 13165, lihgt, ligth, lightbulb','hikari35W.jpg'),('7','18845','4','replaces the 18858','8','12.98','1','10','100w','120v','AC','BA15d, Double Contact Bayonet','Clear','N/A','N/A','N/A','http://replacementlightbulbs.com/lamp18858.html','18845, 64485, 64475, 18858, 100W, 120V, Sylvania, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, lihgt, ligth, lightbulb, 18858 lightbulbs, 18858 lamp, 18858 bulb',NULL),('8','64250 HLX','7','20w/6v (2-pin/G4) (ESB)','1','2.95','1','10','20w','6v','DC',' G4, Sub-Miniature, 2-Pin, round, 7mm, 4mm apart','T-3, T3','N/A','100 hrs','N/A','http://replacementlightbulbs.com/lampESB.html','ESB, Lamp, 6 volt, 20 watt, G4 2-pin base, 6V20W, 100 hour, light bulb, bulbs, lightbulb, lightbulbs, lamps, ESB/FHE, FHE, O64250, OSRAM 64250, P7388 (Philips), PHILIPS 7388, 7388 (Philips), 64250 (Osram), Ushio 1000532, Thorn M30/ESB, S7388, M/30, Noritsu I061012-00, 409867, M30, Type 7388, PH J3 Focusline, 25678-4, JC6V20W-G4, NAED 54019-0, 012407, M30, M/30, M-30, M34, M-34, JC 6V-20W 20WM-03',NULL),('9','13117','1','37614-5 376145 17V 150W MR16 50 Dich GX5.3 1000 Hours CC-6 MOL 1.85\"/ 47mm 3200°K Burn in Any Positon 409935 Type 13117','12','25.02','1','10','150w','17v',NULL,' GX5.3, GX5,3, 2-Pin, Bi-Pin, Bipin','50 DICH, MR16, MR-16','CC-6','1000 hrs',NULL,'http://replacementlightbulbs.com/lamp13117.html','13117, 17V, 150W, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, lumen, candle, dental, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb',NULL),('10','13139','1','GZ6.35 GZ6,35 12V 75W 409799 33545-5 335455 MR16 50 DICH 1000 Hour Long Life EFN C-8','10','13.97','1','10','75w','12v',NULL,'GZ6.35, GZ6,35, 2-Pin, Bi-Pin, Bipin','50 DICH, MR16, MR-16','C-8','1000 hrs',NULL,'http://replacementlightbulbs.com/lamp13139.html','6604, 13139, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, 13165, lihgt, ligth, lightbulb, 13165 lightbulbs, 13165 lamp, 13165 bulb',NULL),('11','13288','1','22146-5 221465 13.8V 85W MR-16 50 Dich GX5.3 1000 Hours C-8 MOL 1.81\"/46mm Base Down to Horizontal Burn Positon Type 13288 FO 410252','17','20.7','1','10','85w','13.8v',NULL,'GX5.3, GX5,3, 2-Pin, Bi-Pin, Bipin','50 DICH, MR16, MR-16','C-8','1000 hrs',NULL,'http://replacementlightbulbs.com/lamp13288.html','Philips, 13288, 13.8V, 85W, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, lumen, candle, dental, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb',NULL),('12','13298','1','35436-5 354365 10V 52W MR-11 35 Dich GZ4 20 Hours CC-8 MOL 1.77\"/44.9mm Burn Positons Horizontal ±40°','12','15.53','1','10','52w','10v',NULL,'GZ4','MR11, 35 DICH, MR-11','CC-8','20 hrs',NULL,'http://replacementlightbulbs.com/lamp13298.html','13298, 10V, 52W, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, dental, lighting, light bulbs, lamp, lamps, bulb',NULL),('13','13347W','1','31453-4 314534 6V 15W T-6 BA15d 100 Hours C-6F LCL 1.75\"/44.5mm MOL 2.13\"/51.1mm 210 Lumens Horizontal Burn Position, Zeiss Standard 14','7','9.06','1','10','15w','6v',NULL,' BA15d, DC Bay, Double Contact Bayonet',' T-6, T6, .75\" Tubular','C-6F','100 hrs',NULL,'http://replacementlightbulbs.com/lamp13347w8018.html','Philips, 13347W, 8018, 6V, 15W, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, lumen, candle, dental, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb',NULL),('14','13477R',NULL,'31349-4 313494 220V 800W','12','15','1','10','800w','220v, 230v, 240v',NULL,'R7S Double Ended RSC','T3.5, T-3.5, Clear','C-8, C8','150 hrs',NULL,'http://replacementlightbulbs.com/lampeme.html','EME, 220V, 230V, 240V, 800W, P2/11, Q800T3/4CL, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb',NULL),('15','13528','1','6V 15W LV Halogen 31504-4 315044 MR11 35 DICH GZ4 500 Hours C-6 13157','10','12.95','1','10','15w','6v',NULL,'GZ4','MR11, 35 DICH','C-6','500 hrs',NULL,'http://replacementlightbulbs.com/lamp13528.html','13528, 6V, 15W, MR11, GE, Osram, Wiko, Ushio, Philips, light, Phillips, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, dental, base, lighting, light bulbs, lamp, lamps, bulb',NULL),('16','13528','3','6V, 15W, GZ4, MR11','2','5.95','1','10','15w','6v',NULL,'GZ4','MR11, 35 DICH ','C-6','500 hrs',NULL,'http://replacementlightbulbs.com/lamp13528.html','13528, 6V, 15W, MR11, GE, Osram, Wiko, Ushio, Philips, light, Phillips, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, dental, base, lighting, light bulbs, lamp, lamps, bulb',NULL),('17','13529','1','31507-7 315077 6V 9W MR11 GZ4 250 Hours C-6 MOL 1.5\"/38mm Base Down ±105° 409911 315077, Leica ATC-2000, Lieca Microscope','12','15.71','1','10','9w','6v',NULL,'GZ4','MR11, 35 DICH','C-6','250 hrs',NULL,'http://replacementlightbulbs.com/lamp13529.html','13529, 6V, 9W, MR11, GE, Osram, 13529-D, Wiko, Ushio, Philips, light, Phillips, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, dental, base, lighting, light bulbs, lamp, lamps, bulb',NULL)
[2010-07-23 08:03:06] [Err] 1062 - Duplicate entry '18' for key 'PRIMARY'
[2010-07-23 08:03:06] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('18','13529','3','6V, 9W, MR11, GZ4','2','5.95','1','10','9w','6v',NULL,'GZ4','MR11, 35 DICH','C-6','250 hrs',NULL,'http://replacementlightbulbs.com/lamp13529.html','13529, 6V, 9W, MR11, GE, Osram, 13529-D, Wiko, Ushio, Philips, light, Phillips, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, dental, base, lighting, light bulbs, lamp, lamps, bulb',NULL),('19','13865','1','26423-4 264234 12V 75W MR11 G5.3 50 Hours MOL 1.57\"/40mm Burn Base Down ±105°','17','21.57','1','10','75w','12v',NULL,'G5.3-4.8, G5,3-4,8, 2 Flat Pins','MR11, MR-11, 35DICH, 35mm Diameter','C-8, C8','50 hrs',NULL,'http://replacementlightbulbs.com/lamp64617.html','64617, Optibulb, Philips, 13865, 410719, 12V, 75W, Dental, Curing, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, dental, base, lighting',NULL),('20','14553','1','26391-3 263913 10V 52W MR11 GZ4 20 Hours MOL 1.57\"/40mm Burn Base Down ±105°','17','19.59','1','10','52w','10v',NULL,'GZ4','MR11, 35 DICH, MR-11','N/A','20 hrs',NULL,'http://replacementlightbulbs.com/lamp14553.html','14553, 10V, 52W, Dental, Curing, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, lumen, candle, dental, fixture, base, lighting, light bulbs, lamp, lamps, bulbb',NULL),('21','35MR16/Q/8/TL','6','30932 TAL417/C 12V 35W 8° Beam Spread Twist and Lock ConstantColor Constant Color Very Narrow Spot TAL 417/C GU7 No UV MR-16 35MR16/Q/8/TL-12V 3500 Hours Cover Glass/Front Glass','7','9.38','1','10','35w','12v',NULL,'GU7, TAL, TL, Twist and Lock','MR16, MR-16, Cover Glass/Front Glass','N/A','3500 hrs',NULL,'http://replacementlightbulbs.com/lamp35MR16Q8TL.html','30932, 81282, TAL417/C 12V 35W GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, 13165, lihgt, ligth, lightbulb',NULL),('22','37MR16/IR/NFL25/C-12V','4','12V 37W MR16 GU5.3 Infrared, Cover Glass','3','5.69','1','10','37w','12v',NULL,'GU5.3, GU5,3 Bi-Pin','MR16, MR-16 Cover Glass, MR16C, Front Glass, Multifaceted Reflector','Axial, AX','5000 hrs',NULL,'http://replacementlightbulbs.com/lamp58634.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, EFM lihgt, ligth, lightbulb, EFM lightbulbs, EFM lamp, EFM bulb',NULL),('23','37MR16/HIR/CG25','6','Q37MR16/HIR/CG25, 16716, RES. #4730405, ACG141XC11, 37W, Precise IR, UV Control, 25° NFL Beam, Cool Beam, 12V, Halogen Infrared','5','7.49','1','10','37w','12v',NULL,'GU5.3','MR16',NULL,'5000 hrs',NULL,'N/A',NULL,NULL),('24','37MR16/HIR/CG40','6','37W, 12V, Infrared, GU5.3, 40° Flood, MR16, 5000 Hours, CBCP 2050, 3000°K, Q37MR16/HIR/CG40','5','7.49','1','10','37w','12v',NULL,'GU5.3','MR16',NULL,'5000 hrs',NULL,'N/A',NULL,NULL),('25','41488','6','24V, 50W, MR16, 15° Spot, Constant Color Coating, Cover Glass, Precise, UV Control, Q50NR16/CCG15°, Spot 15','10','12.99','1','10','50w','24v',NULL,NULL,'MR16',NULL,'N/A',NULL,'N/A',NULL,NULL),('26','41870 WFL','8','50MR16/WFL/12V (2-Pin) 38 degrees (EXN)','0.2','0.99','1','10','50w','12v',NULL,'Min 2-Pin/GU5.3','MR16, MR-16, MR16C',NULL,'N/A',NULL,'http://replacementlightbulbs.com/lampexn.htm','EXN, 41870WFL, 41870, WFL, EXN-P, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, EXN lamp, EXN lamps, EXN bulbs, EXN light bulbs, EXN light bulb, lightbulb, lightbulbs',NULL)
[2010-07-23 08:03:06] [Err] 1062 - Duplicate entry '27' for key 'PRIMARY'
[2010-07-23 08:03:06] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('27','50MR16/Q/10/TL','6','50MR16/Q/10°/TL 50W MR16 10° Narrow Spot Turn & Lock ConstantColor® TAL TAL402 12V 30901 3500 Hours CBCP 10800 3000°K MOL 2\"/51mm C-6 UPC 043168994491 043168309011 SCC 00043168309011 TAL420/C','7','9.38','1','10','50w','12v',NULL,'GU7, TAL, TL, Twist and Lock','MR16, MR-16, Cover Glass/Front Glass, Frontglas, Frontglass, Clear','C-6','3500 hrs',NULL,'http://replacementlightbulbs.com/lamp50MR16Q10TL.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, 13165, lihgt, ligth, lightbulb, 13165 lightbulbs, 13165 lamp, 13165 bulb',NULL),('28','5761','1','30W, 6V, G4, 3200°K, 765 Lumens, 100 Hours, CF-6','3','5.85','1','10','30w','6v',NULL,'G4','Clear','CF-6','100 hrs',NULL,'http://replacementlightbulbs.com/lamp5761.html','5761, Microscope, 6V, 30W, 6V30W, GE, Osram, Wiko, Ushio, Philips, Phillips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, dental, LCD, base, lighting, light bulbs, lamp, lamps, bulb, lihgt, ligth, lightbulb',NULL),('29','58634','4','12V 37W MR16 GU5.3 Infrared, Cover Glass','3','5.69','1','10','37w','12v',NULL,'GU5.3, GU5,3 Bi-Pin','MR16, MR-16 Cover Glass, MR16C, Front Glass, Multifaceted Reflector','Axial, AX','5000 hrs',NULL,'http://replacementlightbulbs.com/lamp58634.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, EFM lihgt, ligth, lightbulb, EFM lightbulbs, EFM lamp, EFM bulb',NULL)
[2010-07-23 08:03:06] [Err] 1062 - Duplicate entry '30' for key 'PRIMARY'
[2010-07-23 08:03:06] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('30','58662','7','20W, 24V, G4 Bi-Pin, Halostar UV-Stop, UVS, HSG/TR/UB','1','2.76','1','10','20w','24v',NULL,'G-4 Bi-Pin, Sub-Miniature 2-Pins; round .7mm; 4mm apart','T-3, T3','Transversal','1000 hrs',NULL,'http://replacementlightbulbs.com/lamp64435.html','64435, 24V, 58862, 20T3Q/UVS/CL/24V, JCD24V20WH20, 20W, Bi-pin, G4, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs elc 64425 bulb 64425 light bulb 64425 bulbs lightbulb lightbulbs',NULL),('31','5972','1','31333-8 313338 6V 10W T-3 G4 200 Hours LCL .95\"/24mm MOL 1.5\"/38mm 150 Lumens 3000°K Burn in Any Position 38 61 08-0000','2','3.44','1','10','10w','6v',NULL,'G4, Miniature Bi-Pin, 2-Pin','T3, T-3, Clear, Quartz, Non UV Block','1.1mm x. 7mm','200 hrs',NULL,'http://replacementlightbulbs.com/lamp5972.html','5972, 10W, 6V, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb',NULL)
[2010-07-23 08:03:06] [Err] 1062 - Duplicate entry '32' for key 'PRIMARY'
[2010-07-23 08:03:06] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('32','62138','7','12V 100W GZ6.35 HALOGEN MEDICAL & MICROSCOPE 54026 T-3 CRI 100','5','6.11','1','10','100w','12v',NULL,'GZ6.35, GZ,6.35, GZ6, 2-Pin','T3, T-3 Clear','N/A','25 hrs',NULL,'http://replacementlightbulbs.com/lamp62138.html','digital poster posters ink jet inkjet fast laminate laminating mount mounted mounting 35mm film processing greensboro nc processed discount quality print photos develop process processing 35mm film developing image prints hour one hour process develop develope development developement image imaging imaging print color color print GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, 13165, lihgt, ligth, lightbulb, 13165 lightbulbs, 13165 lamp, 13165 bulb',NULL)
[2010-07-23 08:03:06] [Err] 1062 - Duplicate entry '33' for key 'PRIMARY'
[2010-07-23 08:03:06] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('33','64225','7','ESA 26126-3 7387 64225 54025 M/29 M29 6V 10W G4 100 Hours 200 Lumens T-2.5 3200°K Clear P-6605 8-B104','1','2.4','1','10','10w','6v',NULL,'G-4, G4 2-Pin, Sub-Miniature 2-Pins; round .7mm; 4mm apart','T2.5, Clear','C-6, 1.7mm x .65mm','100 hrs',NULL,'http://replacementlightbulbs.com/lampesa.html','ESA, FHD, 64225, M/29, 6V, 10W, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, light, bulb, replacement bulb, halogen, medical, lighting, light bulbs, lamp, lamps, bulb',NULL),('34','64255','7','20W/8V (GZX4) MR-11','12','15.14','1','10','20w','8v',NULL,'GZX4','MR11, MR-11','N/A','N/A',NULL,'http://replacementlightbulbs.com/lamp64255.html','Howtek, Scanmaster 4500, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, 64255, 64255 bulb, 64255 light bulb, 64255 bulbs, lightbulb, lightbulbs',NULL),('35','64260','7','12V 30W 38-01-20-7040 3801207040 38 01 20-7040 PG22 Special 2-Pin Base, T-3 Clear Glass, 41546, 800 Lumens, 54022, 8000216, 13077, 50 Hours, 380179-9540, 3828, 3801-20-7040, HLX64260, 40310256, 79761, 3077F9, M055129 LAMPARA, LIF: M/185, CRI 100','10','13.52','1','10','30w','12v',NULL,'PG22 Special Two-Pin Base, 2-Pin, Prefocus Flanged PG22d-b','T-3 Clear Glass','C-6, C6','50 hrs',NULL,'http://replacementlightbulbs.com/lamp64260.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, 64265, 64265 bulb, 64265 light bulb, 64265 bulbs, lightbulb, lightbulbs',NULL),('36','64265','7','30W 6V HLX64265 NAED 53999','5','6.99','1','10','30w','6v',NULL,NULL,'N/A','N/A','N/A',NULL,'http://replacementlightbulbs.com/lamp64265.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, 64265, 64265 bulb, 64265 light bulb, 64265 bulbs, lightbulb, lightbulbs',NULL),('37','64275','7','35W 6V G4 64275AX AX Axial Filament 54258 54027 Q35T3/CL-6V','3','5.03','1','10','35w','6v',NULL,'G4 G-4 2-Pin','N/A','Axial','50 hrs',NULL,'http://replacementlightbulbs.com/lamp64275.html','digital poster posters ink jet inkjet fast laminate laminating mount mounted mounting 35mm film processing greensboro nc processed discount quality print photos develop process processing 35mm film developing image prints hour one hour process develop develope development developement image imaging imaging print color color print GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, 64265, 64265 bulb, 64265 light bulb, 64265 bulbs, lightbulb, lightbulbs',NULL),('38','64318','7','6.6A, 45W, PK30d','22','25.5','1','10','45w','6.8v',NULL,'PK30d, Two Female Leads, With Female Receptacle Contact According to DIN 46247','T4, 13.5mm','1.4mm x 3.6mm','1000 hrs',NULL,'http://replacementlightbulbs.com/lamp64318.html','64318, 6.6A, 45W, PK30d, Airport, Airfield, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen',NULL),('39','64321','7','6.6A 45W J1/57 G6.35 1200 Hours 840 Lumens C-8 6.6A/45 T3.5Q 6A/45T3.5Q 58813 MOL 50mm T3.5','12','14.63','1','10','45w','6.8v',NULL,' G6.35, G6,35, G 6.35, G 6,35','T3.5, T-3.5, T3½, T-3½','C-8, C8','1200 hrs',NULL,'http://replacementlightbulbs.com/lamp64321.html','64321, 6.6A, 45W, G6.35, Airport, Airfield, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen',NULL),('40','64338','7','48W MR16 Special Base 58711 6.6A/48MR16/64338AC 1000 Hours, 64338A','28','32.18','1','10','48w','7.27v',NULL,'Special Base','MR16, MR-16','N/A','1000 hrs',NULL,'http://replacementlightbulbs.com/lamp64338.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, 64265, 64265 bulb, 64265 light bulb, 64265 bulbs, lightbulb, lightbulbs',NULL),('41','64339','7','HQI-R 150/NDX/FO 150W MH R30 AMP 42K 64339 Fiber Optic HQIR150NDX FO HQI-R150/NDL/FO','100','135.98','1','10','150w','N/A',NULL,'2 Pin Connector','R30, R-30, Clear','N/A','9000 hrs',NULL,'http://replacementlightbulbs.com/lamp64339.html','Martin, QFX150, QFX-150, 64339, Powerstar, Osram, HQI-R, 150W/NDL/FO, Made in Slovakia, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, T748, medical, Hg, 150W, Neutral White De Luxe, 4-050300-465722, 4050300465722, base, lighting, light bulbs',NULL),('42','64341 HLX','7','100W/6.6A PK30d J1/79 58709 6.6A/100T4/64341/HLX C bar 6 Filament 1000 Hours MOL 55mm w/Cable, Agfa MSC2 Scanner (Straight Leads) Airfield/Airport','20','22.5','1','10','100w','15v',NULL,'PK30d w/Cable','N/A','C bar 6','1000 hrs',NULL,'http://replacementlightbulbs.com/lamp64341.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, 64341, 64341 bulb, 64341 light bulb, 64341 bulbs, lightbulb, lightbulbs',NULL),('43','64342 HLX','7','100W/6.6A PK30d JI/80 58706 6.6A/100T4/64342/HLX 2700 Lumens C bar 6 Filament 1000 Hours MOL 58mm w/Cable, Agfa MSC2 Scanner (Straight Leads) Airfield/Airport','20','22.5','1','10','100w','15v',NULL,'PK30d','N/A','N/A','N/A',NULL,'http://replacementlightbulbs.com/lamp64342.html','digital poster posters ink jet inkjet fast laminate laminating mount mounted mounting 35mm film processing greensboro nc processed discount quality print photos develop process processing 35mm film developing image prints hour one hour process develop develope development developement image imaging imaging print color color print, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs elc64342A 64342 bulb 64342 light bulb64342 bulbs lightbulb lightbulbs',NULL),('44','64342A','7','100W/6.6A PK30d, Agfa MSC2.3 Scanner (90 degree) Airfield/Airport','30','39.38','1','10','100w','15v',NULL,'PK30d w/Female Leads','N/A','N/A','N/A',NULL,'http://replacementlightbulbs.com/lamp64342A.html','64342A, 64342, HLX, 100W, 6.6A, Airport, Agfa, Printer, Xenon, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen',NULL),('45','64361 HLX','7','150W 6.6A PK30d T-4 T4 58717 6.6A/150T4/64361/HLX 3600 Lumens C bar 6 Filament 1000 Hours MOL 58mm w/Cable Female Leads','20','22.5','1','10','150w','22.7v',NULL,'PK30d W/Female Connector','T4, T-4','C bar 6','1000 hrs',NULL,'http://replacementlightbulbs.com/lamp64361.html','Airport, Airfield, 80589, 150W, 6.6A, GE, Osram, Wiko, Ushio, Philips, light, lamp, bulb, replacement bulb, halogen, medical, lighting, light bulbs, 64361, 64361 bulb, 64361 light bulb, 64361 bulbs, lightbulb, lightbulbs',NULL),('46','64361Z','7','150W 6.6A PK30d T-4 T4 58717 6.6A/150T4/64361/HLX 3600 Lumens C bar 6 Filament 1000 Hours MOL 58mm w/Cable Male Leads','20','24.95','1','10','150w','22.7v',NULL,'PK30d',' T-4 T4','C bar 6','1000 hrs',NULL,'N/A','N/A',NULL),('47','64405-F','8','12V 5W Frosted Frost 2-Pin G4','0.75','1.49','1','10','5w','12v',NULL,'G4, G-4, 2-Pin 4mm Apart','T-3, T3 Clear','Transverse','2000 hrs',NULL,'http://replacementlightbulbs.com/lampjc12v5wg4fr.html','12V, 5W, 12V5W, Frost, frosted, JC12V5W/F, G4, 2-Pin, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, base, lighting, light bulbs, lamp, lamps, bulb, lihgt, ligth, lightbulb',NULL),('48','64405S','7','12V 5W 2-Pin G4 JCD12V5WH20 JCD H20 OS64405 T3 MOL 31mm C6 #58652 60 Lumens 4000 Hours Q5T3/CL/12V 68601 NA68601 13283 5T3Q/CL/TR 12V filiment orientation is Axial or parallel to the pins, Marine','0.75','1.99','1','10','5w','12v',NULL,'G4 2-Pin 4mm','T3, T-3, Klar, Clear','C6, C-6','4000 hrs',NULL,'http://replacementlightbulbs.com/lamp64405.html','64405S, 64405, 58652, G4, 12V, 5W, 5T3Q/CL, Sylvania, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, fixture, base, lighting, light bulbs',NULL),('49','64415-F','7','10W 12V T3 Frosted Glass G4 Bi-Pin Base 58656 Q10T3/FR/12V/G4 10T3Q/F Frost 64415/FR Halostar Halogen 2000 Hour Matt 64415F HSG/F/LP 4050300942278 4050300269047, Zeiss Stemi DB4, UV Filter Dimmable','1','2.48','1','10','10w','12v',NULL,'G4 2-Pin 4mm','T3, T-3, Frost, Frosted, Matt',NULL,'2000 hrs',NULL,'http://replacementlightbulbs.com/lamp64415f.html','64415F, 12V, 10W, Frosted, Frost, Sylvania, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, fixture, base, lighting, light bulbs',NULL),('50','64425','7','20T3Q/CL-12V Transverse Filament 2000 Hours','1','1.99','1','10','20w','12v',NULL,'G-4 Bi-Pin, Sub-Miniature 2-Pins; round .7mm; 4mm apart','T-3, T3','Transverse','2000 hrs',NULL,'http://replacementlightbulbs.com/lamp64425.html','64425, 64425s, 12V, 20W, Bi-pin, G4, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs elc 64425 bulb 64425 light bulb 64425 bulbs lightbulb lightbulbs',NULL),('51','64427S','7','12V, 20W, GY6.35, 58663, 4000 Hour, 3000°K, 320 Lumens, Axial Filament, CRI 100, Clear Glass Capsule, 20T4Q/CL/AX, Low Pressure, UV Filter, Dimmable','1','1.89','1','10','20w','12v',NULL,'GY6.35','T4, T-4, Klar, Clear','Axial, Horizontal','4000 hrs',NULL,'http://replacementlightbulbs.com/lamp64427s.html','64427S, 12V, 20W, Starlite, 58663, 20T4Q/CL/AX, GE, Halogen, Sylvania, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, fixture, base, lighting, light bulbs',NULL),('52','64432','7','12V, 35W, GY6.35','1','1.8','1','10','35w','12v',NULL,'GY6.35','N/A','N/A','N/A',NULL,'N/A','N/A',NULL),('53','64432S','7','12V, 35W, Halostar, Starlite, 58672, 4000 Hour, 3000°K, 600 Lumens, Axial Filament, CRI 100, Clear Glass Capsule, 35T4Q/CL/AX, Low Pressure, UV Filter, Dimmable, 2-Pin GY6.35, 35T4QCLAX, 64432-AX, GY6,35, 40-50300-017426, M75','1','1.89','1','10','35w','12v',NULL,'2-Pin GY6.35','Clear Glass Capsule','Axial','4000 hrs',NULL,'N/A','N/A',NULL),('54','64432-IRC','7','12V, 35W, IRC, 64432IRC','3','5.63','1','10','35w','12v',NULL,'N/A','N/A','N/A','N/A',NULL,'N/A','N/A',NULL)
[2010-07-23 08:03:06] [Err] 1062 - Duplicate entry '55' for key 'PRIMARY'
[2010-07-23 08:03:06] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('55','64435u','7','20W, 24V, G4 Bi-Pin, Halostar UV-Stop, UVS, HSG/TR/UB','1.5','2.76','1','10','20W','24V',NULL,'G-4 Bi-Pin, Sub-Miniature 2-Pins; round .7mm; 4mm apart','T-3, T3','Transverse','1000 hrs',NULL,'http://replacementlightbulbs.com/lamp64435.html','64435, 24V, 58862, 20T3Q/UVS/CL/24V, JCD24V20WH20, 20W, Bi-pin, G4, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs elc 64425 bulb 64425 light bulb 64425 bulbs lightbulb lightbulbs',NULL)
[2010-07-23 08:03:06] [Err] 1062 - Duplicate entry '56' for key 'PRIMARY'
[2010-07-23 08:03:06] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('56','64440','7','50T4Q/CL-12V ( 2-Pin/GY6.35)','1','1.49','1','10','50w','12v',NULL,'GY 6,35, 2-Pin GY6.35 ','T-4, T4',NULL,'2000 hrs',NULL,'http://replacementlightbulbs.com/lamp50T4QCL-12V.html','64440, Leica, 500182, Olympus, 8C402, Guerra, 6419/AX7, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, hlx, base, lighting, light bulbs, 64440, 50T4QCL-12V, Bulb, lamp, light bulb, lightbulb, lightbulbs',NULL),('57','64440-IRC','7','50W, 12V, IRC, 64440IRC','3','5.63','1','10','50w','12v',NULL,'N/A','N/A','N/A','N/A',NULL,'N/A','N/A',NULL),('58','64445U','7','24V 50W 64445 64445-U UV Stop 2000 Hours GY6.35 50T4Q/CL/AX/24V Halostar 335544 HSGT/UB-50-24-GY6,35-15 900 Lumens 58678 3000°K CRI 100 T-4 Clear Glass MOD 12mm, MOL 1.75\"/44.5mm LCL 1.12\"/28.6mm 750228, 4050300335544, FS1, Axial Filament, ILCOS HGS/C/UB-50-24-GY6,35-12/30, 4050300942414','3','3.6','1','10','50w','24v',NULL,'GY6.35 Bi-Pin','T-4, Clear, T4','Axial','2000 hrs',NULL,'http://replacementlightbulbs.com/lamp64445u24v50w.html','64445, 64445U, 24V, 58678, 20T3Q/UVS/CL/24V, JCD24V20WH20, 20W, Bi-pin, G4, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs elc 64425 bulb 64425 light bulb 64425 bulbs lightbulb lightbulbs',NULL),('59','64447-IRC','7','12V, 65W, IRC Infrared Coating, 65W = 90W Energy Saving Bulb, 1700 Lumens, Halostar ES, GY6.35, UV Filter','8','9.83','1','10','65w','12v',NULL,'GY6.35','N/A','N/A','N/A',NULL,'N/A','N/A',NULL),('60','64473','7','75W, 230V, BA15d/SBC, Double Contact Base with Ceramic Extension, Halolux Ceram','6','7.05','1','10','75w','230v',NULL,'BA15d/SBC, Double Contact Base with Ceramic Extension','N/A','N/A','N/A',NULL,'N/A','N/A',NULL),('61','64485','7','100W, 120V, BA15d/SBC, Double Contact Base with Ceramic Extension','10','12.98','1','10','100w','120v',NULL,'BA15d, Double Contact Bayonet','Clear','N/A','N/A',NULL,'http://replacementlightbulbs.com/lamp18858.html','18845, 64485, 64475, 18858, 100W, 120V, Sylvania, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, lihgt, ligth, lightbulb, 18858 lightbulbs, 18858 lamp, 18858 bulb',NULL),('62','64501','7','54001, 120V, 150W, GX6.35','9','10.88','1','10','150w','120v',NULL,'GX6.35','N/A','N/A','N/A',NULL,'N/A','N/A',NULL),('63','64502','7','230V 150W GX6.35 T4','7','8.25','1','10','150w','230v',NULL,'2-Pin/GX6.35, GX6,35, GX 6,35, G6,35, G6.35','T4, T-4, Clear',NULL,'25 hrs',NULL,'http://replacementlightbulbs.com/lamp64502.html','digital poster posters ink jet inkjet fast laminate laminating mount mounted mounting 35mm film processing greensboro nc processed discount quality print photos develop process processing 35mm film developing image prints hour one hour process develop develope development developement image imaging imaging print color color print, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, 64514, 64514 bulb, 64514 light bulb, 64514 bulbs, lightbulb, lightbulbs',NULL),('64','64512','7','300W/120V (2-Pin/GX6.35) (FNS) 15 Hours 9500 Lumens','7','8.03','1','10','300w','115-120v',NULL,'2-Pin/GX6.35','N/A','9.5mm x 9.8mm','15 hrs',NULL,'http://replacementlightbulbs.com/lampfns.html','FNS, 64512, 120V, 300W, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, stage, stage studio, studio, lumen, theater, night club, display, base, lighting, light bulbs, lightbulb, lightbulbs',NULL),('65','64514','7','300W/120V (2-Pin/GX6.35) 75 Hours 7700 Lumens','7','8.25','1','10','300w','120v',NULL,'2-Pin/GX6.35','N/A','9.5mm x 10mm','75 hrs',NULL,'http://replacementlightbulbs.com/lamp64514.html','64514, 120V, 300W, Lamp, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, 64514, 64514 bulb, 64514 light bulb, 64514 bulbs, lightbulb, lightbulbs',NULL),('66','64514','3','300W, 120V, GX6.35, 75 Hours, 7700 Lumens','1','2.49','1','10','300w','120v',NULL,'2-Pin/GX6.35','N/A','9.5mm x 10mm','75 hrs',NULL,'http://replacementlightbulbs.com/lamp64514.html','64514, 120V, 300W, Lamp, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, 64514, 64514 bulb, 64514 light bulb, 64514 bulbs, lightbulb, lightbulbs',NULL)
[2010-07-23 08:03:06] [Err] 1062 - Duplicate entry '67' for key 'PRIMARY'
[2010-07-23 08:03:06] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('67','64515','7','300W, 240V, 58524, GX6.35, 3400°K, P1/23, EAN 4008321098719, 4008321098726','8','9.75','1','10','300w','240v',NULL,'GX6.35','N/A','N/A','N/A',NULL,'N/A','N/A',NULL),('68','64535','7','650W/120V (2-Pin/GX6.35) JCV120V-650WC EGW','12','14.95','1','10','650w','120v',NULL,'2-Pin/GX6.35','T8, T-8','14mm x 15mm','15 hrs',NULL,'http://replacementlightbulbs.com/lamp64535.html','64535, 120V, 650W, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs elc 64535 bulb 64535 light bulb 64535 bulbs lightbulb lightbulbs',NULL),('69','64535','3','650W, 120V, GX6.35','6.5','7.48','1','10','650w','120v',NULL,'2-Pin/GX6.35','T8, T-8','14mm x 15mm','15 hrs',NULL,'http://replacementlightbulbs.com/lamp64535.html','64535, 120V, 650W, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs elc 64535 bulb 64535 light bulb 64535 bulbs lightbulb lightbulbs',NULL),('70','64573','7','Discontinued-Limited Stock Available, 58639, 1000W, 120V, GX6.35, GX6,35, 15 Hours, 33000 Lumens, 3400°K, For 230V use 64576','20','25','1','10','1000w','120v',NULL,'2-Pin/GX6.35, GX6,35','N/A','14x14mm','15 hrs',NULL,'http://replacementlightbulbs.com/lamp64573.html','64573, 1000W, 120V, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs elc 64535 bulb 64535 light bulb 64535 bulbs lightbulb lightbulbs',NULL),('71','64576','7','230V, 1000W, P2/17, GX6.35, GX6,35, 75 Hours, 27500 Lumens, 3200°K, Universal Burn Position, MOD 24mm, MOL 67.5mm, LCL 38mm, Filament 14x14mm For 120V use 64573','19','21.75','1','10','1000w','230v',NULL,'P2/17, GX6.35, GX6,35','N/A','14x14mm','75 hrs',NULL,'N/A','N/A',NULL),('72','64610 HLX','7','50W, 12V, Glass 2-pin, G6.35, BRL, MacBeth Transmission','1','2.55','1','10','50w','12v',NULL,'2-pin/G6.35, G,6.35','T3.5, T-3.5, Tubular T3½','C-6, C6','50 hrs',NULL,'http://replacementlightbulbs.com/lampbrl.html','BRL, 64610, 12V, 50W, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, BRL lihgt, ligth, lightbulb, BRL lightbulbs, BRL lamp, BRL bulb',NULL),('73','64611','7','12V, 50W','3','5.75','1','10','50w','12v',NULL,'N/A','N/A','N/A','N/A',NULL,'N/A','N/A',NULL),('74','64615 HLX','7','75W, 12V, 2-Pin, GZ6.35, MR16, EFN, KIS','6','7.79','1','10','75w','12v',NULL,'2-Pin/GZ6.35, GZ6,35','MR16','N/A','50 hrs',NULL,'http://replacementlightbulbs.com/lampefn.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, efn, 64615, efn lihgt, ligth, lightbulb, efn lightbulbs, efn lamp, efn bulb',NULL),('75','64617','7','12V 75W 54154 G5.3-4.8 25 Hours p90/15 MR11','10','11.99','1','10','75w','12v',NULL,'G5.3-4.8, G5,3-4,8, 2 Flat Pins',' MR11, MR-11, 35DICH, 35mm Diameter','C-8, C8','50 hrs',NULL,'http://replacementlightbulbs.com/lamp64617.html','64617, Optibulb, Philips, 13865, 410719, 12V, 75W, Dental, Curing, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, dental, base, lighting',NULL),('76','64623 HLX','7','100W, 12V, 2-Pin, GY6.35, EVA, Gretag 3141','2','3.89','1','10','100w','12v',NULL,'2-Pin/GY6.35','T-3.5, T3.5, T3½',' C-6F','2000 hrs',NULL,'http://replacementlightbulbs.com/lampeva.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, EVA lihgt, ligth, lightbulb, EVA lightbulbs, EVA lamp, EVA bulb',NULL),('77','64624','7','12V 100W JCR/M-12V100W 644358 03624 C-8 MOL 1.46\"/37mm MOD 1.41\"/35.8mm 50 Hours MR11 G5.3','11','13.79','1','10','100w','12v',NULL,'G5.3-4.8, G5,3-4,8, 2 Flat Pins',' MR11, MR-11, 35DICH, 35mm Diameter','C-8, C8','25 hrs',NULL,'http://replacementlightbulbs.com/lamp64624.html','64624, Dental, 12V, 100W, JCR/m12V100W, 3021, 3961, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, dental, lighting, light bulbs, lamp, lamps, bulb, lihgt, ligth, lightbulb, lightbulbs',NULL)
[2010-07-23 08:03:06] [Err] 1062 - Duplicate entry '78' for key 'PRIMARY'
[2010-07-23 08:03:07] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('78','64625 HLX','7','100W/12V (GY6.35/2 Pin) (FCR) A1/215','1','2.49','1','10','100w','12v',NULL,'GY6.35; also known as: Glass, 2-Pins round 1mm; 6.35mm apart','T3, T-3','CBAR6','50 hrs',NULL,'http://replacementlightbulbs.com/lampfcr.html','GE, Wiko, Ushio, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, base, lighting, P7158, 7158, Philips, Osram, 190600, Efos 4075, fcr, light, bulb, 64625, lamp, lamps, bulbs, light bulbs, light bulb, lightbulb, lightbulbs',NULL)
[2010-07-23 08:03:07] [Err] 1062 - Duplicate entry '79' for key 'PRIMARY'
[2010-07-23 08:03:07] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('79','64627 HLX','7','100W, 12V, MR16, 2-Pin, GZ6.35, EFP','6','7.2','1','10','100w','12v',NULL,'2-Pin/GZ6.35','MR16 Dichroic','N/A','50 hrs',NULL,'http://replacementlightbulbs.com/lampefp.html','EFP, 12V, 100W, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, dental, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, efp, efp lihgt, ligth, lightbulb, efp lightbulbs, efp lamp, efp bulb',NULL),('80','64633 HLX','7','BRJ/EVB 150W 15V 54250 54039 G6.35 50 Hours A1/234 5600 Lumens, Medical & Microscope','2.5','3.99','1','10','150w','15v',NULL,'2-pin/G6.35, G6,3.5, Bi-Pin, Bipin','T3, T-3, Clear','N/A','50 hrs',NULL,'http://replacementlightbulbs.com/lampbrj.html','digital poster posters ink jet inkjet fast laminate laminating mount mounted mounting 35mm film processing greensboro nc processed discount quality print photos develop process processing 35mm film developing image prints hour one hour process develop develope development developement image imaging imaging print color color print, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, BRL lihgt, ligth, lightbulb, BRL lightbulbs, BRL lamp, BRL bulb',NULL),('81','64634 HLX','7','150W/15V (2-Pin/GZ6.35) (EFR)','5.5','6.95','1','10','150w','15v',NULL,'2-Pin/GZ6.35','N/A','N/A','50 hrs',NULL,'http://replacementlightbulbs.com/lampefr.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, efr, efr lihgt, ligth, lightbulb, efr lightbulbs, efr lamp, efr bulb',NULL),('82','64637','7','JCR12V100W/15H/5 1500 Hour, EFP/LL, 54214, MR16, GZ6.35, Burn Position S120, A1/271, 130259, 1000941, 6834-15H, 12-100-27LR','12','15','1','10','100w','12v',NULL,'GZ6.35','MR16','N/A','1500 hrs',NULL,'N/A','N/A',NULL),('83','64638 HLX','7','100W/24V (Glass 2-Pin/G6.35)','6','7.28','1','10','100w','24v',NULL,' G6.35, G6,35','Clear, T4, T-4','C-BAR-6, CBAR6','300 hrs',NULL,'http://replacementlightbulbs.com/lamp64638.html','64638, 24v, 100w, Dental, Surgical, Halogen, 24V, 100W, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, dental, lighting, light bulbs, lamp, lamps, bulb, lihgt, ligth, lightbulb, lightbulbs',NULL),('84','64640 HLX','7','150W/24V (Glass 2-Pin/G6.35) (FCS) A1/216','1','2.5','1','10','150w','24v',NULL,'G6.35 Miniature 2-Pins; round 1mm, 6.35mm apart, -Pin/G6.35 G6,35-15','T-4, T4','CBAR6, C-6F','50 hrs',NULL,'http://replacementlightbulbs.com/lampfcs.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, lamp, lamps, bulb, FCS lihgt, ligth, lightbulb, FCS lightbulbs, FCS lamp, FCS bulb',NULL),('85','64642 HLX','7','150W/24V 2-Pin/G6.35 FDV, Kodak Class \r\nDigital Film Scanner','2.5','3.89','1','10','150w','24v',NULL,'2-Pin/G6.35','N/A','N/A','300 hrs',NULL,'http://replacementlightbulbs.com/lampfdv.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, FDV 64642, FDV 64642 bulb, FDV 64642 light bulb, FDV 64642 bulbs, lightbulb, lightbulbs',NULL)
[2010-07-23 08:03:07] [Err] 1062 - Duplicate entry '86' for key 'PRIMARY'
[2010-07-23 08:03:07] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('86','64653 HLX','7','250W/24V (2-Pin) MR16 ELC, Copal, Kodak 40, 75, Noritsu QSS, Creation Station','6','7.95','1','10','250w','24v',NULL,'GX5.3; also known as: Miniature 2-pins; round','MR-16. MR16','CC-6, CC6','50 hrs',NULL,'http://replacementlightbulbs.com/lampelc.htm','ELC, ELC Light Bulb, ELC 24V 250W, 19.7V, 200W, 183W, 220W, HI-111, Fiber Star, GE, Osram, Wiko, Ushio, Philips, light, replacement bulb, ELC lamp, lighting, halogen, medical, stage, studio, theater, night club, dental, display, lighting, lamps, bulbs, light bulbs, light bulb, lightbulb, lightbulbs, POOL, SPA, hi-110, HI111, HI110, lights, lighting, FiberStar Fiber Optics, swimming pool',NULL),('87','64655 HLX','7','250W/24V 2-Pin/G6.35, EHJ, Oriental','1','2.93','1','10','250w','24v',NULL,'G6.35','T4, T-4','C-6F','50 hrs',NULL,'http://replacementlightbulbs.com/lampehj.html','GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, ehj lamp, ehj lamps, ehj bulbs, ehj light bulbs, ehj light bulb, lightbulb, lightbulbs',NULL),('88','64657 HLX','7','250W, 24V, 2-Pin/G6.35, EVC/FGX, Agfa Minilab, Agfa Dimax Scan, 3141 Print Lamp','2','3.74','1','10','250w','24v',NULL,'2-Pin/G6.35','N/A','N/A','300 hrs',NULL,'http://replacementlightbulbs.com/lampevc.html','EVC, FGX, 24V, 250W, M33, 6958, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs, EVC/FGX 64657, EVC/FGX 64657 bulb, EVC/FGX 64657 light bulb, EVC/FGX 64657 bulbs, lightbulb, lightbulbs',NULL)
[2010-07-23 08:03:07] [Msg] Processed:118, Added:0, Updated:0, Deleted:0, Errors:118
[2010-07-23 08:03:07] [Msg] Finished - Unsuccessfully

Member Avatar
pritaeas
mod_pritaeas
11,315 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 156 [?]
Moderator
Featured
Sponsor
 
0
 

You are trying to insert records where the id (bulbID and brandID I guess) is already in the database. Since this is a primary key field, it is not allowed to be added again. It should be possible to not import this id field, but then you would probably get duplicate records in your database.

Member Avatar
teedoff
Practically a Master Poster
605 posts since Jul 2010
Reputation Points: 3 [?]
Q&As Helped to Solve: 60 [?]
Skill Endorsements: 0 [?]
 
0
 

Hmmm ok so is there a solution? I mean from what you said I olny have two choices? Import and deal with the errors, which after about 4 or 5 times importing, all the records seem to get imported, or not import the primary key records and have duplicate records.

Member Avatar
teedoff
Practically a Master Poster
605 posts since Jul 2010
Reputation Points: 3 [?]
Q&As Helped to Solve: 60 [?]
Skill Endorsements: 0 [?]
 
0
 

There should be an easier way to enter all this data. I know you can import several different file types into databases, but what I have is an html table on a website with thousands of products listed. When I tried to import this table into Access, and I tried using delimiters and others like tabs and breaks, it put all the text into one column. Isn't there a way I can do this?? If anyone would like to look at the table I'm trying to create a DB for, go here and let me know if there's something I can do.

http://replacementlightbulbs.com/lampsphoto.htm

Member Avatar
pritaeas
mod_pritaeas
11,315 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 156 [?]
Moderator
Featured
Sponsor
 
0
 

I think you can best parse it with a text editor to strip out all tags, and create a csv of it. Any text editor supporting regex replace can do it.

Member Avatar
teedoff
Practically a Master Poster
605 posts since Jul 2010
Reputation Points: 3 [?]
Q&As Helped to Solve: 60 [?]
Skill Endorsements: 0 [?]
 
0
 

thanks for all the help pritaeas! Now one more question if you dont mind. I've pretty much gotten everything to work, but now I get another error. I have 214 records in my database, but when I pull it up in my webpage, there are 2 missing. When I do an import from Access to Navicat, I get two errors that say 1406 data too long for column 'description' at row 1.

Not sure what this means. I changed the data type in the Description column to memo, because the text type only allows for 255 a few days ago. Still confused as the first row in in the table when I pull it up in my browser. ANy ideas and suggestions are greatly appreciated! Thanks.

Member Avatar
teedoff
Practically a Master Poster
605 posts since Jul 2010
Reputation Points: 3 [?]
Q&As Helped to Solve: 60 [?]
Skill Endorsements: 0 [?]
 
0
 

here is the error log...sorry didnt post it in the last posting

[2010-07-26 09:52:32] [Msg] Import start
[2010-07-26 09:52:32] [Msg] Import type - MS Access database
[2010-07-26 09:52:32] [Msg] Import from - C:\ColdFusion8\wwwroot\rlb\rlb.mdb
[2010-07-26 09:52:32] [Msg] Import table [rlbbrand]
[2010-07-26 09:52:34] [Msg] Import table [rlbbulbs]
[2010-07-26 09:52:36] [Err] 1406 - Data too long for column 'description' at row 1
[2010-07-26 09:52:36] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('58','64445U','7','24V 50W 64445 64445-U UV Stop 2000 Hours GY6.35 50T4Q/CL/AX/24V Halostar 335544 HSGT/UB-50-24-GY6,35-15 900 Lumens 58678 3000°K CRI 100 T-4 Clear Glass MOD 12mm, MOL 1.75\"/44.5mm LCL 1.12\"/28.6mm 750228, 4050300335544, FS1, Axial Filament, ILCOS HGS/C/UB-50-24-GY6,35-12/30, 4050300942414','3','3.6','1','10','50w','24v',NULL,'GY6.35 Bi-Pin','T-4, Clear, T4','Axial','2000 hrs',NULL,'http://replacementlightbulbs.com/lamp64445u24v50w.html','64445, 64445U, 24V, 58678, 20T3Q/UVS/CL/24V, JCD24V20WH20, 20W, Bi-pin, G4, GE, Osram, Wiko, Ushio, Philips, light, light bulb, replacement bulb, replacement lamp, lighting, light, lamp, bulb, replacement bulb, halogen, medical, stage, stage studio, studio, lumen, candle, theater, night club, dental, LCD, display, fixture, base, lighting, light bulbs elc 64425 bulb 64425 light bulb 64425 bulbs lightbulb lightbulbs',NULL)
[2010-07-26 09:52:40] [Err] 1406 - Data too long for column 'description' at row 1
[2010-07-26 09:52:40] [Err] INSERT INTO `rlbbulbs` (`bulbID`,`item`,`brandID`,`description`,`cost`,`price`,`qtyPerPrice`,`qtyInStock`,`wattage`,`voltage`,`acDC`,`base`,`glass`,`filament`,`avgLife`,`beamAngle`,`oldPage`,`keyWords`,`image1`) VALUES ('186','DVH','6','750W 130V 22117 1000 Hour 750T24/16 14800 Lumens Medium Bi-Post Base 9.18 Inches, 234mm Maximum Overall Length C-13 Filament Inside Frost, Lamp is made of heat resistant glass (HRG). Operate base up, within 30° of vertical. Collector grid. Insertion in \"twist-in\" type sockets requires only a slight clockwise turn - excessive force may break the bulb.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
[2010-07-26 09:52:42] [Msg] Processed:244, Added:117, Updated:0, Deleted:0, Errors:2
[2010-07-26 09:52:42] [Msg] Finished - Unsuccessfully

Member Avatar
pritaeas
mod_pritaeas
11,315 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 156 [?]
Moderator
Featured
Sponsor
 
0
 

Apparantly the description is too long for the database. If I copy/paste it in my editor it reports the length of about 280/290 chars. So you'd best change your mySql table.

Member Avatar
teedoff
Practically a Master Poster
605 posts since Jul 2010
Reputation Points: 3 [?]
Q&As Helped to Solve: 60 [?]
Skill Endorsements: 0 [?]
 
0
 

Apparantly the description is too long for the database. If I copy/paste it in my editor it reports the length of about 280/290 chars. So you'd best change your mySql table.

Change it in what way? Again, I'm not very familiar with databases, but especially with MySQL. I know the basics of Access, but not sure how to change what you're talking about. I thought that by setting the data type to memo, that would accomodate the long descriptions column.

Member Avatar
teedoff
Practically a Master Poster
605 posts since Jul 2010
Reputation Points: 3 [?]
Q&As Helped to Solve: 60 [?]
Skill Endorsements: 0 [?]
 
0
 

Nevermind. lol I figured it out! I saw the design table option in navicat and then changed the type to "longtext".. Then ran the import wizard and the last 2 records were added! Thanks so much for all your help!

Question Answered as of 3 Years Ago by pritaeas
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: