forums.lyricapps.com

Hi! I downloaded the demo app to give it a spin but it won't import a .qfx file with transactions. I downloaded them from my bank, clicked import and chose the file, clicked "Validate" several times, but I always get a result of "1 account / 0 transactions" on the last screen. The log isn't helpful to me, but I've included it below (edited somewhat to remove data I don't want public).

I'm guessing the problem is the date format. The file has lines such as
<DTPOSTED>20140101000000[-5:America/New_York]
so I changed iCompta's date format from MM/dd/yyyy to yyyyMMdd. I also tried variations such as yyyyMMddhhmmss and yyyyMMddhhmmssz (note the z for timezone). Still didn't work.

Questions:
* Any suggestions for how to get the file import to work?
* Are problems like this a regular occurrence with this program?

Thanks,
Byron


Getting data from file:///Users/.../Downloads/statement.qfx?date=1990-01-01…

Parsing data…
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:TYPE1
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
<MESSAGE>OK
</STATUS>
<DTSERVER>20140113033212[-8:PST]
<LANGUAGE>ENG
<INTU.BID>00022
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<STMTTRNRS>
<TRNUID>...
<STATUS>
<CODE>0
<SEVERITY>INFO
<MESSAGE>OK
</STATUS>
<STMTRS>
<CURDEF>CAD
<BANKACCTFROM>
<BANKID>...
<BRANCHID>...
<ACCTID>...
<ACCTTYPE>CHECKING
</BANKACCTFROM>
<BANKTRANLIST>
<DTSTART>20140101000000
<DTEND>20140113235959
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20140111000000
<TRNAMT>-1000.00
<FITID>33851903101112014
<NAME>PC Banking Transfer Out
<MEMO>To: optimum; Sub#: 12
</STMTTRN>
</BANKTRANLIST>
<LEDGERBAL>
<BALAMT>11940.16
<DTASOF>20140113063212
</LEDGERBAL>
<AVAILBAL>
<BALAMT>...
<DTASOF>20140113063212
</AVAILBAL>
</STMTRS>
</STMTTRNRS>
</BANKMSGSRSV1>
</OFX>


Checking unmapped values…

Creating transactions…

The fact the defat date format is MM/dd/yyyy means that the import format was not set to OFX when you imported the file. So make sure to select OFX in the popup button of the file chooser when you import and tell me if it works better.

Got it! Boy, do I feel dumb for missing that one