Import new Pocketmoney database into iCompta 6

Discussions about iCompta on iOS
Sirius
Posts: 2
Joined: 23 May 2020, 22:28

Re: Import new Pocketmoney database into iCompta 6

Post by Sirius »

I found out what to do.
I needed to:
- download the up to date PocketMoney version to my MAC,
- import the PocketMoney.db file from my older PocketMoney version that still runs on my iPhone into PocketMoney on the MAC,
- then the PocketMoney.cdb with the new data structure is created.
- treat this with Navicat and proceed to the import into iCompta on the MAC.

What I still need to figure out is how to get all the data of the last 10 years that resides in the "Name" fields of all transactions into the "Payee" field.
Amiko
Posts: 13
Joined: 01 January 2020, 21:03

Re: Import new Pocketmoney database into iCompta 6

Post by Amiko »

The PocketMoney's field Payee was imported to some field in iCompta, but I can't remember which one. Choose to see all fields and find out. Then, create a rule in iCompta that imports the old Payee value to the new Name field. It will be something as "Set name / to the contents of / "field where are Payees". I did this way.
Post Reply