Import Bills not working?

[Nelson Handcock]

Hi Mike,

Thanks for the advice - I'll follow this up.


Thanks & Regards,

Nelson Handcock

<http://www.linkedin.com/in/nelsonhandcockaustralia>


On Wed, Aug 20, 2014 at 10:24 PM, Mike Evans <mikee at saxicola.co.uk> wrote:

> Hi Nelson
>
> I've tested the file on 2.6.1 where it failed to import, on 2.6.3 and it
> imports fine.
>
> Looks like you need to upgrade to 2.6.3.
>
> Cheers.
>
> Mike E
>
>
> On Wed, 20 Aug 2014 20:13:20 +1000
> Nelson Handcock <nelson.handcock at gmail.com> wrote:
>
> > Hi Mike,
> >
> > Thanks for taking an interest!
> >
> > I've only used gnucash for a few months - 2.6.1 was the current version
> > when I started.
> >
> > I'm using Windows 8.1 on a laptop.
> >
> > I've attached a sample file. This is based on the file layout specified
> > within the User Guide.
> >
> > The same file format worked fine for importing invoices for my customers,
> > so I was expecting it to work for my vendors, as the User guide implies
> it
> > should work for "Bills and Invoices". All you'd have to change to turn
> the
> > data into an invoice would be to change the columns holding the account
> > names and customer ID.
> >
> >
> > I look forward to hearing how you get on.
> >
> > Thanks & Regards,
> >
> > Nelson Handcock
> >
> >
> >
> > On Wed, Aug 20, 2014 at 5:21 PM, Mike Evans <mikee at saxicola.co.uk>
> wrote:
> >
> > > On Mon, 18 Aug 2014 22:41:04 +1000
> > > Nelson Handcock <nelson.handcock at gmail.com> wrote:
> > >
> > > > Hi,
> > > >
> > > > I'm using gnucash V2.6.1...
> > > >
> > > > I'm trying to import data from a csv file into my customer and vendor
> > > > accounts.
> > > >
> > > > I have set up the data in the format explained on the help files,
> and it
> > > > works really well for invoices for my customers.
> > > >
> > > > However, it doesn't work for importing bills for my vendors.
> > > >
> > > > I've set up my data file using the same format, and when I set up the
> > > > details in the Import Bills and Invoices everything seems fine.
> > > >
> > > > When I run the import I get a popup saying:
> > > > Import results:
> > > > 0 lines were ignored
> > > > 35 lines imported:
> > > >    0 fixes
> > > >    0 ignored (not fixable)
> > > >
> > > >    0 created
> > > >    0 updated (based on id)
> > > >
> > > > If anyone has any idea why - I'd love to hear from you!
> > > >
> > > > The import results suggest I have the ID incorrect. The only thing I
> can
> > > > think of is that this import function only works on customers - not
> on
> > > > vendors?
> > > >
> > > >
> > > >
> > > >
> > > > Thanks & Regards,
> > > >
> > > > Nelson Handcock
> > >
> > > Hi Nelson
> > >
> > > Some questions.
> > > Has the importer ever worked for you in previous versions?  What OS are
> > > you using?  Are you willing to post an example of the failed import
> for me
> > > to test?  Take out any any sensitive data obviously, a single line
> will do
> > > for testing.
> > >
> > > Mike E
> > >
>
>
> --
> Anti NSA?  Use PGP.
> http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x00CDB13500D7AB53
>