Hi everyone, I downloaded and installed this extension which creates a desktop shortcut for database documents such as forms and reports.
Do you know what changes need to be made? Thanks in advance.
It works well in Windows (AOO and, with some modifications, even LO) but not in macOS.[Solved] Extension DBDocShortCuts-1.0.1.oxt in macOS
- charlie.it
- Volunteer
- Posts: 417
- Joined: Wed Aug 21, 2013 2:12 pm
- Location: Italy
[Solved] Extension DBDocShortCuts-1.0.1.oxt in macOS
Last edited by charlie.it on Tue May 21, 2019 3:05 pm, edited 1 time in total.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
- MrProgrammer
- Moderator
- Posts: 4909
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Extension DBDocShortCuts-1.0.1.oxt in macOS
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:charlie.it wrote:Do you know what changes need to be made?
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.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
- charlie.it
- Volunteer
- Posts: 417
- Joined: Wed Aug 21, 2013 2:12 pm
- Location: Italy
Re: Extension DBDocShortCuts-1.0.1.oxt in macOS
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.
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.
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
/Applications/LibreOffice.app/Contents/Resources/../MacOS/soffice -invisible "macro:///DBDocShortCuts.runtime.openDBDoc(Fatture_2,Ricerca13,Report)"
This is the purpose of using the extension that works in Windows.
Thanks for your help.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
- charlie.it
- Volunteer
- Posts: 417
- Joined: Wed Aug 21, 2013 2:12 pm
- Location: Italy
Re: Extension DBDocShortCuts-1.0.1.oxt in macOS
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.
The right paths are those that appear in the dialog box.
I enclose the correct version of the extension in case you need someone.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org