Import Bills not working?

Mike Evans mikee at saxicola.co.uk
Wed Aug 20 08:24:44 EDT 2014


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  


More information about the gnucash-user mailing list