[Solved] Error in macro to extract/reconnect embedded HSQLDB

[fcsw]

Edit: Split from [Python] Macro to extract and reconnect embedded HSQLDB because the Code Snippets forum is only for sharing working examples of macros. Do not ask about problems there. -- MrProgrammer, forum moderator

Windows 11 25H2, LO 25.8.3.2
I ran Main and received the following error:

Code: Select all

com.sun.star.uno.RuntimeException: Couldn't convert file url  to a system path for reason (21) (Error during invoking function Main in module file:///C:/Users/rjhjr/AppData/Roaming/LibreOffice/4/user/Scripts/python/pyDBA/ExtractHSQL.py (<class 'uno.com.sun.star.uno.RuntimeException'>: Couldn't convert file url  to a system path for reason (21)
  File "C:\Program Files\LibreOffice\program\pythonscript.py", line 941, in invoke
    ret = self.func(*args)
          ^^^^^^^^^^^^^^^^
  File "C:\Users\rjhjr\AppData\Roaming\LibreOffice\4\user\Scripts\python\pyDBA\ExtractHSQL.py", line 151, in Main
    dba = DBA()
          ^^^^^
  File "C:\Users\rjhjr\AppData\Roaming\LibreOffice\4\user\Scripts\python\pyDBA\ExtractHSQL.py", line 64, in __init__
    self.fpath = uno.fileUrlToSystemPath(url.Protocol + url.Path)
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Program Files\LibreOffice\program\uno.py", line 133, in fileUrlToSystemPath
    return pyuno.fileUrlToSystemPath(url)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
))

[Jurassic Pork]

Hello,
is your odb file is in a path with special characters or has special characters. I have no problem to use the macro in my Champignons.odb (Mushrooms) file :

pyDBAdebug.gif (125.13 KiB) Viewed 8326 times

urlDebug.png (19.15 KiB) Viewed 8326 times

Friendly, J.P

[fcsw]

This has been resolved.

As for this thread, I didn't create it and I had no idea it existed.