Based on Product highlights - openSUSE, it would appear that using sqlite3 in gnucash would be available. However, I do not have an option to save an existing book to the database format, nor is it available when creating a new book - only xml is available. Is there anything special that I need to do to enable the sqlite backend?
View 2 Replies
Gnucash 2.4 has been released and I'd like to install it in my OpenSuSE 11.3 system. It isn't in any of the repositories that I have listed, although it might be in some repository I don't know about. If it's not in a repository, then I'll have to build it from source. I downloaded the source package and attempted to build it, starting with configure. I got as far as this:
configure: External QOF Disabled. Using Internal QOF Code.
checking dbi/dbi.h usability... no
checking dbi/dbi.h presence... no
checking for dbi/dbi.h... no
configure: error: Unable to find dbi/dbi.h
The perl-DBI package is installed, so that's probably not what it's looking for.So what do I need to do to install Gnucash 2.4?
The latest version of Gnucash available in openSUSE - and I checked the Gnome factory repo - is 2.4.0. The latest version from Gnucash was announced on Sunday and that was 2.4.5. Admittedly 2.4.1 doesn't seem to have been released and 2.4.2 had a bug in Windows but 2.4.3 was released on 27th Feb. Any reason why openSUSE seems to be lagging behind? Graham Davis, Bracknell, Berks. E-mail: change boy to man openSUSE 11.4; KDE 4.6.00; AMD Athlon X2 Dual Core Processor 5000+; Video: Radeon HD 2400 Pro; Sound: MCP61 HDA (nVidia); Wireless: BCM4318
View 3 Replies View RelatedI'm running OpenSuSE 11.1 and trying to install aqbanking using Yast. Gnucash tells me this: The external program "AqBanking Setup Wizard" has not been found. The aqbanking-qt3 package should include the program "qt3-wizard".check your installation to ensure this program is present. On some distributions this may require installing additional packages.When I try to install aqbanking-qt3, I get dependency problems. How can I get past this?
View 4 Replies View RelatedWhen I try to install Zimbra 7.1.2, the installation fails because it cannot find sqlite. I used strace and found that it uses "rpm -q sqlite" to find the package. But it fails-"package sqlite is not installed". Although I have sqlite installed:
Code:
#rpm -qa | grep sqlite
mono-data-sqlite-2.6.4-2.13.x86_64
[code]....
I am trying to install sqlite-python package in my FC11 machine. I couldn't find an rpm to install.
View 2 Replies View RelatedHow do I install php-sqlite extension on fedora 14.
View 5 Replies View RelatedJust tried to install gnucash on a fresh install of 13.37. ALL dependencies are installed, with no errors from any. The gnucash slackbuild dies with a message that says "gnome.h, no such file or directory". All I can find is that it is and very old dependency of gnome.
View 9 Replies View RelatedI can't install gnucash 2.4.7 on Debian 6,xfce environment with did not install the gnome environment
View 4 Replies View RelatedI want to be able to create an RPM that will install python 2.7.1 along with sqlite 3.7.3, MySQL-Python-1.2.3 on a CentOS 5.5 x86_64 host(s) in a directory (e.g. /opt/python2.7). Once that's done, I want to be able to alias the new python binary in .bash_profile so that my developers can begin using it.
I understand 2.7.1 can't be installed on a CentOS host but I've done the above using a shell script successfully. If you search hard enough, I posted my script on line . However, I need to create the RPM for political reasons. Besides placing the source file(s) in the SOURCES directory, what do I need to do in the spec to be able to successfully create an RPM installer?
Please be gentle with me. I've been drinking the Windows cool-aid for most of my IT career so, this is one of my first attempts of becoming a better DevOps Admin.
ERROR "global name 'sqlite' is not defined" when install Apache + Subversion + Trac
Apache+Subversion+Trac
httpd-2.2.16
Python-2.6
swig-1.3.31
sqlite-3.6.13
subversion-1.6.12
mod_python-3.3.1
[Code]....
How to take Backup & how to do restore in GnuCash. I need to take backup of my all accounts & all transactions
View 1 Replies View RelatedI installed GNUCash to try it out, but ended up not liking it too much. So I went into Ubuntu Software Center and pushed remove. It was taking really long (over 25 minutes) so I restarted my system. Now it is telling me I need to first repair the installation before I can remove it.I've been trying really hard to keep my system clean and organized and now this is bugging me
View 3 Replies View RelatedI just installed fedora 14 and it rocks! The problem is gnucash. When I start it it throws the following error:
gnucash-2.3.15-2.fc13.i686 requires libwebkit-1.0.so.2
I tried to find such lib but it's not available. I noticed there's libwebkitgtk and then I created a symbolic link to it and gnucash works fine, except the menu bar doesn't appear. This bar is crucial for accessing some features what makes gnucash almost useless since I cannot import .ofx files for example.
I recently transferred my old Quicken data to GnuCash. That data includes some very old (15 years ago) transactions and accounts. How can I get rid of all transactions prior to, say, 1/1/2004? I would guess that the Close Book tool is relevant, but there's no documentation on it that I can find. I also want to get rid of ancient accounts, but when I try, I get a message to the effect that I can't delete read-only transactions. More generally, is there a place for asking GnuCash questions?
View 2 Replies View RelatedI'm having a bit of trouble with a web server running Fedora 12. Apache works fine, and serves up php content without a hitch. My problem is SQLite -- I thought that it was built into php5, but support is disabled in the repo version. phpinfo shows this as part of the configure command:
Code:
'--without-sqlite' ... '--disable-pdo' ... '--without-sqlite3'
The only solution I've read anywhere is "compile php from source," but I'd like to avoid that if possible, for ease of future upgrades. Is there a way to convince php to use sqlite despite its current state?
Is there a binary available somewhere, even if it's a non-Fedora repo?
View 8 Replies View RelatedWith this sqlite query ? I have these tables:
what is the query to list all cities and its neighboring cities like this?
I am trying to connect to sqlite via perl:
Code:
#! /usr/bin/perl
use LWP::Simple;
use XML::DOM;
use DBI;
[Code]....
Anyone know how to execute SQLite db commands from C++?
View 1 Replies View RelatedI am trying to replicate my GnuCash files between two computers. My GnuCash folder has three types of files:
* One Gzip archive file
* Many xac files (GnuCash Financial Data)
* Many log files
The xac and log files replicate with no problem. However the Gzip file does not. Without this Gzip file, GnuCash cannot makes sense of the other files.Why would this Gzip file not sync? Have others used Ubuntu One to sync their GnuCash files?
I'm trying to take off with GnuCash and I've been trying to work on the basics.
Here's my question: I don't want to enter all the details of bills sine there's another program for that. So I thought it would be right to enter the sales summary in the accounts receivable account and post the corresponding entry for the Sales account. Based on this,
1. What does the TYPE mean (I/P) on the receivable account?
2. I let it have I and now I want to go back and edit those entries but I can't seem to do that. It appears to be locked.
Running 10.04 64bit. Installed the latest Gnucash from repositories. Using Quicken 2003 and exported an account to a qif file. When trying to import to Gnucash the error "A bug was detected while reading the QIF file." displays. This, at least is more than I was able to do previously (prior to 10.04 and several earlier versions of Gnucash running in 8.04 through 9.10). Before it would cause Gnucash to crash and shutdown. I select a specific account with categories from Quicken to export. I can import to KMymoney and use it but that program is not compatible with the wife and does not do reconciliation reports by default.
View 3 Replies View RelatedAfter upgrading to 11.04 I've realized that the mt940 import is broken for Gnucash. No specific message on the console.
View 1 Replies View RelatedI am using SQLite as my database for some portable cross platform applications I am working on with REALBasic as my IDE. I have an old Sybase 8.0 database that I can access via Microsoft Access and thereby extract the data I need from each table.
Now I know I can create .csv files from each table and load them into SQLite using the import tool, but then I can't define the primary key and other field attributes. So the other option is to load each file via SQL.
Now with most SQL editors I can create multiple queries and they will run just fine. But I can't seem to do that with the SQLite interfaces. I can paste multiple queries but I can only run one at a time. And by that I mean I have to click run.
Ummm that's not acceptable since my biggest table contains over 600,000 records. I have the queries all written, that was easy using a simple interface I wrote in Access.
Code:
INSERT INTO tblMeters(recordId,meterId,meterName,meterSerNum,registerSerNum,mxuSerNum,meterType,manufacture,meterModel,readType,groupId,multiplier,rollover,vendorId,xfrmerCode,bldgCode,CATEGORY,energyType,unitOfMeasure,location,access,comments,dateInstalled,dateCalibrate,pipeSizeIn,pipeSizeOut,elecMeterSpecs)
[Code]...
So is there another method I can use? I can't seem to find anything relating to my particular question at the SQLite web site
i am trying to compile too the sqlite for arm9 - mini2440.could you please tell me what was the steps you make? im read that book but im still having some trouble while i compile i have been trying to do the compilation.
View 3 Replies View RelatedAnybody know how to import Simply Accounting files into Gnucash?
View 1 Replies View RelatedI have been using gnucash for years and never had any problems but now every time I try to load it it crashes upon trying access an account. The sequence is that it first tells me it cannot get a lock on ANY of my files reporting that they may be in use by somebody else; this is impossible. However when I do load it the initial list of accounts installs.
However when I try to open any specific account Gnucash crashes. I am using Mepis 8.0 and Gnucash 2.2.6 directly from the repositories. I have removed it and reinstalled it but to no avail. I have tried to install version 2.2.9 as a tar file but I keep getting dependency errors despite the fact the files are installed.
So I think I almost have gnucash figured out. One problem though. When I try to import my stock quotes for my portfolios, It won't get any quotes for my OTC BB Stocks. Under the security editor, there is no option for OTC as an exchange. For example: CNEX. How would I set GnuCash up to import this quote?
View 1 Replies View RelatedI've used GNUCash before and just didn't click with it. Has anyone here used Homebank? I was just wondering how it might compare with GNUCash?
View 3 Replies View Related
