Opening balance reconciling investment account incorrect.

[David Carlson]

On 11/13/2013 1:35 PM, hnaparst wrote:
> Well, maybe, but who knows.  I am just histoguessing that the encoding that
> Quicken is producing is WINDOWS-1252.   After running iconv -f=WINDOWS-1252
> -t=UTF-8 -o NordnetUTF.QIF Nordnet.QIF  the same import error occurred:
>
> * 19:31:19  WARN <gnc.scm> In unknown file:
>    ?: 12* [private-convert]
> In /usr/share/gnucash/scm/qif-import/qif-to-gnc.scm:
>  224: 13* (let* (# # # # ...) (letrec # # # ...))
> In unknown file:
>    ?: 14  (letrec (#) (if progress-dialog #) (hash-fold # #t qif-acct-map)
> ...)
> In /usr/share/gnucash/scm/qif-import/qif-to-gnc.scm:
>  370: 15* [for-each #<procedure #f (qif-file)> (#)]
> In unknown file:
>    ?: 16* [#<procedure #f #> #]
> In /usr/share/gnucash/scm/qif-import/qif-to-gnc.scm:
>  376: 17* [for-each #<procedure #f (xtn)> (# # # # ...)]
> In unknown file:
>    ?: 18* [#<procedure #f #> #]
> In /usr/share/gnucash/scm/qif-import/qif-to-gnc.scm:
>  381: 19* (if (not (qif-xtn:mark xtn)) (let* (#) (xaccTransBeginEdit
> gnc-xtn) ...))
>  383: 20  (let* ((gnc-xtn #)) (xaccTransBeginEdit gnc-xtn) ...)
>  392: 21* [qif-import:qif-xtn-to-gnc-xtn # # # ...]
>  431: 22  (let (# # # # ...) (cond # # #) (if qif-payee #) ...)
>  507: 23* (if (not qif-security) (begin # # # ...) (let* # # # ...))
>  601: 24  (let* (# # # # ...) (if # #) (if xtn-amt # #) ...)
>  660: 25* (if (and qif-near-acct qif-far-acct) (begin # # # ...))
>  661: 26  (begin (set! near-acct-info #) (set! near-acct-name #) ...)
>  683: 27* (set! far-acct-name (qif-map-entry:gnc-name far-acct-info))
>  683: 28* [qif-map-entry:gnc-name #f]
> In unknown file:
>    ?: 29  (if (eq? # #) (struct-ref obj 3) (%record-type-error # obj))
>    ?: 30* [eq? ...
>    ?: 31* [struct-vtable #f]
> <unnamed port>: In procedure struct-vtable in expression (struct-vtable
> obj):
> <unnamed port>: Wrong type argument in position 1 (expecting struct): #f
>
>
>
> On Wed, Nov 13, 2013 at 6:34 PM, Derek Atkins [via GnuCash] <
> ml-node+s1415818n4665436h31 at n4.nabble.com> wrote:
>
>> hnaparst <[hidden email]<http://user/SendEmail.jtp?type=node&node=4665436&i=0>>
>> writes:
>>
>>> Haha, no matter.
>>>
>>> Of greater concern is that importing most of my QIF-file securities
>>> accounts fail.  There are 141 open import-related bugs, including some
>> that
>>> are quite similar to what I am experiencing.
>>>
>>> Obviously, if I can't import my transactions, either from Quicken or
>> from
>>> my broker, then I can't use Gnucash at all.
>> The issue you are experiencing is an encoding issue.  QIF does not
>> specify the actual encoding.  GnuCash uses UTF-8, but it is probably
>> failing to properly transcode from e.g. ISO encoding.
>>
>> As an interim you can manually use 'iconv' to translate from ISO to UTF8
>> before you import the QIF.
>>
>>> Thanks for listening!
>>>
>>> Harold
>> -derek
>>
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> -derek
>> --
>>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>        Member, MIT Student Information Processing Board  (SIPB)
>>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>>        [hidden email]<http://user/SendEmail.jtp?type=node&node=4665436&i=1>                       PGP key available
>> _______________________________________________
>> gnucash-user mailing list
>> [hidden email] <http://user/SendEmail.jtp?type=node&node=4665436&i=2>
>> 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.
>>
>>
>> ------------------------------
>>  If you reply to this email, your message will be added to the discussion
>> below:
>>
>> http://gnucash.1415818.n4.nabble.com/Opening-balance-reconciling-investment-account-incorrect-tp4665391p4665436.html
>>  To unsubscribe from Opening balance reconciling investment account
>> incorrect., click here<http://gnucash.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4665391&code=aGFyb2xkQGFsdW0ubWl0LmVkdXw0NjY1MzkxfDUxMDIxOTA5>
>> .
>> NAML<http://gnucash.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>>
>
>
>
> --
> View this message in context: http://gnucash.1415818.n4.nabble.com/Opening-balance-reconciling-investment-account-incorrect-tp4665391p4665437.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.
>

Harold,

Have you tried taking baby steps with a test file? 

Create a GnuCash data file with a sample brokerage account containing
one or two security accounts similar to the example in the Tutorial.

Then try exporting a very short history from your source with a very
small number of transactions involving only those test securities. Then
try importing that into your GnuCash test file. 

If you see errors that corroborate one or two of the 141 bugs that you
counted in bugzilla or the issue that Derek suggested here,  the users
and developers here may be able to help you.  Perhaps some of  those
bugs are not currently on anyone's radar.

Good Luck.

David C