Closed (duplicate)
Project:
Table Wizard
Version:
6.x-1.1
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
1 Oct 2009 at 13:09 UTC
Updated:
7 Oct 2009 at 00:35 UTC
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.
| Comment | File | Size | Author |
|---|---|---|---|
| table_wizard_sideways_excel.csv_.txt | 361 bytes | joachim |
Comments
Comment #1
mikeryanThis is clearly a line-ending issue - please review #590050: CSV import needs to handle incompatible line endings.