Importing CSV files

[Richard Thomas]

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