[libreoffice-users] Re: csv files not displaying properly

On 07/21/2013 03:16 PM, Jay Lozier wrote:
> On Sun, 21 Jul 2013 15:47:14 -0400, Jim Byrnes <jf_byrnes@comcast.net>
> wrote:
>
> > On 07/21/2013 01:29 PM, Jay Lozier wrote:
> > > 1. On Sun, 21 Jul 2013 13:56:21 -0400, Jim Byrnes
> > > <jf_byrnes@comcast.net> wrote:
> > >
> > > > OS = Ubuntu 12.04 up to date & LO = 3.5.7.2
> > > >
> > > > I have been downloading and opening bank and credit card activity as
> > > > csv files for some time now with no problems using LO.  Today when I
> > > > did it the results are unusable.
> > > >
> > > > In regards to the bank download, by unusable I mean:
> > > >
> > > > There should be six columns of data and there is, but column C is very
> > > > wide.  Column C should only contain a check or deposit amount.
> > > > Starting on row 3, column C has parts of other columns and rows in it
> > > > and has 3 separate lines in it.
> > > >
> > > > In regards to the credit card download:
> > > >
> > > > In this case it displays the columns correctly, but some rows are
> > > > missing. It should have a heading and 6 rows.  It displays a heading
> > > > and 3 rows.  The bottom 3 rows are missing.
> > > >
> > > > In trying to figure this out I:
> > > >
> > > > Looked at the files with a text editor and they look properly
> > > > formatted.
> > > >
> > > > They open correctly in Gnumeric and Calligra sheets.
> > > >
> > > > In the text import dialog down in the Fields section both display
> > > > correctly.  That is all of the columns display as they should and all
> > > > the rows are present.
> > > >
> > > > I have Character set = Unicode (UTF-8), Language = Default - English
> > > > (USA), Separated by = Comma.
> > > >
> > > > Here is a sanitized sample of the bank file from a text editor.
> > > >
> > > > xxxxxxxxx555,06/30/2013,0.31,0,Added to Account,Accr Earning Pymt
> > > > xxxxxxxxx555,06/28/2013,104.82,0,Deposit,ACH Deposit
> > > > xxxxxxxxx555,06/27/2013,-1499.50,1130,,Check
> > > >
> > > > I had a copy of this type of file in my trash folder that I processed
> > > > last month with no problems.  When I tried it today I got the same
> > > > results as above.
> > > >
> > > > To my knowledge I have not changed any settings that would cause this.
> > > > The only thing I have done differently is download and read  Andrew
> > > > Pitonyak's excellent book on macro's in Writer format.  While reading
> > > > it I did activate some of his example macros.  I don't see how this
> > > > could cause any problems and mention it only for completeness.
> > > >
> > > > OK, while gathering information for this post I discovered that my
> > > > problems start when a negative number is encountered.  In fact if I
> > > > remove the minus sign from all numbers the file displays correctly.
> > > >
> > > > Does anyone have any idea what is happening and how to fix it?
> > > >
> > > > Thanks,  Jim
> > >
> > > Jim,
> > >
> > > Using your sample data I had no problems with the csv file with the
> > > following settings
> > >
> > > 1. Character set = Unicode (UTF-8), Language = Default - English  (USA),
> > > Separated by = Comma, Detect Special Numbers checked
> > >
> > > 2. Character set = Unicode (UTF-8), Language = Default - English  (USA),
> > > Separated by = Comma, Detect Special Numbers unchecked
> > >
> > > 3. Character set = Unicode (UTF-7), Language = Default - English  (USA),
> > > Separated by = Comma, Detect Special Numbers checked
> > >
> > > In all cases the data imported correctly and the amounts behaved as
> > > expected; formatting and sum() worked as expected.
> > >
> > > Using LO 4.0.0 from openSUSE 12.3 repository.
> >
> > Jay,
> >
> > It was working for me also. Mine is from the Unbuntu repository and I
> > don't think there have been any updates to it , but I will check. I'm
> > hoping someone recognizes the problem or knows of some setting I may
> > have inadvertently changed to cause the problem.
> >
> > Just out of curiosity did you happen to add a couple of lines after
> > the last one that had the negative number in it?  All of my problems
> > seem to start after a negative number.  Silly me, I was just giving
> > people a look at the file format, it never dawned on me that could be
> > used to test with.  I should have included some more lines.
> >
> > Thanks,  Jim
> Jim,

Jay,

> I know there is LO ppa you can add to your ppa list that will allow you
> to get the lastest version.

I have been thinking about doing that.

> I did add any extra data; I did not think of it. But after replicating
> the data a couple times in the csv file then importing it I had no
> problems with the data. I used #1 of the test methods, which is my
> default setting.
>
> I can not see anything is the csv file that looked wrong such as
> unexpected character.
>
> One thing to check is the columns in the wizard should show "standard"
> (the default as far as I know) for the import type.


Mine say standard.  I just remembered that I loaned my laptop to my 
daughter and it is setup the same as my desktop that I am having trouble 
with.  Had her bring it over and I tried the problem file on it and it 
worked just fine, so something is wrong with my setup.  I opened 
tools-->options on both machines and compared them line by line they 
were almost exactly the same. I couldn't see how the minor differences 
would make any difference but I changed mine to match the laptop but it 
still doesn't work correctly.  I guess after a bit if no one else has 
any ideas I will reinstall or go the ppa route.

Thanks,  Jim


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted