Project

General

Profile

Actions

Bug #271

closed

CSV Import Problems

Added by Chuck Burton over 12 years ago. Updated about 12 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
Start date:
08/09/2012
Due date:
% Done:

0%

Estimated time:
Chirp Version:
daily
Model affected:
(All models)
Platform:
All
Debug Log:
I read the instructions above:

Description

I have figured out why some users (see Bug #125, entries 4 & 5) cannot load CSV files and obtain a "new-line character seen" error. It turns out that you are assuming a Windows CSV file, which terminates lines with a CR/LF (0x0D/0x0A) character pair. Linux and Mac OSX terminate lines with just a CR (0x0D) character. If you adjust your code to accept both line terminations, things should start working for all the O/Ss.


Files

CSV-ReadError.jpg (53.1 KB) CSV-ReadError.jpg Chuck Burton, 08/09/2012 12:53 PM
Test1.csv (271 Bytes) Test1.csv Chuck Burton, 08/09/2012 03:21 PM
Test2.csv (240 Bytes) Test2.csv Chuck Burton, 08/09/2012 03:21 PM
Test2Error.jpg (49.3 KB) Test2Error.jpg Chuck Burton, 08/09/2012 03:21 PM
Actions #1

Updated by Tom Hayward over 12 years ago

I can't reproduce this. I'm on OS X and files with both newline formats open without issue.

Updated by Chuck Burton over 12 years ago

I am running OS X 10.6.8 and Chirp20120730.app. Test1.csv loads in Chirp just fine, but Test2.csv provides the error (Test2Error.jpg).

Actions #3

Updated by Chuck Burton over 12 years ago

Oops, for got to tell you that Test1.csv has CR/LF terminating the lines. While Test2.csv is the same as Test1, but only has CR terminating the lines.

Actions #4

Updated by Tom Hayward over 12 years ago

  • Status changed from New to In Progress
  • Assignee set to Tom Hayward
  • Target version set to 0.2.3

Oh, I guess I didn't read carefully enough. I tried Windows and Unix newlines (\r\n and \n). This is old Mac format (\r). We should be able to support it...

Actions #5

Updated by Tom Hayward over 12 years ago

Almost forgot to ask... which MRA group are you with? I am with http://larimercountysar.org

Actions #6

Updated by Chuck Burton over 12 years ago

I'm with Chaffee County North (most 14ers in the US).

Actions #7

Updated by Tom Hayward about 12 years ago

  • Status changed from In Progress to Closed

Fixed last week.

Actions

Also available in: Atom PDF