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!
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.
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.
It's 'Transactions" not
"Movements" :-)
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…
hi,
i'm new with money 2006.
can you supply a way to connect to leumi in israel?
thank you
mar
How do u handle the Hebrew...Do u have a hebrew version
of Money 2006?
Ben: I actually reverse the charachters manually when
parsing... (but not all of them, just the "special"
ones).
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
Dov, I'm not making this available right now...
It's just too cluncky to be usable..
Roy
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?