stoneelsie / google-refine

Automatically exported from code.google.com/p/google-refine
Other
0 stars 0 forks source link

CSV import fails to load row when the first column of that row is empty #484

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Create new project with attached bad.csv as the data file or use a csv that 
has a row with an empty first column
2. Use the default advanced options and create the project
3. The second row does not import correctly and the row count is only 4

What is the expected output? What do you see instead?
I expect refine to detect 5 rows and correctly display the second row (the 
second row is missing the ordinal number in the left column)

What version of Google Refine are you using?
Version 2.1 [r2136]

What operating system and browser are you using?
Ubuntu 11.10 Firefox 7.0.1

Is this problem specific to the type of browser you're using or it happens
in all the browsers you tried?
All browsers

I've attached bad_csv.png to show the broken second row that appears when the 
row does not have a value in the first column and the incorrect row count.

Original issue reported on code.google.com by c...@christophermanning.org on 17 Nov 2011 at 6:30

Attachments:

GoogleCodeExporter commented 8 years ago
Refine interprets leading blank cells as a poor man's record format (so you 
could have a column with multiple values per "record").

If below where it says "4 records", you click on "Show as: rows" the display 
will switch to row mode and you'll see it say "5 rows" and update the display 
accordingly.

If I misinterpreted what you need, feel free to reopen the bug report.

Original comment by tfmorris on 18 Nov 2011 at 12:15