Importing CSV files

[David Reiser]

>From Wikipedia's presentation of the QIF spec:

C	Cleared status. Values are blank (not cleared), "*" or "c" (cleared) and "X" or "R" (reconciled).

--
Dave Reiser
dbreiser at me.com



On Jul 17, 2012, at 5:03 PM, Richard Thomas wrote:

> Hi,
> 
> Thanks for that, the N for the number record is working for me.
> 
> Would you be able to help me with the C record please?
> 
> What should the entire C line look like?
> 
> Thanks,
> 
> Richard.
> 
> On 17 July 2012 15:00, Derek Atkins <warlord at mit.edu> wrote:
> 
>> Hi,
>> 
>> Richard Thomas <richdthomas at gmail.com> writes:
>> 
>>> Hi Derek,
>>> 
>>> Thanks for getting back to me.
>>> 
>>> Here's a sample of the QIF file that my bank provides, I've deleted all
>> but
>>> the top transaction:
>>> 
>>> !Type:Bank
>>> D13/07/2012
>>> PSTARBUCKS CARD REL CD ****
>>> T-10.00
>>> ^
>>> 
>>> So, would I need to change the "T-10.00" to "C-10.00" and then add an
>> "N" line
>>> for my "num" field?
>> 
>> No, and Yes.  Yes, add an N line to specify the Num field.  But you also
>> need to add a C line to specify the Cleared Flag.  Do NOT change the T
>> (total) line.
>> 
>>> Thanks,
>>> 
>>> Richard.
>> 
>> -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
>> 
> _______________________________________________
> 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.