After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 771246 - Set Invoice/Bill items date correctly from imported CSV
Set Invoice/Bill items date correctly from imported CSV
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Import - Other
git-maint
Other All
: Normal normal
: ---
Assigned To: Mike Evans
gnucash-import-maint
Depends on:
Blocks:
 
 
Reported: 2016-09-11 13:33 UTC by Mike Evans
Modified: 2018-06-29 23:50 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Mike Evans 2016-09-11 13:33:06 UTC 
The importer sets the date of each line entry to the date the import is run. This should be set to the date actually specified in the CSV file. Only set it to the current date if there is no date in the field.
Comment 1 Mike Evans 2016-09-12 08:05:30 UTC 
Pushed to maint.
Comment 2 Mike Evans 2016-09-25 07:55:05 UTC 
Now I get warnings about Invalid timestamp in data file. Must have missed something.
Comment 3 Mike Evans 2016-12-02 08:58:42 UTC 
I forgot to add:

Fixed in maint branch and will be in the next GnuCash release scheduled for 2016-12-18. I just missed the 2.6.14 release.
Comment 4 Geert Janssens 2017-04-11 13:18:06 UTC 
FYI, a Fedora user has reported it's still not working on Fedora 25 with gnucash 2.6.15: https://bugzilla.redhat.com/show_bug.cgi?id=1418176

I've asked for more details there.
Comment 5 Mike Evans 2017-04-11 19:28:14 UTC 
Ack. Will look into it. I'll re-open this in that case.
Comment 6 Mike Evans 2017-05-06 12:55:27 UTC 
I tested the Fedora version and maint and the behaviour is the same. It works as it should.

Left a comment on the redhat bug.
Comment 7 porjo38 2017-05-09 10:26:47 UTC 
This continues to be an issue for me using Fedora 25 v2.6.16 package - I've posted updates here: https://bugzilla.redhat.com/show_bug.cgi?id=1418176
Comment 8 Mike Evans 2017-05-09 17:52:55 UTC 
(In reply to porjo38 from comment #7)
> This continues to be an issue for me using Fedora 25 v2.6.16 package - I've
> posted updates here: https://bugzilla.redhat.com/show_bug.cgi?id=1418176

Not a Fedora Bug, a Gnucash bug. Ive left a comment on the Fedora bug.
Comment 9 Mike Evans 2017-05-09 17:55:56 UTC 
In the meantime, put the dates in column 2 of the CSV to get the correct behaviour. The first date becomes the invoices' date opened and the subsequent dates are the line entry date. Which made perfect sense to me at the time.
Comment 10 porjo38 2017-05-10 02:48:46 UTC 
I've copied the date to column2 and can confirm that it now works in v2.6.16.
Comment 11 Mike Evans 2017-05-11 18:28:27 UTC 
There are 2 date columns.

I'm not sure that the two are required but clearly the line/item  date should be as specified in the import. Does the date opened matter? It doesn't to me as long as the line items date are correct. In my useage I sometimes open invoices before the work is done and sometimes after. To me the date_opened doesn't matter, but I guess there may be contractual/legal reasons where it does.

Before I fix this I'd like some thoughts on how to handle the various invoice dates. Bearing in mind that that changes may break some peoples workflow.

The next release is scheduled for 2017-03-26 and I'd like to get this fixed before then.
Comment 12 Mike Evans 2017-05-18 18:31:46 UTC 
Pushed to maint. 5df97ba2

I'll await any comments before closing this.
Comment 13 Mike Evans 2017-07-30 12:01:55 UTC 
No complaints so far so closing.
Comment 14 porjo38 2017-07-31 04:25:48 UTC 
Thanks Mike, working for me!
Comment 15 John Ralls 2018-06-29 23:50:59 UTC 
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=771246. Please update any external references or bookmarks.