Correct URL line for Linux

English
#1

I have this code:

Sub AuthenticationTest
  dim sURL as string
  dim oArgs(0) As New com.sun.star.beans.PropertyValue
  dim oDocStatus as object
  dim oihandler
  oihandler = CreateUnoListener("InteractionHandler_", "com.sun.star.task.XInteractionHandler")
  sURL = "file:///home/jim/Documents/checksjdbc.odb"
  rem sURL = "C:\Users\jimwin7a\Documents\checksjdbc.odb"
  oArgs(0).Name = "InteractionHandler"
  oArgs(0).Value = oihandler
  oDocStatus = StarDesktop.loadComponentFromURL(sURL, "_default", 0, oArgs)
  oDocStatus.DataSource.Password = ""
  oDocStatus.setModified(0)
End Sub

The line sURL = "file:///home/jim/Documents/checksjdbc.odb"

I am not sure of on linux, new to linux. On windows I used a drive letter.

Also my macros aren't working so far on linux, but same app on windows all macros worked.

Thanks.
#2

Use the ConverToURL() function.
https://help.libreoffice.org/latest/en-US/text/sbasic/shared/03120312.html

#3

Drive letters were never used on Unix/linux/MacOS. This is something left over from MS-DOS.
.
But where your files are and if you have a Documents folder in your home-folder can only checked by you. Attention: In Linux Documents and documents are two different files or folders.
.
If in doubt, open a terminal and try with ls (the unix command wich is named dir in the DOS-command-line) like

ls /home/jim/Documents/checksjdbc.odb
.
Using ConvertToURL is recommended, but this can not replace Drive-Letters.

#4

At first: Unless you ported your profile, your settings and trusted locations from Windows are not available/seen by your LO on Linux. Modfy your settings. Do you get a warning, telling macros are not active?
.
Second: For Linux there are Maintainers for the distribution wich check and bundle software, so updates can be handled by the system. They often cripple especially Base (? Because of the Java-dependency? ) Depending on your distribution you may have to install additional packages like script-providers or sometimes the complete module Base is left out.
.
A problem for macros can also be the installation of LibreOffice as Snap (typically in Ubuntu), where the container sometimes is limited.

#5

… and also the macros could use some Windows-specific functionality, like creating COM/OLE objects, or using WinAPI.

#6

Thank you to all who answered, a few tweaks and it works.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.