Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

HYPTUSS runtime error

Discussions regarding financial software
Fluke
Lemon Slice
Posts: 609
Joined: November 4th, 2016, 8:51 pm
Has thanked: 61 times
Been thanked: 137 times

HYPTUSS runtime error

#519050

Postby Fluke » August 2nd, 2022, 10:06 am

Could be me but I'm getting the following message when trying to update the company data sheet using the update button on the libra version. I'm currently using b-p but checked on the latest version too and still getting the error.

You probably just haven't got round to it yet but just so you're aware, b-s doesn't have the latest version of company data eg it's missing Haleon, which is why I was trying to update it.


com.sun.star.uno.RuntimeException: Error during invoking function importDataSheet in module vnd.sun.star.tdoc:/3/Scripts/python/HypTopUp.py (<class 'UnicodeDecodeError'>: 'ascii' codec can't decode byte 0xae in position 2925: ordinal not in range(128)
File "/Applications/LibreOffice.app/Contents/Resources/pythonscript.py", line 915, in invoke
ret = self.func( *args )
File "vnd.sun.star.tdoc:/3/Scripts/python/HypTopUp.py", line 7326, in importDataSheet
File "/Applications/LibreOffice.app/Contents/Resources/../Resources/../Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.8/encodings/ascii.py", line 26, in decode
return codecs.ascii_decode(input, self.errors)[0]
)

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: HYPTUSS runtime error

#519061

Postby kiloran » August 2nd, 2022, 10:20 am

It works fine for me, Fluke. Imports the new data in the blink of an eye.

From the error message, I get the feeling that maybe the file is not a plain text file. Go to http://lemonfoolfinancialsoftware.weebl ... op-up.html and click on the company_data_sheet.txt link. This probably opens the text file in your browser (this is OK for me with Chrome and Firefox). From the browser, save the file, ensuring it is .txt and not .html or whatever.

From your HYPTUSS, go to the Company Data Sheet tab, select cell A1 (or select row 1) and click on the macro button. And that should be it.
What OS and browser are you using?

--kiloran

Itsallaguess
Lemon Half
Posts: 9129
Joined: November 4th, 2016, 1:16 pm
Has thanked: 4140 times
Been thanked: 10023 times

Re: HYPTUSS runtime error

#519067

Postby Itsallaguess » August 2nd, 2022, 10:38 am

kiloran wrote:
Go to http://lemonfoolfinancialsoftware.weebl ... op-up.html and click on the company_data_sheet.txt link.

This probably opens the text file in your browser (this is OK for me with Chrome and Firefox).

From the browser, save the file, ensuring it is .txt and not .html or whatever.


A simpler method might be to right-click the company data-sheet link on the website, and use the 'Save Link As' option to directly save the TXT file to desktop or a local folder.

Cheers,

Itsallaguess

Fluke
Lemon Slice
Posts: 609
Joined: November 4th, 2016, 8:51 pm
Has thanked: 61 times
Been thanked: 137 times

Re: HYPTUSS runtime error

#519071

Postby Fluke » August 2nd, 2022, 10:49 am

MacOS 12.4 / Safari.

I'm selecting the company_data_sheet.txt file straight from the downloads folder unchanged.

I click into cell A6 as I have a couple of custom rows followed by a couple of blank rows. Click the button, get the dialogue box, select the file, click open which deletes everything from the company data sheet along with the error message.

Not sure if this helps or further confuses but I started by adding Haleon as a custom row to my existing version (b-p). Share price updated ok but when I tried to update the forecast yields it fell over when it got to Haleon with the following message:

com.sun.star.uno.RuntimeException: Error during invoking function HypFcstYldPy in module vnd.sun.star.tdoc:/1/Scripts/python/HypTopUp.py (<class 'UnboundLocalError'>: local variable 'myYield' referenced before assignment
File "/Applications/LibreOffice.app/Contents/Resources/pythonscript.py", line 915, in invoke
ret = self.func( *args )
File "vnd.sun.star.tdoc:/1/Scripts/python/HypTopUp.py", line 2559, in HypFcstYldPy
File "vnd.sun.star.tdoc:/1/Scripts/python/HypTopUp.py", line 2642, in HypFcstYldPy_1
File "vnd.sun.star.tdoc:/1/Scripts/python/HypTopUp.py", line 2839, in getDlData
File "vnd.sun.star.tdoc:/1/Scripts/python/HypTopUp.py", line 2893, in getAicData
)

Fluke
Lemon Slice
Posts: 609
Joined: November 4th, 2016, 8:51 pm
Has thanked: 61 times
Been thanked: 137 times

Re: HYPTUSS runtime error

#519074

Postby Fluke » August 2nd, 2022, 10:57 am

Could be something to do with how I downloaded the file. Don't waste any time in case it's me. I've got to jump on another call, I'll have a fiddle and get back if I can't fix it.

Thanks.

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: HYPTUSS runtime error

#519100

Postby kiloran » August 2nd, 2022, 11:41 am

Fluke wrote:MacOS 12.4 / Safari.

I'm selecting the company_data_sheet.txt file straight from the downloads folder unchanged.

I click into cell A6 as I have a couple of custom rows followed by a couple of blank rows. Click the button, get the dialogue box, select the file, click open which deletes everything from the company data sheet along with the error message.

Not sure if this helps or further confuses but I started by adding Haleon as a custom row to my existing version (b-p). Share price updated ok but when I tried to update the forecast yields it fell over when it got to Haleon with the following message:

