[libreoffice-users] create custom macro within share location (program files)
Hi, This is probably trivial but I'm not capable of correctly creating new custom macros within %PROGRAMFILES%\LibreOffice 4.0\share\basic\ (Windows 7). My goal is to setup some custom macros globally for all users (location=share). I don't want to include the macros within location=document because I'll be deploying lots of docs and it would be a pain to maintain/update macros within every single odt document. I'd also like to avoid location=user (or location=application - I don't remember which is which) because I have PCs that are being used by lots of users and copying/syncing "user macros" to each user profile on every machine would be a waste of space and network bandwidth. That's why I was hoping to install and update all my macros within the main LO application. Another even better way would be to tell the LO application that my custom macros can be found on a remote server, eg. something like "location=url". This way, I'd maintain my macros on my web/ftp/webdav/whatever server (just one single copy) and forget about syncing them with each and every LO client installation. Any ideas? Vieri -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] create custom macro within share location (program files)
Hi :) Do any of these guides look helpful with that sort of thing? https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Corporate_Users Regards from Tom :) > > From: Vieri >To: users@global.libreoffice.org >Sent: Wednesday, 12 June 2013, 7:26 >Subject: [libreoffice-users] create custom macro within share location >(program files) > > >Hi, > >This is probably trivial but I'm not capable of correctly creating new custom >macros within %PROGRAMFILES%\LibreOffice 4.0\share\basic\ (Windows 7). > >My goal is to setup some custom macros globally for all users >(location=share). I don't want to include the macros within location=document >because I'll be deploying lots of docs and it would be a pain to >maintain/update macros within every single odt document. I'd also like to >avoid location=user (or location=application - I don't remember which is >which) because I have PCs that are being used by lots of users and >copying/syncing "user macros" to each user profile on every machine would be a >waste of space and network bandwidth. >That's why I was hoping to install and update all my macros within the main LO >application. >Another even better way would be to tell the LO application that my custom >macros can be found on a remote server, eg. something like "location=url". >This way, I'd maintain my macros on my web/ftp/webdav/whatever server (just >one single copy) and forget about syncing them with each and every LO client >installation. > >Any ideas? > >Vieri > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >List archive: http://listarchives.libreoffice.org/global/users/ >All messages sent to this list will be publicly archived and cannot be deleted > > > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] create custom macro within share location (program files)
Openoffice stores individual macros in modules. Modules are stored in libraries, and libraries are stored in macro containers. Three "things" can be macro containers, documents, your user space, and one that is global to OpenOffice. It sounds like you desire to add a macro that is global to OpenOffice. I have never done this It is not enabled on my Linux system, is it available to you to do from the GUI when you are logged in as an administrator? I expect that the Link from Tom Davis is the best you can find, since I don't see an ability to set the Macro location directories in the configuration. On 06/12/2013 02:26 AM, Vieri wrote: Hi, This is probably trivial but I'm not capable of correctly creating new custom macros within %PROGRAMFILES%\LibreOffice 4.0\share\basic\ (Windows 7). My goal is to setup some custom macros globally for all users (location=share). I don't want to include the macros within location=document because I'll be deploying lots of docs and it would be a pain to maintain/update macros within every single odt document. I'd also like to avoid location=user (or location=application - I don't remember which is which) because I have PCs that are being used by lots of users and copying/syncing "user macros" to each user profile on every machine would be a waste of space and network bandwidth. That's why I was hoping to install and update all my macros within the main LO application. Another even better way would be to tell the LO application that my custom macros can be found on a remote server, eg. something like "location=url". This way, I'd maintain my macros on my web/ftp/webdav/whatever server (just one single copy) and forget about syncing them with each and every LO client installation. Any ideas? Vieri -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] create custom macro within share location (program files)
Hi Andrew, The link that Tom refers to lead me to several documents of which only one deals with what I want to do (which is install a macro that is global to openoffice/libreoffice). That would be location=share and on Windows the path would be %PROGRAMFILES%\libreoffice 4.0\share\basic\. >From the LO/OO GUI I can't create any NEW macros within the "global container" >(grayed out). And I haven't found any option to enable it. So there's >obviously some kind of security reason that I don't know how to circumvent. The only document within Tom's links that should do what I want is the following: http://wiki.openoffice.org/wiki/Documentation/Administration_Guide/Using_Custom_Macros_and_Libraries "To Make a Custom OpenOffice.org Basic Library Available to All Users on a Network" The basic idea of this guide is to create my macros within my "user profile folder" and then copy them to the "global share folder". However, note how the guide suggests to include in script.xlc and dialog.xlc: the library xlink:href should point to $(USER)/basic...etc. I find that wrong (or not what I want). I understand that $(USER) points to the user profile folder where I first wrote my macros. It doesn't point to the "global share folder". So maybe it does make the macros available in OO/LO on that PC as "global macros" BUT it is required to keep a copy of the macros in the $USER dir. Am I right? What I would like to do (or at least that's what I feel should be done) is not to COPY the macros from a user dir to the global share dir but to MOVE them. So if I do that then the library xlink:href in script.xlc and dialog.xlc should point to something like "$(INST)/share/basic/MyLibraryName/script.xlb/". Doing so doesn't make LO or OO complain BUT I don't see my library listed in the "gloabl macros tree mode". So I can't run my macros in the "global share". As I stated in another e-mail on this list, I managed to actually install my custom BASIC macros within the "global share" by creating my own extension .oxt file. So I'd be happy with that except for the fact that I can't also bundle my JAVA macros in my extension oxt file. So I'm stuck in the middle: I can install my Java macros by copying them over to the global share (and they work!) but I can0t do the same with Basic macros; and on the other hand I can deploy my Basic macros with a custom extension but not my Java macros. I can combine both methods to do what I need (ie. "install custom Basic and Java macros in the global share") but that doesn't sound "clean" or efficient. Any more ideas? Thanks, Vieri --- On Thu, 6/13/13, Andrew Douglas Pitonyak wrote: > Openoffice stores individual macros > in modules. Modules are stored in libraries, and libraries > are stored in macro containers. > > Three "things" can be macro containers, documents, your user > space, and one that is global to OpenOffice. It sounds like > you desire to add a macro that is global to OpenOffice. I > have never done this It is not enabled on my Linux > system, is it available to you to do from the GUI when you > are logged in as an administrator? > > I expect that the Link from Tom Davis is the best you can > find, since I don't see an ability to set the Macro location > directories in the configuration. > > On 06/12/2013 02:26 AM, Vieri wrote: > > Hi, > > > > This is probably trivial but I'm not capable of > correctly creating new custom macros within > %PROGRAMFILES%\LibreOffice 4.0\share\basic\ (Windows 7). > > > > My goal is to setup some custom macros globally for all > users (location=share). I don't want to include the macros > within location=document because I'll be deploying lots of > docs and it would be a pain to maintain/update macros within > every single odt document. I'd also like to avoid > location=user (or location=application - I don't remember > which is which) because I have PCs that are being used by > lots of users and copying/syncing "user macros" to each user > profile on every machine would be a waste of space and > network bandwidth. > > That's why I was hoping to install and update all my > macros within the main LO application. > > Another even better way would be to tell the LO > application that my custom macros can be found on a remote > server, eg. something like "location=url". This way, I'd > maintain my macros on my web/ftp/webdav/whatever server > (just one single copy) and forget about syncing them with > each and every LO client installation. > > > > Any ideas? > > > > Vieri -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] create custom macro within share location (program files)
Hi :) I take it that it's not easy to re-write all the macros in, say Java, into Basic (or the other way around)? Also I take it that the http://wiki.openoffice.org/wiki/Documentation/Administration_Guide/Using_Custom_Macros_and_Libraries needs significant updating? Apols and regards from Tom :) > > From: Vieri >To: users@global.libreoffice.org >Sent: Friday, 14 June 2013, 8:02 >Subject: Re: [libreoffice-users] create custom macro within share location >(program files) > > >Hi Andrew, > >The link that Tom refers to lead me to several documents of which only one >deals with what I want to do (which is install a macro that is global to >openoffice/libreoffice). That would be location=share and on Windows the path >would be %PROGRAMFILES%\libreoffice 4.0\share\basic\. > >>From the LO/OO GUI I can't create any NEW macros within the "global >>container" (grayed out). And I haven't found any option to enable it. So >>there's obviously some kind of security reason that I don't know how to >>circumvent. > >The only document within Tom's links that should do what I want is the >following: > >http://wiki.openoffice.org/wiki/Documentation/Administration_Guide/Using_Custom_Macros_and_Libraries > >"To Make a Custom OpenOffice.org Basic Library Available to All Users on a >Network" > >The basic idea of this guide is to create my macros within my "user profile >folder" and then copy them to the "global share folder". However, note how the >guide suggests to include in script.xlc and dialog.xlc: the library xlink:href >should point to $(USER)/basic...etc. >I find that wrong (or not what I want). >I understand that $(USER) points to the user profile folder where I first >wrote my macros. It doesn't point to the "global share folder". So maybe it >does make the macros available in OO/LO on that PC as "global macros" BUT it >is required to keep a copy of the macros in the $USER dir. Am I right? > >What I would like to do (or at least that's what I feel should be done) is not >to COPY the macros from a user dir to the global share dir but to MOVE them. >So if I do that then the library xlink:href in script.xlc and dialog.xlc >should point to something like >"$(INST)/share/basic/MyLibraryName/script.xlb/". Doing so doesn't make LO or >OO complain BUT I don't see my library listed in the "gloabl macros tree >mode". So I can't run my macros in the "global share". > >As I stated in another e-mail on this list, I managed to actually install my >custom BASIC macros within the "global share" by creating my own extension >.oxt file. So I'd be happy with that except for the fact that I can't also >bundle my JAVA macros in my extension oxt file. So I'm stuck in the middle: I >can install my Java macros by copying them over to the global share (and they >work!) but I can0t do the same with Basic macros; and on the other hand I can >deploy my Basic macros with a custom extension but not my Java macros. I can >combine both methods to do what I need (ie. "install custom Basic and Java >macros in the global share") but that doesn't sound "clean" or efficient. > >Any more ideas? > >Thanks, > >Vieri > >--- On Thu, 6/13/13, Andrew Douglas Pitonyak wrote: > >> Openoffice stores individual macros >> in modules. Modules are stored in libraries, and libraries >> are stored in macro containers. >> >> Three "things" can be macro containers, documents, your user >> space, and one that is global to OpenOffice. It sounds like >> you desire to add a macro that is global to OpenOffice. I >> have never done this It is not enabled on my Linux >> system, is it available to you to do from the GUI when you >> are logged in as an administrator? >> >> I expect that the Link from Tom Davis is the best you can >> find, since I don't see an ability to set the Macro location >> directories in the configuration. >> >> On 06/12/2013 02:26 AM, Vieri wrote: >> > Hi, >> > >> > This is probably trivial but I'm not capable of >> correctly creating new custom macros within >> %PROGRAMFILES%\LibreOffice 4.0\share\basic\ (Windows 7). >> > >> > My goal is to setup some custom macros globally for all >> users (location=share). I don't want to include the macros >> within location=document because I'll be deploying lots of >> docs and it would be a pain to maintain/update macros within >> every
Re: [libreoffice-users] create custom macro within share location (program files)
--- On Fri, 6/14/13, Tom Davies wrote: > Hi :) Hi Tom > I take it that it's not easy to re-write all the macros in, > say Java, into Basic (or the other way around)? No, not easy. At least for me. > Also I > take it that the > http://wiki.openoffice.org/wiki/Documentation/Administration_Guide/Using_Custom_Macros_and_Libraries > needs significant updating? It doesn't fully address what I'm trying to do. Regards, Vieri -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted