Importing invoices

Anthony Abry abry at gyofukan.com
Mon Jan 16 13:43:54 EST 2017


Thank you for your suggestions.

Since I do not program in python, the instructions 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/import-invoices.html 
are of no use to me. I wish they would just show the fields for how the 
excel should look like to be imported via the comma separated option. I 
tried numerous ways of editing the excel but to no avail.

After formatting the excel into 3 columns for Date, Description, Decimal 
Hours I try to parse it in via File -> Import and I use custom regular 
expression since that gives me some fields to edit.

I get this

^(?<id>[^;]*);(?<date_opened>[^;]*);(?<owner_id>[^;]*);(?<billing_id>[^;]*);?(?<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>[^;]*)$

So I edit it to

^(?<date>[^;]*);?(?<desc>[^;]*);?(?<quantity>[^;]*)$

Just those 3 columns.

This, however, causes a crash.

Now, if I put it like this:

^(?<id>[^;]*);(?<date>[^;]*);?(?<desc>[^;]*);?(?<quantity>[^;]*)$

It imports nothing and shows me all the lines which it decided to ignore 
(which is all my info).

Creating a new invoice, and importing it via the csv importer also does 
not work.

Any help is very much appreciated.






<http://www.linkedin.com/pub/anthony-abry-cmt-mba/13/a61/7b4>
On 1/16/2017 1:51 AM, Geert Janssens wrote:
> Op maandag 16 januari 2017 00:14:06 CET schreef GoodNamesGone:
>> 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?
>>
> Hi,
>
> I'm sorry the process caused you so much frustration.
>
> On the other hand, if you would give us some more details about what you tried
> *exactly*, perhaps with a sample import file for illustration, it would be
> more likely you get some help with your current problem.
>
> As for the "open source" argument, that is rarely raised on this list. In fact
> only when people express unreasonable expectations.
>
> Regards,
>
> Geert
>




More information about the gnucash-user mailing list