Re: [GNC] Inconsistent MySQL databases

Good point and indeed doing it that way gives consistent sizes. I’ll let the client developer know. > On Mar 1, 2024, at 9:24 AM, Derek Atkins wrote: > > Hi, > > On Fri, March 1, 2024 9:21 am, Ira Fuchs wrote: >> My MySQL client shows tables sizes. > > I would

Re: [GNC] Inconsistent MySQL databases

My MySQL client shows tables sizes. > On Mar 1, 2024, at 9:02 AM, Derek Atkins wrote: > > What queries are you running to compare the two databases? > > -derek > > On Fri, March 1, 2024 8:53 am, Ira Fuchs wrote: >> They are precisely the same. No changes have

Re: [GNC] Inconsistent MySQL databases

On Fri, March 1, 2024 8:30 am, Ira Fuchs wrote: >> I have 2 instances of MySQL to which I save copies of my Gnucash data. I >> have gnucash open with an xml file and I do a save to the first instance >> and then I reopen the XML file and Save again, this time to another MySQL. &

[GNC] Inconsistent MySQL databases

I have 2 instances of MySQL to which I save copies of my Gnucash data. I have gnucash open with an xml file and I do a save to the first instance and then I reopen the XML file and Save again, this time to another MySQL. In both cases the save proceeds normally after warning the file will be

[GNC] Saving to MySQL 8.0.36

I am trying to save my Gbucash data to MySQl v8.0.36 on a newly installed MySQL instance on WIndwos 10. Gnucash is running on a Mac and I also have a MySQL instance on that machine running v .8.0.22. I have no problem saving the gnucash data to the local MySQL instance but when I try to save it

[GNC] Upgraded to v5.2- now can't save

I just upgraded to v5.2 and I can no longer save changes. I get this error: Could not write to file /Users/if/Documents/GnuCash folder/ gnucash_transactions.gnucash.20181105195638.gnucash. 20211205203910.gnucash. Check that you have permission to write to this file and that there is sufficient

Re: [GNC] Stock quotations

t 8:11 PM, John Ralls wrote: > > Please remember to copy the list on all replies. > > What happens if you run gnc-fq-update like the message suggests? > > Regards, > John Ralls > >> On Nov 17, 2022, at 4:22 PM, Ira Fuchs wrote: >> >> Thanks but: >

[GNC] Stock quotations

I am trying to get quotes to work on Gnucash 4.2.1 on a Mac running Mojave. Gnucash says that Finance::Quote is not installed properly. However, this is what I get in terminal: cpan[1]> install Finance::Quote Reading '/var/root/.cpan/Metadata' Database was generated on Thu, 17 Nov 2022

