Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

My blog has moved. You can view this post at the following address: http://www.osherove.com/blog/2006/4/8/hacking-microsoft-money-to-import-my-own-banks-data-fix-for.html
Published Saturday, April 08, 2006 4:12 AM by RoyOsherove

Comments

Friday, April 07, 2006 10:15 PM by Alex

# re: Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

You can also use SWExplorerAutomation (SWEA)(http://alexfurman.net) to write the data extraction program. The SWEA TableDatExtractor returns data as DataTable (ADO.NET) - no pasting needed. SWEA supports very well Web sites with script and frames (Poalim Web site uses them a lot).
Friday, April 07, 2006 10:34 PM by Alex

# re: Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

I have just recorded the script for Hapoalim:

ExplorerManager explorerManager = new SWExplorerAutomation.Client.ExplorerManager();
explorerManager.Connect(-1);
explorerManager.LoadProject("D:\\alf\\JobSearch\\CJSearchService\\Hapoalim.htp");
explorerManager.Navigate("https://login.bankhapoalim.co.il/cgi-bin/poalwwwc?dt=924&nls=HE");
scene = explorerManager["Scene_0"];
scene.WaitForActive(30000);
((HtmlInputText)(scene["userid"])).Value = "XXXXX";
((HtmlInputText)(scene["id"])).Value = "XXXXX";
((HtmlInputText)(scene["password"])).Value = "XXXX";
((HtmlInputButton)(scene["inputSend"])).Click();
scene = explorerManager["Scene_1"];
scene.WaitForActive(30000);
System.Data.DataTable dataTable;
dataTable = ((HtmlContent)(scene["HtmlContent_0"])).TableDataExtractor.DataTable;
Saturday, April 08, 2006 6:55 AM by Roy Osherove

# re: Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

Alex: that's wonderful, and kinda ironic.
I actually started out by recording a SWExplorerAutomation script that does everything you mention, only I didn't know I could get a data table out of it, so I exported to Xml/Html and tried to parse that.
I finally decided it was easer to just copy paste, by your way seems waay more productive if I had to start from scratch again!
Saturday, April 08, 2006 9:10 AM by Alex

# re: Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

TableDataExtractor tranforms to DataTable any HTML repeating pattern. It uses XPath as "delimiters", so it couldn't be <TABLE> tag. The HtmlContent control should cover the "Table" area. The control has property TableDataExtractor which runs the extractor editor. The extractor editor allows visually define row and column (XPath) delimiters. Sometimes the delimiters should be edited manually to support empty cells or fix a table structure irregularities.
Saturday, April 08, 2006 9:21 AM by Alex

# re: Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

Just forgot to mention. I recommend to encrypt the password. SWEA supports a password encryption using DPAPI. In the script recorder select the password record and check [Encrypt] check box. The password value will be replaced by an encrypted value.
Sunday, April 23, 2006 10:24 AM by Amir

# re: Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

It's 'Transactions" not "Movements" :-)
Monday, April 24, 2006 8:23 AM by Alex Pinsker

# re: Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

Hi Roy,
May be there is a sense to make your app' public, so that pplz could extend it for other IL banks? I personally was volunteering for Leumi then…
Saturday, May 06, 2006 4:29 AM by mar

# re: Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

hi,

i'm new with money 2006.

can you supply a way to connect to leumi in israel?

thank you

mar
Tuesday, September 05, 2006 9:07 AM by Ben

# re: Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

How do u handle the Hebrew...Do u have a hebrew version of Money 2006?
Wednesday, September 06, 2006 4:00 AM by RoyOsherove

# re: Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

Ben: I actually reverse the charachters manually when parsing... (but not all of them, just the "special" ones).

Saturday, December 09, 2006 4:42 PM by Dov

# re: Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

Hi Roy,

I was looking for this kind of tool for a long time. where can I get your 'little software hack'?

P.S: I use MS Money 2004.

Thanks

Dov

Saturday, December 09, 2006 5:58 PM by RoyOsherove

# re: Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

Dov, I'm not making this available right now...

It's just too cluncky to be usable..

Roy

Sunday, December 10, 2006 2:46 AM by Dov

# re: Hacking Microsoft Money to import my own bank's data + Fix for hidden money transactions

Hi Roy,

I using MSMoney since 1997 but today it become very problematic to update my transactions. I just don't have time for it.

After seeing your blog I deiced to give it another try.

Is there other way that I can import transaction from bank hapoalim website?

Can you please give me the code an I will try to customize it for my need?

Thanks

Dov