Importing invoices

[Nelson Handcock]

I imported a series of bills to my Vendor accounts last night - i'm using
version 2.6.12 BTW.... and it worked perfectly for me - including handling
Sales Tax tables.

As mentioned in earlier responses, the csv file has to be in a certain
format, with placeholder columns for the ones that are not relevant to you.
The layout is pretty clearly explained in the online help.

https://www.gnucash.org/docs/v2.6/C/gnucash-guide/import-invoices.html

HTH....

Thanks & Regards,

Nelson Handcock
0409 149919

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

On Tue, Jan 17, 2017 at 1:44 AM, R. Victor Klassen <rvklassen at gmail.com>
wrote:

> I know I had it working, based on the instructions earlier in this
> thread.  That was a couple of years ago, and we no longer ship to that
> customer so I haven’t used it in some time.   What I can say, is 1) it can
> be done, and 2) the instructions worked for me.
> You can either create a spreadsheet with all the right columns, or write a
> script that converts what you have to a .csv file with the right
> information in the right columns.
>
>
> > On Jan 16, 2017, at 9:22 AM, Mike Evans <mikee at saxicola.co.uk> wrote:
> >
> > On Mon, 16 Jan 2017 00:14:06 -0800 (PST)
> > GoodNamesGone <abry at gyofukan.com> wrote:
> >
> >> Really, does it have to be THAT complicated? And don't give me the
> "it's an
> >> open source - therefore deal with it" argument. - because, maybe give
> it a
> >> tier - I will certainly pay for it rather than spend weeks trying to
> figure
> >> this thing out, or spending 1.5 hours a week manually typing in invoice
> >> details - that is 72 hours a year!!
> >> If one wants to import 3 columns from excel into the invoice section,
> >> GNUCash will crash. That's ridiculous.
> >> The parsing/import does NOT work. I even hired a guy - and he couldn't
> get
> >> it to work. So, is there an alternative import?
> >>
> >
> >
> > I'm sorry to hear about your troubles importing invoice data.
> >
> > To be fair the actual import is not complicated, it's getting the data
> into an importable format that's a little more involved. The problem is
> that invoices are complicated beasts with many variables that cannot be
> guessed by GnuCash The fact that many people do use the importer
> successfully demonstrates that it does work, provided that the import data
> are correct.
> >
> > It will not import a 3 column Excel sheet but it certainly shouldn't
> crash. The data format is demonstrated in the documentation and there are
> certainly more that 3 columns involved.
> >
> > https://www.gnucash.org/docs/v2.6/C/gnucash-guide/import-invoices.html
> >
> > A typical CSV import line looks like:
> >
> > BL-0071,,000013,,,,BC108 NPN GP TRANSISTOR,,Expenses:Materials
> General,20,0.16,,,,,,,,,,,
> > Yes, there are a lot of commas but there's only 6 that have to contain
> data.
> >
> > It should never crash GnuCash however, and that is clearly worthy of a
> bug report. See
> > https://wiki.gnucash.org/wiki/Bugzilla and
> > https://wiki.gnucash.org/wiki/FAQ#Q:_I_think_I_found_a_bug._
> How_do_I_report_it.3F
> > for how to report a bug.
> >
> > Please supply a sample of the data that causes the crash and if possible
> an empty account file to test it on. You can export an empty account tree
> with File->Export->export Accounts.
> >
> > Mike E
> >
> > --
> > PGP key:
> > http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xDB8F7CF1C67BBC0F
> > _______________________________________________
> > 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.
>