macromedia.dreamweaver.appdev
[Top] [All Lists]

Re: Invalid field count in CSV input on line 1.

Subject: Re: Invalid field count in CSV input on line 1.
From: Dooza
Date: Tue, 16 Dec 2008 17:13:44 +0000
Newsgroups: macromedia.dreamweaver.appdev


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

<Prev in Thread] Current Thread [Next in Thread>