Re: [Ledger-smb-users] question about db structure re: fixing potential corruption

2011-06-26 Thread brush
thanks so much, chris. this is phenomenally timely and helpful! further discussion inline. On Sun, Jun 26, 2011 at 06:32:58AM -0700, Chris Travers wrote: > On Sun, Jun 26, 2011 at 5:10 AM, brush wrote: > > hi folks, > > > > i've run into the first signs of potent

[Ledger-smb-users] question about db structure re: fixing potential corruption

2011-06-26 Thread brush
hi folks, i've run into the first signs of potential DB corruption. so far, it's showing up as a discrepancy between what trial balance shows on the first page of by-account totals when selected w/o any dates, vs. what it shows when you drill down into the account. select sum(amount) from acc_tr

Re: [Ledger-smb-users] bug? in 1.2.x: departments/accounts/projects change unpredictably on update or post

2011-06-16 Thread brush
hi chris, On Thu, Jun 16, 2011 at 01:33:09AM -0700, Chris Travers wrote: > Two things that might help: > > 1) What fields specifically are causing this problem? department, "amount" (ie. the expense/income account), project, employee. (perhaps also the payment account, ie. the asset account).

Re: [Ledger-smb-users] bug? in 1.2.x: departments/accounts/projects change unpredictably on update or post

2011-06-16 Thread brush
se. So now I update the > customer/vendor first, and hit update, prior to any other changes. > > Probably not what's happening to you, but it's the only time I have > noticed something similar. > > Luke > > On Thu, 16 Jun 2011, brush wrote: > > > hi

[Ledger-smb-users] bug? in 1.2.x: departments/accounts/projects change unpredictably on update or post

2011-06-16 Thread brush
hi folks, i'd love help with a nagging problem: on AR/AP entries, the selected values for department, project, expense/income account, and employee are all vulnerable to "disappearing" or changing to other values on update or on post. the update behavior seems to be the most reproducible, with s

Re: [Ledger-smb-users] BIRT reports: request for useful SQL

2011-06-16 Thread brush
ccounts in configurable ways, etc. nice. i'll contrib them when they're a bit more polished. where should they go besides this list? and i'd be very interested to see yr perl script, nigel. thanks, all. .b On Sun, May 22, 2011 at 08:40:41AM +0100, Nigel Titley wrote: > On Fri, 2011

Re: [Ledger-smb-users] BIRT reports: request for useful SQL

2011-05-13 Thread brush
list. The code will be based on > 1.2.x however as that's what I am using presently. > > Pete > > On Wed, May 11, 2011 at 12:05:12AM -0700, brush wrote: > > we're using lsmb 1.1.12, waiting for 1.3 to upgrade. improved and timely > > reporting is a major

[Ledger-smb-users] BIRT reports: request for useful SQL

2011-05-11 Thread brush
greetings, we're using lsmb 1.1.12, waiting for 1.3 to upgrade. improved and timely reporting is a major current goal in our organization, and i'm starting to develop reports using BIRT (in eclipse) that directly access the postgres db. i have two requests: 1) has anyone developed any reports i

[Ledger-smb-users] experience using BI reports? (eg: jasper, pentaho, openRPT, etc)

2010-04-22 Thread brush
months at a time, combining certain accounts, etc.). i've been exploring the world of open source reporting tools, and jasper and openRPT seem somewhat promising. does anyone have experience with these or others? any example reports to share? thanks

Re: [Ledger-smb-users] Fwd: Teething problem after upgrade from sql-ledger

2008-04-10 Thread brush
dear topper, did you ever get that how-to written? i'd love to see it: i'm about to take the plunge and migrate from sql-ledger 2.4.11 (!). thanks, .b On Sun, Feb 10, 2008 at 11:20:58AM +, Topper Doggle wrote: > Forwarding to list again - no response first time, just wondering if I > can ge

Re: [Ledger-smb-users] batch import and export (CSV)

2007-10-31 Thread brush
On Wed, Oct 31, 2007 at 10:45:18PM +1100, Phil Rhoades wrote: ... (re : importing) > > > I have made a little progress using fireWatir to automate input but have > > > not had time to get back and sort out the remaining problems. > > > > > > http://swik.net/fireWatir > > > > i've looked a bit a

Re: [Ledger-smb-users] ledger-npo, configurable categories, and integration with civicrm & paypal

2007-10-30 Thread brush
dear chris, On Tue, Oct 30, 2007 at 10:41:12AM -0700, Chris Travers wrote: > I would subscribe to the devel list, search the archives for the CoA > proposal, and offer your thoughts on our direction. Our current > approach is a flat CoA attached to hierarchical headers. Mostly we > are looking a

Re: [Ledger-smb-users] batch import and export (CSV)

2007-10-30 Thread brush
On Tue, Oct 30, 2007 at 10:26:14AM -0700, Chris Travers wrote: > On 10/27/07, brush <[EMAIL PROTECTED]> wrote: > > also, are imports in the picture as well as exports? > Long-term, yes. Not sure when they will be included. I think the big > issue is that people send all so

Re: [Ledger-smb-users] batch import and export (CSV)

2007-10-30 Thread brush
hi folks, On Wed, Oct 31, 2007 at 04:37:32PM +1100, Phil Rhoades wrote: > > Can't resist such a call! ;) > > > > What I need right now is something that can take a CSV (or whatever) and > > import it as a GL transaction. Just a trivial CSV like this: > > > > Account,Credit,Debit,Memo > > 1060,0,

Re: [Ledger-smb-users] ledger-npo, configurable categories, and integration with civicrm & paypal

2007-10-27 Thread brush
dear chris, thanks for the response! i've joined the -devel list, and am cross-posting because i'm not sure which is best; guidance appreciated re: netiquette here! On Thu, Oct 11, 2007 at 02:04:45PM -0700, Chris Travers wrote: > > sql-ledger was the only OSS accounting package available to us a

Re: [Ledger-smb-users] batch import and export (CSV)

2007-10-27 Thread brush
ion? (for transactions, of course). i've looked a tiny bit at what it would take, but can't really tell whether the hooks are there to make it fairly easy. (not much of a perl hacker.) thanks so much for all the work, .b On Thu, Oct 11, 2007 at 02:07:32PM -0700, Chris Travers wrote: > Hi

[Ledger-smb-users] batch import and export (CSV)

2007-10-11 Thread brush
allies, one more comment. a more immediate need to simply to be able to export and import data to spreadsheets that can then be tweaked and fed into CiviCRM. i've noticed a variety of comments around this, but no unambiguous replies from developers: is there, or will there soon be, functional im

[Ledger-smb-users] ledger-npo, configurable categories, and integration with civicrm & paypal

2007-10-11 Thread brush
allies! it's wonderful to discover ledger-smb and this thriving community. i'm tech and financial coordinator for TLC Farm, a "small to medium" non-profit (NPO) with $100-200k annual budget. since our founding, we've been committed to using open source technologies and approaches regarding both