[Bug 261128] New: import skips empty field in csv file (different than other bug - 243405)

[Robert Simmons]

https://bugs.kde.org/show_bug.cgi?id=261128

           Summary: import skips empty field in csv file (different than
                    other bug - 243405)
           Product: kaddressbook
           Version: unspecified
          Platform: Ubuntu Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
        AssignedTo: kdepim-bugs at kde.org
        ReportedBy: rsimmons0 at gmail.com
                CC: tokoe at kde.org


Created an attachment (id=55206)
 --> (http://bugs.kde.org/attachment.cgi?id=55206)
csv file with one complete entry and one with empty fields

Version:           unspecified (using KDE 4.5.4) 
OS:                Linux

When I try to import a csv file from outlook (or openoffice.org) the blank
fields are skipped and subsequent fields are shifted left and end up in the
wrong column as seen in the preview.  I attribute this to the import code not
parsing the data properly.  The blank fields are completely empty in the csv. 
They do not have a "".  It seems like the import wants "" in blank fields to
consider them blank rather than non-existant.  Please try to import the
attached file for an example.  I would skip using "" or '' when I save the csv,
but I have data in the Notes field in many of my 1000+ entries that requires
either ' or ".  I will massage the csv file with a perl script to make the
import happy, but it should be able to parse this type of csv seeing as it is
the only way that Ooo _and_ Outlook save their csv files.

Reproducible: Always

Steps to Reproduce:
Open KAddressBook or Kontact
In the "File" menu select "Import" then "Import CSV file..."
Enter my test.csv file in the "File to import"
Look at the preview: The first person is ok, and the second has the email
address in the wrong column.  Both people are deliberately simplified to
demonstrate just this bug.

Actual Results:  
Data ends up in the wrong columns

Expected Results:  
Data in the correct columns/flawless import of data

OS: Linux (i686) release 2.6.35-24-generic
Compiler: cc
This box is kubuntu 10.10 with the newest KDE stable packages installed,
everything is plain vanilla fresh install (this is one of the first things I
tried to do on this box).

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.