Home → General Questions →

TXN Files

• Edit

ed.fischer

Oct 20, 2021 @ 10:25 PM

Over 1600 *.txn files have been created since Oct 14. I do have have syncing turned on.

What are these files for?

Can these files be deleted?

1. 1 Posted by Stuart Beesley ... on Oct 21, 2021 @ 05:33 AM

   

   Are they txn or mdtxn? And which folder are they in? Is syncing actually working?

   Please send help / console window contents

   What version of MD?

   If on md2021.1 onwards, install and run toolbox extension. Click analyse my datasets and objects. Post that output here too.

   • Edit

2. 2 Posted by ed.fischer on Oct 21, 2021 @ 04:22 PM

   

   They are [FILENAME].txn
   They are in [DATABASE]/safe/tiksync/out
   Running 2022 (4056)

   CONSOLE:
   DATASET FILE ANALYSIS
    ====================

   Dataset path: [PATH]/[Database]

   Dataset size: 73.8MB
   - settings file size: 45.4KB
   - key file size: 0.1KB
   - tiksync folder size: 73.8MB (with 1634 files)
     (note trunk file size: 28.0MB)
     (WAITING Sync 'Out' size: 45.7MB with 1632 files)
   - attachments size: 0.0MB (in 0 attachments)
   - archive size: 0.0MB (in 0 files)
   ---------------------------------------------
   Valid files size: 73.8MB (in 1636 files)

   Non-core file(s) size: 0.0MB (in 1 files)
      - Non-core: 0.0MB [PATH]/[Database]/net_account_balances_extension.dict

   LARGE (core) file(s) > 0.5MB....:
      - 28.0MB Mod: 2021-10-20 [PATH]/[Database]/safe/tiksync/trunk
      - 41.1MB Mod: 2021-10-14 [PATH]/[Database]/safe/tiksync/out/20210930222810_310.txn

   DATABASE OBJECT COUNT (count) (est.size KBs):
   -----------------------------------------------------
   Object: csnap 49097 10869.2
   Object: reminder 21 16.8
   Object: secsubtypes 1 0.2
   Object: txn 25405 16460.9
   Object: olsvc 1 0.1
   Object: csplit 2 0.3
   Object: oltxns 112 10.2
   Object: curr 134 36.5
   Object: acct 454 120.8
   Object: misc 2 0.1
    ==========
    TOTAL: 75229 27515.3

   QUICK SEARCH FOR OTHER DATASETS:
   ---------------------------------
   Dataset: Mod: 2021-10-21 [Path]/[Database].moneydance

   BACKUP FILES
   -------------
   Archive: Mod: 2021-10-20 [PATH]/Backups/[Database].2021-10-20.moneydancearchive
   Archive: Mod: 2021-10-21 [PATH]/Backups/[Database].2021-10-21.moneydancearchive

   SYNC FOLDERS FOUND:
   ---------------------
   <NONE FOUND>

   (for a more extensive search please use Toolbox - Find my Datasets and Backups button

   <END>

   TOOLKIT:
   DATASET FILE ANALYSIS
    ====================

   Dataset path: [PATH]/[DATABASE].moneydance

   Dataset size: 73.8MB
   - settings file size: 45.4KB
   - key file size: 0.1KB
   - tiksync folder size: 73.8MB (with 1634 files)
     (note trunk file size: 28.0MB)
     (WAITING Sync 'Out' size: 45.7MB with 1632 files)
   - attachments size: 0.0MB (in 0 attachments)
   - archive size: 0.0MB (in 0 files)
   ---------------------------------------------
   Valid files size: 73.8MB (in 1636 files)

   Non-core file(s) size: 0.0MB (in 1 files)
      - Non-core: 0.0MB [PATH]/[DATABASE].moneydance/net_account_balances_extension.dict

   LARGE (core) file(s) > 0.5MB....:
      - 28.0MB Mod: 2021-10-20 [PATH]/[DATABASE].moneydance/safe/tiksync/trunk
      - 41.1MB Mod: 2021-10-14 [PATH]/[DATABASE].moneydance/safe/tiksync/out/20210930222810_310.txn

   DATABASE OBJECT COUNT (count) (est.size KBs):
   -----------------------------------------------------
   Object: csnap 49097 10869.2
   Object: reminder 21 16.8
   Object: secsubtypes 1 0.2
   Object: txn 25405 16460.9
   Object: olsvc 1 0.1
   Object: csplit 2 0.3
   Object: oltxns 112 10.2
   Object: curr 134 36.5
   Object: acct 454 120.8
   Object: misc 2 0.1
    ==========
    TOTAL: 75229 27515.3

   QUICK SEARCH FOR OTHER DATASETS:
   ---------------------------------
   Dataset: Mod: 2021-10-21 [PATH]/[DATABASE].moneydance

   BACKUP FILES
   -------------
   Archive: Mod: 2021-10-20 [PATH]/Backups/[DATABASE].2021-10-20.moneydancearchive
   Archive: Mod: 2021-10-21 [PATH]/Backups/[DATABASE].2021-10-21.moneydancearchive

   SYNC FOLDERS FOUND:
   ---------------------
   <NONE FOUND>

   (for a more extensive search please use Toolbox - Find my Datasets and Backups button

   <END>

   • Edit

3. 3 Posted by Stuart Beesley ... on Oct 21, 2021 @ 04:49 PM

   

   OK - you said that you 'DO' have Syncing on.... Or did you mean that you do NOT have syncing on...?

   The clue is here: '(WAITING Sync 'Out' size: 45.7MB with 1632 files) '

   This suggests that Sync is not on / not operational? They get zapped once Sync runs and consumes them....

   Can you do Help>Console Window and send your console output?

   • Edit

4. 4 Posted by ed.fischer on Oct 21, 2021 @ 06:31 PM

   

   Sorry DO NOT have syncing on. It appears I typed have twice instead of NOT

   CONSOLE:
   Starting Moneydance 2022 (4056) at Thu Oct 21 08:44:03 PDT 2021
   Settings Folder: [PATH].moneydance
   OS: Linux 5.4.0-89-generic amd64
   Java: 15.0.1 (AdoptOpenJDK)
   Is in sandbox: false; restricted file access: false
   Library path: /usr/java/packages/lib:/usr/lib64:/lib64:/lib:/usr/lib
   initialized extension moneyforesight in 0.305 seconds
   findandreplace (0): 10-21 08:44:04.192|Initialized build 1215 ok
   initialized extension findandreplace in 0.03 seconds
   Initializing fonts:
     default: [[Dialog]]
     printing: [[Dialog]]
     monospaced: [[Monospaced]]
     coding: [[Hack, Monospaced]]
   fonts resolved:
    default: Dialog:12.0:style0
    mono: Monospaced:12.0:style0
    coding: Hack:12.0:style0
    print: Dialog:12.0:style0
    header: Dialog:14.0:style0
    register: Dialog:11.0:style0
    reportTitle: Dialog:32.0:style0
    calendarTitle: Dialog:11.0:style0
    reportHeader: Dialog:10.0:style0
    detailTitle: Dialog:14.0:style0
   Setting look and feel class to javax.swing.plaf.metal.MetalLookAndFeel
   initialized extension yahooqt in 0.829 seconds
   opening last file: [PATH]SR/Devices/Common/[DATABASE].moneydance
   loading dataset: [PATH]SR/Devices/Common/[DATABASE].moneydance
   loading with 128 bit encryption key
   reading trunk data tiksync/trunk
   trunk data loaded (11.453 seconds), checking for incremental updates
   loading un-synced txn files...
   loading synced txn files...
   replacing root: null () with new root: 20210930-QDATA (c560706c-9202-4c6c-9488-369037e9a14e
   ConnectionTask for Update_If_Needed done, result false
   Update info received with successful signature verification
   Version info retrieved; we are up to date!
   loading dataset: [PATH]/[DATABASE].moneydance
   loading with 128 bit encryption key
   reading trunk data tiksync/trunk
   trunk data loaded (2.177 seconds), checking for incremental updates
   loading un-synced txn files...
   loading synced txn files...
   replacing root: null () with new root: 20210930-QDATA (c560706c-9202-4c6c-9488-369037e9a14e
   adding file [PATH]/[DATABASE].moneydance to external account list
   Compacting old transaction logs
   event listener com.moneydance.apps.md.view.gui.sidebar.SideBarModel$SideBarEventListener@3e6c5541 took a while (0.442 seconds) to respond to event md:file:presave
   ConnectionTask for Update_If_Needed done, result false
   backing up file...
   saving automatic backup file: [PATH].moneydance/archive/backups/[DATABASE].2021-10-21.moneydancearchive
   finished backing up file; now to remove expired backups...
   completed removal of expired backups
   Setting look and feel class to javax.swing.plaf.metal.MetalLookAndFeel
   calculated portfolio cost basis in 0.0 seconds
   opening connection with no proxy to https://infinitekind.com/app/md/extensions.dct
   connecting to: https://infinitekind.com/app/md/extensions.dct with method: GET proxy: null
   CookieHandler request for https://infinitekind.com/app/md/extensions.dct
   Cookies retrieved: {Cookie=[]}
   Sending https request:
   GET /app/md/extensions.dct HTTP/1.1
   Content-Length: 0
   Host: infinitekind.com
   DNT: 1
   Accept-Encoding: gzip, inflate
   Connection: close

   ---end headers

   • Edit

5. 5 Posted by Stuart Beesley ... on Oct 21, 2021 @ 09:28 PM

   

   In simple terms, yes you can delete these *.txn files if you don’t intend to sync. Restart MD, File/export backup, and then exit MD. Then delete them.

   (Not support, just a fellow user)

   • Edit

6. 6 Posted by ed.fischer on Oct 22, 2021 @ 09:37 PM

   

   Thanks for the information. I am fairly new to MoneyDance as I've been a quicken user for too many years. I created a PL/SQL app in an Oracle database to move away from Quicken but then found MoneyDance and thought I'd give it a try.

   Anyway, about syncing. you mentioned the txn files can be deleted as long as I do not intend to sync.

   If I set up syncing later without them will sync fail or not be accurate?

   Are the txn files basically every transaction I've performed since startup?

   It appears they continue to be created for each transaction. So if I delete these more will appear?

   If i setup syncing to a network drive will they be then be removed automatically?

   Thanks for your assistance.

   • Edit

7. 7 Posted by Stuart Beesley ... on Oct 23, 2021 @ 09:00 AM

   

   If you have never sync'd, then even if you delete the .txn files and then setup sync, all will be OK. The first thing it does it upload a new trunk file (your dataset) to the sync location and starts from there... Even if that were to fail, the toolbox extension has options to reset and refresh your sync...

   TXN files contain updated records (perhaps 1, sometimes several).. It's the whole record, not just the changed data.... Occasionally that are also your trunk file (the whole thing)... But, yes, essentially then changes since startup... When you enable sync these get consumed and then put into the /in folder renamed as *.mdtxn... Later they get moved (into a zip) into the archive folder....

   Yup - more will appear with every change......

   Yes, if you set up syncing to a network drive they will get consumed.. Then you will have these files in your network location and renamed to .mdtxn in your /in/ folder, later moved to archive.....

   So, your tidy-up routines can be an annual event..

   NOTE: When syncing is enabled, then toolbox can purge these for you....

   • Edit

8. 8 Posted by ed.fischer on Oct 28, 2021 @ 09:46 PM

   

   Thanks for your assistance Stuart it is appreciated.

    

   Is there anything specific I should watch out for when moving the master database/trunk directory from one machine to another with syncing turned on?

    

   I ask because I am in the process of replacing windows with linux on all my computers but have not yet converted my main box.

    

   Thanks

   Ed

   • Edit

9. 9 Posted by Stuart Beesley ... on Oct 29, 2021 @ 05:03 AM

   

   Not really. Just move the whole xxx.moneydance file/folder/package. Don’t worry about the internals.

   Note: If you file/export backup and move the xxx.moneydancearchive file and then file/restore from backup then this will disable sync and the restored dataset will need to have sync reenabled from scratch.

   For a new machine, you will need to copy config.dict too, or as a minimum rekey your license key too.

   • Edit

10. 10 Posted by ed.fischer on Oct 29, 2021 @ 07:30 PM

    

    Thanks and best wishes!

    • Edit

11. ed.fischer closed this discussion on Nov 05, 2021 @ 10:54 PM.