Re: [GNC] Scripted price editing and adding
Thanks to all for the inputs and suggestions. It sounds like I could make this work with a number of different paths, but I'll follow the "read, but don't write" suggestion and defer more of the analysis to the post-reading side and rely less on things like the built-in net worth time plot in Gnucash. I'd hate to end up in a situation where I realize I messed something up somewhere down the road and have to backtrack my save file to old backups. Best, Ray On Fri, Jan 17, 2020 at 6:53 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > If I recall, the general advice is you can read, but don’t write. > > GnuCash is not yet a true database app. (that is a long term goal) Until > then, writing could be potentially very destructive. > > There are some projects out there designed specifically to query an sqlite > backend of GnuCash for custom reporting. (PieCash comes to mind) I’m not > sure about MySQL or XML. > > GnuCash has Python bindings so you could roll your own solution. But even > then, I think they are query only. > > > Regards, > Adrien > > > On Jan 17, 2020 w3d17, at 8:34 PM, Peter West wrote: > > > > I’m curious about using sql scripts for read and update operations on > Gnucash data when that data is maintained in such a database. For XML, > similar things could be accomplished using XSLT or XQuery. > > > > Has anything along these lines been done? > > > > -- > > Peter West > > > ___ > 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. > ___ 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] Car Repair Shop GNU questions
Hello, I just helped a friend with GNUcash (I am a current user as well) however his situation is completely different then mine soI have some questions, maybe you guys can help me? Question 1:Can I make a summery at the bottom of an invoice with "Total Parts" and "Total Labor"?He itemizes every single 'part' on his invoice and might have 2 or 3 line items of 'labor'. Question 2:I also noticed the column "Action Items" I can select 'Hours' or 'materials' or 'Project'.Can I add more items to the "Action Items" column and how can I utilize this in a report? Question 3:How can I link his bank account to GNUcash? .Question 4: Is there any way I can add an extra column when I select "new invoice" for part numbers? Thanks so much for your help and have a blessed week! Martijn ___ 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] Sales Tax Report
On 1/19/20 12:13 PM, Michael or Penny Novack wrote: > On 1/19/2020 2:07 PM, Stephen M. Butler wrote: > >> Just this quarter (starting 1 Jan 2020) the State of Washington added >> some Idaho zip codes to its list of taxable zip codes. These are for >> houses in Washington State that get their mail via an Idaho post >> office. [ Note, Washington State is one of those that tax sales upon >> the delivered to address. ] >> > I think that legally, almost all do. But in the example you just gave, > are ALL houses in these "taxable Idaho zip codes" in Washington? In > that case you are lucky. In the more general case, those Idaho zip > codes would also include houses that are in Idaho. > > Note that this is early days of enforcement of sales tax for mail and > internet sales. Not yet time for cases to work their way through the > courts of people claiming wrongfully taxed or states suing states > because they argue the tax collected should be theirs. > > Michael D Novack Nobody in that zip code has ordered product yet. So I don't know what the "mailing address" will actually show. If they claim their "mailing address" is Idaho, I'll not collect. Now, I do a post process that looks at the address to figure out what I should have collected (so I can split local codes that share a common zip code). Will be interesting to see as the business grows. I do ship rather than visit. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Sales Tax Report
On 1/19/2020 2:07 PM, Stephen M. Butler wrote: Just this quarter (starting 1 Jan 2020) the State of Washington added some Idaho zip codes to its list of taxable zip codes. These are for houses in Washington State that get their mail via an Idaho post office. [ Note, Washington State is one of those that tax sales upon the delivered to address. ] I think that legally, almost all do. But in the example you just gave, are ALL houses in these "taxable Idaho zip codes" in Washington? In that case you are lucky. In the more general case, those Idaho zip codes would also include houses that are in Idaho. Note that this is early days of enforcement of sales tax for mail and internet sales. Not yet time for cases to work their way through the courts of people claiming wrongfully taxed or states suing states because they argue the tax collected should be theirs. Michael D Novack -- There is no possibility of social justice on a dead planet except the equality of the grave. ___ 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] Sales Tax Report
On 1/19/2020 1:22 PM, Keith Fetterman wrote: Adrien, Thanks for the help. In the state of Washington, we need to report the local city/county sales tax for each physical location we do work in. The state assigns a tax code based on address. The business is a very small landscaping business that only does work in a few local locations, so fortunately there are not many tax codes to keep track of. In your case, you are in luck, because physically going to the address where the service is provided, you will know what state it is in. Will know that although an address may be served by a Washington post office actually in Oregon or vice versa. I realize that this might not apply to you (not close to a state boundary) but I was just pointing out the data issue. Michael D Novack ___ 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] Sales Tax Report
On 1/19/20 10:22 AM, Keith Fetterman wrote: > Adrien, > > Thanks for the help. w > > In the state of Washington, we need to report the local city/county sales tax > for each physical location we do work in. The state assigns a tax code based > on address. The business is a very small landscaping business that only does > work in a few local locations, so fortunately there are not many tax codes to > keep track of. > > I have created a tax table for each tax code and assigned it to a customer. > This works because the physical work locations are the customers’ homes. If > work done in a different location, it’s almost always in the same area. > > I see what you mean about creating a sub account for each custom location. > In general, this could become very large. Your suggestion of using filters > is a good one. I hadn’t thought of it. But, it doesn’t appear that you add > notes to the memo lines of an invoice. I tested adding a note in the invoice > to see if it would appear in the memo line in AR. It doesn’t. The invoice > transaction in the AR is locked so you can not edit the memo lines. > > The ideal solution is a report of taxable sales by tax table. > > Thanks, > Keith > Keith, I also have a small business in Washington State that mails product to the buyers (very small amount of personal sales handed "over the counter"). I built a SQLite3 database to track the individual orders along with the State and Local jurisdiction collected taxes. It is just too complicated to keep track in GnC. For 2020Q1 there are 476 distinct local jurisdictions and 1,185,337 address locators in the states downloadable files. In two cases, the same block-face (same zip + zip-4) has different location codes based on the house number. However, the hosting site (Squarespace) will only apply taxes at the zip code level of which there are 716 different zip codes in the state. Thankfully I don't have "presence" in any other state (yet). Also, thankfully, I can download the orders direct from the web site in CSV format. I only have to manually add the very few OTC sales. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Sales Tax Report
On 1/18/20 6:19 PM, Michael or Penny Novack wrote: > On 1/18/2020 5:25 PM, Keith Fetterman wrote: > >> I need to file an end of year sales tax report to the state showing >> the sales by tax code. I created a tax table for each customer’s >> city and assigned the entries to the customers. . > > > I'm going to ask you a scary question, Keith. How do you KNOW the > customer's city/state for legal purposes? Are you keeping that data? > The PHYSICAL location (city/state) as opposed to the city/state/zip of > the post office that delivers mail to that location. Postal routes do > NOT respect state boundaries. > > Of course you would be in good company with perhaps the majority of > businesses making mistakes with addresses close to state boundaries. > > Michael Just this quarter (starting 1 Jan 2020) the State of Washington added some Idaho zip codes to its list of taxable zip codes. These are for houses in Washington State that get their mail via an Idaho post office. [ Note, Washington State is one of those that tax sales upon the delivered to address. ] -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Sales Tax Report
Adrien, Thanks for the help. In the state of Washington, we need to report the local city/county sales tax for each physical location we do work in. The state assigns a tax code based on address. The business is a very small landscaping business that only does work in a few local locations, so fortunately there are not many tax codes to keep track of. I have created a tax table for each tax code and assigned it to a customer. This works because the physical work locations are the customers’ homes. If work done in a different location, it’s almost always in the same area. I see what you mean about creating a sub account for each custom location. In general, this could become very large. Your suggestion of using filters is a good one. I hadn’t thought of it. But, it doesn’t appear that you add notes to the memo lines of an invoice. I tested adding a note in the invoice to see if it would appear in the memo line in AR. It doesn’t. The invoice transaction in the AR is locked so you can not edit the memo lines. The ideal solution is a report of taxable sales by tax table. Thanks, Keith > -- > > Message: 1 > Date: Sat, 18 Jan 2020 21:53:07 -0600 > From: Adrien Monteleone > To: GnuCash users group > Subject: Re: [GNC] Sales Tax Report > Message-ID: <226840b7-6eb5-4879-b1ff-e32850e5d...@lusfiber.net> > Content-Type: text/plain; charset=utf-8 > > A common method is to post sales tax lines on invoices to a ?sales tax > collected? account or something similar. > > Then when you file the reports and make the payments, you reduce the amount > still unremitted. (some books might then employ a ?sales tax due? account as > an intermediary when filing, then reduce that account when making payments) > > Reporting varies by jurisdiction of course. > > I?m most familiar (in 3 US states) with filing a report of total sales and > total taxable sales, calculating tax due on that amount, and then remitting > it. How much you actually collected is irrelevant. (UNLESS, you collected > more than you were supposed to, in which case, you had to remit what was > actually collected. A business generally can?t ?profit? off of excessive tax > charged, though they are in some locales allowed to deduct a tiny if not > infinitesimal ?vendor compensation? from the remittance) > > So for some jurisdictions at least, all that would be needed is a total > taxable sales report. Comparing that to what was charged to and collected > from customers would otherwise be an internal auditing matter to make sure > you were collecting the right amount so you don?t lose money or run afoul of > the law. > > If you need to break down sales by customer location, that can get real messy > really fast. GnuCash isn?t really set up for it out of the box. > > You might be able to employ a little extra work by putting the filter > criteria in a note or memo. That way you can run a report restricted to > matching that note or memo to aggregate sales. > > As with all such questions, seek the advice of a local CPA before embarking > on a particular bookkeeping method. > > Regards, > Adrien > > ___ 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] Broken QFX import in 3.8
On 1/19/20 12:18 PM, Tom Teixeira wrote: > On 1/19/20 12:06 PM, John Ralls wrote: >>> On Jan 19, 2020, at 5:01 AM, Tom Teixeira wrote: >>> >>> On 1/5/20 8:53 AM, Jon Schewe wrote: I just got version 3.8 using flatpak and it seems that the QFX import is broken. I download my QFX files as usual. Then use the import menu item to load the file. However GnuCash maps to one of my stock accounts rather than the correct bank account. Version 3.7 worked just fine. Has anyone else seen this? Is there a way around it? Jon >>> I also ran into this problem and rolled bacl to Version 3.7 >>> >> It's due to a change in the import matcher to accommodate AQBanking 6 which >> had an unintended affect on both file imports and on accounts with sub >> accounts. https://github.com/Gnucash/gnucash/pull/631 will fix it, we're >> waiting on testing with FinTS to make sure that it doesn't break that. >> >> Regards, >> John Ralls >> > Thanks for the prompt reply. I'll probably just wait for version 3.9 > > I mean to add that knowing the specific version to get will be very helpful for anyone who is building from source. Thanks for the additional level of detail. ___ 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] Broken QFX import in 3.8
On 1/19/20 12:06 PM, John Ralls wrote: > >> On Jan 19, 2020, at 5:01 AM, Tom Teixeira wrote: >> >> On 1/5/20 8:53 AM, Jon Schewe wrote: >>> I just got version 3.8 using flatpak and it seems that the QFX import >>> is broken. I download my QFX files as usual. Then use the import menu >>> item to load the file. However GnuCash maps to one of my stock >>> accounts rather than the correct bank account. Version 3.7 worked just >>> fine. >>> >>> Has anyone else seen this? Is there a way around it? >>> >>> Jon >>> >> I also ran into this problem and rolled bacl to Version 3.7 >> > It's due to a change in the import matcher to accommodate AQBanking 6 which > had an unintended affect on both file imports and on accounts with sub > accounts. https://github.com/Gnucash/gnucash/pull/631 will fix it, we're > waiting on testing with FinTS to make sure that it doesn't break that. > > Regards, > John Ralls > Thanks for the prompt reply. I'll probably just wait for version 3.9 ___ 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] Broken QFX import in 3.8
> On Jan 19, 2020, at 5:01 AM, Tom Teixeira wrote: > > On 1/5/20 8:53 AM, Jon Schewe wrote: >> I just got version 3.8 using flatpak and it seems that the QFX import >> is broken. I download my QFX files as usual. Then use the import menu >> item to load the file. However GnuCash maps to one of my stock >> accounts rather than the correct bank account. Version 3.7 worked just >> fine. >> >> Has anyone else seen this? Is there a way around it? >> >> Jon >> > I also ran into this problem and rolled bacl to Version 3.7 > It's due to a change in the import matcher to accommodate AQBanking 6 which had an unintended affect on both file imports and on accounts with sub accounts. https://github.com/Gnucash/gnucash/pull/631 will fix it, we're waiting on testing with FinTS to make sure that it doesn't break that. Regards, John Ralls ___ 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] Sales Tax Report
On 1/18/2020 10:53 PM, Adrien Monteleone wrote: If you need to break down sales by customer location, that can get real messy really fast. GnuCash isn’t really set up for it out of the box. But you HAVE to do that for mail order or internet sales. Else you don't know whether the items are taxable, at what rate, and what state gets it. My earlier comment is that you may not be collecting/keeping the (correct) state for that location because the post office serving that location might be in a different state << you probably only have the customer's MAILING address, town, zip, state but that will not be the legal state of that location in all cases.>> Like I said, in the same boat as many businesses. I do not recall any vendors with whom I am currently doing business ask for the information "in what state is the location of your mailing address?" In MY case, I know that the state is correct (but the "town" is not, has political and excise tax ramifications but not sales tax. But I know people for whom the state is "incorrect". Mind, I don;t think you are likely to get into trouble over this because "same boat". By contrast, in my working days, where I worked DID collect/keep "legal state" (aka, the contract state ) in addition to "mail state" because it was THAT state's laws that would apply to the insurance contract, not those of the state that delivered the mail. Michael D Novack ___ 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] OFX/qfx Downloads from American Express
On 1/1/20 2:15 PM, David Carlson wrote: > It seems that American Express and Intuit software are colluding on a new > method of downloading ofx/qfx format files from American Express. They > have changed the format so that, according to their website, one needs to > Deactivate Online Banking Services for a Quicken Account, then Reactivate > Online Banking Services for a Quicken Account in order to get a clean > download. Since we do not have Quicken accounts, this will probably fail > for us. It appears that this process will probably spread to all financial > institutions that support qfx downloads via a license with Intuit > software. American Express also supports CSV format, so I am now trying > that method. > > If others have run into this problem and found a solution to make ofx/qfx > work with this new interference, please post your experience here. > > I have noticed that while CSV is short for Comma Separated Values, many CSV > files use a different separator, and some require text to be enclosed with > quotes. Fortunately, the GnuCash CSV importer tolerates these anomalies. > I saw the notice about deactivating/reactivating online banking but assumed that the ofx/qfx has no equivalent to deactivate/reactivate. However, importing the resulting qfx file no longer works. Opening the file with a text editor shows some very different headers, and the file is now pure XML: http://ofx.net/types/2003/04;>0INFOLogin Successful! Compared with older qfx files where the files began: OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:NONE So it looks like both the OFXHEADER and VERSION have changed. I tried looking at some of the source for the OFX library on github and saw that at least some version 2 of OFX is supported, but don't know how to proceed beyond that: I use gnucash binary packages, not compiling my own. One code snippet I saw showed the code does ad hoc parsing and had some special code to allow for an XML element to have attributes. I see the version 202 file has proper closing tags for many elements (such as and ) that are missing in the version 102 file. ___ 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] Broken QFX import in 3.8
On 1/5/20 8:53 AM, Jon Schewe wrote: > I just got version 3.8 using flatpak and it seems that the QFX import > is broken. I download my QFX files as usual. Then use the import menu > item to load the file. However GnuCash maps to one of my stock > accounts rather than the correct bank account. Version 3.7 worked just > fine. > > Has anyone else seen this? Is there a way around it? > > Jon > I also ran into this problem and rolled bacl to Version 3.7 -- Tom ___ 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] 3.8 crash on Ubuntu 18.04
Looking at the report I think that a fix has now been merged, so hopefully it will be fixed in the next release of gtk (or maybe even in the current release). Colin On Sat, 18 Jan 2020, 23:58 Fred Smith, wrote: > On Sat, Jan 18, 2020 at 02:59:09PM -0800, John Ralls wrote: > > > > > > > On Jan 18, 2020, at 1:00 PM, Fred Smith > wrote: > > > > > > Hi all! > > > > > > My wife just switched from Win7 to Ubunt 18.04. she has used GnuCash > for many years and is comfortable with what she uses it for. > > > > > > I built a 3.8 for here when I set up the system, built on that system, > > > and until today it has been working fine (built it about 1.5 weeks > ago). > > > > > > All of a sudden today, when she opens an account and attempts to add a > new entry OR to modify an existing entry she gets an instant crash. > > > > > > Here are some of the pertinent entries from system logs: > > > > > > from syslog: > > > Jan 18 15:29:12 carolyn-ThinkCentre-M72e kernel: [189871.138663] > gnucash[20215]: segfault at f0 ip 7f6d11dca1f2 sp 7ffdbdec1418 > error 4 in libgdk-3.so.0.2200.30[7f6d11d83000+eb000] > > > Jan 18 15:29:12 carolyn-ThinkCentre-M72e kernel: [189871.138675] Code: > fe ff 48 83 c4 40 89 05 dc dc 2a 00 5b 5d 41 5c c3 0f 1f 80 00 00 00 00 48 > 8b 87 f0 00 00 00 c3 0f 1f 84 00 00 00 00 00 31 c0 <48> 39 bf f0 00 00 00 > 0f 94 c0 c3 0f 1f 00 41 55 41 54 55 53 48 89 > > > Jan 18 15:30:37 carolyn-ThinkCentre-M72e kernel: [189956.002039] > gnucash[20549]: segfault at f0 ip 7fa57dbda1f2 sp 7fff21b341c8 > error 4 in libgdk-3.so.0.2200.30[7fa57db93000+eb000] > > > Jan 18 15:30:37 carolyn-ThinkCentre-M72e kernel: [189956.002051] Code: > fe ff 48 83 c4 40 89 05 dc dc 2a 00 5b 5d 41 5c c3 0f 1f 80 00 00 00 00 48 > 8b 87 f0 00 00 00 c3 0f 1f 84 00 00 00 00 00 31 c0 <48> 39 bf f0 00 00 00 > 0f 94 c0 c3 0f 1f 00 41 55 41 54 55 53 48 89 > > > Jan 18 15:31:30 carolyn-ThinkCentre-M72e kernel: [190008.801728] > gnucash[20577]: segfault at f0 ip 7f233fa8a1f2 sp 7fff789f3c28 > error 4 in libgdk-3.so.0.2200.30[7f233fa43000+eb000] > > > Jan 18 15:31:30 carolyn-ThinkCentre-M72e kernel: [190008.801740] Code: > fe ff 48 83 c4 40 89 05 dc dc 2a 00 5b 5d 41 5c c3 0f 1f 80 00 00 00 00 48 > 8b 87 f0 00 00 00 c3 0f 1f 84 00 00 00 00 00 31 c0 <48> 39 bf f0 00 00 00 > 0f 94 c0 c3 0f 1f 00 41 55 41 54 55 53 48 89 > > > > > > from kern.log > > > Jan 18 15:29:12 carolyn-ThinkCentre-M72e kernel: [189871.138663] > gnucash[20215]: segfault at f0 ip 7f6d11dca1f2 sp 7ffdbdec1418 > error 4 in libgdk-3.so.0.2200.30[7f6d11d83000+eb000] > > > Jan 18 15:29:12 carolyn-ThinkCentre-M72e kernel: [189871.138675] Code: > fe ff 48 83 c4 40 89 05 dc dc 2a 00 5b 5d 41 5c c3 0f 1f 80 00 00 00 00 48 > 8b 87 f0 00 00 00 c3 0f 1f 84 00 00 00 00 00 31 c0 <48> 39 bf f0 00 00 00 > 0f 94 c0 c3 0f 1f 00 41 55 41 54 55 53 48 89 > > > Jan 18 15:30:37 carolyn-ThinkCentre-M72e kernel: [189956.002039] > gnucash[20549]: segfault at f0 ip 7fa57dbda1f2 sp 7fff21b341c8 > error 4 in libgdk-3.so.0.2200.30[7fa57db93000+eb000] > > > Jan 18 15:30:37 carolyn-ThinkCentre-M72e kernel: [189956.002051] Code: > fe ff 48 83 c4 40 89 05 dc dc 2a 00 5b 5d 41 5c c3 0f 1f 80 00 00 00 00 48 > 8b 87 f0 00 00 00 c3 0f 1f 84 00 00 00 00 00 31 c0 <48> 39 bf f0 00 00 00 > 0f 94 c0 c3 0f 1f 00 41 55 41 54 55 53 48 89 > > > Jan 18 15:31:30 carolyn-ThinkCentre-M72e kernel: [190008.801728] > gnucash[20577]: segfault at f0 ip 7f233fa8a1f2 sp 7fff789f3c28 > error 4 in libgdk-3.so.0.2200.30[7f233fa43000+eb000] > > > Jan 18 15:31:30 carolyn-ThinkCentre-M72e kernel: [190008.801740] Code: > fe ff 48 83 c4 40 89 05 dc dc 2a 00 5b 5d 41 5c c3 0f 1f 80 00 00 00 00 48 > 8b 87 f0 00 00 00 c3 0f 1f 84 00 00 00 00 00 31 c0 <48> 39 bf f0 00 00 00 > 0f 94 c0 c3 0f 1f 00 41 55 41 54 55 53 48 89h > > > > > > Can anyone help here? > > > > > > Is there any other info I can provide, or other steps I can do to help > > > diagnose this? > > > > > > Thanks in advance! > > > > It's probably https://gitlab.gnome.org/GNOME/gtk/issues/61. If you know > how you can take a stack trace to be sure. The work-around is to set > GTK_IM_MODULE=ibus in the environment. > > > > Regards, > > John Ralls > > John, thanks for the pointer! problem now solved. > > from that page, it looks like it is not a new problem, wondefr if the GTK > maintainers will ever fix it. > > Fred > -- > > --- > .Fred Smith / > ( /__ ,__. __ __ / __ : / > // / /__) / / /__) .+' Home: > fre...@fcshome.stoneham.ma.us > // (__ (___ (__(_ (___ / :__ > 781-438-5471 > Jude 1:24,25 > - > ___ > 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,
[GNC] Finance::Quote on Windows
I am having trouble getting Finance::Quote to work on Windows (GnuCash 3.8;
64-bit Windows 10). I had it working sometime in the last couple of months,
but it has stopped working for some reason.
Specifically: 1) stock prices do not update; 2) in “Price Database” the
“Get Quotes” button is grayed out; 3) in “Security Editor” when I open a
stock it has the error, “Warning: Finance::Quote not installed properly.”
I have run the “Install Online Price Retrieval for GnuCash” utility
(several times), and it always ends with “Installation succeeded” — and no
errors before that.
I'm able to get stock quotes from the command line:
C:\Program Files (x86)\gnucash\bin>echo (alphavantage "AMZN") | perl -w
gnc-fq-helper
(("AMZN" (symbol . "AMZN") (gnc:time-no-zone . "2020-01-17 12:00:00") (last
. #e1864.7200) (currency . "USD")))
The trace files do seem to have a a perl-related warning:
* 12:00:58 WARN Could not spawn perl: Failed to execute
child process (Bad file descriptor)
* 12:00:58 ERROR gnc_process_get_fd: assertion 'proc' failed
* 12:00:58 ERROR gnc_detach_process: assertion 'proc &&
proc->pid' failed
perl is available on the command line, however.
I've googled all of these error messages, and haven't found anything that
seemed relevant. I'd appreciate any pointers about how to move forward.
Thanks,
Adam
___
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.
