How to reset Income/Excpense account dates globally?

Sun Dec 25 07:49:49 UTC 2016

Hi Peter,

On Sunday 18 December 2016 18:18:39 Peter J. Farley III wrote:

> > -----Original Message-----
> > From: Thomas Baumgart [mailto:thb at net-bembel.de]
> > Sent: Sunday, December 18, 2016 6:46 AM
> > To: Peter J. Farley III
> > Cc: kmymoney at kde.org
> > Subject: Re: How to reset Income/Excpense account dates globally?
> > 
> > Hi Peter
> > 
> > On Sunday 11 December 2016 14:28:13 Peter J. Farley III wrote:
> > > Hi All,
> > > 
> > > I was able to import all my checking account transactions with
> > > categories into kMyMoney nicely, but all of the Income/Expense
> > > accounts that I added myself before the import were dated 1/1/2016
> > > instead of the default date of 1/1/1900.  When I saved my file all the
> > > transactions dated prior to 1/1/2016 that had one of the categories
> > > that I added myself were flagged as inconsistent.
> > > 
> > > I did not realize that the date field in the Add Category screen had
> > > any significance, which is why I did not change the date field at the
> > > time I added them.
> > > 
> > > Is there a way to globally reset all Income/Expense category dates to
> > > the default date of 1/1/1900?  Or do I have to go to each one I added
> > > individually to change the dates?  I want to import my other accounts
> > > as well (Savings, Credit Cards, etc.) and I don’t want the category
> > > dates affecting them too.
> > 
> > sorry that it took some time to find an answer which starts with a
> > question from my end: which version of KMyMoney are you using?
> > The code base contains the feature you are looking for since May 2015
> > where all category accounts opening date is changed to 1900-01-01
> > during the save operation. I am pretty sure that this is part of KMyMoney
> >
> >4.8.0 and later.
> >
> > So from what you explain, it looks like you are using an older version
> > than that. Or there is something else which would be strange.
> > 
> > Hope that helps. If an upgrade to 4.8.0 does not help or you already
> > have that version, please get back to us.
> 
> Hi Thomas,
> 
> Thanks for getting back to me.  I am running V4.7.2 of kMyMoney from a
> download dated on my system as 7/20/2015 (kmymoney-x86-setup-4.7.2.exe).  I
> have not yet tried this under V4.8.0.
> 
> I have been importing and deleting about 1300 checking account transactions
> as I adjust the categories that I want them assigned to (I am
> programmatically pre-assigning categories in a CSV import file).  I delete
> all payees and all transactions between each pass.  When I finish the
> import and then Save is when the "consistency checks" error messages
> appear, saying that the starting date for some of the categories is after
> the date of the earliest transaction assigned to that category.  It also
> says it automatically fixed the category date in each case.

This automatically fixed probably means, that the category opening date has 
been changed to the date of the first transaction referencing it or 
1900-01-01. In any way, you should see this message only once. Following save 
operations should not show it again (it has been fixed).

> I then decided that I wanted a shorter list of categories, so after deleting
> all payees and transactions again I then deleted all categories and started
> over with the detailed account template and added a few more groups
> (Housing, Schedule A) and then added a few custom categories of my own. 
> For the custom categories that I added manually I did set the start date to
> the opening date of the account I am loading, but I didn't set any dates on
> the system-provided categories that I imported.  I *think* I saved after
> setting up my new account template; I should have, but I can’t be positive
> that I did.
> 
> I will restart the process again from scratch (empty account template, no
> payees or transactions) and log what happens at each step and report my
> results as soon as I can.

Well, don't put too much effort into this with 4.7.2 as the behavior has been 
changed in 4.8.0.

> Some RL events and duties will likely prevent me from getting back to this
> exercise right away, so it may be a few days or more before I can report
> back, possibly not until after Christmas.

No problem, this applies here as well ;)

> BTW, is it possible to actually import an entire externally-modified account
> template (a *.kmt file) into a new, completely empty kMyMoney file which
> has no categories defined at all?  If so, what date would be assigned to
> those imported categories?

Yes it is, though it could be possible that KMyMoney only looks in a specific 
place for them. They should show up in the 'Account' selection process of the 
new file wizard (see https://docs.kde.org/stable4/en/extragear-office/kmymoney/firsttime.3.html for details)

-- 

Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
Mankind makes a lot of things wrong, but if you really want to
screw up, you need to use a computer! (Juergen von der Lippe)
-------------------------------------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 225 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20161225/b120e4d7/attachment.sig>