This CSV file has two columns and about a dozen rows.
What happens on import is that the column names AND the data get treated as field names.
So I end up with an empty table with 20 or so fields:

Field  	Type  	Collation  	Attributes  	Null  	Default  	Extra  	Action
	Region 	longtext 	utf8_general_ci 		Yes 	NULL 		Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	EMail_4 	longtext 	utf8_general_ci 		Yes 	NULL 		Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	dummyname_bbc_co_uk_8 	longtext 	utf8_general_ci 		Yes 	NULL 		Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	dummyname_oup_com_6 	longtext 	utf8_general_ci 		Yes 	NULL 		Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	dummyname_digitalvillage_co_uk_4 	longtext 	utf8_general_ci 		Yes 	NULL 		Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	dummyname_youthmusic_org_uk_5 	longtext 	utf8_general_ci 		Yes 	NULL 		Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	dummyname_normans_co_uk_4 	longtext 	utf8_general_ci 		Yes 	NULL 		Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	dummyname_sibelius_com_4 	longtext 	utf8_general_ci 		Yes 	NULL 		Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	dummyname_club_europe_co_uk_8 	longtext 	utf8_general_ci 		Yes 	NULL 		Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	

This is a different effect from http://drupal.org/node/590050, but I'm guessing the same cause.

CommentFileSizeAuthor
table_wizard_sideways_excel.csv_.txt361 bytesjoachim

Comments

mikeryan’s picture

Status: Active » Closed (duplicate)

This is clearly a line-ending issue - please review #590050: CSV import needs to handle incompatible line endings.