Re: [GNC] How to reimport an ofx file?

[jeffrey black]

I'll give it a try. The last time I tried it I was told that all transactions 
had ben imported.

Get Outlook for Android

From: David Carlson 
Sent: Monday, February 19, 2024 11:53:50 PM
To: jeffrey black 
Cc: GnuCash-User@GnuCash.Org 
Subject: Re: [GNC] How to reimport an ofx file?

Jeffrey,

My regular procedure involves intentionally deleting some OFX imported 
transactions after I have replaced them with transactions that have more 
detailed descriptions and I have found that if I re-run an old OFX import file, 
those transactions will import again.  So in your case, I would expect missing 
transactions to re-appear without any special editing of the import files.  
Because I have the room on my backup devices, I never delete old OFX files, I 
just move them to different folders.

On Mon, Feb 19, 2024 at 11:23 PM jeffrey black 
mailto:beastmaster...@hotmail.com>> wrote:
I'm not going into great detail here but I had a surge suppressor  strip 
explode when I turned it off.  It is way out of its warranty period so no help 
there. It fried my server, laptop, printer, 3 external drives, 3 USB Backuo 
drives, and 2 SSD drives ( which i just found out are non-recoverable , 
period).  But thankfully not the drives my GNC datafiles were on.

Anyways, my question to the GNC community is that I imported an account via OFX 
and forgot to reconcile it.  Know I find out that there are several hundred 
transactions that were never imported.

How can I convince  GNC to import the missing transactions via OFX?  And do not 
ask me which version of GNC I was running because I do not remember and cannot 
access that drive.  98% of the time I was running GNC under Ubuntu (I hate  
WindoZe and very seldom use it).

--  Jeffrey  Black, M.B.A.

(Forgive my poor spelling and explanation. These little keyboards on a phone 
are too small for my fumble fingers.  And spell check cannot spelll any better 
than I can.  I'm still trying to setup a new server and a new network.)

-- Jeffrey Black, M.B.A.


Get Outlook for Android
___
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.


--
David Carlson
___
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] How to reimport an ofx file?

[David Carlson]

Jeffrey,

My regular procedure involves intentionally deleting some OFX imported
transactions after I have replaced them with transactions that have more
detailed descriptions and I have found that if I re-run an old OFX import
file, those transactions will import again.  So in your case, I would
expect missing transactions to re-appear without any special editing of the
import files.  Because I have the room on my backup devices, I never delete
old OFX files, I just move them to different folders.

On Mon, Feb 19, 2024 at 11:23 PM jeffrey black 
wrote:

> I'm not going into great detail here but I had a surge suppressor  strip
> explode when I turned it off.  It is way out of its warranty period so no
> help there. It fried my server, laptop, printer, 3 external drives, 3 USB
> Backuo drives, and 2 SSD drives ( which i just found out are
> non-recoverable , period).  But thankfully not the drives my GNC datafiles
> were on.
>
> Anyways, my question to the GNC community is that I imported an account
> via OFX and forgot to reconcile it.  Know I find out that there are several
> hundred transactions that were never imported.
>
> How can I convince  GNC to import the missing transactions via OFX?  And
> do not ask me which version of GNC I was running because I do not remember
> and cannot access that drive.  98% of the time I was running GNC under
> Ubuntu (I hate  WindoZe and very seldom use it).
>
> --  Jeffrey  Black, M.B.A.
>
> (Forgive my poor spelling and explanation. These little keyboards on a
> phone are too small for my fumble fingers.  And spell check cannot spelll
> any better than I can.  I'm still trying to setup a new server and a new
> network.)
>
> -- Jeffrey Black, M.B.A.
>
>
> Get Outlook for Android
> ___
> 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.
>


-- 
David Carlson
___
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] How to reimport an ofx file?

[jeffrey black]

I'm not going into great detail here but I had a surge suppressor  strip 
explode when I turned it off.  It is way out of its warranty period so no help 
there. It fried my server, laptop, printer, 3 external drives, 3 USB Backuo 
drives, and 2 SSD drives ( which i just found out are non-recoverable , 
period).  But thankfully not the drives my GNC datafiles were on.

Anyways, my question to the GNC community is that I imported an account via OFX 
and forgot to reconcile it.  Know I find out that there are several hundred 
transactions that were never imported.

How can I convince  GNC to import the missing transactions via OFX?  And do not 
ask me which version of GNC I was running because I do not remember and cannot 
access that drive.  98% of the time I was running GNC under Ubuntu (I hate  
WindoZe and very seldom use it).

--  Jeffrey  Black, M.B.A.

(Forgive my poor spelling and explanation. These little keyboards on a phone 
are too small for my fumble fingers.  And spell check cannot spelll any better 
than I can.  I'm still trying to setup a new server and a new network.)

-- Jeffrey Black, M.B.A.


Get Outlook for Android
___
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] Problem install Finance::Quote

