How to set Description on A/R when importing invoices

[Arnd Vehling]

Hi Mike,

>   Did you read my reply yesterday concerning this?

yes, and i already said that i can import/create customers. Sorry, but i 
did overlook the import customer feature initially.

I am now using the home-compiled 2.6.3 version now with guile-1.8 
instead of the stock ubuntu 14.04 version. Is guile-1.8 ok/recommended?

Now a general question for importing invoices. 
http://www.gnucash.org/docs/v2.4/C/gnucash-guide/python-import-invoices.html#python-

Citation:
---
17.1.1. Notes for Python authors

In order for the import to succeed the number of fields must be adhered 
to, so the trailing commas are important.

A complete list of the required fields is:

id, date_opened, owner_id, billingid, notes, date, desc, action, 
account, quantity, price, disc_type, disc_how, discount, taxable, 
taxincluded, tax_table, date_posted, due_date, account_posted, 
memo_posted, accu_splits,
	Note

Mind the trailing comma. <= (!)
---

If i use ";" as seperator and add one ";" to the end of an import line 
(after 22 values/fields) the import fails. Did the import format change 
from 2.4 to 2.6?

I tried "," and ";" as separator so far and both only works partially. 
Means not all fields get imported ALSO they are shown correctly in the 
preview.

Heres an example of my generated import data:
--
80;;GUEST;80;03.09.14-17.09.14:Custname1:07-01;29.04.2014;03.09.14-17.09.14:Custname1:07-01;Rental;Income:Rentals;1;382,0;$;=;0;;;;;03.09.2014;;03.09.14-17.09.14:Custname1:07-01;
82;;GUEST;82;28.08.14-18.09.14:Custname2:03-01;02.05.2014;28.08.14-18.09.14:Custname2:03-01;Rental;Income:Rentals;1;765,0;$;=;0;;;;;28.08.2014;;28.08.14-18.09.14:Custname2 
:03-01;
111;;AGENT023;111;16.08.14-02.09.14:Custname3:01-02;13.06.2014;16.08.14-02.09.14:Custname3:01-02;Agent;Income:Agents;1;832,0;$;=;84,0;;;;;16.08.2014;;16.08.14-02.09.14:Custname3:01-02;
122;;GUEST;122;28.09.14-12.10.14:Custname4:03-01;11.07.2014;28.09.14-12.10.14:Custname4:03-01;Rental;Income:Rentals;1;428,0;$;=;0;;;;;28.09.2014;;28.09.14-12.10.14:Custname4:03-01;
123;;GUEST;123;28.09.14-12.10.14:Custname5:Dorm-02;11.07.2014;28.09.14-12.10.14:Custname5:Dorm-02;Rental;Income:Rentals;1;504,0;$;=;0;;;;;28.09.2014;;28.09.14-12.10.14:Custname5:Dorm-02;
--

For convenience i did attach this as text/csv file. See below.

If an import generates errors, is there some way to check which errors 
did occur? I do get a report of 5 Fixes if i import this?!

cheers,

   Arnd


-------------- next part --------------
A non-text attachment was scrubbed...
Name: invoice-exa.csv
Type: text/csv
Size: 908 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20140910/89bf3074/attachment.csv>