Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?
On Sat, 17 Nov 2018 at 22:52, Peter Holck wrote: > > * 15:25:47 CRIT [GncDbiBackend::session_begin()] > Unable to connect to database 'gnucash' Please copy the list on replies, you sent this one just to me. On gmail use Reply All when replying. Are you able to connect to the server using the command line client mysql -u username -p and it will prompt for the password. If that connects then show databases; will show the databases (oddly enough). Then you can exit with exit; Colin ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Multiple Currency transaction with bank fee
Hello, I am a longtime user (GC3.3, Mac OSX) trying to do something new in GnuCash, and I ran into a situation that I found rather confusing, and I’d like to share that with the group to see whether I have understood the situation correctly. Basically, I am transferring funds from a US dollar account to an Indian Rupee account. I have the USD account already, and created the INR account as an asset account: Assets:Current Assets:Checking Accounts:INR Checking. The account is denominated in INR, while the parent accounts are USD. I created the opening balance transaction using funds from my USD-denominated cash account. After tinkering around with the exchange rate dialog (God, the terminology used there is not understandable!), I got the numbers to be sane and based on the actual amounts involved. Then, I attempted to document a subsequent transfer I initiated using Xoom, and this is where things get messy. Xoom is an online funds transfer service that allows me to transfer this money to this INR account for a small fee. So, I opened the INR account and created the transfer for the base amount, and got a second sensible multicurrency transaction (again, after some tinkering. Did I mention that the terminology used in the dialog is confusing?). Then I remembered that Xoom charged me another $4.99, and I went to the Cash account and opened up the transaction in split mode. There, I changed the total amount charged to my origination account to $504.99, fully expecting to assign the extra $4.99 to Expenses:Bank Fees. Imagine my surprise when I received the Exchange Rate dialog again, which GnuCash would not let me dismiss. I could only adjust the numbers, and everything I did messed things up further. Knowing that many others are using GC for just this sort of use case, I deleted the transaction, and then read a bit in the Guide, but didn’t find anything to explain the odd situation I found myself in. I *did* notice that the example in the Guide started in the originating account and added splits as: Total Cost, Fee Charged, Net Transferred. When I tried THAT sequence, it all worked out. Here's, my question: Is this the *only* sequence a user should follow? It seems rather limiting for GC not to allow a user to add a new split to a multicurrency transaction, but I am unable to see any way to subsequently add a fee*. It’s not a big deal, but we should perhaps make it clear to users that they must follow this split sequence to enter such transactions. It occurs to me that part of the problem likely has to do with where the tranasction was originally entered. I entered this transaction in the INR account, and then attempted to change the USD figure from the USD account. Maybe this is why the exchange rate dialog triggers when I try to change that split. I surmise this because in further tests, I note that I could change the INR split without trouble. I would assume that the dialog would trigger based on the account in which the tranaction was edited (rather than whether the split is considered the “foreign” currency split), but that seems to be wrong. David * - I recognize that I could roll the fee into the exchange rate itself (similar to how some recommend rolling investment fees into the stock share prices), but I am glutton for punishment, and I like to see how much it is costing me to shift money around. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Multiple Currency transaction with bank fee
Am 18.11.2018 um 17:50 schrieb David T. via gnucash-user: > Hello, > > I am a longtime user (GC3.3, Mac OSX) trying to do something new in GnuCash, > and I ran into a situation that I found rather confusing, and I’d like to > share that with the group to see whether I have understood the situation > correctly. > > Basically, I am transferring funds from a US dollar account to an Indian > Rupee account. I have the USD account already, and created the INR account as > an asset account: Assets:Current Assets:Checking Accounts:INR Checking. The > account is denominated in INR, while the parent accounts are USD. I created > the opening balance transaction using funds from my USD-denominated cash > account. After tinkering around with the exchange rate dialog (God, the > terminology used there is not understandable!), I got the numbers to be sane > and based on the actual amounts involved. > > Then, I attempted to document a subsequent transfer I initiated using Xoom, > and this is where things get messy. Xoom is an online funds transfer service > that allows me to transfer this money to this INR account for a small fee. > > So, I opened the INR account and created the transfer for the base amount, > and got a second sensible multicurrency transaction (again, after some > tinkering. Did I mention that the terminology used in the dialog is > confusing?). > > Then I remembered that Xoom charged me another $4.99, and I went to the Cash > account and opened up the transaction in split mode. There, I changed the > total amount charged to my origination account to $504.99, fully expecting to > assign the extra $4.99 to Expenses:Bank Fees. Imagine my surprise when I > received the Exchange Rate dialog again, which GnuCash would not let me > dismiss. I could only adjust the numbers, and everything I did messed things > up further. > > Knowing that many others are using GC for just this sort of use case, I > deleted the transaction, and then read a bit in the Guide, but didn’t find > anything to explain the odd situation I found myself in. I *did* notice that > the example in the Guide started in the originating account and added splits > as: Total Cost, Fee Charged, Net Transferred. When I tried THAT sequence, it > all worked out. > > Here's, my question: Is this the *only* sequence a user should follow? It > seems rather limiting for GC not to allow a user to add a new split to a > multicurrency transaction, but I am unable to see any way to subsequently add > a fee*. It’s not a big deal, but we should perhaps make it clear to users > that they must follow this split sequence to enter such transactions. > > It occurs to me that part of the problem likely has to do with where the > tranasction was originally entered. I entered this transaction in the INR > account, and then attempted to change the USD figure from the USD account. > Maybe this is why the exchange rate dialog triggers when I try to change that > split. I surmise this because in further tests, I note that I could change > the INR split without trouble. I would assume that the dialog would trigger > based on the account in which the tranaction was edited (rather than whether > the split is considered the “foreign” currency split), but that seems to be > wrong. > > David > > * - I recognize that I could roll the fee into the exchange rate itself > (similar to how some recommend rolling investment fees into the stock share > prices), but I am glutton for punishment, and I like to see how much it is > costing me to shift money around. What’s so confusing about the currency exchange rate window? I understand it perfectly fine. But yes, I’ve also noticed that the dialog is triggered depending on were the transaction was entered. When following the sequence described, you can always change the amounts and add fees. I don’t if has something to with the usage of trading accounts. But I could add a fee in this scenario just fine. Standard account currency EUR, foreign currency USD, exchanging EUR to USD. Starting with a blank transaction in the EUR account, I selected the USD account and entered the amount in USD, got prompted for the exchange rate and remembered the converted EUR amount and completed the transaction with this amount and the EUR account and left the transaction. Afterwards I changed the amount for the EUR account and could just assign the new remaining amount to an EUR exchange rate expenses account. What would be your use case. You could also write the final EUR amount first and change the imbalance EUR account to the right one afterwards. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information
Re: [GNC] compiling 3.3
On 11/17/18 7:24 PM, John Ralls wrote: ;;; WARNING: loading compiled file/home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/account-piecharts.go failed: ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" ;;; compiling/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/account-piecharts.scm ;;; compiled/home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/account-piecharts.scm.go That’s telling you that the compiled guile files from your build are defective for some reason and that guile is rebuilding them in the location listed. While that’s a bunch of noise it’s not what’s crashing GnuCash. It does suggest that there’s something wrong with Guile on your machine and it’s possible that the rebuilt .go files are also invalid. What OS/Distro and version are you running? debian buster > How did you set up the build environment? No env vars used (that I know). launch build by commands: cmake -DCMAKE_INSTALL_PREFIX=/home/john/.local/gnucash-3.3 /mosource/gnucash make sudo make install > Do you have more than one version of Guile installed 2.2 was removed when I used a prerequisites script to get dependencies for debian. I have 2.0 installed. I just found that 2.2 was still there, only guile-2.2-dev was removed, so I did sudo apt purge guile-2.2 and libguile-2.2 and removed all 2.2 from /usr/lib/x86_64-linux-gnu > Then you want to delete all of /usr/local/lib/gnucash and /usr/local/share/gnucash. Did that. /usr/local/share/gnucash was there, now deleted. After another configure and compile the run time errors go away and all is well. Thanks for the hints on cleaning out the old that conflicts with the new. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Account ID when importing CSV Transactions
I have been using GnuCash for many years and I am still using release 2.6.17 or similar depending on which computer I am using. I just noticed that when I am importing a CSV transactions file and I get to the step to determine which account to import the transactions into, the list of accounts shows a column named Account ID. I had previously assumed that this was the description column from the Chart of Accounts page, but today the accont that I was importing into did not have an account ID in the import page but many other accounts do have ID's and most of them match the description because that is where I have customarily put the accont number. There is no column in the Chart of Accounts page called Account ID or containing the same information. How can I put the missing account number into the Account ID column if I cannot see it? David C ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?
Thanks again for your help; I think I understand my problem now. GnuCash (reasonably) looks for an instance of MySQL using the same port that it used when closed (or when created? Not sure). Anyway, I had assigned a different port number to my new version of MySQL (since I wanted to keep both MySQL 5.6 and MySQL 8.0 installed on my machine at least until I confirmed the new version was working correctly). Swapping the port numbers so the new 8.0 version used the old 5.6 port and vice versa (via editing the my.ini config file) seems to have done the trick. Thanks! On Sun, Nov 18, 2018 at 1:21 AM Colin Law wrote: > On Sat, 17 Nov 2018 at 22:52, Peter Holck wrote: > > > > * 15:25:47 CRIT > [GncDbiBackend::session_begin()] Unable to connect to database > 'gnucash' > > Please copy the list on replies, you sent this one just to me. On > gmail use Reply All when replying. > > Are you able to connect to the server using the command line client > mysql -u username -p > and it will prompt for the password. > > If that connects then > show databases; > will show the databases (oddly enough). Then you can exit with > exit; > > Colin > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] CSV Importer - Single amount column
My bank has a CSV format with a data column, an amount column , a description then a balance column and finally an expense category. The amount column is negative for withdrawals and positive for deposits. When I tried to import the data with the currency set to Locale (the default) and the amount column set as Withdrawal, the importer did not recognise the positive quantities as withdrawls and markde them as errors. I played a bit with the other settings and by setting the currency to a period as the separator and with a comma as a thousands indicator, the importer then recognized all the transactions in the file and imported them correctly. As this behavior is not exactly intuitive, I thought it was worth posting to help anyone else trying to use the CSV importer who may encounter a similar problem. I don't normally use the CSV importer as my bank also has a correctly formatted OFX export which works. I was experimenting with it to try and find a way of dealing with importing CSV output from my PayPal account. However still no luck with that without extensive editing in LibreOffice Calc before re-exporting the modified CSV. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?
I expect that gnucash assumes you are using the default mysql port. Colin On Mon, 19 Nov 2018, 03:31 Peter Holck Thanks again for your help; I think I understand my problem now. > > GnuCash (reasonably) looks for an instance of MySQL using the same port > that it used when closed (or when created? Not sure). Anyway, I had > assigned a different port number to my new version of MySQL (since I wanted > to keep both MySQL 5.6 and MySQL 8.0 installed on my machine at least until > I confirmed the new version was working correctly). Swapping the port > numbers so the new 8.0 version used the old 5.6 port and vice versa (via > editing the my.ini config file) seems to have done the trick. > > Thanks! > > On Sun, Nov 18, 2018 at 1:21 AM Colin Law wrote: > >> On Sat, 17 Nov 2018 at 22:52, Peter Holck >> wrote: >> > >> > * 15:25:47 CRIT >> [GncDbiBackend::session_begin()] Unable to connect to database >> 'gnucash' >> >> Please copy the list on replies, you sent this one just to me. On >> gmail use Reply All when replying. >> >> Are you able to connect to the server using the command line client >> mysql -u username -p >> and it will prompt for the password. >> >> If that connects then >> show databases; >> will show the databases (oddly enough). Then you can exit with >> exit; >> >> Colin >> > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Brand new and lost...
Johnathon for further information see: https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-files1.html https://www.gnucash.org/docs/v3/C/gnucash-help/chapter_busnss.html David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
