MMEX Discussion Forum

Posted: **Mon Dec 21, 2020 7:25 pm**

How can I clean up the database from all records, balances, historical budgets, leaving only the names of categories, accounts, customers, etc.
I want to use it as a "template" to start from scratch, but without having to create all the settings yet.

Posted: **Mon Dec 21, 2020 7:38 pm**

Delete all transactions in current view is only options available for now.
Repeat it for every account.

Posted: **Mon Dec 21, 2020 8:21 pm**

I did it and I moved all recurring operations to 2021, but then why do I have a budget for 2019?

Posted: **Mon Dec 21, 2020 10:06 pm**

I would use the DB Browser to delete the unwanted tables. But please be careful not to destroy the DB structure.
http://sqlitebrowser.org

Posted: **Tue Dec 22, 2020 6:29 am**

Any budget record are some data in BUDGETTABLE_V1 and BUDGETYEAR_V1 tables.

It may be deleted as well

: budget.png (84.41 KiB) Viewed 12619 times

Posted: **Tue Dec 22, 2020 6:36 am**

There are Tools - Database - Database Debug menu item.
There may be executed SQL script like this (save it to a file with .mmdbg extension):

Code: Select all

-- MMEX Debug SQL - Update --

delete from BUDGETTABLE_V1 
where BUDGETYEARID in 
  (select BUDGETYEARID from BUDGETYEAR_V1 where BUDGETYEARNAME like '2019%');

delete from BUDGETYEAR_V1 where BUDGETYEARNAME like '2019%';

delete from CUSTOMFIELDDATA_V1 where REFID in
(select TRANSID from CHECKINGACCOUNT_V1 where strftime('%Y', TRANSDATE)='2019');

DELETE from ATTACHMENT_V1 WHERE REFID in 
(select TRANSID from CHECKINGACCOUNT_V1 where strftime('%Y', TRANSDATE)='2019');

delete from SPLITTRANSACTIONS_V1 where TRANSID in
(select TRANSID from CHECKINGACCOUNT_V1 where strftime('%Y', TRANSDATE)='2019');

DELETE from CHECKINGACCOUNT_V1 where strftime('%Y', TRANSDATE)='2019';

Posted: **Tue Dec 22, 2020 7:52 am**

https://github.com/moneymanagerex/money ... ssues/2760

PS this report may be helpful for know account balances for any date

https://github.com/moneymanagerex/gener ... ntBalances

Posted: **Tue Dec 22, 2020 10:02 am**

OK, many thanks to all

Posted: **Tue Mar 28, 2023 8:32 pm**

Thanks for the info,

How can we reset the Transaction ID counter?

Have a nice day

Posted: **Mon Apr 10, 2023 8:21 pm**

The next Transaction ID is always max(TRANSID) + 1, and deleting a transaction automatically frees that ID for use. To reset the Transaction ID counter to 1 you would have to delete all transactions.

MMEX Discussion Forum

[SOLVED] How to clean database?

[SOLVED] How to clean database?

Re: How to clean database?

Re: How to clean database?

Re: How to clean database?

Re: How to clean database?

Re: How to clean database?

Re: How to clean database?

Re: How to clean database?

Re: [SOLVED] How to clean database?

Re: [SOLVED] How to clean database?