[grisbi-bugs] [Grisbi-0.6.0 0001385]: Transaction date revert to import date when importing .csv data

[Grisbi Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://www.grisbi.org/bugsreports/view.php?id=1385 
====================================================================== 
Reported By:                simondup
Assigned To:                pbiava
====================================================================== 
Project:                    Grisbi-0.6.0
Issue ID:                   1385
Category:                   Main
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     assigned
Plateforme:                 Linux 
OS:                         Fedora 
Version OS:                 14 
Unstable Impact:            Yes 
Version GTK:                 
====================================================================== 
Date Submitted:             2011-08-06 00:20 CEST
Last Modified:              2011-08-29 19:59 CEST
====================================================================== 
Summary:                    Transaction date revert to import date when
importing .csv data
Description: 
My bank statement data are downloaded as a .csv file. When importing the file
all the transacion dates revert to the date the file was imported even though it
is correct in the file.

Steps to Reproduce: 
1. Download .csv data
2. Import into back account
====================================================================== 

---------------------------------------------------------------------- 
 (0003201) pbiava (administrator) - 2011-08-06 12:47
 http://www.grisbi.org/bugsreports/view.php?id=1385#c3201 
---------------------------------------------------------------------- 
Can you send me a sample? pierre.biava at nerim.net 

---------------------------------------------------------------------- 
 (0003203) simondup (reporter) - 2011-08-06 20:09
 http://www.grisbi.org/bugsreports/view.php?id=1385#c3203 
---------------------------------------------------------------------- 
Hi Pierre

Do you need a sample of the .csv file or the Grisbi file? 

---------------------------------------------------------------------- 
 (0003205) pbiava (administrator) - 2011-08-06 23:35
 http://www.grisbi.org/bugsreports/view.php?id=1385#c3205 
---------------------------------------------------------------------- 
hi,

a sample of the .csv file.

Best regards 

---------------------------------------------------------------------- 
 (0003206) simondup (reporter) - 2011-08-07 01:28
 http://www.grisbi.org/bugsreports/view.php?id=1385#c3206 
---------------------------------------------------------------------- 
Uploaded is a zipped file containing the sample .csv file and a test Grisbi file
it was imported into. 

---------------------------------------------------------------------- 
 (0003207) pbiava (administrator) - 2011-08-07 07:09
 http://www.grisbi.org/bugsreports/view.php?id=1385#c3207 
---------------------------------------------------------------------- 
hi,

The date format used is not recognized by Loot. The date should be in the form:
mm/dd/YYYY eg 14/07/2011 and not 14/Jul/2011

Best regards 

---------------------------------------------------------------------- 
 (0003208) simondup (reporter) - 2011-08-07 12:16
 http://www.grisbi.org/bugsreports/view.php?id=1385#c3208 
---------------------------------------------------------------------- 
Thanks,

I suppose you meant dd/mm/yyyy, rather than mm/dd/yyyy?

Will the date format 14/Jul/2011 be supported in future as my bank does not
allow me to change the format. 

I tried to change the format to dd/mm/yyy but got the same error. When changed
to dd/mm/yy it works correctly 

---------------------------------------------------------------------- 
 (0003209) pbiava (administrator) - 2011-08-07 18:26
 http://www.grisbi.org/bugsreports/view.php?id=1385#c3209 
---------------------------------------------------------------------- 
Sorry. The format depends on the local. I had assumed that the local is en_EN.
The date format used by Grisbi is set in péférences.
I am looking at what to do to support the literal abbreviated format for the
month 

---------------------------------------------------------------------- 
 (0003234) philippedelorme (reporter) - 2011-08-29 19:59
 http://www.grisbi.org/bugsreports/view.php?id=1385#c3234 
---------------------------------------------------------------------- 
Fixed in Git.

Assuming the date is either dd/mm/YY or mm/dd/YY with month as a 3-length string
(jan, feb, mar, ...). Case does not matter. The month string is not localized.
It's just english. Hoping decent softwares export dates in english... 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-08-06 00:20 simondup       New Issue                                    
2011-08-06 12:47 pbiava         Assigned To               => pbiava          
2011-08-06 12:47 pbiava         Status                   new => assigned     
2011-08-06 12:47 pbiava         Note Added: 0003201                          
2011-08-06 20:09 simondup       Note Added: 0003203                          
2011-08-06 23:35 pbiava         Note Added: 0003205                          
2011-08-07 01:27 simondup       File Added: DateProblem.zip                    
2011-08-07 01:28 simondup       Note Added: 0003206                          
2011-08-07 07:09 pbiava         Note Added: 0003207                          
2011-08-07 12:16 simondup       Note Added: 0003208                          
2011-08-07 18:26 pbiava         Note Added: 0003209                          
2011-08-29 19:59 philippedelormeNote Added: 0003234                          
======================================================================