Re: Read the GnuCash files

2010-07-29 Thread Marcus Wolschon
2010/7/29 Fabrice Estiévenart fabri...@gmail.com: 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

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 stimm...@tuhh.de 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

Re: How to access the customer database

2009-10-26 Thread Marcus Wolschon
On Mon, Oct 26, 2009 at 5:33 PM, Statewide Software scott.furt...@gmail.com 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.

Re: Importing Invoices Expense Reports

2009-09-20 Thread Marcus Wolschon
On Sat, Sep 19, 2009 at 8:02 PM, Sebastian Held sebastian.h...@gmx.de 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

Re: MySQL sync

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

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 as

Re: Gnucash and root-account in MySQL

2009-08-09 Thread Marcus Wolschon
On Sat, Aug 8, 2009 at 6:07 PM, Phil Longstaffplongst...@rogers.com wrote: On August 8, 2009 04:26:48 am Marcus Wolschon wrote: Colin Law schrieb: 2009/8/8 Marcus Wolschon mar...@wolschon.biz: The root account guid is in the books table (column root_account_guid). This is causing me some

Gnucash and root-account in MySQL

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

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

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

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

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.

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 you

Re: sorting of transactions within day

2009-05-01 Thread Marcus Wolschon
2009/4/29 Charles Day ceda...@gmail.com: 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,

Re: Tutorial on Plugins

2009-04-04 Thread Marcus Wolschon
On Fri, Apr 3, 2009 at 9:39 PM, Sebastian Held sebastian.h...@gmx.de 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,

Re: String lengths in the SQL backend

2008-11-18 Thread Marcus Wolschon
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-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 support you by

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). We cannot depend on Stored Procedures because not all the supported

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, * jGnucashEditor, a java-tool ment for bulk-operations

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

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 developing

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