com.sun.star.uno.RuntimeException: Error during invoking function HypFcstYldPy in module vnd.sun.star.tdoc:/1/Scripts/python/HypTopUp.py (<class 'UnboundLocalError'>: local variable 'myYield' referenced before assignment
File "/Applications/LibreOffice.app/Contents/Resources/pythonscript.py", line 915, in invoke
ret = self.func( *args )
File "vnd.sun.star.tdoc:/1/Scripts/python/HypTopUp.py", line 2559, in HypFcstYldPy
File "vnd.sun.star.tdoc:/1/Scripts/python/HypTopUp.py", line 2642, in HypFcstYldPy_1
File "vnd.sun.star.tdoc:/1/Scripts/python/HypTopUp.py", line 2839, in getDlData
File "vnd.sun.star.tdoc:/1/Scripts/python/HypTopUp.py", line 2893, in getAicData
)

I don't have access to MacOS so I can't check that unfortunately. I just tried version b-s updated with the current company data sheet, and it worked fine with Haleon, correctly reporting the forecast yield as n/a

--kiloran

Fluke
Lemon Slice
Posts: 609
Joined: November 4th, 2016, 8:51 pm
Has thanked: 61 times
Been thanked: 137 times

Re: HYPTUSS runtime error

#519166

Postby Fluke » August 2nd, 2022, 2:00 pm

Well I ended up doing an old fashioned cut and paste from the text file to the data sheet of the latest version (b-s), and the prices and yields updated fine. However for some reason the update macro button just doesn't work for me.

I've lost my instructions on how to insert an image or I'd include a screenshot.

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: HYPTUSS runtime error

#519189

Postby kiloran » August 2nd, 2022, 3:16 pm

Fluke wrote:Well I ended up doing an old fashioned cut and paste from the text file to the data sheet of the latest version (b-s), and the prices and yields updated fine. However for some reason the update macro button just doesn't work for me.

I've lost my instructions on how to insert an image or I'd include a screenshot.

Glad you got the yields updated OK. Sounds like there is an issue with HYPTUSS on MacOS, I'll have a think about it.

--kiloran

Fluke
Lemon Slice
Posts: 609
Joined: November 4th, 2016, 8:51 pm
Has thanked: 61 times
Been thanked: 137 times

Re: HYPTUSS runtime error

#519291

Postby Fluke » August 2nd, 2022, 8:08 pm

Thanks Kiloran. I'm pretty sure the same thing happened once before but because I need to update the data sheet so rarely I'd forgotten. I'll make a note for myself in the user guide to do a manual update should the need arise again. Since no one else has posted with a similar problem it could be something peculiar to my setup, I just can't think what.

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: HYPTUSS runtime error

#519432

Postby kiloran » August 3rd, 2022, 11:45 am

Fluke wrote:Thanks Kiloran. I'm pretty sure the same thing happened once before but because I need to update the data sheet so rarely I'd forgotten. I'll make a note for myself in the user guide to do a manual update should the need arise again. Since no one else has posted with a similar problem it could be something peculiar to my setup, I just can't think what.

I just tried HYPTUSS version b-s on Ubuntu Linux and got the same failure, so it's not you. Something has changed, I know it used to work. Leave it with me.

--kiloran

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: HYPTUSS runtime error

#519456

Postby kiloran » August 3rd, 2022, 12:41 pm

kiloran wrote:
Fluke wrote:Thanks Kiloran. I'm pretty sure the same thing happened once before but because I need to update the data sheet so rarely I'd forgotten. I'll make a note for myself in the user guide to do a manual update should the need arise again. Since no one else has posted with a similar problem it could be something peculiar to my setup, I just can't think what.

I just tried HYPTUSS version b-s on Ubuntu Linux and got the same failure, so it's not you. Something has changed, I know it used to work. Leave it with me.

--kiloran

Cracked it! At least on Ubuntu, and hopefully MacOS also.
The problem was not with HYPTUSS, but with company_data_sheet.txt at http://lemonfoolfinancialsoftware.weebl ... op-up.html

The record for EMDV had an odd character in it, copied and pasted from a web site. This character was handled OK by Windows, but upset the file decoding in Ubuntu. I've corrected this and published a new version of company_data_sheet.txt.

This explains why the HYPTUSS import macro for the company_data_sheet.txt used to work OK..... EMDV was added in March 22, 6 months after the HYPTUSS import macro was added.

Have a play and let me know if this is now OK on MacOS

--kiloran

Fluke
Lemon Slice
Posts: 609
Joined: November 4th, 2016, 8:51 pm
Has thanked: 61 times
Been thanked: 137 times

Re: HYPTUSS runtime error

#519649

Postby Fluke » August 3rd, 2022, 10:20 pm

kiloran wrote:
kiloran wrote:
Fluke wrote:Thanks Kiloran. I'm pretty sure the same thing happened once before but because I need to update the data sheet so rarely I'd forgotten. I'll make a note for myself in the user guide to do a manual update should the need arise again. Since no one else has posted with a similar problem it could be something peculiar to my setup, I just can't think what.

I just tried HYPTUSS version b-s on Ubuntu Linux and got the same failure, so it's not you. Something has changed, I know it used to work. Leave it with me.

--kiloran

Cracked it! At least on Ubuntu, and hopefully MacOS also.
The problem was not with HYPTUSS, but with company_data_sheet.txt at http://lemonfoolfinancialsoftware.weebl ... op-up.html

The record for EMDV had an odd character in it, copied and pasted from a web site. This character was handled OK by Windows, but upset the file decoding in Ubuntu. I've corrected this and published a new version of company_data_sheet.txt.

This explains why the HYPTUSS import macro for the company_data_sheet.txt used to work OK..... EMDV was added in March 22, 6 months after the HYPTUSS import macro was added.

Have a play and let me know if this is now OK on MacOS

--kiloran


That did it kiloran. Thanks, well deduced :)


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 3 guests