[Kalpesh Patel]

The gentleman having issues is on newer silicon Mac but Perl's maintenance is 
universal across platforms.

Strawberry Perl is indeed installed when you run 'Install Online Price 
Retrieval for GnuCash' script on Windows...

-Original Message-
From: david amaral  
Sent: Monday, February 19, 2024 2:02 PM
To: Kalpesh Patel 
Cc: GnuCash List 
Subject: Re: [GNC] Problem install Finance::Quote

If you are onWindows platform, I sugguest you download  perl for windows.
https://strawberryperl.com/
It may resolve all your problems as it is compatible dow windows.
It is what I have and there are no issues with gnucash






On Monday, February 19, 2024 at 11:12:06 AM GMT-7, Kalpesh Patel 
 wrote: 





I am on Windows platform but most likely one of two issues likely on the Perl 
front as it seems to be universal across platform:

Since you forced installed LWP::Protocol::https module, it skipped install of 
one or more under lying dependent modules so it is broken at its heart even 
though physically it is present. IMHO, if Perl is configured correctly then 
there is hardly need to force install modules other than in extremely few rare 
cases. This also means your CPAN module for Perl is not likely to be configured 
correctly to retrieve dependent modules and install them as necessary. 

-- OR --

Your GNC install is looking at Perl that is entirely located in a different 
location and it isn't finding all the required modules there.

Former is likely to issue. Also may I ask how you came to conclusion that 
installing OpenSSL via brew package manager will be sufficient on Mac to get 
F::Q up and running? You may want to review documentation at 
https://finance-quote.sourceforge.net/index.html to become familiar. 

While commands you listed might work, I like to use following (not sure how 
they will behave on your system at this point though) after Perl CPAN module is 
properly configured:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e 
'install Test2'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e 
'install Finance::Quote'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e 
'install JSON::Parse'

If things are broken in the process of install then fix them; don't skip them!

As for Perl's CPAN module, normally if the CPAN's 'prerequisites_policy'
setting (configured with 'follow' option), 'build_requires_install_policy'
setting (with 'yes') and 'make' settings (with fully qualified path to a make 
that is found by search or compatible one) are properly set then that should 
have installed all pre-requisite dependencies automatically. These are the sane 
defaults that gets configures with when CPAN module is initialized. In case 
there is interest for the CPAN module configuration settings, refer to 
https://metacpan.org/pod/CPAN#Config-Variables link.

Perl sadly does not have a way to uninstall a module on its own. The unofficial 
way to do is to delete (safer to rename!?!?) the module's Perl files and then 
attempt to install it again.

- Run 'sudo find . -name Quote | xargs ls -al | grep Finance' to find the 
location where it is installed.
- Rename 'Finance' directory under .../lib/perl5/... subtree (with perhaps .bak 
extension).
- Rerun the installer as mentioned above using modified commands.

With the current state of it, YMMV though.

-Original Message-
From: Gustavo Taouil 
Sent: Friday, February 16, 2024 5:34 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Problem install Finance::Quote

Hi Guys, I tried to install Finance::Quote in my new mac (M3) with Sonoma 
macOs. I Use these lines of command to install:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i Test2 sudo 
env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i Finance::Quote 
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i JSON::Parse

Now, I was receiving theses kind of messages when I tried to update quotes:


* B3:IVVB11.SA Finance::Quote reported failure with error: 501 Protocol scheme 
'https' is not supported (LWP::Protocol::https not installed)


I already force the install of LWP::Protocol::https and I installed the opensll 
with the command: brew install openssl, but it's not working.

My perl is installed in /usr/bin/perl and my version is 5.30.3

anyone can help me?






___
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 

Re: [GNC] Problem install Finance::Quote

[david amaral via gnucash-user]

If you are onWindows platform, I sugguest you download  perl for windows.
https://strawberryperl.com/
It may resolve all your problems as it is compatible dow windows.
It is what I have and there are no issues with gnucash






On Monday, February 19, 2024 at 11:12:06 AM GMT-7, Kalpesh Patel 
 wrote: 





I am on Windows platform but most likely one of two issues likely on the
Perl front as it seems to be universal across platform:

Since you forced installed LWP::Protocol::https module, it skipped install
of one or more under lying dependent modules so it is broken at its heart
even though physically it is present. IMHO, if Perl is configured correctly
then there is hardly need to force install modules other than in extremely
few rare cases. This also means your CPAN module for Perl is not likely to
be configured correctly to retrieve dependent modules and install them as
necessary. 

-- OR --

Your GNC install is looking at Perl that is entirely located in a different
location and it isn't finding all the required modules there.

Former is likely to issue. Also may I ask how you came to conclusion that
installing OpenSSL via brew package manager will be sufficient on Mac to get
F::Q up and running? You may want to review documentation at
https://finance-quote.sourceforge.net/index.html to become familiar. 

