Importing CSV files

Derek Atkins derek at ihtfp.com
Thu Jul 19 15:29:49 EDT 2012


Can you show an example QIF that you've used?  The code should accept:

CX, Cx, CR, and Cr as reconciled, and CC, Cc, and C* as cleared.

Is there any output in your gnucash.trace when you load something with a
"C" line that isn't recognized?

-derek

On Thu, July 19, 2012 3:10 pm, Richard Thomas wrote:
> Hi,
>
> I have tried all 4 "C" codes and cannot get transactions to go to the "c"
> status.
>
> If there a QIF file example that has been successfully imported into
> GNUCash to clear transactions?
>
> If not, are there any other ideas?
>
> Thanks in advance,
>
> Richard.
>
> On 17 July 2012 22:32, David Reiser <dbreiser at me.com> wrote:
>
>>
>> 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.
>>
>>
> _______________________________________________
> 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.
>


-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant



More information about the gnucash-user mailing list