Or run reports directly from the CSV: $ hledger -f checking.csv bal You can print the resulting transactions in any of hledger's output formats: $ hledger -f checking.csv print # we can optionally refine it by matching patterns in the CSV record: # the other account will default to expenses:unknown or income:unknown # set the base account that this CSV file corresponds to # since the CSV amounts have no currency symbol, add one: # specify the date field's format - not needed here since date is Y/M/D # use the first three CSV fields for hledger's transaction date, description and amount: This tells hledger how to read this CSV file. Say you have downloaded this checking.csv file from a bank for the first time: "Date","Note","Amount"Ĭreate a rules file named in the same directory. This is described in detail in the hledger manual, After saving a fewĭeclarations in a "CSV rules file", it can read transactions fromĪlmost any CSV file. Hledger has a powerful CSV converter built in. Customize the default "unknown" accounts.But if anybody could provide the requested information, I am sure we will find a resolution that everybody can agree with. I hope all this helps to get to a better resolution of this issue. So, frankster and/or SHULTZIE, could you please confirm that it works with a dash as separator (at least if the CSV data adhere to the selected order of day, month and year)? Alternatively, can you please provide a test file and more precise instructions how to reproduce the issue? Is this correct? Unfortunately I can't try it on my own as I have no such CSV file. SHULTZIE, in note #8 you wrote that you have too issues with importing CSV files, even when using a dash as a separator. When I wrote note #6, I assumed that it does. Sorry for not explaining it at that time.īack to the issue this is all about: In note #5, frankster (wtfrank) does not explicitly answer my question whether the import works when using a dash as a separator. This is not really a Gnucash issue, which is why I changed the status to 'Invalid' in note #6. If a bank decides to invent yet another date format (I consider separating the numbers with spaces odd), please contact your bank and ask them to fix the CSV export. Regarding the user expectation that Gnucash should import whatever format the banks provide, please note that there are so many calendar date formats in use all over the world that it is almost impossible to always parse a string representation of any calendar date correctly. So please accept my apologies for not taking enough time to write an answer with an end user and not an IT expert in mind. This format is so common in the IT industry that I thought my brief notes were enough to understand the problem. For me it was obvious that the date format d-m-y means exactly this: A string composed of three groups of digits separated by dashes. Yes, my question in note #1 was not helpful at all, and I now regret that I wrote it at all. Failing!"įirst I feel sorry that I seem to have offended frankster (wtfrank) in my earlier notes in this bug. "Do you know the hardest part about trying to be funny?. RE: SOLUTIONS: Has anyone found a date format that works?Īt this point I don't care if I have to fix it by hand (though I think the community should consider this problem is a bug). " Do you know the hardest part about trying to be funny?. Here is an original SHULTZIE that you can add to your repetoir (Use it when you bomb) (Otherwise people see you as just another wiseguy.) SUGGEST: You earn your priviledge to make jokes by offering something constructive (like a solution) alongside your efforts to be funny. RE: POOR EFFORT (To be funny ) BY: Micha Lenk (micha) wrote on : "Do you really intend to add a transaction that is more than 2000 years old?" I tried MM/DD/YY, and MM/DD/YYYY and MM-DD-YYYY I TOO AM HAVING A PROBLEM WITH GNUCASH DATES AND CSV IMPORTS. So its not appropriate to mark this bug as invalid. Either way, it is a reasonable user expectation that the programme will import a csv file provided by a bank without having to edit the file by hand. If it is only designed to import dates that use a specific separator then this is a bug with the specification, rather than the implementation. It doesn't import the dates in the csv file provided by my bank. I AGREE WITH: frankster (wtfrank) wrote on : #7
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |