[Solved] Extension DBDocShortCuts-1.0.1.oxt in macOS

Discussions about using 3rd party extension with OpenOffice.org

[Solved] Extension DBDocShortCuts-1.0.1.oxt in macOS

Postby charlie.it » Sun May 19, 2019 12:13 pm

Hi everyone, I downloaded and installed this extension which creates a desktop shortcut for database documents such as forms and reports.
DBDocShortCuts-1.0.1.oxt
(7.22 KiB) Downloaded 188 times

It works well in Windows (AOO and, with some modifications, even LO) but not in macOS.
Do you know what changes need to be made? Thanks in advance.
Attachments
Schermata 2019-05-19 alle 12.11.01.png
Schermata 2019-05-19 alle 12.11.01.png (10.13 KiB) Viewed 1170 times
Schermata 2019-05-19 alle 12.11.14.png
Last edited by charlie.it on Tue May 21, 2019 3:05 pm, edited 1 time in total.
charlie
macOS 10.12 Sierra: Open Office 4.1.5 - LibreOffice 5.4.3.2
Windows 7 pro (VirtualBox): Open Office 4.1.5 - LibreOffice 5.4.4.2
Ubuntu 17.04 LTE (VirtualBox): LibreOffice 5.1.6.2
http://www.charlieopenoffice.altervista.org
User avatar
charlie.it
Volunteer
 
Posts: 311
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: Extension DBDocShortCuts-1.0.1.oxt in macOS

Postby MrProgrammer » Sun May 19, 2019 9:04 pm

charlie.it wrote:Do you know what changes need to be made?
I do not use that extension. I cannot find any documentation for that extension. A user's desktop on MacOS is /Users/Username/Desktop not /home/mac/Desktop, Perhaps the "shortcut command" is "ln -s". I don't know what the extension will do with that setting. A command to create a symbolic link on MacOS would be:
ln -s path/DatabaseNameOrReportFile ~/Desktop/ShortcutLabel

~/Desktop is the current user's desktop. After that command, using Finder to open ShortcutLabel on the Desktop is the same as using Finder to open path/DatabaseNameOrReportFile; on MacOS the shortcut doesn't need to know the application (soffice location). I don't understand "Shortcut type", but maybe that is needed for Windows. One can create symbolic links in any directory, not just the desktop. MacOS also provides the ~/Library/Favorites directory as a location to store commonly used files.

In Finder one can easily create shortcuts/links/aliases by locating the file, holding Option and Command, then dragging the file to the desktop or elsewhere. The drag shows a black arrow on the file during this operation to show that Option+Command is creating a pointer to the original file. The pointer has all the information needed to find the original file and application. The pointer on the desktop will have the same file name as the original file, however one can rename it as desired. No extension is really needed for creating shortcuts to database documents on MacOS because Finder provides that feature. Finder → Help → Search → Alias has more information. This picture illustrates using Option+Command+Drag to create a pointer on the desktop to a spreadsheet in another folder. I don't use database forms and reports. You should be able to create pointers to a group of files by selecting them and O/C/dragging this set to the desktop.
Grab.jpg
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3709
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Extension DBDocShortCuts-1.0.1.oxt in macOS

Postby charlie.it » Mon May 20, 2019 8:50 am

Thank you for your kind reply that made me realize that I have to change the path from /home/mac/Desktop to /Users/Username/Desktop.
Now the extension, if I run the macro, creates a bash shortcut file on the desktop but it is an empty file and therefore I don't need it at all.
Even if I paste the generated code and open the bash file from terminal.
Code: Select all   Expand viewCollapse view
/Applications/LibreOffice.app/Contents/Resources/../MacOS/soffice -invisible "macro:///DBDocShortCuts.runtime.openDBDoc(Fatture_2,Ricerca13,Report)"


For the rest of your advice, I'm not useful because I need to open a report file (which, as you know, is a Writer file) in a embedded database inside Base without opening Base.
This is the purpose of using the extension that works in Windows.
Thanks for your help.
charlie
macOS 10.12 Sierra: Open Office 4.1.5 - LibreOffice 5.4.3.2
Windows 7 pro (VirtualBox): Open Office 4.1.5 - LibreOffice 5.4.4.2
Ubuntu 17.04 LTE (VirtualBox): LibreOffice 5.1.6.2
http://www.charlieopenoffice.altervista.org
User avatar
charlie.it
Volunteer
 
Posts: 311
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: Extension DBDocShortCuts-1.0.1.oxt in macOS

Postby charlie.it » Tue May 21, 2019 3:03 pm

With some help and many tests I managed to solve the problem due to the wrong paths for MacOS saved by the macro.
The right paths are those that appear in the dialog box.
I enclose the correct version of the extension in case you need someone.

Schermata 2019-05-21 alle 14.51.41.png


DBDocShortCutsMacOs-1.0.1.oxt
Extension for MacOS
(5.86 KiB) Downloaded 187 times
charlie
macOS 10.12 Sierra: Open Office 4.1.5 - LibreOffice 5.4.3.2
Windows 7 pro (VirtualBox): Open Office 4.1.5 - LibreOffice 5.4.4.2
Ubuntu 17.04 LTE (VirtualBox): LibreOffice 5.1.6.2
http://www.charlieopenoffice.altervista.org
User avatar
charlie.it
Volunteer
 
Posts: 311
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy


Return to Extensions

Who is online

Users browsing this forum: No registered users and 2 guests