[libreoffice-users] search path not working user profile versus system wide lo base macros in Ubuntu

Hi this is a problem i am having and a conversation with gemini the ai. LO is not letting me use 
the script profile correctly. I run lo using apt package manager through Ubuntu 22.04.
My code is not letting me run this location from within libreoffice. I go to Tools->Organize Python 
Scripts-> Execute and it doesnt work with my user profile. It goes to location=application and 
searches backward in that dir first which is out of order because if I hadve a dialog in system 
wide it searches there first and then falls back to user. Only location=application is working with 
DIALOG_URL = "vnd.sun.star.script:Standard.Dialog1?location=application" If i run it in code 
specified like this my dialog shows -- otherwise No. I will include the code i am testing a the end 
of this email.

Thanks so much for considering helping me resolve this because my scripts will not be portable or 
able to be used in a business that I am not the administrator for which is unlikely.

Have the coolest of days.

thanks again - j.

I am using Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 8; OS: Linux 6.14; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4
Calc: threaded


You are correct that the URL
DIALOG_URL = "vnd.sun.star.script:Standard.Dialog1?location=application" is strange in this 
context. Given the file path you provided, the location=application part of the URL is incorrect 
and will cause an error.
Here is an explanation of why and how to fix it:
The problem with location=application
The location=application argument in the URL tells LibreOffice to look for the script or dialog in 
the application's shared directory, which is a system-wide directory. Your files, however, are in 
your user profile: /home/funnysys/.config/libreoffice/4/user/basic/Standard.
The correct URL needs to specify location=user so that LibreOffice looks in the correct place, 
which is your user profile.
Correct URL for a Python script
To call a Basic dialog (Dialog1 from the Standard library) from a Python macro, you must 
instantiate it from the correct location.
If your Python macro is calling a Basic macro
If your Python script is simply triggering a Basic macro that handles the dialog, the URL should 
point to the Basic macro itself.
python

# Calls a macro named 'Main' inside Module1.xba
DIALOG_URL = "vnd.sun.star.script:Standard.Module1.Main?language=Basic&location=user"

Use code with caution.
If your Python macro is opening the dialog directly
If your Python macro is responsible for instantiating the dialog, the process is different. The 
Python script would get the dialog from the correct library and then run it. The URL would not be 
used in the same way.
Instead, a Python macro would use the UNO framework to get the dialog from the Standard library in 
the user's profile and then execute it. The code might look something like this:
python

import uno

def run_dialog():
    # Get the LibreOffice Basic libraries
    basic_libraries = uno.getComponentContext().getServiceManager().createInstance(
        "com.sun.star.script.provider.MasterScriptProviderFactory"
    ).createScriptProvider("")

    # Get the user's Standard library
    user_script_library = basic_libraries.getLibrary("Standard", "user")

    # Load the dialog from the library
    dialog_container = user_script_library.getDialogContainer()
    oDialog = dialog_container.getByName("Dialog1")

    # Create the dialog model
    dialog_model = 
uno.getComponentContext().getServiceManager().createInstance("com.sun.star.awt.Dialog")
    dialog_model.setModel(oDialog.createUnoModel())

    # Execute the dialog
    dialog_model.execute()

Use code with caution.
dialog.xlc and script.xlc
The .xlc files are cache files that LibreOffice uses for faster access to the Basic libraries. They 
store information about the modules (script.xlc) and dialogs (dialog.xlc) in the library. You 
should never edit these manually. They are automatically created and updated by LibreOffice when 
you use the Macro Organizer.
In summary
The URL vnd.sun.star.script:Standard.Dialog1?location=application will fail because your files are 
in the user profile, not the system-wide application folder. The location parameter must be changed 
from application to user for the call to work correctly from a Basic macro. For a Python macro, you 
would use UNO to access the dialog programmatically from the correct location.

# -*- coding: utf-8 -*-
from __future__ import unicode_literals

import uno, unohelper
from com.sun.star.awt import XDialogEventHandler
from com.sun.star.lang import IllegalArgumentException

_DLG_PROVIDER = "com.sun.star.awt.DialogProvider2"
DIALOG_URL = "vnd.sun.star.script:Standard.Dialog1?location=user"

class Console(unohelper.Base, XDialogEventHandler):
    """ Access2Base Console Handler """

    def show(self, ctx, smgr):
        """Creates and executes the dialog using the provided context."""

        # Create dialog with handler.
        dp = smgr.createInstanceWithContext(_DLG_PROVIDER, ctx)

        try:
            # Note: location=user is typically for "My Macros & Dialogs"
            dialog = dp.createDialogWithHandler(DIALOG_URL, self)
            dialog.setTitle("Konsole")

            # Execute the dialog.
            dialog.execute()

        except IllegalArgumentException as e:
            # Handle error if dialog is not found.
            self._msgbox(f"Dialog not found: {DIALOG_URL}\nError: {e.Message}", "Dialog Error")
        except uno.Exception as e:
            self._msgbox(f"UNO Exception: {e.Message}", "UNO Error")

    # The method handles the dialog's events (not part of IDE testing)
    # The handles method is a requirement of XDialogEventHandler
    def handleEvent(self, event):
        return False

    def getSupportedMethodNames(self):
        return () # Empty tuple since no custom methods are supported in this example.

    def _msgbox(self, prompt, title):
        """Helper function for displaying message boxes."""
        try:
            # Get the desktop window as a parent for the message box.
            ctx = uno.getComponentContext()
            toolkit = ctx.getServiceManager().createInstance("com.sun.star.awt.Toolkit")
            parent = toolkit.getDesktopWindow()

            mb = toolkit.createMessageBox(parent, "infobox", 1, title, prompt)
            mb.execute()
        except Exception:
            # Fallback for IDE testing
            print(f"[{title}] {prompt}")


def ConsoleHandler():
    """Main entry point for the LibreOffice macro."""
    try:
        # Get the component context provided by LibreOffice.
        ctx = XSCRIPTCONTEXT.getComponentContext()
        smgr = ctx.getServiceManager()
        Console().show(ctx, smgr)
    except NameError:
        # This will be caught when running outside LibreOffice.
        print("This function cannot be run outside of LibreOffice.")

g_exportedScripts = (ConsoleHandler,)

if __name__ == "__main__":
    # IDE runnable code: uses a mock LibreOffice environment.
    # We explicitly avoid the graphical parts here.
    from IDE_utils import Runner
    with Runner():
        print("Simulating ConsoleHandler, but skipping GUI interactions.")
        # We cannot create the dialog handler correctly here, so we skip it.


Sent with Proton Mail secure email.




Sent with Proton Mail secure email.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy