Importing CSV files

David Reiser dbreiser at me.com
Tue Jul 17 17:32:17 EDT 2012


On Jul 17, 2012, at 5:28 PM, David Reiser wrote:

> From Wikipedia's presentation of the QIF spec:
> 
> C	Cleared status. Values are blank (not cleared), "*" or "c" (cleared) and "X" or "R" (reconciled).

So it appears that the permitted C lines are:

Cc
C*
CR
CX

> 
> --
> 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.
> 
> _______________________________________________
> 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.



More information about the gnucash-user mailing list