Re: Read the GnuCash files

2010-07-29 Thread Marcus Wolschon
2010/7/29 Fabrice Estiévenart : > Hi, > > I'm still unable to unzip the file. I tried gunzip or tar xzf. My zip file > is possibly corrupted but each time I try to create a new one with GnuCash I > get the same error (in french 'Une erreur s'est produite lors de > l'extraction des fichiers.'). It

Re: Loss of business data running a python script to manipulate gnucash data.

2010-04-03 Thread Marcus Wolschon
On Thu, Apr 1, 2010 at 4:57 PM, Christian Stimming wrote: > > I don't know exactly where this has to be fixed, but it will be somewhere > where the gnucash modules are initialized... If that´s the case that it 1) does not initialize itself automatically on first use BUT 2) allows to be used in an

Re: How to access the customer database

2009-10-26 Thread Marcus Wolschon
On Mon, Oct 26, 2009 at 5:33 PM, Statewide Software wrote: > > Where is the encrypted xml file located?  Is there anything special I have to > do to deal with the encryption when I read/write to the file?  Is there an > ETA on the database support for 2.4? It´s not encrypted. Just compressed by g

Re: Importing Invoices & Expense Reports

2009-09-20 Thread Marcus Wolschon
On Sat, Sep 19, 2009 at 8:02 PM, Sebastian Held wrote: > I'm glad to say, that importing customers and invoices already works on my > development machine. > I can provide precompiled plugins for gnucash, but please tell me the gnucash > version and your operating system. > > If you are an experien

Re: MySQL sync

2009-08-21 Thread Marcus Wolschon
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Derek Atkins schrieb: > Marcus, > > Marcus Wolschon writes: > >> There must be a way without violating 1st normal form and storing >> everything twice. >> Maybe an "updated"-timstamp or something may help.

Re: MySQL sync

