Re: [GNC] Report filter Syntax
Hi Grace You can find a a particular transaction in an account using either the Transaction Report or the Find Transaction facility (Edit / Find) from within the account's register. Both methods support "regular expressions" which extend the capabilities of the Filters beyond a mere "find this text" search. GnuCash supports what are known as POSIX Regular Expressions, and you can read all about them here: https://www.ibm.com/docs/en/watson-explorer/12.0.x?topic=queries-posix-regular-expression-syntax-examples Note, regular expressions are cAsE sensitive. Hope this helps. Regards Geoff = On 1/03/2024 5:08 am, Grace wrote: Hi, Can anyone point me in the direction of the syntax for the report filters. I need to select particular transaction from an account, and I don't see any guidance in the help. A google search didn't get me anywhere either. Thanks, Grace ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Saving to MySQL 8.0.36
Ira, there's not enough information in what you have posted to assist in getting your problem solved. What does "Saving to Windows on local network does not work" mean? What actually happens? What error message is generated? Is there one MySQL database or two? If there is one, on which machine is it: the Mac, the Windows machine, or something else? As far as I can tell, there are no current problems involving both GnuCash 5.1 and MySQL. At a guess, there's a library missing, or the link is not specified correctly. On 2024-02-29 14:40, Tommy Trussell wrote: Hi -- you replied to me yesterday but I don't know if version 5.1 is significant so I am copying the list. Be sure to use REPLY ALL or CC the list on all your replies. You might also try saving as sqlite because I know that database format is used by more folks (though I don't use it). On Wed, Feb 28, 2024 at 9:14 PM Ira Fuchs wrote: Software came from gnucash.org and is Version: 5.1 Build ID: 5.1+(2023-04-30) To reiterate, saving to MySQl instnace on the MAc (same machien running Gnucash) works fine. Saving to Windows on local network does not work. On Feb 28, 2024, at 9:28 PM, Tommy Trussell wrote: On Wed, Feb 28, 2024 at 8:02 PM Ira Fuchs wrote: 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 to the WIndows instance, I get a non-specific error. My MySQL client can login from the Mac to the Sinwows instance without problem so I know that I have both connectivity and the correct userid/passwd. Can anyone please help me to diagnose why gnucash will not save to the Windows instance. I also tried creating a user entry for the same userid but specifying the Mac ip and Standard authentication. This also failed to work. What am I missing? What versions of GnuCash on the Mac and on Windows? And (if relevant) did you download the software from anyplace other than gnucash.org ? (please reply to the list as I know nothing about either the Windows or Mac versions) - 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 - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Saving to MySQL 8.0.36
Hi -- you replied to me yesterday but I don't know if version 5.1 is significant so I am copying the list. Be sure to use REPLY ALL or CC the list on all your replies. You might also try saving as sqlite because I know that database format is used by more folks (though I don't use it). On Wed, Feb 28, 2024 at 9:14 PM Ira Fuchs wrote: > Software came from gnucash.org and is Version: 5.1 > Build ID: 5.1+(2023-04-30) > > To reiterate, saving to MySQl instnace on the MAc (same machien running > Gnucash) works fine. Saving to Windows on local network does not work. > > On Feb 28, 2024, at 9:28 PM, Tommy Trussell > wrote: > > On Wed, Feb 28, 2024 at 8:02 PM Ira Fuchs wrote: > >> 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 to >> the WIndows instance, I get a non-specific error. My MySQL client can login >> from the Mac to the Sinwows instance without problem so I know that I have >> both connectivity and the correct userid/passwd. >> Can anyone please help me to diagnose why gnucash will not save to the >> Windows instance. I also tried creating a user entry for the same userid >> but specifying the Mac ip and Standard authentication. This also failed to >> work. What am I missing? >> > > What versions of GnuCash on the Mac and on Windows? And (if relevant) did > you download the software from anyplace other than gnucash.org ? > > (please reply to the list as I know nothing about either the Windows or > Mac versions) > > >> - >> 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Saving to MySQL 8.0.36
Wild guess but could it be your MAC's and/or Windows host firewall settings? Sinwows? Wow, you really hate Windoz$ that much but yet run MySQL on it which was born on Linux... -Original Message- From: Ira Fuchs Sent: Wednesday, February 28, 2024 9:01 PM To: Gnucash Subject: [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 to the WIndows instance, I get a non-specific error. My MySQL client can login from the Mac to the Sinwows instance without problem so I know that I have both connectivity and the correct userid/passwd. Can anyone please help me to diagnose why gnucash will not save to the Windows instance. I also tried creating a user entry for the same userid but specifying the Mac ip and Standard authentication. This also failed to work. What am I missing? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Report filter Syntax
Hi, Can anyone point me in the direction of the syntax for the report filters. I need to select particular transaction from an account, and I don't see any guidance in the help. A google search didn't get me anywhere either. Thanks, Grace -- This email has been checked for viruses by Avast antivirus software. www.avast.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.