Hello,
How do I import the categories and payees from a database to another?
Import Category
Moderator: Renato
-
frankieorabona
- Super User
- Posts: 79
- Joined: Sat Mar 21, 2015 9:15 am
- Are you a spam bot?: No
- Location: Italia
-
Nikolay
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Import Category
Seems there is no option to do this. But it's easy to add this feature.frankieorabona wrote:Hello,
How do I import the categories and payees from a database to another?
-
DaleVa
- New User
- Posts: 6
- Joined: Tue Feb 16, 2016 12:02 am
- Are you a spam bot?: No
Re: Import Category
Hello Nikolay, Was this ever added? I"m running 1.3.3 (DB v.7)and cannot see anyway to to import categories, and payees from one database to another. Is there a utility that I can use to open the db to copy the tables/data?
Thank you,
Dale
Thank you,
Dale
-
Nikolay
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Import Category
I think it possible using QIF Export - Inport for categories.
But not for payees.
Why you need it?
But not for payees.
Why you need it?
-
DaleVa
- New User
- Posts: 6
- Joined: Tue Feb 16, 2016 12:02 am
- Are you a spam bot?: No
Re: Import Category
A significant change in life necessitated a complete new setup. New accounts, new starting balances, but many of the same payees and categories that I've added over the years. It would be nice to simply import them. Alas, I shall have to start from scratch.Nikolay wrote:I think it possible using QIF Export - Inport for categories.
But not for payees.
Why you need it?
-
Sinanju
- New User
- Posts: 11
- Joined: Mon Jul 19, 2021 10:38 pm
- Are you a spam bot?: No
Re: Import Category
Has this gone any further?
Would be nice to have a simple way to export both a Categories list and a Payees list, and to import either list.
We have option of starting a new database, but if starting from scratch, probably wouldn't want the same transactions, but may want same Categories and Payees.
Would be nice to have a simple way to export both a Categories list and a Payees list, and to import either list.
We have option of starting a new database, but if starting from scratch, probably wouldn't want the same transactions, but may want same Categories and Payees.
-
dbolton
- Super User
- Posts: 129
- Joined: Fri Jan 03, 2020 3:24 pm
- Are you a spam bot?: No
Re: Import Category
Why not copy your old database and delete all the old transactions?
-
whall3y
- Developer
- Posts: 353
- Joined: Fri Aug 21, 2020 5:44 pm
- Are you a spam bot?: No
Re: Import Category
That would do the job. Great idea.
-
Sinanju
- New User
- Posts: 11
- Joined: Mon Jul 19, 2021 10:38 pm
- Are you a spam bot?: No
Re: Import Category
This is exactly what I did - except I did it by accident. I thought I'd see what would happen if I changed my Mortgage account from Term to Checking using 'Account Relocation'. All but 2 of my 200+ transactions gone! 
In hindsight, I should have made a copy of my file, and changed that. I didn't so had to use the file from previous day, and update that with over 50 entries.
Thank goodness for daily automatic MMEX backups.
In hindsight, I should have made a copy of my file, and changed that. I didn't so had to use the file from previous day, and update that with over 50 entries.
Thank goodness for daily automatic MMEX backups.
-
frankieorabona
- Super User
- Posts: 79
- Joined: Sat Mar 21, 2015 9:15 am
- Are you a spam bot?: No
- Location: Italia
Re: Import Category
So the only way to import the entire category structure is to do a copy/paste of the database?
-
Roberto
- New User
- Posts: 13
- Joined: Mon Feb 19, 2024 10:35 am
- Are you a spam bot?: No
Re: Import Category
It seems yes working from MMEX.
Otherwise using a tool for working with databases like dbeaver or SQLiteStudio there are various methods: import a table from one database to another, or save a table as a SQL script to run into another DB in order to populate categories table (CATEGORY_V1) with your desired categories.
Otherwise using a tool for working with databases like dbeaver or SQLiteStudio there are various methods: import a table from one database to another, or save a table as a SQL script to run into another DB in order to populate categories table (CATEGORY_V1) with your desired categories.