Parse Qfx And Insert – Php
We are looking for a new developer to outsource work to, so you may consider this project an interview.
We chose this project because it will show your skills and iniative.
The script basically has to take a QFX file (bank statement) and enter all the individual transactions into a database (MySQL).
The format is as follows:
<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20081130
<TRNAMT>-1000
<FITID>2008113001
<NAME>A SHOP SOMEWHERE
<MEMO>EFTPOS
</STMTTRN>
<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20081130
<TRNAMT>-1000
<FITID>2008113001
<NAME>A SHOP SOMEWHERE
<MEMO>EFTPOS
</STMTTRN>
<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20081130
<TRNAMT>-1000
<FITID>2008113001
<NAME>A SHOP SOMEWHERE
<MEMO>EFTPOS
</STMTTRN>
You must be quick and relaible – thank you.
