tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/7462-file-load-error-in-load-security-transactionsInfinite Kind: Discussion 2023-04-26T10:50:21Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/576895822023-01-25T09:12:05Z2023-01-25T09:12:53ZFile load error in Load Security Transactions <div><p>Hmm. I’m sceptical that you have a valid csv that can be used for investment accounts. I also use HL and I don’t know of any download that provides all the necessary information. And MD cannot import csv into investment accounts. Sorry.</p>
<p>A qif file could work if you could get all the relevant data into it.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/576895822023-01-25T09:14:21Z2023-01-25T09:14:21ZFile load error in Load Security Transactions <div><p>Ignore me. I think you are referring to Mike Bray’s extension. I look forward to seeing how you get on.</p>
<p>FYI. I recently set about creating my own extn, but gave up in making a generic one as a lot of data was missing from HL extracts.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/576895822023-01-25T09:21:23Z2023-01-25T09:21:23ZFile load error in Load Security Transactions <div><p>Yes, he says its specifically created for HL, and mentions that whilst it doesn't have buy sell flags so might not do security transactions, it will import the much more frequent lines for loyalty bonuses, divs, mgmt fees etc that are actually harder to reconcile.</p>
<p>Actually, it might be because I have uninstalled java. Will reinstall and confirm.</p></div>simontag:infinitekind.tenderapp.com,2009-01-14:Comment/576895822023-01-25T09:35:30Z2023-01-25T09:35:30ZFile load error in Load Security Transactions <div><p>Moneydance has its own bundled version of Java included.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/576895822023-01-25T09:41:19Z2023-01-25T09:41:26ZFile load error in Load Security Transactions <div><p>Thanks, and yes intalling java didn't help either. I am on Ventura, and see some comments about Java swing having issues on some Mac versions?</p></div>simontag:infinitekind.tenderapp.com,2009-01-14:Comment/576895822023-01-25T09:58:50Z2023-01-25T09:58:50ZFile load error in Load Security Transactions <div><p>Yes. Unfortunately I need multi accounts, multi client, and all the buy/sell stuff etc.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/576895822023-01-25T09:59:20Z2023-01-25T09:59:20ZFile load error in Load Security Transactions <div><p>I have actually recommended to HL a new download, but doubt it will get actioned.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/576895822023-01-25T10:02:55Z2023-01-25T10:02:55ZFile load error in Load Security Transactions <div><p>If you look in help/console after this error, is there an error stack dump..? If so, post that here... and/or upload an example file here...</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/576895822023-01-25T10:12:54Z2023-01-25T10:12:56ZFile load error in Load Security Transactions <div><p>No stack dump.<br>
This is a most basic file I am testing with created in Bbedit, and same error as the HL files.</p></div>simontag:infinitekind.tenderapp.com,2009-01-14:Comment/576895822023-01-25T10:41:19Z2023-01-25T10:41:19ZFile load error in Load Security Transactions <div><p>I seem to vaguely remember, but I could well be wrong, that Mike's extension handles income and expense types of transactions it did not handle Buy and Sells.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/576895822023-01-25T10:42:49Z2023-01-25T10:42:50ZFile load error in Load Security Transactions <div><p>Correct.. the fact I entered buy shouldn't matter when I load the file, as you set what that field means later.</p></div>simon