tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/5490-python-script-to-extract-investment-transactions-to-csv-initial-release-v1bInfinite Kind: Discussion 2021-02-15T22:57:22Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/488179792020-11-10T18:00:04Z2020-12-22T15:38:25ZPython script to extract Investment Transactions to CSV - Initial release v1b<div><p>All, please find attached my Python script that will allow you to extract your Investment transactions to CSV file. There are lots of user options. Let me know if you have any issues. This script is read-only.</p>
<p>extract_investment_transactions_csv.py - v1b</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/488179792020-11-11T17:40:30Z2020-12-22T15:38:25ZPython script to extract Investment Transactions to CSV - Initial release v1b<div><p>Small update v1d</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/488179792020-11-27T10:35:31Z2020-12-22T15:38:24ZPython script to extract Investment Transactions to CSV - Initial release v1b<div><p>All, if you use my extract_investment_transacttions_csv script or others from me, please update them all to the latest version. ZIP of all attached.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/488179792020-12-14T17:26:21Z2020-12-22T15:38:24ZPython script to extract Investment Transactions to CSV - Initial release v1b<div><p>Now decommissioned and absorbed into Toolbox extension:<br>
<a href="https://infinitekind.tenderapp.com/discussions/moneydance-development/4016-toolbox-preview-release-of-python-extension-for-moneydance">https://infinitekind.tenderapp.com/discussions/moneydance-developme...</a></p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/488179792020-12-20T18:38:10Z2020-12-22T15:38:24ZPython script to extract Investment Transactions to CSV - Initial release v1b<div><p>From: sprimost --just a fellow user.</p>
<p>Hmm. This script does not seem to be working for me. See errorlog from<br>
MoneyBot below.</p>
<p>Using MD 2019.3 on LINUX Manjaro. By default, using LibreOffice Calc.</p>
<p>Any ideas, or should I look into modifying the script (I have a "basic"<br>
working knowledge of Python having done a script similar to this. Maybe<br>
this script will give me an idea how to fix some of the issues on am<br>
having with the output.</p>
<p>/sprimost</p>
<p>Beginning file<br>
/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py at Sun Dec 20 13:32:20 EST 2020<br>
StuWareSoftSystems...<br>
extract_investment_transactions_csv.py: Python Script<br>
Initialising.......Version:1d<br>
User Parameters...<br>
Hiding Hidden Securities...<br>
Hiding Inactive Accounts...<br>
Hiding Hidden Accounts...<br>
Selecting ALL Currencies...<br>
Selecting ALL Securities...<br>
Selecting ALL Accounts...<br>
Including Opening Balances...<br>
Script will adjust for Stock Splits...<br>
user date format....: %Y/%m/%d<br>
Non-ASCII characters will not be stripped from file: Using Delimiter: ,<br>
WARNING: file exists,but assuming user said OK to overwrite..<br>
Will extract investment transactions to file:<br>
/home/sprimost/Downloads/extract_investment_transactions.csv ... Investment Transaction Records selected: 2101</p>
<p>Error running script: Traceback (most recent call last):<br>
File "/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py", line 1337, in<br>
ExportDataToFile() File "/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py", line 1274, in ExportDataToFile<br>
writer = csv.writer(csvfile, dialect='excel', quoting=csv.QUOTE_MINIMAL, delimiter=csvDelimiter)<br>
File "/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py", line 1274, in ExportDataToFile<br>
writer = csv.writer(csvfile, dialect='excel', quoting=csv.QUOTE_MINIMAL, delimiter=csvDelimiter)<br>
TypeError: "delimiter" must be an 1-character string<br>
Traceback (most recent call last):<br>
File "/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py", line 1337, in<br>
ExportDataToFile() File "/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py", line 1274, in ExportDataToFile<br>
writer = csv.writer(csvfile, dialect='excel', quoting=csv.QUOTE_MINIMAL, delimiter=csvDelimiter)<br>
File "/home/sprimost/Finance/Installed/extract_investment_transactions_csv.py", line 1274, in ExportDataToFile<br>
writer = csv.writer(csvfile, dialect='excel', quoting=csv.QUOTE_MINIMAL, delimiter=csvDelimiter)<br>
TypeError: "delimiter" must be an 1-character string</p></div>sprimosttag:infinitekind.tenderapp.com,2009-01-14:Comment/488179792020-12-31T17:50:27Z2020-12-31T17:50:27ZPython script to extract Investment Transactions to CSV - Initial release v1b<div><p>This was fixed.<br>
URL for downloads is now:<br>
<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/488179792021-02-15T22:57:18Z2021-02-15T22:57:18ZPython script to extract Investment Transactions to CSV - Initial release v1b<div><p>FYI - All my extract scripts have now been consolidated into a single script/extension called extract_data. The old individual scripts have been decommissioned.</p>
<p><a href="https://yogi1967.github.io/MoneydancePythonScripts/">https://yogi1967.github.io/MoneydancePythonScripts/</a></p></div>Stuart Beesley (Mr Toolbox)