search

masbug / etoro-edavki

MIT License
49 stars 14 forks source link

CERTIFICATE_VERIFY_FAILED #33

Closed LeMar70 closed 7 months ago

LeMar70 commented 7 months ago

Mi lahko kdo pomaga.
ob zagonu komande etoro-edavki etoroaccountstatement2023.xlsx mi ob izvajanju javi napako.. raise URLError(err) urllib.error.URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1007)>

Kje je tezava.. Hvala

masbug commented 7 months ago

Hm, zgleda kot da je nek problem s certifikatom pri downloadu https://www.bsi.si/_data/tecajnice/dtecbs-l.xml ...če nimate precej starih windowsov, potem za vsak slučaj preverite računalnik za viruse (potencialni man-in-the-middle attack).

Hitra rešitev je, da ročno prenesete https://www.bsi.si/_data/tecajnice/dtecbs-l.xml in shranite kot bsrate-.xml. Primer za danes: bsrate-2024125.xml To datoteko skopirate v isto mapo kot je etoro_edavki.exe. Potem bi moralo delovati. Če ne bo, pa priporočam, da vse skupaj ponovno prenesete na drugem računalniku in tam tudi poženete.

LeMar70 commented 7 months ago

Hvala za pomoc. Te napake ni več. se mi pa pojavi nova, ki pa naj bi bila odpravljena. File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/openpyxl_templates/table_sheet/table_sheet.py", line 379, in read raise HeadersNotFound(self) openpyxl_templates.table_sheet.table_sheet.HeadersNotFound: Header column not found on sheet 'Closed Positions' either make sure that the following headers are present 'Position ID, Action, Amount, Units, Open Date, Close Date, Leverage, Spread Fees (USD), Profit(USD), Profit(EUR), Open Rate, Close Rate, Take profit rate, Stop lose rate, Rollover Fees and Dividends, Copied From, Type, ISIN, Notes'.

Skripto zaganjam na mac.u.

hvala za pomoc.

On 25 Jan 2024, at 21:19, masbug @.***> wrote:

Hm, zgleda kot da je nek problem s certifikatom pri downloadu https://www.bsi.si/_data/tecajnice/dtecbs-l.xml ...če nimate precej starih windowsov, potem za vsak slučaj preverite računalnik za viruse (potencialni man-in-the-middle attack https://en.wikipedia.org/wiki/Man-in-the-middle_attack).

Hitra rešitev je, da ročno prenesete https://www.bsi.si/_data/tecajnice/dtecbs-l.xml in shranite kot bsrate-.xml. Primer za danes: bsrate-2024125.xml To datoteko skopirate v isto mapo kot je etoro_edavki.exe. Potem bi moralo delovati. Če ne bo, pa priporočam, da vse skupaj ponovno prenesete na drugem računalniku in tam tudi poženete.

— Reply to this email directly, view it on GitHub https://github.com/masbug/etoro-edavki/issues/33#issuecomment-1910934692, or unsubscribe https://github.com/notifications/unsubscribe-auth/BFTMTKQTDNLXQFH2FSV4HCLYQK43ZAVCNFSM6AAAAABCK25WDCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMJQHEZTINRZGI. You are receiving this because you authored the thread.

masbug commented 7 months ago

A pa tako poimenovani stolpci obstajajo v vašem xlsu na strani "Closed Positions"?

LeMar70 commented 7 months ago

Ja sem preveril. Samo se mi skripta ne izvede. Lahko vam pošljem xlsx.

Če lahko pomagate. Hvala

On 26 Jan 2024, at 07:05, masbug @.***> wrote:

A pa tako poimenovani stolpci obstajajo v vašem xlsu na strani "Closed Positions"?

— Reply to this email directly, view it on GitHub https://github.com/masbug/etoro-edavki/issues/33#issuecomment-1911532225, or unsubscribe https://github.com/notifications/unsubscribe-auth/BFTMTKWZASQ642NCPXBZOX3YQNBSHAVCNFSM6AAAAABCK25WDCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMJRGUZTEMRSGU. You are receiving this because you authored the thread.

masbug commented 7 months ago

Lahko, pošljite.

LeMar70 commented 7 months ago



Hvala

On 26 Jan 2024, at 07:13, masbug @.***> wrote:

Lahko, pošljite.

— Reply to this email directly, view it on GitHub https://github.com/masbug/etoro-edavki/issues/33#issuecomment-1911538707, or unsubscribe https://github.com/notifications/unsubscribe-auth/BFTMTKQM3EY36J342O4J4ULYQNCPDAVCNFSM6AAAAABCK25WDCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMJRGUZTQNZQG4. You are receiving this because you authored the thread.

masbug commented 7 months ago

...potrebujem xlsx datoteko.

LeMar70 commented 7 months ago

Sem jo pripel. Vam jo lahko pošljem na kak drug način.

On 26 Jan 2024, at 07:41, masbug @.***> wrote:

...potrebujem xlsx datoteko.

— Reply to this email directly, view it on GitHub https://github.com/masbug/etoro-edavki/issues/33#issuecomment-1911561631, or unsubscribe https://github.com/notifications/unsubscribe-auth/BFTMTKUPMLFMS5U63ZRO73TYQNF2BAVCNFSM6AAAAABCK25WDCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMJRGU3DCNRTGE. You are receiving this because you authored the thread.