While commands you listed might work, I like to use following (not sure how
they will behave on your system at this point though) after Perl CPAN module
is properly configured:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install Test2'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install Finance::Quote'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install JSON::Parse'

If things are broken in the process of install then fix them; don't skip
them!

As for Perl's CPAN module, normally if the CPAN's 'prerequisites_policy'
setting (configured with 'follow' option), 'build_requires_install_policy'
setting (with 'yes') and 'make' settings (with fully qualified path to a
make that is found by search or compatible one) are properly set then that
should have installed all pre-requisite dependencies automatically. These
are the sane defaults that gets configures with when CPAN module is
initialized. In case there is interest for the CPAN module configuration
settings, refer to https://metacpan.org/pod/CPAN#Config-Variables link.

Perl sadly does not have a way to uninstall a module on its own. The
unofficial way to do is to delete (safer to rename!?!?) the module's Perl
files and then attempt to install it again.

- Run 'sudo find . -name Quote | xargs ls -al | grep Finance' to find the
location where it is installed.
- Rename 'Finance' directory under .../lib/perl5/... subtree (with perhaps
.bak extension).
- Rerun the installer as mentioned above using modified commands.

With the current state of it, YMMV though.

-Original Message-
From: Gustavo Taouil  
Sent: Friday, February 16, 2024 5:34 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Problem install Finance::Quote

Hi Guys, I tried to install Finance::Quote in my new mac (M3) with Sonoma
macOs. I Use these lines of command to install:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i Test2
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i
Finance::Quote
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i
JSON::Parse

Now, I was receiving theses kind of messages when I tried to update quotes:


* B3:IVVB11.SA Finance::Quote reported failure with error: 501 Protocol
scheme 'https' is not supported (LWP::Protocol::https not installed)


I already force the install of LWP::Protocol::https and I installed the
opensll with the command: brew install openssl, but it's not working.

My perl is installed in /usr/bin/perl and my version is 5.30.3

anyone can help me?






___
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] Problem install Finance::Quote

[Kalpesh Patel]

I am on Windows platform but most likely one of two issues likely on the
Perl front as it seems to be universal across platform:

Since you forced installed LWP::Protocol::https module, it skipped install
of one or more under lying dependent modules so it is broken at its heart
even though physically it is present. IMHO, if Perl is configured correctly
then there is hardly need to force install modules other than in extremely
few rare cases. This also means your CPAN module for Perl is not likely to
be configured correctly to retrieve dependent modules and install them as
necessary. 

-- OR --

Your GNC install is looking at Perl that is entirely located in a different
location and it isn't finding all the required modules there.

Former is likely to issue. Also may I ask how you came to conclusion that
installing OpenSSL via brew package manager will be sufficient on Mac to get
F::Q up and running? You may want to review documentation at
https://finance-quote.sourceforge.net/index.html to become familiar. 

While commands you listed might work, I like to use following (not sure how
they will behave on your system at this point though) after Perl CPAN module
is properly configured:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install Test2'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install Finance::Quote'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install JSON::Parse'

If things are broken in the process of install then fix them; don't skip
them!

As for Perl's CPAN module, normally if the CPAN's 'prerequisites_policy'
setting (configured with 'follow' option), 'build_requires_install_policy'
setting (with 'yes') and 'make' settings (with fully qualified path to a
make that is found by search or compatible one) are properly set then that
should have installed all pre-requisite dependencies automatically. These
are the sane defaults that gets configures with when CPAN module is
initialized. In case there is interest for the CPAN module configuration
settings, refer to https://metacpan.org/pod/CPAN#Config-Variables link.

Perl sadly does not have a way to uninstall a module on its own. The
unofficial way to do is to delete (safer to rename!?!?) the module's Perl
files and then attempt to install it again.

- Run 'sudo find . -name Quote | xargs ls -al | grep Finance' to find the
location where it is installed.
- Rename 'Finance' directory under .../lib/perl5/... subtree (with perhaps
.bak extension).
- Rerun the installer as mentioned above using modified commands.
 
With the current state of it, YMMV though.

-Original Message-
From: Gustavo Taouil  
Sent: Friday, February 16, 2024 5:34 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Problem install Finance::Quote

Hi Guys, I tried to install Finance::Quote in my new mac (M3) with Sonoma
macOs. I Use these lines of command to install:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i Test2
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i
Finance::Quote
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i
JSON::Parse

Now, I was receiving theses kind of messages when I tried to update quotes:


* B3:IVVB11.SA Finance::Quote reported failure with error: 501 Protocol
scheme 'https' is not supported (LWP::Protocol::https not installed)


I already force the install of LWP::Protocol::https and I installed the
opensll with the command: brew install openssl, but it's not working.

My perl is installed in /usr/bin/perl and my version is 5.30.3

anyone can help me?






___
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.