Comment 9 for bug 1093139

Revision history for this message
Micha Lenk (micha) wrote :

Hi,

first I feel sorry that I seem to have offended frankster (wtfrank) in my earlier notes in this bug. Yes, my question in note #1 was not helpful at all, and I now regret that I wrote it at all. 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. This format is so common in the IT industry that I thought my brief notes were enough to understand the problem. 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.

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. 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. This is not really a Gnucash issue, which is why I changed the status to 'Invalid' in note #6. Sorry for not explaining it at that time.

Back 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. When I wrote note #6, I assumed that it does. SHULTZIE, in note #8 you wrote that you have too issues with importing CSV files, even when using a dash as a separator. Is this correct? Unfortunately I can't try it on my own as I have no such CSV file. 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?

I hope all this helps to get to a better resolution of this issue. But if anybody could provide the requested information, I am sure we will find a resolution that everybody can agree with.

Regards,
Micha