Importing invoices

Nelson Handcock nelson.handcock at gmail.com
Mon Jan 16 15:58:40 EST 2017


Hi,

The last section of the link I posted clearly explains the format for a csv
file that can be directly loaded into Gnu cash. there is no need for any
python coding ... it's a simple csv file that is imported using the Import
Bills and Invoices function under the File menu.

On 17 Jan 2017 6:44 a.m., "Anthony Abry" <abry at gyofukan.com> wrote:

>
> 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>[^;]*);(?<bi
> lling_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
>>
>>
>
> _______________________________________________
> 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.
>


More information about the gnucash-user mailing list