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-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)