tag:infinitekind.tenderapp.com,2009-01-14:/discussions/general-questions/115632-txn-filesInfinite Kind: Discussion 2021-11-05T22:54:55Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/494457612021-10-21T05:33:00Z2021-10-21T05:33:00ZTXN Files<div><p>Are they txn or mdtxn? And which folder are they in? Is syncing actually working?</p>
<p>Please send help / console window contents</p>
<p>What version of MD?</p>
<p>If on md2021.1 onwards, install and run toolbox extension. Click analyse my datasets and objects. Post that output here too.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/494457612021-10-21T16:22:53Z2021-10-21T16:22:53ZTXN Files<div><p>They are [FILENAME].txn<br>
They are in [DATABASE]/safe/tiksync/out<br>
Running 2022 (4056)</p>
<p>CONSOLE:<br>
DATASET FILE ANALYSIS<br>
====================</p>
<p>Dataset path: [PATH]/[Database]</p>
<p>Dataset size: 73.8MB<br>
- 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)</p>
<h2><a name="-archive-size-0-0mb-in-0-files-" class="anchor" href="#-archive-size-0-0mb-in-0-files-"></a>- archive size: 0.0MB (in 0 files)</h2>
<p>Valid files size: 73.8MB (in 1636 files)</p>
<p>Non-core file(s) size: 0.0MB (in 1 files)<br>
- Non-core: 0.0MB [PATH]/[Database]/net_account_balances_extension.dict</p>
<p>LARGE (core) file(s) > 0.5MB....:<br>
- 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</p>
<h2><a name="database-object-count-count-est-size-kbs-" class="anchor" href="#database-object-count-count-est-size-kbs-"></a>DATABASE OBJECT COUNT (count) (est.size KBs):</h2>
<p>Object: csnap 49097 10869.2<br>
Object: reminder 21 16.8<br>
Object: secsubtypes 1 0.2<br>
Object: txn 25405 16460.9<br>
Object: olsvc 1 0.1<br>
Object: csplit 2 0.3<br>
Object: oltxns 112 10.2<br>
Object: curr 134 36.5<br>
Object: acct 454 120.8<br>
Object: misc 2 0.1<br>
========== TOTAL: 75229 27515.3</p>
<h2><a name="quick-search-for-other-datasets-" class="anchor" href="#quick-search-for-other-datasets-"></a>QUICK SEARCH FOR OTHER DATASETS:</h2>
<p>Dataset: Mod: 2021-10-21 [Path]/[Database].moneydance</p>
<h2><a name="backup-files-" class="anchor" href="#backup-files-"></a>BACKUP FILES</h2>
<p>Archive: Mod: 2021-10-20 [PATH]/Backups/[Database].2021-10-20.moneydancearchive<br>
Archive: Mod: 2021-10-21 [PATH]/Backups/[Database].2021-10-21.moneydancearchive</p>
<h2><a name="sync-folders-found-" class="anchor" href="#sync-folders-found-"></a>SYNC FOLDERS FOUND:</h2>
<p>(for a more extensive search please use Toolbox - Find my Datasets and Backups button</p>
<p>TOOLKIT:<br>
DATASET FILE ANALYSIS<br>
====================</p>
<p>Dataset path: [PATH]/[DATABASE].moneydance</p>
<p>Dataset size: 73.8MB<br>
- 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)</p>
<h2><a name="-archive-size-0-0mb-in-0-files-_1" class="anchor" href="#-archive-size-0-0mb-in-0-files-_1"></a>- archive size: 0.0MB (in 0 files)</h2>
<p>Valid files size: 73.8MB (in 1636 files)</p>
<p>Non-core file(s) size: 0.0MB (in 1 files)<br>
- Non-core: 0.0MB [PATH]/[DATABASE].moneydance/net_account_balances_extension.dict</p>
<p>LARGE (core) file(s) > 0.5MB....:<br>
- 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</p>
<h2><a name="database-object-count-count-est-size-kbs-_1" class="anchor" href="#database-object-count-count-est-size-kbs-_1"></a>DATABASE OBJECT COUNT (count) (est.size KBs):</h2>
<p>Object: csnap 49097 10869.2<br>
Object: reminder 21 16.8<br>
Object: secsubtypes 1 0.2<br>
Object: txn 25405 16460.9<br>
Object: olsvc 1 0.1<br>
Object: csplit 2 0.3<br>
Object: oltxns 112 10.2<br>
Object: curr 134 36.5<br>
Object: acct 454 120.8<br>
Object: misc 2 0.1<br>
========== TOTAL: 75229 27515.3</p>
<h2><a name="quick-search-for-other-datasets-_1" class="anchor" href="#quick-search-for-other-datasets-_1"></a>QUICK SEARCH FOR OTHER DATASETS:</h2>
<p>Dataset: Mod: 2021-10-21 [PATH]/[DATABASE].moneydance</p>
<h2><a name="backup-files-_1" class="anchor" href="#backup-files-_1"></a>BACKUP FILES</h2>
<p>Archive: Mod: 2021-10-20 [PATH]/Backups/[DATABASE].2021-10-20.moneydancearchive<br>
Archive: Mod: 2021-10-21 [PATH]/Backups/[DATABASE].2021-10-21.moneydancearchive</p>
<h2><a name="sync-folders-found-_1" class="anchor" href="#sync-folders-found-_1"></a>SYNC FOLDERS FOUND:</h2>
<p>(for a more extensive search please use Toolbox - Find my Datasets and Backups button</p></div>ed.fischertag:infinitekind.tenderapp.com,2009-01-14:Comment/494457612021-10-21T16:49:41Z2021-10-21T16:49:41ZTXN Files<div><p>OK - you said that you 'DO' have Syncing on.... Or did you mean that you do NOT have syncing on...?</p>
<p>The clue is here: '(WAITING Sync 'Out' size: 45.7MB with 1632 files) '</p>
<p>This suggests that Sync is not on / not operational? They get zapped once Sync runs and consumes them....</p>
<p>Can you do Help>Console Window and send your console output?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/494457612021-10-21T18:31:56Z2021-10-21T18:31:56ZTXN Files<div><p>Sorry DO NOT have syncing on. It appears I typed have twice instead of NOT</p>
<p>CONSOLE:<br>
Starting Moneydance 2022 (4056) at Thu Oct 21 08:44:03 PDT 2021<br>
Settings Folder: [PATH].moneydance<br>
OS: Linux 5.4.0-89-generic amd64<br>
Java: 15.0.1 (AdoptOpenJDK)<br>
Is in sandbox: false; restricted file access: false<br>
Library path: /usr/java/packages/lib:/usr/lib64:/lib64:/lib:/usr/lib<br>
initialized extension moneyforesight in 0.305 seconds<br>
findandreplace (0): 10-21 08:44:04.192|Initialized build 1215 ok<br>
initialized extension findandreplace in 0.03 seconds<br>
Initializing fonts:<br>
default: [[Dialog]] printing: [[Dialog]] monospaced: [[Monospaced]] coding: [[Hack, Monospaced]] fonts resolved:<br>
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<br>
initialized extension yahooqt in 0.829 seconds<br>
opening last file: [PATH]SR/Devices/Common/[DATABASE].moneydance<br>
loading dataset: [PATH]SR/Devices/Common/[DATABASE].moneydance<br>
loading with 128 bit encryption key<br>
reading trunk data tiksync/trunk<br>
trunk data loaded (11.453 seconds), checking for incremental updates<br>
loading un-synced txn files...<br>
loading synced txn files...<br>
replacing root: null () with new root: 20210930-QDATA (c560706c-9202-4c6c-9488-369037e9a14e<br>
ConnectionTask for Update_If_Needed done, result false<br>
Update info received with successful signature verification<br>
Version info retrieved; we are up to date!<br>
loading dataset: [PATH]/[DATABASE].moneydance<br>
loading with 128 bit encryption key<br>
reading trunk data tiksync/trunk<br>
trunk data loaded (2.177 seconds), checking for incremental updates<br>
loading un-synced txn files...<br>
loading synced txn files...<br>
replacing root: null () with new root: 20210930-QDATA (c560706c-9202-4c6c-9488-369037e9a14e<br>
adding file [PATH]/[DATABASE].moneydance to external account list<br>
Compacting old transaction logs<br>
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<br>
ConnectionTask for Update_If_Needed done, result false<br>
backing up file...<br>
saving automatic backup file: [PATH].moneydance/archive/backups/[DATABASE].2021-10-21.moneydancearchive<br>
finished backing up file; now to remove expired backups...<br>
completed removal of expired backups<br>
Setting look and feel class to javax.swing.plaf.metal.MetalLookAndFeel<br>
calculated portfolio cost basis in 0.0 seconds<br>
opening connection with no proxy to <a href="https://infinitekind.com/app/md/extensions.dct">https://infinitekind.com/app/md/extensions.dct</a><br>
connecting to: <a href="https://infinitekind.com/app/md/extensions.dct">https://infinitekind.com/app/md/extensions.dct</a> with method: GET proxy: null<br>
CookieHandler request for <a href="https://infinitekind.com/app/md/extensions.dct">https://infinitekind.com/app/md/extensions.dct</a><br>
Cookies retrieved: {Cookie=[]}<br>
Sending https request:<br>
GET /app/md/extensions.dct HTTP/1.1<br>
Content-Length: 0<br>
Host: infinitekind.com<br>
DNT: 1<br>
Accept-Encoding: gzip, inflate<br>
Connection: close</p>
<p>---end headers</p></div>ed.fischertag:infinitekind.tenderapp.com,2009-01-14:Comment/494457612021-10-21T21:28:14Z2021-10-21T21:28:14ZTXN Files<div><p>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.</p>
<p>(Not support, just a fellow user)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/494457612021-10-22T21:37:58Z2021-10-22T21:37:58ZTXN Files<div><p>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.</p>
<p>Anyway, about syncing. you mentioned the txn files can be deleted as long as I do not intend to sync.</p>
<p>If I set up syncing later without them will sync fail or not be accurate?</p>
<p>Are the txn files basically every transaction I've performed since startup?</p>
<p>It appears they continue to be created for each transaction. So if I delete these more will appear?</p>
<p>If i setup syncing to a network drive will they be then be removed automatically?</p>
<p>Thanks for your assistance.</p></div>ed.fischertag:infinitekind.tenderapp.com,2009-01-14:Comment/494457612021-10-23T09:00:30Z2021-10-23T09:00:30ZTXN Files<div><p>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...</p>
<p>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....</p>
<p>Yup - more will appear with every change......</p>
<p>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.....</p>
<p>So, your tidy-up routines can be an annual event..</p>
<p>NOTE: When syncing is enabled, then toolbox can purge these for you....</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/494457612021-10-28T21:46:10Z2021-10-28T21:46:10ZTXN Files<div><p>Thanks for your assistance Stuart it is appreciated.</p>
<p>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?</p>
<p>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.</p>
<p>Thanks</p>
<p>Ed</p></div>ed.fischertag:infinitekind.tenderapp.com,2009-01-14:Comment/494457612021-10-29T05:03:14Z2021-10-29T05:03:14ZTXN Files<div><p>Not really. Just move the whole xxx.moneydance file/folder/package. Don’t worry about the internals.</p>
<p>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.</p>
<p>For a new machine, you will need to copy config.dict too, or as a minimum rekey your license key too.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/494457612021-10-29T19:30:53Z2021-10-29T19:30:53ZTXN Files<div><p>Thanks and best wishes!</p></div>ed.fischer