TXN Files

ed.fischer's Avatar

ed.fischer

20 Oct, 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 21 Oct, 2021 05:33 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    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.

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

    ed.fischer's Avatar

    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>

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

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    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?

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

    ed.fischer's Avatar

    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

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

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    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)

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

    ed.fischer's Avatar

    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.

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

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    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....

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

    ed.fischer's Avatar

    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

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

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    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.

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

    ed.fischer's Avatar

    Thanks and best wishes!

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

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac