Re: String lengths in the SQL backend

2008-11-13 Thread Graham Leggett
Derek Atkins wrote: Uhh, yeah. Sorry. Totally unreasonable. The code in question is a user-input field. Historically accountants used codes instead of names to keep track of accounts. So GnuCash provides a place for you to enter in an Account Code. But it's a string, not a number.

Re: Russian translation update

2008-11-13 Thread Christian Stimming
Am Mittwoch, 12. November 2008 18:40 schrieb Сергей Беляшов: This is update of russian translation for current 2.2 branch (rev. 17688). Committed to SVN. Thanks a lot! Christian ___ gnucash-devel mailing list gnucash-devel@gnucash.org

Re: String lengths in the SQL backend

2008-11-13 Thread Manfred Usselmann
Phil Longstaff [EMAIL PROTECTED] schrieb am Wed, 12 Nov 2008 10:24:03 -0500: Can anyone think of a reason that account code size limit cannot be reduced to a smaller value (e.g. 32)? Will anyone ever enter an account code longer than that? I can't, but I'm sure sooner or later a user will

Re: String lengths in the SQL backend

2008-11-13 Thread Geert Janssens
I agree that this would be the best course of action. Use a separate key for the codes. Internally, link the tables using the keys, and only where user interaction is expected, present the code. My 2c. Geert On Thursday 13 November 2008, Graham Leggett wrote: Derek Atkins wrote: Uhh, yeah.

Re: Can't find commodity using gnc_commodity_table_lookup()

2008-11-13 Thread Derek Atkins
Justin Mazzola Paluska [EMAIL PROTECTED] writes: Hi Derek, On Tue, Nov 11, 2008 at 08:43:42AM -0500, Derek Atkins wrote: Well, for one thing I would either use NYCE or GNC_COMMODITY_NS_NYSE in both places. Yes, technically they should be the same, but you might as well test that theory.

Re: Importing Data

2008-11-13 Thread Derek Atkins
Marcus Wolschon [EMAIL PROTECTED] writes: The linked sourceforge-project consists of * jGnucashLib, a stable library for reading and writing gnucash's data-format, * jGnucashEditor, a java-tool ment for bulk-operations and automation and * jGnucashViewer, a standalone viewer that requires

Re: Writing Reports - Schreiben von Berichten in Gnucash

2008-11-13 Thread Derek Atkins
Norbert Bachl [EMAIL PROTECTED] writes: Hello Development-Team, I would like to create an invoice with a logo an maybe some other features. For this reason I would appreaciate your help. Set up a style sheet with your image? This is a User Question. -derek -- Derek Atkins, SB '93

Re: trunk doesn't compile

2008-11-13 Thread Derek Atkins
Hi, Casey Cichon [EMAIL PROTECTED] writes: [snip] /usr/local/lib/gnucash/libgncmod-ledger-core.so: undefined reference to `gnc_split_value_print_info' [snip] Seems like a completely different error to me and since I figured I caused enough trouble already, I haven't done anything to fix

Re: String lengths in the SQL backend

2008-11-13 Thread Derek Atkins
Herbert Thoma [EMAIL PROTECTED] writes: Ah well, I have a 30, 2560 pixel wide screen, 256 chars on a single line is possible, if the font is not too large ... Rolf wants german SKR4 account codes and these are 6 or 8 digit numerical codes, but that fact does not help since other users may

Re: String lengths in the SQL backend

2008-11-13 Thread Derek Atkins
Paul Schwartz [EMAIL PROTECTED] writes: I've worked with several accounting packages, and I would find it very strange if someone could not adapt their procedures to live with 32 for the length of the account code. Except that the UI makes no limitation on the field size... So people who

Re: String lengths in the SQL backend

2008-11-13 Thread Derek Atkins
Roland Roberts [EMAIL PROTECTED] writes: I confess I haven't been paying attention to the SQL backend in a while. I'm one who would very much like to have this working since my wife and I often run into conflicts having to serialize our data entry (neither of us has much time to do data

Re: trunk doesn't compile

2008-11-13 Thread Casey Cichon
Hi, I recommend you uninstall all your old gnucash from /usr/local and then try again. Better yet, use a --prefix to load into something like /opt/gnucash Both of your suggestions work to get it compiled. Thanks Casey ___ gnucash-devel

Re: String lengths in the SQL backend

2008-11-13 Thread Phil Longstaff
On November 13, 2008 10:12:32 am Derek Atkins wrote: Roland Roberts [EMAIL PROTECTED] writes: I confess I haven't been paying attention to the SQL backend in a while. I'm one who would very much like to have this working since my wife and I often run into conflicts having to serialize our

Re: String lengths in the SQL backend

2008-11-13 Thread Herbert Thoma
Derek Atkins schrieb: Herbert Thoma [EMAIL PROTECTED] writes: Ah well, I have a 30, 2560 pixel wide screen, 256 chars on a single line is possible, if the font is not too large ... Rolf wants german SKR4 account codes and these are 6 or 8 digit numerical codes, but that fact does not help

Re: String lengths in the SQL backend

2008-11-13 Thread Phil Longstaff
On November 13, 2008 10:10:53 am Derek Atkins wrote: What exactly is the use-case for using codes as a primary key? Keep in mind that the SQL Backend data store is just that, a data store. GnuCash does NOT use database constraints, and for Accounts it doesn't even need to use an Index,

Re: Importing Data

2008-11-13 Thread Marcus Wolschon
(Mail sent again using gmail as this morning a spammer guesses a user's password. We disabled it within 40min but it temporarily got us into some blacklists.) 2008/11/13 Derek Atkins [EMAIL PROTECTED]: Marcus Wolschon [EMAIL PROTECTED] writes: The linked sourceforge-project consists of *