Re: [GNC] Postgress connection string for nonstandard port

2023-02-23 Thread Geert Janssens 
From what I read in the code you should be able to pass a custom port by adding 
it in the 
hostname field, like so:

yourserver.xyz:6543

Regards,

Geert

Op donderdag 23 februari 2023 07:26:09 CET schreef Peter West:
> Are you on Windows, Mac or linux? How do you invoke GnuCash? There will be
> some sort of environment in which the invocation occurs from your end.
> 
> —
> Peter West
> p...@pbw.id.au
> “Blessed are the peacemakers, for they shall be called sons of God.”
> 
> > On 23 Feb 2023, at 2:13 am, Bob Treumann  wrote:
> > 
> > 
> > 
> > I could set it since I control the server, but I don't know where I would
> > set it so that it would take effect before the connection attempt is
> > made.
> > 
> > On Tue, Feb 21, 2023 at 10:53 PM Peter West  > > wrote: Is it possible for you to set the PGPORT
> > environment variable?
> > 
> > 
> > —
> > Peter West
> > p...@pbw.id.au 
> > “Blessed are the peacemakers, for they shall be called sons of God.”
> > 
> >> On 22 Feb 2023, at 11:01 am, Peter West  >> > wrote:
> >> 
> >> I’m using the default port, so I can’t help there.
> >> 
> >> “Database” refers to the database, in my case, gnucash.
> >> 
> >> 
> >> —
> >> Peter West
> >> p...@pbw.id.au 
> >> “Blessed are the pure in heart, for they shall see God.”
> >> 
> >>> On 22 Feb 2023, at 8:07 am, Bob Treumann  >>> > wrote:
> >>> 
> >>> I am running PG on an amazon server on a non standard port (6543).
> >>> 
> >>> The connection setup on gnucash does not have a filed to input the port.
> >>> I added the port to the end of the hostname, a style that has worked
> >>> with
> >>> other applications.
> >>> 
> >>> There is a field to enter the "database", which in PG contains multiple
> >>> schemas.
> >>> The user is typically connected to a schema by a default path.
> >>> 
> >>> My questions are:
> >>> How do I define the port?
> >>> Does "Database" refer to "Schema"?
> >>> 
> >>> I would try every combination but the interface only gives me one
> >>> chance.
> >>> It gives a "cannot connect" message then closes.
> >>> 
> >>> 
___
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] Postgress connection string for nonstandard port

2023-02-23 Thread Peter West 
The OP said that that was not working (see his attached image.)


—
Peter West
p...@pbw.id.au
“Blessed are the peacemakers, for they shall be called sons of God.”

> On 23 Feb 2023, at 6:30 pm, Geert Janssens  wrote:
> 
> From what I read in the code you should be able to pass a custom port by 
> adding it in the hostname field, like so:
> 
> yourserver.xyz:6543
> 
> Regards,
> 
> Geert
> 
> Op donderdag 23 februari 2023 07:26:09 CET schreef Peter West:
> > Are you on Windows, Mac or linux? How do you invoke GnuCash? There will be
> > some sort of environment in which the invocation occurs from your end.
> >
> > —
> > Peter West
> > p...@pbw.id.au
> > “Blessed are the peacemakers, for they shall be called sons of God.”
> >
> > > On 23 Feb 2023, at 2:13 am, Bob Treumann  wrote:
> > >
> > >
> > >
> > > I could set it since I control the server, but I don't know where I would
> > > set it so that it would take effect before the connection attempt is
> > > made.
> > >
> > > On Tue, Feb 21, 2023 at 10:53 PM Peter West  > > > wrote: Is it possible for you to set the PGPORT
> > > environment variable?
> > >
> > >
> > > —
> > > Peter West
> > > p...@pbw.id.au 
> > > “Blessed are the peacemakers, for they shall be called sons of God.”
> > >
> > >> On 22 Feb 2023, at 11:01 am, Peter West  > >> > wrote:
> > >>
> > >> I’m using the default port, so I can’t help there.
> > >>
> > >> “Database” refers to the database, in my case, gnucash.
> > >>
> > >>
> > >> —
> > >> Peter West
> > >> p...@pbw.id.au 
> > >> “Blessed are the pure in heart, for they shall see God.”
> > >>
> > >>> On 22 Feb 2023, at 8:07 am, Bob Treumann  > >>> > wrote:
> > >>>
> > >>> I am running PG on an amazon server on a non standard port (6543).
> > >>>
> > >>> The connection setup on gnucash does not have a filed to input the port.
> > >>> I added the port to the end of the hostname, a style that has worked
> > >>> with
> > >>> other applications.
> > >>>
> > >>> There is a field to enter the "database", which in PG contains multiple
> > >>> schemas.
> > >>> The user is typically connected to a schema by a default path.
> > >>>
> > >>> My questions are:
> > >>> How do I define the port?
> > >>> Does "Database" refer to "Schema"?
> > >>>
> > >>> I would try every combination but the interface only gives me one
> > >>> chance.
> > >>> It gives a "cannot connect" message then closes.
> > >>>
> > >>>
> > >>> [image: image.png]
> > >>> ___
> > >>> 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.
> >
> > ___
> > 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] Using Plaid

