File load error in Load Security Transactions

simon's Avatar

simon

25 Jan, 2023 08:58 AM

Hi @mikebray
After years of manually inputting data from HL I have just discovered this and will save me hours, except I get the attached error when I try to load the file. It's a download from HL, with the extra rows removed, so just the header row and data. I have checked in bbedit that its actually comma separated and all looks good, but there seems to be some other issue. I have also tried changing the encoding but no luck there either.
Thanks
Simon

  1. 1 Posted by Stuart Beesley ... on 25 Jan, 2023 09:12 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    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.

    A qif file could work if you could get all the relevant data into it.

  2. 2 Posted by Stuart Beesley ... on 25 Jan, 2023 09:14 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Ignore me. I think you are referring to Mike Bray’s extension. I look forward to seeing how you get on.

    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.

  3. 3 Posted by simon on 25 Jan, 2023 09:21 AM

    simon's Avatar

    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.

    Actually, it might be because I have uninstalled java. Will reinstall and confirm.

  4. 4 Posted by dwg on 25 Jan, 2023 09:35 AM

    dwg's Avatar

    Moneydance has its own bundled version of Java included.

  5. 5 Posted by simon on 25 Jan, 2023 09:41 AM

    simon's Avatar

    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?

  6. 6 Posted by Stuart Beesley ... on 25 Jan, 2023 09:58 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Yes. Unfortunately I need multi accounts, multi client, and all the buy/sell stuff etc.

  7. 7 Posted by Stuart Beesley ... on 25 Jan, 2023 09:59 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I have actually recommended to HL a new download, but doubt it will get actioned.

  8. 8 Posted by Stuart Beesley ... on 25 Jan, 2023 10:02 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

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

  9. 9 Posted by simon on 25 Jan, 2023 10:12 AM

    simon's Avatar

    No stack dump.
    This is a most basic file I am testing with created in Bbedit, and same error as the HL files.

  10. 10 Posted by dwg on 25 Jan, 2023 10:41 AM

    dwg's Avatar

    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.

  11. 11 Posted by simon on 25 Jan, 2023 10:42 AM

    simon's Avatar

    Correct.. the fact I entered buy shouldn't matter when I load the file, as you set what that field means later.

  12. System closed this discussion on 26 Apr, 2023 10:50 AM.

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