Import Bills not working?

[Nelson Handcock]

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
> _______________________________________________
> 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.
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test_vendor.csv
Type: text/csv
Size: 931 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20140820/0c2dfaa3/attachment.csv>