As a continuation from the last blog I have PocketSense back up and running in Microsoft Money since getting my computer hacked last week. Thanks everyone for the help!
One thing I'm still having a problem with. I had the same problem in January when I did a clean install and solved it but should have kept notes on what I did.
Under Favorites/Favorite Web Sites I had a link named Update Prices that I would click and it would run Getdata.py - Shortcut. It pointed to file:///D:/Microsoft%20Money/OFX%20Scripts/Getdata.py - Shortcut.lnk. For the life of me I cannot get that link saved under Favorite Web Sites. I do have a shortcut D:\Microsoft Money\OFX Scripts but it just opens the folder in Microsoft Money.
Where are these Favorite Web Sites stored? I believe many years ago they were stored in Internet Explorer. Maybe that would help me solve this. Thanks!
I have the Windows Firewall prevent Microsoft Money from accessing outside servers. That is to prevent Money from waiting for servers that are gone. If you did that, that might or might not mess up the process.
I have some notes on some previous discussions we have, but I cannot find those discussions. Joe: I did some experimenting, and I am having trouble posting what I want to describe. Let me say I did put a link into favorites, and it appeared in into folder "%USERPROFILE%\Favorites\Financial Links"
The entry was the file type described in https://fileinfo.com/extension/url
See if http://pocketsense.blogspot.com/2025/03/comments-continued.html#comment-form helps. There are steps about getting an entry into place. I think you are already aware of the info in http://moneymvps.org/faq/article/352.aspx
Also consider having the shortcut point to a *.bat file rather than the GetDat.py file. In that batch file, start with a CD (change directory) to the folder that contains your PocketSense files.
I have a file called lines.txt in my PocketSense folder. This contains at least 4 blank lines. Then I invoke getdata with this line in the batch file: getdata.py < lines.txt That causes getdata.py to run to completion, taking all of the defaults, rather than waiting for a response. It presses the Enter key for me up to 4 times.
One of my batch files starts Money with this line in a batch file: start "" /D "C:\Program Files (x86)\Microsoft Money Plus\MNYCoreFiles" msmoney.exe
That line starts Money, but does not wait until the process ends before continuing on with the rest of the batch file. That would be appropriate for starting Money but not for invoking GetData I think.
The other thread is locked, but I wanted to say thank you Robert for this idea. I often forget to add a file to the imports folder before running the script as well and came to look in the comments for an answer to the same question. Ideally there would be an option to only process the imports folder, but it's a great workaround.
AnonymousFebruary 17, 2025 at 11:54 AM Hi Folks,
Is there a way to manually run the scrubber on files in the import folder? With the recent Amex change, I occasionally forget to download the OFX from Amex prior to running Getdata, so I'm looking for a way to do that part of the Getdata processing without doing all of the other accounts and downloads again.
Thanks!
Replies
Robert February 17, 2025 at 12:01 PM There's no setting to do it... however, you can create a new folder with a fresh copy of the scripts, and not configure any accounts, etc. Run setup once, and then getdata to process imports as needed.
Ah. We did it! Thanks, everybody, for pointing me in the right direction. In "%USERPROFILE%\Favorites\Financial Links" was my shortcut Update which would take me to my OFX Scripts file but not run Getdate.py - Shortcut. By right clicking on that shortcut, going to properties and changing the URL: to file:///D:/Microsoft%20Money/OFX%20Scripts/Getdata.py - Shortcut.lnk it now works.
That is, in Money, I can now go to Favorites>Favorite Web Sites and just click on Update to run Getdata.py.
Now another comment. When my computer was hacked the hacker was actually on my computer. Isn't it a concern that ofx_config.cfg has your user names and passwords and can just be opened with a text editor?
Yes. Change all of those passwords at a minimum, and changing your usernames would be a good move too.
PocketSense offers the option to encrypt that file, and require you to enter a password each time. I don't encrypt myself, and when I change password, I tend to modify ofx_config.cfg with Notepad++.
As a continuation from the last blog I have PocketSense back up and running in Microsoft Money since getting my computer hacked last week. Thanks everyone for the help!
ReplyDeleteOne thing I'm still having a problem with. I had the same problem in January when I did a clean install and solved it but should have kept notes on what I did.
Under Favorites/Favorite Web Sites I had a link named Update Prices that I would click and it would run Getdata.py - Shortcut. It pointed to file:///D:/Microsoft%20Money/OFX%20Scripts/Getdata.py - Shortcut.lnk. For the life of me I cannot get that link saved under Favorite Web Sites. I do have a shortcut D:\Microsoft Money\OFX Scripts but it just opens the folder in Microsoft Money.
Where are these Favorite Web Sites stored? I believe many years ago they were stored in Internet Explorer. Maybe that would help me solve this. Thanks!
I have the Windows Firewall prevent Microsoft Money from accessing outside servers. That is to prevent Money from waiting for servers that are gone. If you did that, that might or might not mess up the process.
DeleteI have some notes on some previous discussions we have, but I cannot find those discussions.
Joe: I did some experimenting, and I am having trouble posting what I want to describe. Let me say I did put a link into favorites, and it appeared in into folder
"%USERPROFILE%\Favorites\Financial Links"
The entry was the file type described in https://fileinfo.com/extension/url
That may be enough to get you going.
=========
Cal Learner
See if http://pocketsense.blogspot.com/2025/03/comments-continued.html#comment-form helps. There are steps about getting an entry into place. I think you are already aware of the info in http://moneymvps.org/faq/article/352.aspx
ReplyDeleteAlso consider having the shortcut point to a *.bat file rather than the GetDat.py file. In that batch file, start with a CD (change directory) to the folder that contains your PocketSense files.
I have a file called lines.txt in my PocketSense folder. This contains at least 4 blank lines. Then I invoke getdata with this line in the batch file:
getdata.py < lines.txt
That causes getdata.py to run to completion, taking all of the defaults, rather than waiting for a response. It presses the Enter key for me up to 4 times.
One of my batch files starts Money with this line in a batch file:
start "" /D "C:\Program Files (x86)\Microsoft Money Plus\MNYCoreFiles" msmoney.exe
That line starts Money, but does not wait until the process ends before continuing on with the rest of the batch file. That would be appropriate for starting Money but not for invoking GetData I think.
Cal Learner
Thank you! The batch file was the missing piece that got this working for me.
DeleteThe other thread is locked, but I wanted to say thank you Robert for this idea. I often forget to add a file to the imports folder before running the script as well and came to look in the comments for an answer to the same question. Ideally there would be an option to only process the imports folder, but it's a great workaround.
ReplyDeleteAnonymousFebruary 17, 2025 at 11:54 AM
Hi Folks,
Is there a way to manually run the scrubber on files in the import folder? With the recent Amex change, I occasionally forget to download the OFX from Amex prior to running Getdata, so I'm looking for a way to do that part of the Getdata processing without doing all of the other accounts and downloads again.
Thanks!
Replies
Robert February 17, 2025 at 12:01 PM
There's no setting to do it... however, you can create a new folder with a fresh copy of the scripts, and not configure any accounts, etc. Run setup once, and then getdata to process imports as needed.
Ah. We did it! Thanks, everybody, for pointing me in the right direction. In "%USERPROFILE%\Favorites\Financial Links" was my shortcut Update which would take me to my OFX Scripts file but not run Getdate.py - Shortcut. By right clicking on that shortcut, going to properties and changing the URL: to file:///D:/Microsoft%20Money/OFX%20Scripts/Getdata.py - Shortcut.lnk it now works.
ReplyDeleteThat is, in Money, I can now go to Favorites>Favorite Web Sites and just click on Update to run Getdata.py.
Now another comment. When my computer was hacked the hacker was actually on my computer. Isn't it a concern that ofx_config.cfg has your user names and passwords and can just be opened with a text editor?
Yes. Change all of those passwords at a minimum, and changing your usernames would be a good move too.
DeletePocketSense offers the option to encrypt that file, and require you to enter a password each time. I don't encrypt myself, and when I change password, I tend to modify ofx_config.cfg with Notepad++.
Cal Learner