2023-02-23 Thread Tom Browder 
On Wed, Feb 22, 2023 at 16:02 Ben Pracht  wrote:

> I'd like to use Plaid with GnuCash. There is a plaid2qif project that


How are you able to use Plaid at all? What service do you have access to
that provides access to your personal finances? Or are you using it for a
business?

YNAB is the closest thing I've found for personal use that allows
programmatic access to most any bank or other financial institution.

Thanks.

-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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Using Plaid

2023-02-23 Thread William Prescott 
After reading this discussion about Plaid, I discovered an email from my bank 
from about 6 months ago notifying me that Plaid had access to my bank account. 
I am not aware that I am using Plaid for anything. Is it used in the background 
by Bank Mobil Apps? That is the only thing I can think of that might be why I 
gave it access.

Thanks,
Will
___
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] Using Plaid

2023-02-23 Thread Ben Pracht 
Some financial services such as brokerages now use Plaid. Stash is one 
example. The reason is OFX isn't supported well by banks anymore. I 
tried adding Chase bank, but I had to reference 3 parts of the same 
document, but still couldn't get it to connect. Same situation with 
Truist. With my version of GnuCash/AqBanking, the list of banks to 
select doesn't populate anymore, so I have to manually enter everything 
and hope to get it right, and almost never do.



On 2/23/23 10:11, William Prescott wrote:

After reading this discussion about Plaid, I discovered an email from my bank 
from about 6 months ago notifying me that Plaid had access to my bank account. 
I am not aware that I am using Plaid for anything. Is it used in the background 
by Bank Mobil Apps? That is the only thing I can think of that might be why I 
gave it access.

Thanks,
Will
___
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] Postgress connection string for nonstandard port

2023-02-23 Thread Bob Treumann 
Thanks for all the feedback.   I will share my learnings;

The database must be created before you connect to it.The install
process creates all the tables in the Public schema in that database once
it connects successfully.

Geert Janssens referenced the code where he could tell that the appended
port should work.
Geert, can you tell me where to find that? I would like to see if I can
modify it to connect to my chosen database and schema rather than using the
public schema in a dedicated database.

I mentioned in another post that Postgress creates multiple schemas in a
single database.That is my preferred way of operating because I can
read and write to other schemas without connecting across databases.I'm
not even sure if PG supports cross database connections.

Thanks for everyones help!


On Thu, Feb 23, 2023 at 2:36 AM Peter West  wrote:

> The OP said that that was not working (see his attached image.)
>
>
> —
> Peter West
> p...@pbw.id.au
> “Blessed are the peacemakers, for they shall be called sons of God.”
>
> On 23 Feb 2023, at 6:30 pm, Geert Janssens 
> wrote:
>
> From what I read in the code you should be able to pass a custom port by
> adding it in the hostname field, like so:
>
> yourserver.xyz:6543
>
> Regards,
>
> Geert
>
> Op donderdag 23 februari 2023 07:26:09 CET schreef Peter West:
> > Are you on Windows, Mac or linux? How do you invoke GnuCash? There will
> be
> > some sort of environment in which the invocation occurs from your end.
> >
> > —
> > Peter West
> > p...@pbw.id.au
> > “Blessed are the peacemakers, for they shall be called sons of God.”
> >
> > > On 23 Feb 2023, at 2:13 am, Bob Treumann  wrote:
> > >
> > >
> > >
> > > I could set it since I control the server, but I don't know where I
> would
> > > set it so that it would take effect before the connection attempt is
> > > made.
> > >
> > > On Tue, Feb 21, 2023 at 10:53 PM Peter West  > > > wrote: Is it possible for you
> to set the PGPORT
> > > environment variable?
> > >
> > >
> > > —
> > > Peter West
> > > p...@pbw.id.au 
> > > “Blessed are the peacemakers, for they shall be called sons of God.”
> > >
> > >> On 22 Feb 2023, at 11:01 am, Peter West  > >> > wrote:
> > >>
> > >> I’m using the default port, so I can’t help there.
> > >>
> > >> “Database” refers to the database, in my case, gnucash.
> > >>
> > >>
> > >> —
> > >> Peter West
> > >> p...@pbw.id.au 
> > >> “Blessed are the pure in heart, for they shall see God.”
> > >>
> > >>> On 22 Feb 2023, at 8:07 am, Bob Treumann  > >>> > wrote:
> > >>>
> > >>> I am running PG on an amazon server on a non standard port (6543).
> > >>>
> > >>> The connection setup on gnucash does not have a filed to input the
> port.
> > >>> I added the port to the end of the hostname, a style that has worked
> > >>> with
> > >>> other applications.
> > >>>
> > >>> There is a field to enter the "database", which in PG contains
> multiple
> > >>> schemas.
> > >>> The user is typically connected to a schema by a default path.
> > >>>
> > >>> My questions are:
> > >>> How do I define the port?
> > >>> Does "Database" refer to "Schema"?
> > >>>
> > >>> I would try every combination but the interface only gives me one
> > >>> chance.
> > >>> It gives a "cannot connect" message then closes.
> > >>>
> > >>>
> > >>> [image: image.png]
> > >>> ___
> > >>> 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.
> >
> > ___
> > 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
-
P