2009-08-15 Thread Marcus Wolschon
There must be a way without violating 1st normal form and storing everything twice. Maybe an "updated"-timstamp or something may help. (Also I`m concerned that still loading all transactions from the db into ram will work out after a few years of bookkeeping. You cannot split a database by year a

Re: Gnucash and root-account in MySQL

2009-08-09 Thread Marcus Wolschon
On Sun, Aug 9, 2009 at 9:01 AM, Colin Law wrote: > If I had a vote I would vote for parent_guid = nil for root account. > This maps to the real world better (ie account that has no parent) > rather than an account that is its own parent being a root account. > Also using the latter approach a root

Re: Gnucash and root-account in MySQL

2009-08-08 Thread Marcus Wolschon
On Sat, Aug 8, 2009 at 6:07 PM, Phil Longstaff wrote: > On August 8, 2009 04:26:48 am Marcus Wolschon wrote: >> Colin Law schrieb: >> > 2009/8/8 Marcus Wolschon : >> > >> > The root account guid is in the books table (column >> > root_account_guid). Th

Re: Gnucash and root-account in MySQL

2009-08-08 Thread Marcus Wolschon
What`s the point of not having that entry for the root-account? "books" would just reference it`s guid. It`s the one thing that would make referential integrity possible when access-patterns/transactions have been changed to allow for it at some point. BTW: The database created has no index whatso

Re: Gnucash and root-account in MySQL

2009-08-08 Thread Marcus Wolschon
Colin Law schrieb: > 2009/8/8 Marcus Wolschon : > > The root account guid is in the books table (column > root_account_guid). This is causing me some pain as the type of the > object referenced by parent_guid is not consistent. Thanks, I found it. I also have that data-type -issue

Gnucash and root-account in MySQL

2009-08-07 Thread Marcus Wolschon
Hello, I had a closer look at the data Gnucash 2.3.3 was writing into it`s MySQL-tables and I noticed that the entry for the root-account on the "accounts"-table is missing. All the accounts directly below root have the same parent_guid but there is no entry for that guid in the "accounts"-table.

Re: crash in 2.3.2 Save As

2009-07-09 Thread Marcus Wolschon
What version of MySQL has the windows-binary been compiled against? What mysql-versions should it work with? ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel

requesting mysql-dump

2009-07-09 Thread Marcus Wolschon
Hello, since "save as" with Mysql isn´t working here. Can someone send me an sql-dump of a test-file for mysql? Just some default-accounts with a dummy- transaction/customer/invoice/tax-rate/... Marcus ___ gnucash-devel mailing list gnucash-devel@gnucas

requesting mysql-dump

2009-07-09 Thread Marcus Wolschon
Hello, since "save as" with Mysql isn´t working here. Can someone send me an sql-dump of a test-file for mysql? Just some default-accounts with a dummy- transaction/customeer/invoice/tax-rate/... Marcus ___ gnucash-devel mailing list gnucash-devel@gnuca

gnucash 2.3.2 Windows open file

2009-07-08 Thread Marcus Wolschon
In the Windows-Version Gnucash 2.3.2 complains that the just selected file cannot be found if it is on another drive-letter. Steps to reproduce: start gnucash file-open delect drive-letter p: select path "todo" select file "test" "open" message: "the file '//P:\TODO\test'" cannot be found. (tr

guile version check

2009-06-30 Thread Marcus Wolschon
checking whether guile works... yes checking for guile... /usr/bin/guile checking for guile - 1.6.0 <= version < 99.99.99... no: configure: WARNING: guile version check failed configure: error: guile does not appear to be installed correctly, or is not in the correct version range. Perhaps yo

Re: sorting of transactions within day

2009-04-30 Thread Marcus Wolschon
2009/4/29 Charles Day : > Are we talking about the order they display in the register? Because there > is View->Sort By. > > The "standard" sort is first by transaction (according to posting date, > followed by number, entry date/time, description), and then by split memo, > split action, split rec

Re: Tutorial on Plugins

2009-04-04 Thread Marcus Wolschon
On Fri, Apr 3, 2009 at 9:39 PM, Sebastian Held wrote: > The page "Building" was already there and that seems to be the best > place to put this tutorial in (the best place I had write permissions to). > APIs - yes, good point. But I do not know ;) As far as I currenty > believe, the plugin is abl

Re: String lengths in the SQL backend

2008-11-18 Thread Marcus Wolschon
2008/11/18 Derek Atkins <[EMAIL PROTECTED]>: > "Marcus Wolschon" <[EMAIL PROTECTED]> writes: > >> Or using stored procedures to create transactions >> uppon changes being made in other databases >> on the same DBMS (like a webshop-database). > &g

Re: Importing Data

2008-11-18 Thread Marcus Wolschon
2008/11/18 Phil Longstaff <[EMAIL PROTECTED]>: >> I remember talk about the gnucash-db-backend back when I started >> my first version, about 2 years ago. I'm still looking forward to seeing >> it completed and in actual use. It can scale so much better then the >> xml-file. > > How can I best supp

Re: String lengths in the SQL backend

2008-11-18 Thread Marcus Wolschon
n the same DBMS (like a webshop-database). Both would be a huge benefit. Marcus Wolschon ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: Importing Data

2008-11-14 Thread Marcus Wolschon
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Derek Atkins schrieb: > "Marcus Wolschon" <[EMAIL PROTECTED]> writes: > >> The linked sourceforge-project consists of * jGnucashLib, a >> stable library for reading and writing gnucash's data-format, * >&

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: > >>

Re: String lengths in the SQL backend

2008-11-12 Thread Marcus Wolschon
Well, my 2ct here: I am using the account-code to store item-numbers/item-barcodes (assets) or account-numbers (bank-accounts). Item-numbers can get quite long (think the serial-number identifying a laptop) but 32 characters should be okay, as long as it's not 32 byte (think Unicode). How far has

Re: Importing Data

2008-11-12 Thread Marcus Wolschon
2008/11/11, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > Hello there, > > I don't know which of these two groups is the right one for my question so > I'm sorry to contact both of them... > > I just want to know if it's possible to do a data import from an external > software tool. > The reason: I'm de