|
|
carbiz wrote:
This is the new error I am getting:
Invalid field count in CSV input on line 3
Now the csv file only contains 2 records when I import it, but the csv file
contains a total of 38 records. Here is what it shows. I don't understand why
all the records wont come thru.
CREATE TABLE `handheld` (
`SKU` varchar(10) NOT NULL,
`Title` varchar(50) NOT NULL,
`Short Desc` varchar(100) NOT NULL,
`Price` varchar(15) NOT NULL,
`Shipping Weight` varchar(15) NOT NULL,
`Long Desc` text NOT NULL,
PRIMARY KEY (`SKU`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `handheld`
--
INSERT INTO `handheld` (`SKU`, `Title`, `Short Desc`, `Price`, `Shipping
Weight`, `Long Desc`) VALUES
('14253', 'GPS HANDHELD', 'GARMIN ETREX LEGEND HANDHELD GPS', '157.99', '1
Lb', 'With the eTrex Legend, Garmin has loaded a full basemap of North and
South America into one small unit. The Legend is also designed to provide
precise GPS positioning using correction data obtained from the Wide Area
Augmentation System (WAAS). This product will provide position accuracy to less
than three meters when receiving WAAS corrections. <br><br>The basemap contains
lakes, rivers, cities, interstates, national and state highways, railroads and
coastlines. The eTrex Legend is also equipped with additional memory totaling
eight megabytes. The added memory allows the eTrex Legend to accept downloaded
map data from Garmin''s entire line of MapSource CD-ROMs, including U.S.
Recreational Lakes with Fishing Hot Spots. The eTrex Legend comes in a
brightly-colored translucent blue case that really makes the unit stand out.
New to the product design, Garmin will include marine aids to navigation in
addition to the basemap. These navigational aids will be pre-loaded into each
unit from the factory. '),
('14254', 'GPS HANDHELD', 'GARMIN ETREX VISTA HANDHELD GPS', '199.99', '1 lb',
'The eTrex Vista combines a basemap of North and South America, with a
barometric altimeter and electronic compass. The compass provides bearing
information while you''re standing still and the altimeter determines your
precise altitude. The Vista is also designed to provide precise GPS positioning
using correction data obtained from the Wide Area Augmentation System (WAAS).
This product will provide position accuracy to less than three meters when
receiving WAAS corrections. <br><br>The eTrex Vista also boasts an internal
memory capacity of 24 megabytes, which allows it to accept downloaded mapping
data from Garmin''s MapSource CD-ROMs, including U.S. Recreational Lakes with
Fishing Hot Spots. A silver case gives this unit a high-tech look. New to the
product design, Garmin will include marine aids to navigation in addition to
the basemap. These navigational aids will be pre-loaded into each unit from the
factory. <br>');
Your long description text has comma's in it, so your import then thinks
there is another field, which is where the mismatch is coming from. Do
as Murray suggested and use ; as your delimiter, not the '
Dooza
--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html
|
|