![]() ![]() You can enter m-d-y as a custom date format in LibreOffice, but 09/04/14 is rendered 9-4-y But neither Windows 7 nor LibreOffice have that explicitly. It appears that the routine requires m-d-y. ESPECIALLY if it was exported from GnuCash. So you have to load the exported CSV file into an application, e.g., LibreOffice, and farkle with it a bit. It appears that the GnuCash CSV import routine requires exactly one line per transaction split, and NO HEADERS, NO TRANSACTION SUMMARY line, and a funky DATE FORMAT. First you clear out all the unwanted columns Importing, however, is a bit more daunting.ġ. This offers File → Export → Transactions to CSV You have to do this also for gnucash-lang to avoid conflicts. However, in yast2 sw_software you can search for gnucash and open the Versions tab to select the current 2.6.4 offering: This is the default version offered by their repositories. If it is a duplicate it simply overwrites the originalĭiscussion I was on GnuCash 2.4.13 under Linux openSUSE 13.1. New, transfer $(xxx) to (auto)"*Category Name*" It has correctly read the Category column and creates To whatever clears any data from being highlighted in pink, To whatever causes the headers to be highlighted in pink, If you see headers in the presented view then change Rename the Date, Num, Account, Description, To Num, From Numĭate, Num, Account, Description, Deposit, Withdrawalį. To find the right one (Comma, Tab, Semicolon, etc.)Į. If it does appear as columns then examine the Separators ![]() Select the number columns and delete all minus signs Add the parent transaction account to each of the splits Add the parent transaction date to each of the splits Edit the file to change date column format from MM/DD/YYYY to m-d-yy Open the CSV file (e.g., exported from GnuCash) in an editor (e.g., LibreOffice Calc):Ī. So we have experimented scientifically and carefully and can confirm and replicate the steps below to import CSV files into GnuCash 2.6.4:ġ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |