Report Writer feedback

kris's Avatar

kris

23 Mar, 2021 07:58 PM

Hi Mike
I've been exploring your Report Writer extension and must say I'm pretty impressed. I do like to play around with my data and after all the effort to get data into Moneydance, I now want to get it out again :-) and report writer would offer just what I need.
But when checking a generated transaction file, it looks like the exported categorie is not complete: only the subcategorie is exported , not the parent categorie.
cheers, Kris

Showing page 2 out of 2. View the first page

  1. 31 Posted by SteveH42 on 12 Apr, 2021 08:44 AM

    SteveH42's Avatar

    Hi Mike
    Tried that, but unfortunately, still the same problem.
    Attached is the log file and the param file.
    Thanks
    Steve

  2. 32 Posted by Mike Bray on 12 Apr, 2021 11:21 AM

    Mike Bray 's Avatar

    OK, next test. Find where your data is kept. In that folder should be a file called mrbrwdefault.mbjrp. Rename it to save the contents and then rerun your test. It should ask you to set the folders. Please click on the browse button.

  3. 33 Posted by SteveH42 on 12 Apr, 2021 01:01 PM

    SteveH42's Avatar

    Hi Mike
    Ok tried that but still no luck. Files attached.
    Thanks
    Steve

  4. 34 Posted by SteveH42 on 12 Apr, 2021 01:19 PM

    SteveH42's Avatar

    Just had a play and have found if I rename the MRBPreferences.dict2 file then it works. However, looking at this file it also contains config data for your quote loader. I have uploaded the file for reference.

  5. 35 Posted by SteveH42 on 12 Apr, 2021 01:54 PM

    SteveH42's Avatar

    Further testing: If I remove this file and let it create a new one via the Quote Loader extension, then go into ReportWriter and configure the paths, then the Quote Loader config is removed.

  6. 36 Posted by Mike Bray on 12 Apr, 2021 02:39 PM

    Mike Bray 's Avatar

    That's interesting.  Your original mrbpreferences.dict2 has a rogue
    directory in it
    "firstrundir":"D:\\Users\\Steve\\Desktop\\Report_output". Let me play
    around with this so I can find out what is going on.  On the one where
    the quote loader preferences disappeared, please can you rerun and
    upload the error log and the preferences file.
    Thanks
    Mike

  7. 37 Posted by SteveH42 on 12 Apr, 2021 03:26 PM

    SteveH42's Avatar

    Hi Mike
    Files attached. The process I followed was:

    All files deleted, went into MD and ran the Quote Loader. Contents of MRBPreferences.dict2 is:
    {
    "mapData": {
    "securityquoteload.framedepth": "800",
    "securityquoteload.runtype": "rundaily",
    "securityquoteload.framewidth": "800",
    "securityquoteload.runmode": "automode"
    }
    }

    Now run the Report Writer confif and save folders, Contents of MRBPreferences.dict2 is:

    {
    "mapData": {
    "reportwriter.framex": "0",
    "reportwriter.framey": "0",
    "firstrundir": "C:\\tmp",
    "parmlastdb": "20210121",
    "reportwriter.datapanewidth": "820",
    "reportwriter.datapaneheight": "600"
    }
    }

    Back into Quote Loader and config again, Contents of MRBPreferences.dict2 is:

    {
    "mapData": {
    "securityquoteload.framedepth": "800",
    "securityquoteload.runtype": "rundaily",
    "securityquoteload.framewidth": "800",
    "securityquoteload.runmode": "automode"
    }
    }

    Backl into Report Writer and Contents of MRBPreferences.dict2 is:
    {
    "mapData": {
    "securityquoteload.framedepth": "800",
    "securityquoteload.runtype": "rundaily",
    "securityquoteload.framewidth": "800",
    "securityquoteload.runmode": "automode",
    "reportwriter.framex": "0",
    "reportwriter.framey": "0",
    "parmlastdb": "20210121",
    "reportwriter.datapanewidth": "820",
    "reportwriter.datapaneheight": "600"
    }
    }

    Hope this helps
    Steve

  8. 38 Posted by Mike Bray on 13 Apr, 2021 07:27 AM

    Mike Bray 's Avatar

    Thanks Steve, it is worrying that the preferences file is overwritten. I
    will look into it.
    Regards
    Mike

  9. 39 Posted by Mike Bray on 13 Apr, 2021 02:35 PM

    Mike Bray 's Avatar

    Hi Steve, I have discovered the reason for the loss of data from preferences, thanks for finding this. I have recompiled all my extensions and uploaded them to Downloads. Unfortunately these are unverified. Please download both Quote Loader and Report Writer and retry your tests.

  10. 40 Posted by SteveH42 on 13 Apr, 2021 09:15 PM

    SteveH42's Avatar

    Hi Mike
    That all seems to have fixed the issues.
    Many thanks! I'll now start to try and work out how to create some reports :)

    Steve

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