Multiple csv file import/conversion

[Derek Atkins]

Hi,

Colin Law <clanlaw at googlemail.com> writes:

> On 18 February 2013 23:08, Jamestk <davidjamestk at hotmail.co.uk> wrote:
>> As anticipated I went down the QIF file route using the above Excel add on.
>>
>> The conversion utility works well although I have one remaining query
>> regarding the import in Gnucash.
>>
>> I have used a 'y' min the reconciled column to indicate the transaction is
>> to be imported as reconciled but this returns the following error message:-
>>
>> *Reconciliation status: Unrecognized status 'y'. Defaulting to uncleared.*
>>
>> I also wanted to check if Gnucash is well supported on the forum as I move
>> across. Could someone please confirm this message is actual visible to
>> others as not sure I have ticked all of the boxes with regard to
>> registration?
>
> I am seeing your message ok, this is actually a maiing list, not a
> forum by the way.
> Don't know about QIF but [1] suggests that maybe "CR" is what you
> want, but as I say I don't have personal knowledge.
>
> Colin

>From the GnuCash sources:

;;  parse-cleared-field : In a "C" (cleared status) QIF line,
;;  * or C means cleared, X or R means reconciled, and ! or ?
;;  mean some budget related stuff I don't understand.

So you'd want "CR" or "CX" to be reconciled.

> 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
       warlord at MIT.EDU                        PGP key available