Home → Extension Development →

External Access to data

• Edit

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

   

   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

   • Edit

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

   

   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?

   • new_4.java 863 Bytes
   • Edit

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

   

   .

   • Edit

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

   

   .

   • Edit

5. System closed this discussion on 06 Sep, 2023 08:50 PM.