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

Grisbi Bug Tracker bugtracker at grisbi.org
Sun Aug 7 18:26:22 CEST 2011


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-07 18:26 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 

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                          
======================================================================



More information about the bugsreports mailing list