Importing QIF from Skrooge

[Jimmy Crossley]

Forgive my math/programming background, but you could do a binary search for what it does not like in your QIF file.  First, make a safe copy of the file (of course).  Then edit it and remove the last half of the entries.  Be sure to keep each entry intact.  Then try to import that.  If it does not work, then you know the problem is in that first half.  Otherwise, try the second half.  When you find out which half has the problem, then try each half of that.  Keep doing this until you get a small enough file to examine by hand.  This sounds like a lot of trouble, but it may not take as many tries as you think.  (At most log base 2(N), where N is the number of items in the file.)

I have seen problems with things like trailing spaces or tabs and special characters where they are not expected (like Unicode or something like that).

Good luck and keep us posted.  If you can find out what it does not like, that could be save a lot of work for someone else.

>

-----------------------------
Jimmy Crossley
CoNetrix
Sentry Plaza III
5214 68th Street, Suite 200
Lubbock, TX  79424
jcrossley at CoNetrix.com
https://www.CoNetrix.com
Telephone: 806-687-8600
Toll Free: 800-356-6568
Fax: 806-687-8511
This e-mail message (and attachments) may contain confidential CoNetrix information. If you are not the intended recipient, you cannot use, distribute or copy the message or attachments. In such a case, please notify the sender by return e-mail immediately and erase all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to official business are neither given nor endorsed by CoNetrix.


-----Original Message-----
> From: gnucash-user-bounces+jcrossley=conetrix.com at gnucash.org [mailto:gnucash-user-
> bounces+jcrossley=conetrix.com at gnucash.org] On Behalf Of Algeorge
> Sent: Wednesday, August 29, 2012 15:25
> To: gnucash-user at gnucash.org
> Subject: Re: Importing QIF from Skrooge
>
> Hi Derek.
> Thanks for your reply.
> I used Terminal and there was no errors shown after the importer had
> processed the 80,000 line QIF import.
> I opened QIF and found no $ or € symbols. Any idea where the .trace file
> lies in Ubuntu?
> Here are the opening and closing lines of the QIF:
> !Type:Cat
> NAcc
> E
> ^
> NAccount
> E
> ^
> NAds
> E
> ^
> ---------snip
> D2002-03-12
> T-3285.25
> PXfer
> MClose card
> CR
> L[TSB-VISA]/Transfer internal bank
> ^
> D2002-03-22
> T-7814.75
> MClose card
> CR
> LAccount
> ^
> !Type:Prices
> "NZ$";"1";"1967-07-10"
> ^
>
> It would be helpful when an error did occur the interface provided a tad
> more feedback, for without this, it will be like looking for a needle in a
> haystack.
>
> BTW I did try csv file as well but that did not import either.
> Kind regards,
> Alistair.
>
>
>
>
> --
> View this message in context: http://gnucash.1415818.n4.nabble.com/Importing-QIF-from-Skrooge-
> tp4656568p4656575.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.