Re: [Sikuli-driver] [Question #700736]: Cannot save scripts using IDE on Mac

Question #700736 on SikuliX changed: https://answers.launchpad.net/sikuli/+question/700736 Status: Answered => Solved Ira Fuchs confirmed that the question is solved: Thanks RaiMan, that solved my question. -- You received this question notification because your team Sikuli Driv

Re: [Sikuli-driver] [Question #700736]: Cannot save scripts using IDE on Mac

Question #700736 on SikuliX changed: https://answers.launchpad.net/sikuli/+question/700736 Ira Fuchs posted a new comment: Right,so -v 1.8. -- You received this question notification because your team Sikuli Drivers is an answer contact for SikuliX

Re: [Sikuli-driver] [Question #700736]: Cannot save scripts using IDE on Mac

Question #700736 on SikuliX changed: https://answers.launchpad.net/sikuli/+question/700736 Ira Fuchs posted a new comment: I am not clear on what I need to specify to get the right version of Java. This is what I seem to ahve installed: $ /usr/libexec/java_home -V Matching Java Virtual Machines

Re: [Sikuli-driver] [Question #700736]: Cannot save scripts using IDE on Mac

Question #700736 on SikuliX changed: https://answers.launchpad.net/sikuli/+question/700736 Ira Fuchs posted a new comment: $ /usr/libexec/java_home -V Matching Java Virtual Machines (6): 17.0.2, x86_64: "Java SE 17.0.2" /Library/Java/JavaVirtualMachines/jdk-17.0.2.jd

Re: [Sikuli-driver] [Question #700736]: Cannot save scripts using IDE on Mac

Question #700736 on SikuliX changed: https://answers.launchpad.net/sikuli/+question/700736 Ira Fuchs posted a new comment: I just tried launching it using the Java Launcher app and it seems to work correctly. I surmise that the problem is that I am not getting the same version of java

Re: [Sikuli-driver] [Question #700736]: Cannot save scripts using IDE on Mac

Question #700736 on SikuliX changed: https://answers.launchpad.net/sikuli/+question/700736 Ira Fuchs posted a new comment: When I run sikuli from terminal, it says it is running under Java 13. Is that what it should say? -- You received this question notification because your team Sikuli

Re: [Sikuli-driver] [Question #700736]: Cannot save scripts using IDE on Mac

Question #700736 on SikuliX changed: https://answers.launchpad.net/sikuli/+question/700736 Ira Fuchs posted a new comment: I installed the latest Java SDK but I don't think that is what I am seeing when I run sikuli from the CLI. %java --version openjdk 13.0.2 2020-01-14 OpenJDK Runtime

Re: [Sikuli-driver] [Question #700736]: Cannot save scripts using IDE on Mac

Question #700736 on SikuliX changed: https://answers.launchpad.net/sikuli/+question/700736 Status: Needs information => Open Ira Fuchs gave more information on the question: I am running sikulixide-2.0.5-mac.jar > On Feb 25, 2022, at 10:31 AM, RaiMan > wrote: > > Your q

[Sikuli-driver] [Question #700736]: Cannot save scripts using IDE on Mac

New question #700736 on SikuliX: https://answers.launchpad.net/sikuli/+question/700736 I am running the sikuli IDE jar from terminal.app on MacOS v10.14.6. It runs but every time I go to run a script, the dialog to save the script comes up but it does not save it. Also, the dialog to save comes

[GNC] Support message:// for transaction associations

I am running Gnucash for under MacOS mojave. On MacOS it is possible to get a URL that takes you to a mail message(in mail.app). The URL is of the form . If I enter this URL as the location for an association and then try to go to it in gnucash, I get the error message that the file cannot

[GNC] opening accounts bug

When in the Accounts tab, if I type any of the letters in an account name, the first matching account is highlighted. In order to open this account, it used to be possible to merely hit Return. It is now necessary to double-click TWICE (4 clicks) to open the account. It would be very nice if it

Re: [GNC] Saving to MySQL

ote: > > Hi, > > On Thu, December 10, 2020 9:27 am, Ira Fuchs wrote: >> (Found mysql in /usr/local/mysql/bin) >> I can get to the mysql prompt but how to get Gnucash to be able to save? >> > > Is the server running? > Can you actually get to the server vi

Re: [GNC] Saving to MySQL

gt; Peter West > p...@pbw.id.au <mailto:p...@pbw.id.au> > “Behold, I am the servant of the Lord; let it be to me according to your > word.” > >> On 10 Dec 2020, at 4:47 am, Ira Fuchs > <mailto:irafu...@gmail.com>> wrote: >> >> I have installed MySQL

[GNC] Saving to MySQL

I have installed MySQL 8.0.22 on a Mac running Mojave (v10.14.6) with no changes to any configuration file. I would like to save my GnuCash file to this server but I am getting an error: The server at URL mysql://root@localhost/gnucash experienced an error or encountered bad or corrupt data.

[GNC] Version 4.0 on Mac High Sierra

I may be misreading the Changes but I am unable to see the new type-ahead search when selecting an account. If I type a few letters of the account name, I see the letters typed in the bottom right corner and the first account with those letters is selected. If I use the down arrow I will get

[sqlalchemy] No handlers could be found for logger "sqlalchemy.pool.impl.QueuePool"

Getting the message “ No handlers could be found for logger "sqlalchemy.pool.impl.QueuePool" when I run this script to read from a MSSQL dB The code runs fine and delivers the data, but produces this error. from sqlalchemy import * import pytds import sqlalchemy_pytds engine =

Re: [sqlalchemy] Re: Translating sql query to sqlalchemy

REATE TABLE civicrm_address' should provide you with > enough detail to work out what is going on. > > On Monday, 26 August 2019 10:57:14 UTC+10, Ira Fuchs wrote: >> >> Until I can get a new version of the server installed, I decided to try >> running this scipt on m

Re: [sqlalchemy] Re: Translating sql query to sqlalchemy

on \nWHERE civicrm_contribution.receive_date > %(receive_date_1)s AND civicrm_contribution.contact_id = civicrm_contact.id AND civicrm_contact.id = civicrm_entity_tag.entity_id AND civicrm_entity_tag.tag_id = %(tag_id_2)s)'] [parameters: {u'receive_date_1': datetime.date(2005, 7, 1), u'tag_id_1':

Re: [sqlalchemy] Re: Translating sql query to sqlalchemy

-character-set-utf8mb4 > > <https://stackoverflow.com/questions/21911733/error-1115-42000-unknown-character-set-utf8mb4>. > > On Friday, 23 August 2019 11:05:14 UTC+10, Ira Fuchs wrote: > OK, I made a few changes/corrections to the Class definitions: > > class Contac

[sqlalchemy] Re: Translating sql query to sqlalchemy

OK, I made a few changes/corrections to the Class definitions: class Contact(Base): __tablename__ = "civicrm_contact" id = Column(Integer, primary_key=True) first_name = Column(String(64, u'utf8_unicode_ci'), index=True) middle_name = Column(String(64, u'utf8_unicode_ci'))

[sqlalchemy] Re: Translating sql query to sqlalchemy

-01\' and contact_id = c.id and c.id = entity_id and tag_id = 6 )') This was working fine. (It is just my way of making sure I am connected to db and able to retrieve data (the old way). On Thursday, August 22, 2019 at 6:56:56 PM UTC-4, Ira Fuchs wrote: > > Weird. When I go back to just running the

[sqlalchemy] Re: Translating sql query to sqlalchemy

Weird. When I go back to jsut running the SQL query, I now get: InternalError: (pymysql.err.InternalError) (1115, "Unknown character set: 'utf8mb4'") (Background on this error at: http://sqlalche.me/e/2j85) I seem to be regressing. On Thursday, August 22, 2019 at 6:53:46 PM UTC-4,

[sqlalchemy] Re: Translating sql query to sqlalchemy

tact_id = Column(ForeignKey(u'civicrm_contact.id'), ondelete=u'CASCADE', > nullable=False, index=True) > > Should be this: > > contact_id = Column(ForeignKey(u'civicrm_contact.id', ondelete=u'CASCADE') > , nullable=False, index=True) > > > On Friday, 23 August 2019 05:1

[sqlalchemy] Re: Translating sql query to sqlalchemy

gt;> FROM civicrm_contribution >> WHERE civicrm_contribution.receive_date > %(receive_date_1)s AND >> civicrm_contribution.contact_id = civicrm_contact.id AND civicrm_contact.id >> = civicrm_entity_tag.entity_id AND civicrm_entity_tag.tag_id = %(tag_id_2 >> )s) >&

[sqlalchemy] Re: Translating sql query to sqlalchemy

, 2019 at 6:58:03 PM UTC-4, Ira Fuchs wrote: > > Just an aside: I discovered the sqlacodegen tool which will create the > sqlalchemy class definitions automatically. I ran it against the civicrm > mysql db and it worked. The definitions comprise 5881 lines (428KB). > Fortunately I

[sqlalchemy] Re: Translating sql query to sqlalchemy

at 6:15:46 PM UTC-4, Ira Fuchs wrote: > > I think I may have all the definitions: > > class Contact(Base): > __tablename__ = "civicrm_contact" > id = Column(Integer, primary_key=True) > last_name = Column(String(20), nullable=False) > first_name =

[sqlalchemy] Re: Translating sql query to sqlalchemy

tag_id = Column(Integer, nullable=False) Now, how to create the equivalent SQL query? I presume that this front-end overhead will pay back when I write more interesting scripts that use data from Civicrm. If this works then I can map the remainder of the (many) tables. On Tuesday, August 20, 2019

[sqlalchemy] Re: Translating sql query to sqlalchemy

rm_contribution" id = Column(Integer, primary_key=True) contact_id = Column(Integer, nullable=False) receive_date = Column(DateTime,nullable=False) total_amount = Column(DECIMAL(precision=20,scale=2), nullable=False) On Tuesday, August 20, 2019 at 3:59:55 PM UTC-4, Ira Fuchs wrote:

[sqlalchemy] Re: Translating sql query to sqlalchemy

e,nullable=False) total_amount = Column(Decimal(20), nullable=False) On Tuesday, August 20, 2019 at 3:59:55 PM UTC-4, Ira Fuchs wrote: > > OK, I made some progress (see screenshot). I don't need the full model to > be represented as I will not need many of the columns in each of the &

[sqlalchemy] Re: Translating sql query to sqlalchemy

eclarative base > class (maps db table to python class) and a Session instance (for using a > connection to issue queries). Do you have any familiarity with those > concepts? > > > On Monday, 19 August 2019 02:34:05 UTC+10, Ira Fuchs wrote: >> >> I am new

[sqlalchemy] Translating sql query to sqlalchemy

I am new to sqlalchemy and I would like to begin using it to create scripts with some sql queries that I have been using but need to change from time to time. It would help a lot if someone could translate one of these queries to python sqlalchemy using an ORM (not simply executing the query

Re: eBay no longer searchable with trigger

had to change the URL in 2 places. it now seems to work. > On Jan 13, 2017, at 9:18 AM, Rob McBroom wrote: > > On 13 Jan 2017, at 7:33, ihf wrote: > >> I'm not sure exactly when they changed, but eBay no longer supports >> wildcards ('*") in their searches. As a result

Re: eBay no longer searchable with trigger

Thanks. I tried that but It worked once when I replaced a seasrch word with *** but not again.. It appears that the URL contains more information that may be preventing it. Can you get it to work? > On Jan 13, 2017, at 9:18 AM, Rob McBroom wrote: > > On 13 Jan 2017,

[k-9-mail] Delete on Pebble

Is there a way to get a Delete option to appear for Pebble notifications? I tried disabling 'Global settings > Interaction > Confirm actions > Delete (from notification)' which someone said would help but it was to no avail. Is this doable? (I know I can run another app K9email but would prefer

[web2py] Web2py using IOS Safari

Can anyone please tell me why IOS Safari (on iPad) cannot display the Web2py admin page correctly? In particular the window on the right side of the page is not rendered. Atomic Web (another IOS browser) works but I would like to be able to use Safari. Is there a workaround? -- Resources: -

[web2py] web2py with Mobile Safari

Safari on the iPad apparently sends a mobile useragent string which web2py uses to tailor the UI. As a result I do not see a way to get, for example, the form on the admin screen (the one that you can use to start a new app). Is there a way to get to this form on the mobile UI? Better yet, is

[web2py] Web2py on iPad using Pythonista

I am trying to get web2py working on an iPad running Pythonista. It works fine although there is no Tk library so everything must be done in the console or the web interface. The problem with using the web interface is that if you leave Pythonista and thereby make it a background process in

[k-9-mail] Notifications on the Pebble

I am running Android 4.4 and using a Pebble watch. If I get an email, the notification on the phone and watch shows the sendersubjectportion of msg body. However, if there are other unread messages then the notification changes to N new messages name of sendersubject with no msg body. Is there

[sage-support] Remote browser access

NOOB question: I know that by default the notebook server only listens at localhost but how do I start it so that I can access it from other addresses? I am running the Sage app on OSX. -- You received this message because you are subscribed to the Google Groups sage-support group. To

[sage-support] Re: Remote browser access

I figured it out. I need to use the command line interface to say notebook(interface=''). On Tuesday, April 1, 2014 8:59:45 PM UTC-4, Ira Fuchs wrote: NOOB question: I know that by default the notebook server only listens at localhost but how do I start it so that I can access it from other

[R] Installing quantstrat

I would like to try to run the quantstrat package (located here: https://r-forge.r-project.org/R/?group_id=316). However, if I try to load quantstrat, I get a warning that it is not available for R v3.0.1, so perhaps that is the end of it. Does anyone know if it is possible to run quantstrat

Re: [R] Installing quantstrat

:34 AM, Ira Fuchs irafu...@gmail.com wrote: I would like to try to run the quantstrat package (located here: https://r-forge.r-project.org/R/?group_id=316). However, if I try to load quantstrat, I get a warning that it is not available for R v3.0.1, so perhaps that is the end of it. Does

Re: [R] Installing quantstrat

Thanks for your help! I got quantstrat working after building it along with the FinancialInstrument and blotter packages (as well as foreach). Ira On Nov 26, 2013, at 12:59 PM, Joshua Ulrich wrote: On Tue, Nov 26, 2013 at 11:55 AM, Ira Fuchs irafu...@gmail.com wrote: Thanks. Since

[R] Sending a matrix in an email

I have a matrix which has colnames and I would like to send this matrix using sendmailR. How can I convert this simple matrix to a format which can be used as the body variable in sendmailR? I see how I can create a file attachment using mime_part but I would like to send the matrix in the body

Re: [R] Sending a matrix in an email

) structure(c(1, 2, 3), .Dim = c(1L, 3L), .Dimnames = list(NULL, c(a, b, c))) I want to send x in sendmailR(to,from,x) and have it look more or less like the output above. Simple, right? On Nov 18, 2013, at 9:13 AM, Sarah Goslee wrote: What about dput()? On Mon, Nov 18, 2013 at 8:35 AM, Ira

Re: [R] Sending a matrix in an email

That's the ticket! So many functions…so little time. Thanks to everyone. On Nov 18, 2013, at 9:47 AM, David Winsemius wrote: On Nov 18, 2013, at 8:30 AM, Ira Fuchs wrote: Thanks for the suggestion. I just tried dput and it did not produce what sendmailR requires for the body parameter

Re: [R] Sending a matrix in an email

Research Engineer (Solar/BatteriesO.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --- Sent from my phone. Please excuse my brevity. Ira Fuchs irafu

Re: [R] Sending a matrix in an email

#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --- Sent from my phone. Please excuse my brevity. Ira Fuchs irafu...@gmail.com wrote: I thought that I had provided an example of what

[R] Sending a matrix in an email

I have a matrix which has colnames and I would like to send this matrix using sendmailR. How can I convert this simple matrix to a format which can be used as the body variable in sendmailR? I see how I can create a file attachment using mime_part but I would like to send the matrix in the body

[Jprogramming] insert item

This is very helpful. Thanks to all who replied. The ins, ins1 and insert verbs do what I wanted (and more)..now if only I could decipher how they work :-) -- For information about J forums see

[Jprogramming] updated versions of WS.ijs and logger.ijs?

I reset Parameters to permit x. and y. as suggested. Now I get: load '/Users/ihf/Desktop/logger.ijs' logMsg_logger_ 'Show this text ' |domain error: getTempPath | td=.2{getTempPath 256;256$' ' -- For information

Re: [Jprogramming] updated versions of WS.ijs and logger.ijs?

That would explain it. I was hoping to use these scripts on a Mac. I didn't realize they were platform-dependent. On Jul 9, 2007, at 8:02 PM, Devon McCormick wrote: Is getTempPath defined? It's a Windows-only API definition. On 7/9/07, Ira Fuchs [EMAIL PROTECTED] wrote: I reset

Re: [Jprogramming] updated versions of WS.ijs and logger.ijs?

:[EMAIL PROTECTED] On Behalf Of Ira Fuchs That would explain it. I was hoping to use these scripts on a Mac. I didn't realize they were platform-dependent. I'm pretty sure the only bit that is platform-dependent it the setting of the tempdir (in verb todayfile). If you manually set the global