Invoice Importer

[reubano]

Mike Evans wrote
> 
> On Mon, 20 Aug 2012 18:00:20 +0300
> Reuben Cummings <reubano@> wrote:
> 
>> On 8/20/12, Derek Atkins <warlord@> wrote:
>> > reubano <reubano@> writes:
>> >
>> >> Mike Evans wrote
>> >>>
>> >>> On Sat, 3 Mar 2012 03:55:26 -0800 (PST)
>> >>> reubano <reubano@> wrote:
>> >>>
>> >>>> I have successfully imported invoices but now there is a problem.
>> >>>> After restarting gnucash, the invoices no longer show up in the
>> >>>> "Find Invoice..." druid. Searching for all posted invoices only
>> >>>> shows invoices not entered with the importer. Note: this only
>> >>>> occurs after restarting gnucash. Before restarting, the newly
>> >>>> imported invoices show up in the search results.
>> >>>
>> >>> Imported invoices are not posted by default.  Did you search for
>> >>> ALL invoices.  Odd that a restart should lose data, I assume you
>> >>> saved before restart.
>> >>>
>> >>>
>> >>>>
>> >>>> However, trying to edit the corresponding transaction in the
>> >>>> asset account gives the following warning: "This transaction is
>> >>>> marked read-only with the comment: 'Generated from an invoice.
>> >>>> Try unposting the invoice.'"
>> >>>>
>> >>>> gnucash-2.4.10 built from source (applied row-skipping patch)
>> >>>> with MacPorts 2.0.3 on MacOSX 10.7.2
>> >>> The patch has now been applied to 2.4 branch and will be in the
>> >>> next release.
>> >>>
>> >>> Mike Evans
>> >>>
>> >>
>> >> I just tried using the importer on 2.4.11 and the same problem is
>> >> occurring.
>> >> Invoices and bills import just fine. But, after I post them and
>> >> then restart
>> >> gnucash, neither the new invoices nor bills show up in the druid.
>> >> I'm using
>> >> the mac binary.
>> >
>> > The patch he was referring to was for the "row-skipping" issue.
>> >
>> > The post/restart/not-showing is completely different.  Are you
>> > using a SQL backend or XML?  And how do you "start" gnucash?
>> >
>> > -derek
>> >
>> 
> 
> I can reproduce this behaviour on linux too.  Obviously a bug.  On
> reloading the sqlite file I see:
> 
> * 16:12:18  WARN <gnc.backend.sql> [load_invoice_guid()] Invoice ref
>   '87c42b5bb338df5c665c49ce1d4422c4' not found
> * 16:12:20  WARN <gnc.business.gnome> Can't find invoice
>   87c42b5bb338df5c665c49ce1d4422c4 in current book.
> * 16:12:20  WARN <gnc.business.gnome> Giving up on restoring 'Page 5'.
> * 16:16:52  CRIT <gnc.backend.sql> gnc_sql_save_commodity: assertion
>   `pCommodity != NULL' failed
> * 16:16:52  CRIT <gnc.backend.sql> gnc_sql_save_commodity: assertion
>   `pCommodity != NULL' failed
> 
> Please file a bug report for this. 
> 
> Note that the function works fine with the XML data storage.
> 
> Mike E
> 

Will do. Also please read my previous posts in this thread for a detailed
description of the problem and how I've fixed it using SQL queries. I don't
know if it helps but I figure it can't hurt. 

And I have seen the numerous warnings against using the sql backend. But I
run custom reports off the database so I can't switch to the xml backend.
Plus, if no one uses the sql backend then who will report the bugs?? ;)



--
View this message in context: http://gnucash.1415818.n4.nabble.com/Invoice-Importer-tp3591286p4656350.html
Sent from the GnuCash - Dev mailing list archive at Nabble.com.