Accessing Moneydance data without Moneydance running?

yacoob's Avatar

yacoob

15 Nov, 2020 01:20 AM

I'd like to run some reporting scripts on Moneydance transactions. Is there any way to access MD data without squeezing my code into a Moneydance extension? Primary reason is that I'd like to present an interactive UI for the report having full control over how it looks (eg. web-based d3js powered).

  1. 1 Posted by Stuart Beesley ... on 15 Nov, 2020 07:11 AM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    You have full Java capabilities if you use Java and launch it inside MD (via an extension). Ditto if you write a Jython (Python) MD script. Failing that you have to export the data.

  2. 2 Posted by yacoob on 15 Nov, 2020 07:08 PM

    yacoob's Avatar

    Is the Python environment sandboxed in any way? Can I just open a port and launch a webservice there? Better still - can I generate HTML and have Moneydance display it as a content of report?

    I guess my reluctance here is that I know more or less what I'd like to do with the data and how to massage it into format usable with d3.js. I'm less eager to couple the potential UI to MD's API.

  3. 3 Posted by Stuart Beesley ... on 15 Nov, 2020 07:31 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Here’s what I know.

    - It’s Jython with full access to Java
    - you cannot access it outside of MD
    - within MD you have full access to just about everything (with some rummaging around)
     
    (A fellow user)

  4. 4 Posted by dwg on 15 Nov, 2020 07:43 PM

    dwg's Avatar

    I'm a fellow user.

    On disk Moneydance data is encrypted. Only through Moneydance do you have access to the unencrypted data.

  5. 5 Posted by hleofxquotes on 17 Nov, 2020 06:40 PM

    hleofxquotes's Avatar

    @yacoob, if you are will to tinker around a bit (there is some hoops you need to jump through ...), see https://bitbucket.org/hleofxquotesteam/md-maven/wiki/Home which has some information on create a headless runnable instance.

    See the "See Also" section at the bottom of the page on an example/prototype using Mike's filedisplay extension.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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