Bug 273755

Summary: When importing a csv-file into Kaddressbook, empty fields are disregarded and data end up in the wrong columns.
Product: [Applications] kaddressbook Reporter: engelup
Component: generalAssignee: kdepim bugs <kdepim-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: anderslund, tokoe
Priority: NOR    
Version: unspecified   
Target Milestone: ---   
Platform: openSUSE   
OS: Linux   
Latest Commit: Version Fixed In:

Description engelup 2011-05-20 21:45:37 UTC
Version:           unspecified (using KDE 4.6.0) 
OS:                Linux

Addresses contained in a Libre Office spread sheet are to be imported in Kaddressbook. The table contains empty fields (e.g. no fax number) which appear in the csv file as follows: ,,,, (= three empty fields separated by commas). The parser disregards the empty fields thus data end up in the wrong columns. 

This bug has been reported before and is listed as fixed as of version 4.6, however, it seems it is not.


Reproducible: Didn't try

Steps to Reproduce:
Save LibreOffice-calc table (.ods) as text-csv ("save as"). Go to applications menu, open Kaddressbook, select addressbook, import csv-file. 

Actual Results:  
Parser wsindows opens and shows data in wrong columns, i.e. field contents are moved to the left when there are empty fields to the left of the field with content. 
Cancelled procedure.

Expected Results:  
Show each field as in the original table.

OpenSuse 11.4, LibreOffice 3.3.1.
Comment 1 engelup 2011-05-20 21:47:19 UTC
Reproducible: yes.
Comment 2 Anders Lund 2012-02-01 18:43:57 UTC
Could you provide a test file (csv or ods), then I will test?
Comment 3 engelup 2012-02-08 19:14:04 UTC
PLease excuse my late answer. I am now using Suse 12.1 and the problem no
longer exists.

Regards

Kurt

2012/2/1 Anders Lund <anders@alweb.dk>

> https://bugs.kde.org/show_bug.cgi?id=273755
>
>
> Anders Lund <anders@alweb.dk> changed:
>
>           What    |Removed                     |Added
>
> ----------------------------------------------------------------------------
>                 CC|                            |anders@alweb.dk
>
>
>
>
> --- Comment #2 from Anders Lund <anders alweb dk>  2012-02-01 18:43:57 ---
> Could you provide a test file (csv or ods), then I will test?
>
> --
> Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You reported the bug.
>
Comment 4 Anders Lund 2012-02-08 19:33:10 UTC
Thank you for answering :-)