External Access to data

hvangelder's Avatar

hvangelder

07 Jun, 2023 10:23 AM

Apologies if this has been discussed earlier.

How can I access the data from outside the MD app using Java?

If you have a sample or guide, it will be amazing.

I'm trying to get all the data out and into a MySQL Database.

In the past, I did this with an Add in, made using Java, that will export each major data component to CSV files, but it's cumbersome, and I just want the data exported automatically.

  1. 1 Posted by Stuart Beesley ... on 07 Jun, 2023 10:51 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Slightly tricky and NOT supported by IK.... (and do not update data)...

    Read the section "Experimental / advanced:" here:
    https://yogi1967.github.io/MoneydancePythonScripts/

    and also this post:
    https://infinitekind.tenderapp.com/discussions/moneydance-developme...

    and this repo

    https://github.com/dkfurrow/md_python_headless_demo

  2. 2 Posted by hvangelder on 07 Jun, 2023 01:55 PM

    hvangelder's Avatar

    Hi,

    I'm trying to access the MD file to export the data.

    Attached is what I have until now. The idea is to get the root Account Name and description, but I'm getting the following error:

    ===============================================
    Export Process Start . . .
    Exception in thread "main" java.lang.NoClassDefFoundError: com/moneydance/apps/md/controller/sync/AbstractSyncFolder
    at App.main(App.java:45)
    App.java:45
    Caused by: java.lang.ClassNotFoundException: com.moneydance.apps.md.controller.sync.AbstractSyncFolder
    at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
    BuiltinClassLoader.java:641
    at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
    ClassLoaders.java:188
    at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)
    ClassLoader.java:520
    ... 1 more
    ===============================================

    I think I need to key in the passphrase or similar....Can you help me?

  3. 3 Posted by Stuart Beesley ... on 07 Jun, 2023 08:12 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    .

  4. 4 Posted by Stuart Beesley ... on 07 Jun, 2023 08:43 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    .

  5. System closed this discussion on 06 Sep, 2023 08:50 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

Recent Discussions

15 Apr, 2024 03:26 PM
15 Apr, 2024 03:24 PM
15 Apr, 2024 12:32 PM
15 Apr, 2024 12:20 PM
15 Apr, 2024 11:56 AM