tag:infinitekind.tenderapp.com,2009-01-14:/discussions/moneydance-development/3113-mike-bray-report-writer-extensionInfinite Kind: Discussion 2021-07-30T11:40:22Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912020-10-01T07:45:11Z2020-10-01T07:45:11ZMike Bray - Report Writer Extension<div><p>Steve, Report Writer is under development and has not been released, I<br>
wouldn't use the Wiki for this. You must have listed the files in the<br>
Wiki to get to it as you can not get to it via the Home screen.</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912020-10-01T08:03:27Z2020-10-01T08:03:27ZMike Bray - Report Writer Extension<div><p>Hi Mike, I did think as much. I was looking for something that will create custom reports as the ones inside MD are pretty basic and limited. I sort of stumbled across this as I was looking. It looks very promising so will be quite keen to take a further look once you have a beta release?<br>
Regards<br>
Steve</p></div>SteveH42tag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912020-11-08T07:00:45Z2020-11-08T07:00:45ZMike Bray - Report Writer Extension<div><p>Hi Mike<br>
Any progress on this, so looking forward to seeing a 'production' version<br>
Cheers<br>
tonyt</p></div>tonyttag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912020-11-08T09:38:55Z2020-11-08T09:38:55ZMike Bray - Report Writer Extension<div><p>Hi Tony, not yet it will be a few months. The post was to try and get<br>
input on what people would expect to see.</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912020-11-08T09:51:27Z2020-11-08T09:51:27ZMike Bray - Report Writer Extension<div><p>Hi Mike</p>
<p>I think a report writer is a great idea. The key to how well received it would be dependents on how easy it is for the average person you use. The need to know what’s going on under the bonnet will put most people off.<br>
I know this depends on who your target user is.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912020-11-08T10:00:12Z2020-11-08T10:00:12ZMike Bray - Report Writer Extension<div><p>I agree. As a geek, I want to be able to dump/extract raw data without having to write a script (eg just dump all prices or all securities or all txns). But also as a ‘normal’ user, I want to be able to extract the data as MD presents it.</p>
<p>For example, I just wrote a script to extract investment register data. It took quite a while to understand the MD ‘model’ and then translate that to a format that mirrors the MD onscreen investment register.</p>
<p>Perhaps have a ‘Geek’ / ‘User’ mode and flip between the two. The problem i see is that you will have to code for all datasets but then that’s what will make this tool useful.</p>
<p>I’m happy to beta test any early code and provide comments.</p>
<p>Regards Stuart</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912020-11-08T10:15:04Z2020-11-08T10:15:04ZMike Bray - Report Writer Extension<div><p>Thanks for the feedback, you have both raised the one concern I had,<br>
which is the ability of the user to use the extension. The fields I am<br>
making available are those on the screen for each record, for example<br>
the Account Maintenance screen, the transaction screen and the<br>
investment transaction screen. I am not exposing the underlying fields<br>
or codes. For example for transaction status I am outputing<br>
CLEARED/UNRECONCILED/RECONCILING not the internal status which is<br>
numeric. I am only outputing individual records, there is no<br>
summarisation. I expect users to either use Excel or Jasper Reports to<br>
do the summarisation.</p>
<p>I know that Jasper Reports is not a general user tool but more of an<br>
educated/IT savy user tool, but it is well known and free. If people<br>
wish to use a different tool they can do so by outputing the data top a<br>
database.<br>
Regards<br>
Mike</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912020-11-08T10:30:09Z2020-11-08T10:30:09ZMike Bray - Report Writer Extension<div><p>Well I think having the on screen data version will be the priority for most people. So great!!</p>
<p>Regards Stuart</p>
<p>On 8 Nov 2020, at 10:15, Mike Bray <a href="mailto:tender+d05c4acc18@tenderapp.com">tender+d05c4acc18@tenderapp.com</a> wrote:</p>
<p></p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912020-11-08T10:54:52Z2020-11-08T10:54:52ZMike Bray - Report Writer Extension<div><p>I would agree. I think that initially for most people, they will want to be able to report on what they see on screen rather than the underlying data structure.<br>
I too, would be more than happy to beta test when you get a little nearer.</p>
<p>Regards<br>
Steve</p></div>SteveH42tag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912021-03-27T17:15:57Z2021-03-27T17:15:57ZMike Bray - Report Writer Extension<div><p>Hi Mike<br>
Are you any further forward with this?<br>
Cheers..</p></div>tonyttag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912021-03-29T14:26:08Z2021-03-29T14:26:08ZMike Bray - Report Writer Extension<div><p>Hi Tony, the extension is available here: <a href="https://bitbucket.org/mikerb/moneydance-2019/downloads/">https://bitbucket.org/mikerb/moneydance-2019/downloads/</a></p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912021-03-29T19:50:43Z2021-03-29T19:50:43ZMike Bray - Report Writer Extension<div><p>Hi Mike</p>
<p>I just installed this version 3030.00 and all I get when I run it is a<br>
blank white screen.</p>
<p>Regards</p>
<p>Steve</p>
<p>From: Mike Bray <a href="mailto:tender+d05c4acc18@tenderapp.com">tender+d05c4acc18@tenderapp.com</a><br>
Sent: 29 March 2021 15:26<br>
To: <a href="mailto:mail@stevehurst.org.uk">mail@stevehurst.org.uk</a><br>
Subject: Re: Mike Bray - Report Writer Extension [Extension Development<br>
#3113]</p></div>SteveH42tag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912021-04-09T14:31:09Z2021-04-09T14:31:09ZMike Bray - Report Writer Extension<div><p>Hi Steve, please download the latest version from downloads, it is 3031. What is the file you have attached?</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912021-04-09T16:22:07Z2021-04-09T16:22:07ZMike Bray - Report Writer Extension<div><p>This is now working in 3031 - not sure what that file is - shouldn't be there.<br>
Thanks.</p></div>SteveH42tag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912021-04-17T17:55:02Z2021-04-17T17:55:02ZMike Bray - Report Writer Extension<div><p>Hi, I am running Report Writer 3033.01 on a MAC OS 10.14 with Moneydance 2020.1(1928) from the Apple Store. It constantly shows a blank main screen following any kind of error. Most of the time but not always I can continue buy removing the install, deleting the \mrbredefault.mbjrp and starting over. It would be nice not to have to do that</p></div>donald.reidtag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912021-04-18T12:26:30Z2021-04-18T12:26:30ZMike Bray - Report Writer Extension<div><p>Hi Donald,<br>
Please can you post the error log. To be clear have you set the three<br>
directories required on first use? Lastly please can you upgrade to<br>
3034 that is available in the downloads folder.<br>
Regards<br>
Mike</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912021-04-28T19:23:29Z2021-04-28T19:23:29ZMike Bray - Report Writer Extension<div><p>From: sprimost</p>
<p>This extension is outstanding! Development time (yep, using python3) is<br>
short to get the information for some proper reports in the detail I<br>
need. But having a bit of a problem with the accounts extract: it does<br>
not seem to extract out the broker name and broker phone number. Is it<br>
something that I am not doing within data selection; the only filter I<br>
do is to include all dates, which does not affect this particular<br>
selection of accounts? (Using 3030.0)</p>
<p>/scp</p></div>sprimosttag:infinitekind.tenderapp.com,2009-01-14:Comment/486798912021-04-30T11:31:51Z2021-04-30T11:31:51ZMike Bray - Report Writer Extension<div><p>Hi Donald, sorry for the delay in responding.</p>
<p>Broker name and phone number are only output on securities belonging to<br>
an investment account. You can only enter these fields when you add a<br>
security to the investment account. In the Data Selection Group, select<br>
Accounts and Include Securities.</p>
<p>You should get the fields on the Security accounts.<br>
Regards<br>
Mike</p></div>Mike Bray (Quote Loader Author)