tag:infinitekind.tenderapp.com,2009-01-14:/discussions/general-questions/106940-moneydance-connectorInfinite Kind: Discussion 2021-01-28T17:16:34Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/489264582020-12-23T12:42:13Z2021-01-02T10:03:55ZMoneyDance Connector<div><p>Nope. The dataset is a special format and also encrypted. However, you can extract data to csv and load it from there..... You can explore my extract scripts found here:</p>
<p><a href="https://yogi1967.github.io/MoneydancePythonScripts/">https://yogi1967.github.io/MoneydancePythonScripts/</a></p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/489264582020-12-23T19:11:44Z2020-12-23T19:11:44ZMoneyDance Connector<div><p>Also FYI there is a menu item called File / Export and you can dump the entire database to a json file. I’m aware of another user who uses MS Access and Power BI to read the json file and do reports...</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/489264582021-01-11T15:41:37Z2021-01-11T15:41:37ZMoneyDance Connector<div><p>Hi Stuart,</p>
<p>Thanks for your script. Is 5*!</p>
<p>Is there a way to have the information from also the parent account and not only the sub-account?</p>
<p>[cid:email_8316aeab-b0d2-42f4-96a2-a4359898d3ad.png]</p>
<p>Sérgio Mendes<br>
IT Business Analyst<br>
[cid:email2_6621cb4e-8b02-4a95-a42d-6400a9ed07ec.png]<br>
Avenida da Liberdade 144 5ºESQ<br>
1250-096 | Lisboa</p>
<p>SUJEITO A SEGREDO PROFISSIONAL</p>
<p>Esta mensagem e os seus eventuais anexos são dirigidos unicamente aos respetivos destinatários e estão sujeitos a segredo profissional. Caso os tenha recebido por engano, solicitamos que contacte o remetente e que os elimine sem os utilizar, reproduzir ou disponibilizar a terceiros.</p>
<p>PROTECTED BY PROFESSIONAL PRIVILEGE</p>
<p>This message and its attachments, if any, are intended solely for the use of the persons to whom it is addressed to and are protected by professional privilege. If you have received them by error, you are kindly requested to contact the sender and to delete the e-mail and its attachments, if any, from your computer system without taking any action based upon them, or without copying or disclosing them to anyone.</p>
<p>[cid:email3_5d4ea582-5c5c-4fcb-a197-5555efcf8bd6.jpg]Think green and do not print this email unless absolutely necessary.</p></div>sergio.mendestag:infinitekind.tenderapp.com,2009-01-14:Comment/489264582021-01-11T15:47:57Z2021-01-11T15:47:57ZMoneyDance Connector<div><p>Hi, can you tell me which script you are running and also some examples of what you want? I don't understand.. Thanks S</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/489264582021-01-11T15:52:01Z2021-01-11T15:52:01ZMoneyDance Connector<div><p>Script: Extract_account_registers_csv</p>
<p>The script only retrieve the sub-account, por example (3805 Postmate) and doesn’t retrieve de parent category 38 Restaurantes.</p>
<p>I would like also to have this information in the csv. Please see picture below.</p>
<p>[cid:<a href="mailto:image001.jpg@01D6E831.A54AC2B0">image001.jpg@01D6E831.A54AC2B0</a>]</p>
<p>[cid:email_8316aeab-b0d2-42f4-96a2-a4359898d3ad.png]</p>
<p>Sérgio Mendes<br>
IT Business Analyst<br>
[cid:email2_6621cb4e-8b02-4a95-a42d-6400a9ed07ec.png]<br>
Avenida da Liberdade 144 5ºESQ<br>
1250-096 | Lisboa</p>
<p>SUJEITO A SEGREDO PROFISSIONAL</p>
<p>Esta mensagem e os seus eventuais anexos são dirigidos unicamente aos respetivos destinatários e estão sujeitos a segredo profissional. Caso os tenha recebido por engano, solicitamos que contacte o remetente e que os elimine sem os utilizar, reproduzir ou disponibilizar a terceiros.</p>
<p>PROTECTED BY PROFESSIONAL PRIVILEGE</p>
<p>This message and its attachments, if any, are intended solely for the use of the persons to whom it is addressed to and are protected by professional privilege. If you have received them by error, you are kindly requested to contact the sender and to delete the e-mail and its attachments, if any, from your computer system without taking any action based upon them, or without copying or disclosing them to anyone.</p>
<p>[cid:email3_5d4ea582-5c5c-4fcb-a197-5555efcf8bd6.jpg]Think green and do not print this email unless absolutely necessary.</p></div>sergio.mendestag:infinitekind.tenderapp.com,2009-01-14:Comment/489264582021-01-11T16:03:43Z2021-01-11T16:03:43ZMoneyDance Connector<div><p>Perhaps you are selecting the wrong account. Try selecting the parent and then ticking the box that says include sub accounts...?</p>
<p>If this doesn't work, please send picture of your account structure AND the parameters you are selecting on my script.. Thanks</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/489264582021-01-11T16:11:11Z2021-01-11T16:11:11ZMoneyDance Connector<div><p>Is not a sub-account is a sub-category, from here (picture below)</p>
<p>[cid:<a href="mailto:image001.jpg@01D6E834.514BE4C0">image001.jpg@01D6E834.514BE4C0</a>]</p>
<p>Is possible to have the information about the main category and not only the sub-category?</p>
<p>[cid:email_8316aeab-b0d2-42f4-96a2-a4359898d3ad.png]</p>
<p>Sérgio Mendes<br>
IT Business Analyst<br>
[cid:email2_6621cb4e-8b02-4a95-a42d-6400a9ed07ec.png]<br>
Avenida da Liberdade 144 5ºESQ<br>
1250-096 | Lisboa</p>
<p>SUJEITO A SEGREDO PROFISSIONAL</p>
<p>Esta mensagem e os seus eventuais anexos são dirigidos unicamente aos respetivos destinatários e estão sujeitos a segredo profissional. Caso os tenha recebido por engano, solicitamos que contacte o remetente e que os elimine sem os utilizar, reproduzir ou disponibilizar a terceiros.</p>
<p>PROTECTED BY PROFESSIONAL PRIVILEGE</p>
<p>This message and its attachments, if any, are intended solely for the use of the persons to whom it is addressed to and are protected by professional privilege. If you have received them by error, you are kindly requested to contact the sender and to delete the e-mail and its attachments, if any, from your computer system without taking any action based upon them, or without copying or disclosing them to anyone.</p>
<p>[cid:email3_5d4ea582-5c5c-4fcb-a197-5555efcf8bd6.jpg]Think green and do not print this email unless absolutely necessary.</p></div>sergio.mendestag:infinitekind.tenderapp.com,2009-01-14:Comment/489264582021-01-11T16:33:50Z2021-01-11T16:33:50ZMoneyDance Connector<div><p>Do you mean you want to extract the category field as:<br>
'38 Restaurantes:3805 Postmaster' and not as just<br>
'3805 Postmaster' - i.e. the Full account name....</p>
<p>I assume the extract and txns listed are otherwise OK?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/489264582021-01-11T16:37:46Z2021-01-11T16:37:46ZMoneyDance Connector<div><p>Exactly, is it possible?</p>
<p>[cid:email_8316aeab-b0d2-42f4-96a2-a4359898d3ad.png]</p>
<p>Sérgio Mendes<br>
IT Business Analyst<br>
[cid:email2_6621cb4e-8b02-4a95-a42d-6400a9ed07ec.png]<br>
Avenida da Liberdade 144 5ºESQ<br>
1250-096 | Lisboa</p>
<p>SUJEITO A SEGREDO PROFISSIONAL</p>
<p>Esta mensagem e os seus eventuais anexos são dirigidos unicamente aos respetivos destinatários e estão sujeitos a segredo profissional. Caso os tenha recebido por engano, solicitamos que contacte o remetente e que os elimine sem os utilizar, reproduzir ou disponibilizar a terceiros.</p>
<p>PROTECTED BY PROFESSIONAL PRIVILEGE</p>
<p>This message and its attachments, if any, are intended solely for the use of the persons to whom it is addressed to and are protected by professional privilege. If you have received them by error, you are kindly requested to contact the sender and to delete the e-mail and its attachments, if any, from your computer system without taking any action based upon them, or without copying or disclosing them to anyone.</p>
<p>[cid:email3_5d4ea582-5c5c-4fcb-a197-5555efcf8bd6.jpg]Think green and do not print this email unless absolutely necessary.</p></div>sergio.mendestag:infinitekind.tenderapp.com,2009-01-14:Comment/489264582021-01-11T16:39:57Z2021-01-11T16:39:57ZMoneyDance Connector<div><p>Yes, besides the main-category your script worked like a charm!</p>
<p>[cid:email_8316aeab-b0d2-42f4-96a2-a4359898d3ad.png]</p>
<p>Sérgio Mendes<br>
IT Business Analyst<br>
[cid:email2_6621cb4e-8b02-4a95-a42d-6400a9ed07ec.png]<br>
Avenida da Liberdade 144 5ºESQ<br>
1250-096 | Lisboa</p>
<p>SUJEITO A SEGREDO PROFISSIONAL</p>
<p>Esta mensagem e os seus eventuais anexos são dirigidos unicamente aos respetivos destinatários e estão sujeitos a segredo profissional. Caso os tenha recebido por engano, solicitamos que contacte o remetente e que os elimine sem os utilizar, reproduzir ou disponibilizar a terceiros.</p>
<p>PROTECTED BY PROFESSIONAL PRIVILEGE</p>
<p>This message and its attachments, if any, are intended solely for the use of the persons to whom it is addressed to and are protected by professional privilege. If you have received them by error, you are kindly requested to contact the sender and to delete the e-mail and its attachments, if any, from your computer system without taking any action based upon them, or without copying or disclosing them to anyone.</p>
<p>[cid:email3_5d4ea582-5c5c-4fcb-a197-5555efcf8bd6.jpg]Think green and do not print this email unless absolutely necessary.</p></div>sergio.mendestag:infinitekind.tenderapp.com,2009-01-14:Comment/489264582021-01-11T22:17:56Z2021-01-11T22:17:56ZMoneyDance Connector<div><p>OK, try this, attached, let me know?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/489264582021-01-12T09:42:02Z2021-01-12T09:42:02ZMoneyDance Connector<div><p>Thanks, you have been very helpful!</p>
<p>Is exactly this.</p>
<p>[cid:email_8316aeab-b0d2-42f4-96a2-a4359898d3ad.png]</p>
<p>Sérgio Mendes<br>
IT Business Analyst<br>
[cid:email2_6621cb4e-8b02-4a95-a42d-6400a9ed07ec.png]<br>
Avenida da Liberdade 144 5ºESQ<br>
1250-096 | Lisboa</p>
<p>SUJEITO A SEGREDO PROFISSIONAL</p>
<p>Esta mensagem e os seus eventuais anexos são dirigidos unicamente aos respetivos destinatários e estão sujeitos a segredo profissional. Caso os tenha recebido por engano, solicitamos que contacte o remetente e que os elimine sem os utilizar, reproduzir ou disponibilizar a terceiros.</p>
<p>PROTECTED BY PROFESSIONAL PRIVILEGE</p>
<p>This message and its attachments, if any, are intended solely for the use of the persons to whom it is addressed to and are protected by professional privilege. If you have received them by error, you are kindly requested to contact the sender and to delete the e-mail and its attachments, if any, from your computer system without taking any action based upon them, or without copying or disclosing them to anyone.</p>
<p>[cid:email3_5d4ea582-5c5c-4fcb-a197-5555efcf8bd6.jpg]Think green and do not print this email unless absolutely necessary.</p></div>sergio.mendestag:infinitekind.tenderapp.com,2009-01-14:Comment/489264582021-01-12T09:59:59Z2021-01-12T09:59:59ZMoneyDance Connector<div><p>Great; I'll release the updated code...</p></div>Stuart Beesley (Mr Toolbox)