Fwd: problems importing visa credit account .qif files: FIXED

[Enrique Barahona Ramos]

Hey thanks Andrew and Derek, you were right anyway, those "M"s before 
the date made the qif files invalid.
I was too quick to post - before trying to fix it myself - now that it's 
sorted it may help someone else in the list anyway.
Thanks

Enrique


Andrew Sackville-West wrote:

> I guess I need to read farther before responding... :0
>
> A
>
> Kiko Barahona wrote:
>
>> Hi,
>> I opened them .qif files with TextWrangler in order to compare them, 
>> this is what was different:
>> Each entry has a date, in the good qif file (the one that imported no 
>> problem) the format is:
>>
>> D10/7/2005
>>
>> that's for Oct. the 7th 2005, what that D means, I don't know. The 
>> visa qif file that wouldn't import was formatted as:
>>
>> M10/7/2005
>>
>> I did a search and replace to turn those pesky M's into goodie D's, 
>> and presto, the file loaded OK.
>> As to what the Ms and Ds mean (day, month?) maybe somebody else can 
>> throw some light on this. The dates appear correct once in gnucash 
>> when compared with the online statement.
>> Thanks
>>
>> Enrique
>>
>>
>> Begin forwarded message:
>>
>>     *From: *Kiko Barahona <kikokun at telus.net>
>>     *Date: *October 14, 2005 10:47:16 PM PDT
>>     *To: *gnucash-user at gnucash.org
>>     *Subject: problems importing visa credit account .qif files
>>     *
>>     Hi,
>>     I have been using qif import succesfully when it comes to
>>     downloading Chequing Account data.
>>     But I recently got a credit card with the same bank, Scotiabank in
>>     Canada, and importing the visa acc. qif file brings nothing into
>>     gnucash.
>>
>>     When the QIF import wizard reaches the "Match QIF accounts with
>>     GnuCash accounts", it shows nothing in either column.
>>     (Also, it reaches this step after skipping the "Set the default QIF
>>     account name" step, which I always get when importing the chequing
>>     acc.)
>>
>>     Any hints on how to solve this problem?
>>     Thanks
>>
>>     Enrique
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>