Import Category

General discussion on all other topics under the sun.

Moderator: Renato

frankieorabona
Senior MMEX User
Posts: 26
Joined: Sat Mar 21, 2015 9:15 am
Are you a spam bot?: No
Location: Italia

Import Category

Post by frankieorabona »

Hello,
How do I import the categories and payees from a database to another?
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Import Category

Post by Nikolay »

frankieorabona wrote:Hello,
How do I import the categories and payees from a database to another?
Seems there is no option to do this. But it's easy to add this feature.
DaleVa
New MMEX User
Posts: 5
Joined: Tue Feb 16, 2016 12:02 am
Are you a spam bot?: No

Re: Import Category

Post by DaleVa »

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
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Import Category

Post by Nikolay »

I think it possible using QIF Export - Inport for categories.
But not for payees.
Why you need it?
DaleVa
New MMEX User
Posts: 5
Joined: Tue Feb 16, 2016 12:02 am
Are you a spam bot?: No

Re: Import Category

Post by DaleVa »

Nikolay wrote:I think it possible using QIF Export - Inport for categories.
But not for payees.
Why you need it?
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.
Sinanju
New MMEX User
Posts: 11
Joined: Mon Jul 19, 2021 10:38 pm
Are you a spam bot?: No

Re: Import Category

Post by Sinanju »

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.
dbolton
Super MMEX User
Posts: 126
Joined: Fri Jan 03, 2020 3:24 pm
Are you a spam bot?: No
Contact:

Re: Import Category

Post by dbolton »

Why not copy your old database and delete all the old transactions?
whall3y
MMEX Developer
Posts: 343
Joined: Fri Aug 21, 2020 5:44 pm
Are you a spam bot?: No

Re: Import Category

Post by whall3y »

That would do the job. Great idea.
Sinanju
New MMEX User
Posts: 11
Joined: Mon Jul 19, 2021 10:38 pm
Are you a spam bot?: No

Re: Import Category

Post by Sinanju »

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! :oops:
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
Senior MMEX User
Posts: 26
Joined: Sat Mar 21, 2015 9:15 am
Are you a spam bot?: No
Location: Italia

Re: Import Category

Post by frankieorabona »

So the only way to import the entire category structure is to do a copy/paste of the database?
Post Reply