Importing CSV files
Richard Thomas
richdthomas at gmail.com
Thu Jul 19 16:39:38 EDT 2012
Hi,
Thanks for your help.
Here's a copy-and-paste of the QIF file I have generated:
!Type:Bank
D19/07/2012
NTST
PRICHARD ENTERPRISES
CX
T-12.34
^
Here's a copy-and-paste of my log file (is that the trace file?)
mod trans_guid split_guid time_now date_entered
date_posted acc_guid acc_name num description notes
memo action reconciled amount value date_reconciled
-----------------
===== START
===== END
===== START
C 1a1dd6ed2f700566086dcf82336dedf8
ccafed09ccbd154f926cea2dc26f8cc1 2012-07-19 21:32:33.000000 +0100
2012-07-19 21:32:33.000000 +0100 2012-07-19 00:00:00.000000 +0100
ed4bd1b5b9397e6c009a0ad5036c02d1 Unspecified TST RICHARD
ENTERPRISES n 1234/100 1234/100 1970-01-01
00:00:00.000000 -0000
C 1a1dd6ed2f700566086dcf82336dedf8
81a96f92221157a445a2892efbdbc08c 2012-07-19 21:32:33.000000 +0100
2012-07-19 21:32:33.000000 +0100 2012-07-19 00:00:00.000000 +0100
f8ea54a2227dce028ca8775497968892 LTSB Current TST RICHARD
ENTERPRISES y -1234/100 -1234/100 1970-01-01
00:00:00.000000 -0000
===== END
===== START
B 1a1dd6ed2f700566086dcf82336dedf8
ccafed09ccbd154f926cea2dc26f8cc1 2012-07-19 21:32:40.000000 +0100
2012-07-19 21:32:33.000000 +0100 2012-07-19 00:00:00.000000 +0100
ed4bd1b5b9397e6c009a0ad5036c02d1 Unspecified TST RICHARD
ENTERPRISES n 1234/100 1234/100 1970-01-01
00:00:00.000000 -0000
B 1a1dd6ed2f700566086dcf82336dedf8
81a96f92221157a445a2892efbdbc08c 2012-07-19 21:32:40.000000 +0100
2012-07-19 21:32:33.000000 +0100 2012-07-19 00:00:00.000000 +0100
f8ea54a2227dce028ca8775497968892 LTSB Current TST RICHARD
ENTERPRISES y -1234/100 -1234/100 1970-01-01
00:00:00.000000 -0000
===== END
===== START
D 1a1dd6ed2f700566086dcf82336dedf8
ccafed09ccbd154f926cea2dc26f8cc1 2012-07-19 21:32:40.000000 +0100
2012-07-19 21:32:33.000000 +0100 2012-07-19 00:00:00.000000 +0100
ed4bd1b5b9397e6c009a0ad5036c02d1 Unspecified TST RICHARD
ENTERPRISES n 1234/100 1234/100 1970-01-01
00:00:00.000000 -0000
D 1a1dd6ed2f700566086dcf82336dedf8
81a96f92221157a445a2892efbdbc08c 2012-07-19 21:32:40.000000 +0100
2012-07-19 21:32:33.000000 +0100 2012-07-19 00:00:00.000000 +0100
f8ea54a2227dce028ca8775497968892 LTSB Current TST RICHARD
ENTERPRISES y -1234/100 -1234/100 1970-01-01
00:00:00.000000 -0000
===== END
Does this point to what's going on?
Thanks,
Richard.
On 19 July 2012 20:29, Derek Atkins <derek at ihtfp.com> wrote:
> 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