Re: Invoice Importer

gt;> > >> > > I can reproduce this behaviour on linux too. Obviously a bug. On > reloading the sqlite file I see: > > * 16:12:18 WARN [load_invoice_guid()] Invoice ref > '87c42b5bb338df5c665c49ce1d4422c4' not found > * 16:12:20 WARN Can't find invoice > 87c42b5bb338df5c665c49ce1d4422c4 in current book. > * 16:12:20 WARN Giving up on restoring 'Page 5'. > * 16:16:52 CRIT gnc_sql_save_commodity: assertion > `pCommodity != NULL' failed > * 16:16:52 CRIT 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 > https://bugzilla.gnome.org/show_bug.cgi?id=682280 -- View this message in context: http://gnucash.1415818.n4.nabble.com/Invoice-Importer-tp3591286p4656357.html Sent from the GnuCash - Dev mailing list archive at Nabble.com. ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: Invoice Importer

;t find invoice > 87c42b5bb338df5c665c49ce1d4422c4 in current book. > * 16:12:20 WARN Giving up on restoring 'Page 5'. > * 16:16:52 CRIT gnc_sql_save_commodity: assertion > `pCommodity != NULL' failed > * 16:16:52 CRIT gnc_sql_save_commodity: assertion >

Re: Invoice Importer

On Mon, 20 Aug 2012 18:00:20 +0300 Reuben Cummings wrote: > On 8/20/12, Derek Atkins wrote: > > reubano writes: > > > >> Mike Evans wrote > >>> > >>> On Sat, 3 Mar 2012 03:55:26 -0800 (PST) > >>> reubano wrote: > >>> > I have successfully imported invoices but now there is a pro

Re: Invoice Importer

Hi, Reuben Cummings writes: >> The post/restart/not-showing is completely different. Are you using a >> SQL backend or XML? And how do you "start" gnucash? >> >> -derek >> > > sqlite backend and I "start" gnucash by opening Gnucash.app not by > opening the .gnucash files. Okay. What happens

Re: Invoice Importer

On 8/20/12, Derek Atkins wrote: > reubano writes: > >> Mike Evans wrote >>> >>> On Sat, 3 Mar 2012 03:55:26 -0800 (PST) >>> reubano wrote: >>> I have successfully imported invoices but now there is a problem. After restarting gnucash, the invoices no longer show up in the "Fi

Re: Invoice Importer

reubano writes: > Mike Evans wrote >> >> On Sat, 3 Mar 2012 03:55:26 -0800 (PST) >> 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 a

Re: Invoice Importer

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

Re: Invoice Importer

Mike Evans writes: > This, I think, was caused when the importer skipped alternate rows in > the invoice entries. I has since, I hope, been fixed. This is also one reason we say that "trunk" is unstable and could destroy your data ;) > Mike E -derek -- Derek Atkins, SB '93 MIT EE, S

Re: Invoice Importer

On Mon, 02 Apr 2012 09:10:06 -0400 Derek Atkins wrote: > Reuben Cummings writes: > > > SELECT > > entries.invoice > > > > FROM entries > > LEFT OUTER JOIN invoices ON entries.invoice = > > invoices.guid WHERE invoices.guid IS NULL > >

Re: Invoice Importer

Reuben Cummings writes: > SELECT > entries.invoice > > FROM entries > LEFT OUTER JOIN invoices ON entries.invoice = invoices.guid > WHERE invoices.guid IS NULL > GROUP BY entries.invoice Do you really need the join here? >>> >>> Yes. Since the or

Re: Invoice Importer

On Mar 27, 2012, at 12:01 PM, Derek Atkins wrote: > Reuben Cummings writes: > >>> Umm, let's ignore the database and talk about the GnuCash objects, >>> please? You shouldn't be modifying the database, you should be using >>> the GnuCash APIs to enter your data. >> >> I would like to use the

Re: Invoice Importer

Hi, Reuben Cummings writes: >> Umm, let's ignore the database and talk about the GnuCash objects, >> please? You shouldn't be modifying the database, you should be using >> the GnuCash APIs to enter your data. > > I would like to use the API but I haven't gotten the python module to work. > Se

Re: Invoice Importer

On Mar 27, 2012, at 11:27 AM, Derek Atkins wrote: > Reuben Cummings writes: > I figured it out. The invoices from the entries table were never entered into the invoices table. I wrote a script to match the invoices with the transaction guids and insert them into the invoices tabl

Re: Invoice Importer

Reuben Cummings writes: >>> I figured it out. The invoices from the entries table were never entered >>> into the invoices table. I wrote a script to match the invoices with the >>> transaction guids and insert them into the invoices table. >> >> I don't think I understand this issue. What do y

Re: Invoice Importer

On Mar 26, 2012, at 11:48 AM, Derek Atkins wrote: > reubano writes: > >> reubano wrote >>> >>> On Wed, Mar 7, 2012 at 6:51 PM, Reuben Cummings wrote: On Sun, Mar 4, 2012 at 1:29 PM, Mike Evans wrote: > > On Sat, 3 Mar 2012 03:55:26 -0800 (PST) > reubano

Re: Invoice Importer

reubano writes: > reubano wrote >> >> On Wed, Mar 7, 2012 at 6:51 PM, Reuben Cummings wrote: >>> On Sun, Mar 4, 2012 at 1:29 PM, Mike Evans wrote: On Sat, 3 Mar 2012 03:55:26 -0800 (PST) reubano wrote: > gnucash-2.4.10 built from source

Re: Invoice Importer

invoices with the transaction guids and insert them into the invoices table. -- View this message in context: http://gnucash.1415818.n4.nabble.com/Invoice-Importer-tp3591286p4501169.html Sent from the GnuCash - Dev mailing list archive at Nabble.com. ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: Invoice Importer

On Wed, Mar 7, 2012 at 6:51 PM, Reuben Cummings wrote: > On Sun, Mar 4, 2012 at 1:29 PM, Mike Evans wrote: >> >> On Sat, 3 Mar 2012 03:55:26 -0800 (PST) >> reubano wrote: >> >> > gnucash-2.4.10 built from source (applied row-skipping patch) with >> > MacPorts 2.0.3 on MacOSX 10.7.2 >> The patch

Re: Invoice Importer

On Sun, Mar 4, 2012 at 1:29 PM, Mike Evans wrote: > > On Sat, 3 Mar 2012 03:55:26 -0800 (PST) > reubano wrote: > > > 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 > rele

Re: Invoice Importer

Mike Evans writes: > On Sat, 3 Mar 2012 03:55:26 -0800 (PST) > 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 >> invo

Re: Invoice Importer

On Sat, 3 Mar 2012 03:55:26 -0800 (PST) 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 impo

Re: Invoice Importer

invoice.'" gnucash-2.4.10 built from source (applied row-skipping patch) with MacPorts 2.0.3 on MacOSX 10.7.2 -- View this message in context: http://gnucash.1415818.n4.nabble.com/Invoice-Importer-tp3591286p4441203.html Sent from the GnuCash - Dev mail

Re: Invoice Importer

https://bugzilla.gnome.org/show_bug.cgi?id=670522 On 2/20/12, Mike Evans wrote: > On Mon, 20 Feb 2012 12:18:38 +0300 > Reuben Cummings wrote: > >> >> So, upon further usage I can't get the importer to work as expected. >> >> Importing bills works fine but when importing invoices, I get the >> >>

Re: Invoice Importer

On Mon, 20 Feb 2012 12:18:38 +0300 Reuben Cummings wrote: > >> So, upon further usage I can't get the importer to work as expected. > >> Importing bills works fine but when importing invoices, I get the > >> error "ROW DELETED, VENDOR_DOES_NOT_EXIST: id=1". Since 'id' is > >> the invoice numb

Re: Invoice Importer

>> So, upon further usage I can't get the importer to work as expected. >> Importing bills works fine but when importing invoices, I get the >> error "ROW DELETED, VENDOR_DOES_NOT_EXIST: id=1". Since 'id' is >> the invoice number, I don't understand the error. I even changed the >> invoice numb

Re: Invoice Importer

Fri, 17 Feb 2012, Mike Evans wrote: > > > Date: Fri, 17 Feb 2012 16:26:19 + > > From: Mike Evans > > To: reubano > > Cc: gnucash-devel@gnucash.org > > Subject: Re: Invoice Importer > > > > On Fri, 17 Feb 2012 08:02:16 -0800 (PST) > > reub

Re: Invoice Importer

On Fri, 17 Feb 2012 08:11:28 -0800 (PST) reubano wrote: > It then imports the file but only every even row. E.g., the results > window says "5 lines imported: 3 ignored (not fixable)". > > -- > View this message in context: > http://gnucash.1415818.n4

Re: Invoice Importer

e it's a text match), check leading decimal places. As for skipping rows, no idea. I'll look into it. Mike Evans > > -- > View this message in context: > http://gnucash.1415818.n4.nabble.com/Invoice-Importer-tp3591286p4397661.html > Sent from the GnuCash - Dev mailing

Re: Invoice Importer

It then imports the file but only every even row. E.g., the results window says "5 lines imported: 3 ignored (not fixable)". -- View this message in context: http://gnucash.1415818.n4.nabble.com/Invoice-Importer-tp3591286p4397694.html Sent from the GnuCash - Dev mailing list

Re: Invoice Importer

ce number to match the id of an existing vendor and still get the same error. -- View this message in context: http://gnucash.1415818.n4.nabble.com/Invoice-Importer-tp3591286p4397661.html Sent from the GnuCash - Dev mailing list archive at Nabble.com. _

Re: Invoice Importer

on OSX, the Gnucash config files go in > > ~/Library/Application Support/Gnucash. Move your config.user there > > and it should work (it does for me). > > > > Regards, > > John Ralls > > > > > > ___ > > gnucash-devel ma

Re: Invoice Importer

> ~/Library/Application Support/Gnucash. Move your config.user there and it > should work (it does for me). > > Regards, > John Ralls > > > ___ > gnucash-devel mailing list > [hidden email] > https://lists.gnucash.org/m

Re: Invoice Importer

On Jan 4, 2012, at 10:56 PM, reubano wrote: > On Wed, Jan 4, 2012 at 10:44 PM, Derek Atkins-3 [via GnuCash] > wrote: >> Hi, >> >> On Wed, January 4, 2012 8:15 am, reubano wrote: >>> I can't find config.user on my system. The closet to it is >>> ~/.gconf/apps/gnucash which contains 1 file (%gcon

Re: Invoice Importer

s or build from source? -- View this message in context: http://gnucash.1415818.n4.nabble.com/Invoice-Importer-tp3591286p4264495.html Sent from the GnuCash - Dev mailing list archive at Nabble.com. ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: Invoice Importer

ions >>> >> on enabling python using macports either. >>> > >>> > No, the wiki instructions say that the *minimum* version it will >>> > work on is Leopard. The procedure has been tested on Lion. Do note, >>> > though, that the result

Re: Invoice Importer

version of OSX >> > earlier than the SDK that you use. Note second that the bundle file >> > isn't set up for Python, so you'll need to modify it. You'll want >> > to include Python in your module list as well, so that you have an >> > in-tree

Re: Invoice Importer

is Leopard. The procedure has been tested on Lion. Do note, > > though, that the resulting binary won't work on any version of OSX > > earlier than the SDK that you use. Note second that the bundle file > > isn't set up for Python, so you'll need to modify it. You&#x

Re: Invoice Importer

it. You'll want to include Python in your module list as > well, so that you have an in-tree build to work with. Please explain. So I follow directions from http://wiki.gnucash.org/wiki/MacOSX/Quartz#Building and add the line: module_autogenargs["gnucash"]="--enable-pyt

Re: Invoice Importer

On Jan 3, 2012, at 12:03 AM, reubano wrote: > > Christian Stimming-4 wrote >> >> Am Sonntag, 12. Juni 2011 schrieb knew two gnucash: >> >>> Python is compiled in, per the statement: >>> "The Python extensions are an optional feature in the source code. To be >>> able to use Python scripts, Gnu

Re: Invoice Importer

ave the proper menu option. The wiki instructions for building gnucash on mac only mention testing up to Leopard. And I haven't seen any instructions on enabling python using macports either. -- View this message in context: http://gnucash.1415818.n4.nabb

Re: Invoice Importer

On Monday 13 Jun 2011 01:31:48 knew two gnucash wrote: > It didn't like the permissions the 1st round - said it could not open the > file. Solved that with some chmod + action and got: > > woop /usr/local/share/gnucash/python > Hello from python! > Entries for test, test2 and test3 show up that

Re: Invoice Importer

Alas, I do not see a change in the menus. So - what am I missing? -- View this message in context: http://gnucash.1415818.n4.nabble.com/Invoice-Importer-tp3591286p3592848.html Sent from the GnuCash - Dev mailing list archive at Nabble.com. ___ g

Re: Invoice Importer

Am Sonntag, 12. Juni 2011 schrieb knew two gnucash: > My end goal - import invoices. My reason for posting - not getting to > that end goal. > > The search leads to > http://code.gnucash.org/docs/guide/python-import-invoices.html says: > > "Once you have converted the file navigate to Business

Invoice Importer

oice & Bill Import " to work? -- View this message in context: http://gnucash.1415818.n4.nabble.com/Invoice-Importer-tp3591286p3591286.html Sent from the GnuCash - Dev mailing list archive at Nabble.com. ___ gnucash-devel mailing list gnucash-dev

Re: Invoice Importer

(leaving gnucash-user out of this reply) Graham Leggett writes: > On 09 Jun 2010, at 3:33 PM, Phil Longstaff wrote: > >> I've had thoughts of a generic importer, so I'll lay them out here >> and you can use some or all or none of them. >> >> I have used an accounting system in the past which all

Re: Invoice Importer

On 09 Jun 2010, at 3:33 PM, Phil Longstaff wrote: I've had thoughts of a generic importer, so I'll lay them out here and you can use some or all or none of them. I have used an accounting system in the past which allows CVS files to be imported. You specify the CVS file and which CVS colum

Re: Invoice Importer

ty type can be determined to specify what column interpretation is needed). Then, this engine could be used by the invoice importer, the job importer, the customer importer, ... I think a transaction importer would be a special case because the CVS lines really provide data for both transact