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