On 07/21/2013 04:09 PM, Jay Lozier wrote:
On Sun, 21 Jul 2013 16:47:02 -0400, Jim Byrnes <firstname.lastname@example.org> wrote:On 07/21/2013 03:16 PM, Jay Lozier wrote:On Sun, 21 Jul 2013 15:47:14 -0400, Jim Byrnes <email@example.com> wrote:On 07/21/2013 01:29 PM, Jay Lozier wrote:1. On Sun, 21 Jul 2013 13:56:21 -0400, Jim Byrnes <firstname.lastname@example.org> wrote:OS = Ubuntu 12.04 up to date & LO = 18.104.22.168 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, JimJim, 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, JimJim,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, JimJim Rename the hidden LO user folder to something like user-old, it is the home directory either under .libreoffice or .conf folders. When you start LO after the rename the default folder is recreated. You then move any templates, etc. back to the user folder. This is common methood to avoid a full reinstall.
Jay,That worked. Fortunately I haven't done a whole lot of customization so this is a rather painless solution.
Thanks much, Jim -- To unsubscribe e-mail to: email@example.com 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