[Gambas-user] Output to Libre Office Writer ??
Willy Raets
willy at ...2734...
Wed Apr 3 19:36:01 CEST 2013
On Wed, 2013-04-03 at 10:13 -0700, rocko wrote:
> Ok thanks for suggestions.
>
> I'm now having problems with zipping the files.
> I "m naming the files dynamically with the first name of the
> person from my database.
>
> But the zip command sometimes saves the file as a zip not .odt.
> Why it does this I don't know, actually it does this a lot/
>
> I'm using this as my zip code:
> zip -r " & sFirst & ".odt ." Wait
zip -h2 in a terminal gives you more detailed instructions on use of zip
zip -r NameOfZipFile FileOrFolderToAdd
NameOfZipFile in your case is sFirst & ".odt"
FileOrFolderToAdd is the place you unzipped the original .odt to and
where you replaces some content.
------------------
Dim sCommand, sPath As String
sPath = User.Home & "place you unzipped and modified the content of odt"
sCommand = "zip -r " & sFirst & ".odt " & sPath
Shell sCommand
------------------
Watch the spaces in the strings as they are important!!
>
> How do I get my files saved with the .odt extension all the time??
> I tried renaming any .zip to a .odt with the rename command
> but thats not working either.
>
>
>
>
> On 04/03/2013 10:05 AM, Willy Raets wrote:
> > On Wed, 2013-04-03 at 09:18 -0700, rocko wrote:
> >> Ok I got that to work, but the code is kinda long and ugly
> >> as I have to save the file after doing a /Replace/.
> >>
> >> I have 6 fields I have to replace, so thats 6 Replace statements with 6
> >> File.Save,
> >> I can put in a Function and just call the function when I need it, but
> >> still I would
> >> think the Replace could take multiple arguments for replacing multiple
> >> fields.
> >> But oh well..
> > As Fabien wrote:
> > Load the file in a string
> > Replace as many as need
> > Save the string in the file
> >
> > Dim sFileText, sFilePath As String
> >
> > sFilePath = "home/rocko/Zip/content.xml"
> > '-- Load file in string --
> > sFileText = File.Load(sFilePath)
> > '-- Replace as many as needed --
> > sFileText = Replace(sFileText, "$(Name)", mName)
> > sFileText = Replace(sFileText, ...)
> > sFileText = Replace(sFileText, ...)
> > sFileText = Replace(sFileText, ...)
> > sFileText = Replace(sFileText, ...)
> > sFileText = Replace(sFileText, ...)
> > '-- Save string to file --
> > File.Save(sFilePath, sMyFileText)
> >
> > Only one file load and one file save.
> >
> > Hope this will help you understand the matter..
> >
> >
> >>
> >>
> >> On 04/03/2013 08:57 AM, Willy Raets wrote:
> >>> On Wed, 2013-04-03 at 08:39 -0700, Rocko wrote:
> >>>> so each value needs it's own the replace statement?
> >>> YES
> >>>
> >>>> On Apr 3, 2013 8:28 AM, "Fabien Bodard" <gambas.fr at ...626...> wrote:
> >>>>
> >>>>> Ok so it's one call by entry.
> >>>>>
> >>>>> Unzip odt
> >>>>> Load the file in a string
> >>>>> Replace as many as need
> >>>>> Save the string in the file
> >>>>> Zip the directory
> >>>>>
> >>>>> Simple!
> >>>>> Le 3 avr. 2013 17:20, "Rocko" <sunblaster5 at ...626...> a écrit :
> >>>>>
> >>>>>> I don't think you understanf, I want to replace different fields with
> >>>>>> different values not all the same value
> >>>>>> On Apr 3, 2013 1:41 AM, "Fabien Bodard" <gambas.fr at ...626...> wrote:
> >>>>>>
> >>>>>>> Replace,
> >>>>>>> Replace all the words that match the pattern
> >>>>>>> Read the doc!
> >>>>>>> Le 3 avr. 2013 01:10, "rocko" <sunblaster5 at ...626...> a écrit :
> >>>>>>>
> >>>>>>>> Is it possible to do multiple replacing with/Replace/
> >>>>>>>>
> >>>>>>>> I have several fields that I want to change in an .odt file
> >>>>>>>> do I have to do multiple Replace statements or can I
> >>>>>>>> put them all in one /Replace/ statement??
> >>>>>>>>
> >>>>>>>>
> >>>>>>>> On 04/02/2013 03:34 AM, Fabien Bodard wrote:
> >>>>>>>>> Le 2 avr. 2013 01:37, "rocko" <sunblaster5 at ...626...> a écrit :
> >>>>>>>>>> Not sure I'm using /Replace$/ correctly.
> >>>>>>>>>> I want to replace instance of $(Name) in the XML file
> >>>>>>>>>> with the value of the /mName/ variable
> >>>>>>>>>>
> >>>>>>>>>> Code:
> >>>>>>>>>> /xName = "home/rocko/Zip/content.xml"//
> >>>>>>>>>> // newFile = Replace$(xName, "$(Name)", mName)/
> >>>>>>>>> Newfile=replace (file. Load(xname), "$(Name )",mname )
> >>>>>>>>> File. Save(xname, newfile)
> >>>>>>>>>> Of course this doesn't work, But I don't know why
> >>>>>>>>>>
> >>>>>>>>>> On 03/31/2013 05:21 PM, Benoît Minisini wrote:
> >>>>>>>>>>> Le 01/04/2013 01:32, rocko a écrit :
> >>>>>>>>>>>> I actually tried that after sending my response.
> >>>>>>>>>>>> lo and behold! XML file woo hoo!
> >>>>>>>>>>>>
> >>>>>>>>>>>> So I assume I can just do a search thru th XML file and change
> >>>>>>> things
> >>>>>>>>>>>> then re-save
> >>>>>>>>>>>> the file and re-zip it like you said.
> >>>>>>>>>>>>
> >>>>>>>>>>>>
> >>>>>>>>>>>>
> >>>>>>>>>>>> So how do I unzip and re-zip a file in Gambas?, sorry this is
> >>>>>> kinda
> >>>>>>>>> new
> >>>>>>>>>>>> to me.
> >>>>>>>>>>> SHELL "zip ..." WAIT
> >>>>>>>>>>>
> >>>>>>>>>>> SHELL "unzip ..." WAIT
> >>>>>>>>>>>
> >>>>>>>>>>> That run the shell commands as if you typed them in a terminal.
> >>>>>>>>>>>
> >>>>>>>>>>> There is a compression component that allows you to do the same
> >>>>>> thing
> >>>>>>>>>>> without running external process, but it is a more complex to
> >>>>>>> explain.
> >>>>>>>>>>>> Which kind of search functions does gambas have?? regex I
> >>>>> assume,
> >>>>>>> any
> >>>>>>>>>>>> others??
> >>>>>>>>>>>>
> >>>>>>>>>>> I use Replace$(). No need for regexp. If your search pattern are
> >>>>>> like
> >>>>>>>>>>> "$(field name)", you won't mix up with any OpenOffice XML syntax.
> >>>>>>>>>>>
> >>>>>>>>>>> Don't forget to look at XML format for correctly quoting
> >>>>> characters
> >>>>>>>> that
> >>>>>>>>>>> must be quoted.
> >>>>>>>>>>>
> >>>>>>>>>>> Regards,
> >>>>>>>>>>>
> >>>>> ------------------------------------------------------------------------------
> >>>>>>>>>> Own the Future-Intel® Level Up Game Demo Contest 2013
> >>>>>>>>>> Rise to greatness in Intel's independent game demo contest.
> >>>>>>>>>> Compete for recognition, cash, and the chance to get your game
> >>>>>>>>>> on Steam. $5K grand prize plus 10 genre and skill prizes.
> >>>>>>>>>> Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
> >>>>>>>>>> _______________________________________________
> >>>>>>>>>> Gambas-user mailing list
> >>>>>>>>>> Gambas-user at lists.sourceforge.net
> >>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
> >>>>> ------------------------------------------------------------------------------
> >>>>>>>>> Own the Future-Intel(R) Level Up Game Demo Contest 2013
> >>>>>>>>> Rise to greatness in Intel's independent game demo contest. Compete
> >>>>>>>>> for recognition, cash, and the chance to get your game on Steam.
> >>>>>>>>> $5K grand prize plus 10 genre and skill prizes. Submit your demo
> >>>>>>>>> by 6/6/13. http://altfarm.mediaplex.com/ad/ck/12124-176961-30367-2
> >>>>>>>>> _______________________________________________
> >>>>>>>>> Gambas-user mailing list
> >>>>>>>>> Gambas-user at lists.sourceforge.net
> >>>>>>>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
> >>>>>>>>> .
> >>>>>>>>>
> >>>>>>>>
> >>>>> ------------------------------------------------------------------------------
> >>>>>>>> Minimize network downtime and maximize team effectiveness.
> >>>>>>>> Reduce network management and security costs.Learn how to hire
> >>>>>>>> the most talented Cisco Certified professionals. Visit the
> >>>>>>>> Employer Resources Portal
> >>>>>>>> http://www.cisco.com/web/learning/employer_resources/index.html
> >>>>>>>> _______________________________________________
> >>>>>>>> Gambas-user mailing list
> >>>>>>>> Gambas-user at lists.sourceforge.net
> >>>>>>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
> >>>>>>>>
> >>>>> ------------------------------------------------------------------------------
> >>>>>>> Minimize network downtime and maximize team effectiveness.
> >>>>>>> Reduce network management and security costs.Learn how to hire
> >>>>>>> the most talented Cisco Certified professionals. Visit the
> >>>>>>> Employer Resources Portal
> >>>>>>> http://www.cisco.com/web/learning/employer_resources/index.html
> >>>>>>> _______________________________________________
> >>>>>>> Gambas-user mailing list
> >>>>>>> Gambas-user at lists.sourceforge.net
> >>>>>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
> >>>>>>>
> >>>>> ------------------------------------------------------------------------------
> >>>>>> Minimize network downtime and maximize team effectiveness.
> >>>>>> Reduce network management and security costs.Learn how to hire
> >>>>>> the most talented Cisco Certified professionals. Visit the
> >>>>>> Employer Resources Portal
> >>>>>> http://www.cisco.com/web/learning/employer_resources/index.html
> >>>>>> _______________________________________________
> >>>>>> Gambas-user mailing list
> >>>>>> Gambas-user at lists.sourceforge.net
> >>>>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
> >>>>>>
> >>>>> ------------------------------------------------------------------------------
> >>>>> Minimize network downtime and maximize team effectiveness.
> >>>>> Reduce network management and security costs.Learn how to hire
> >>>>> the most talented Cisco Certified professionals. Visit the
> >>>>> Employer Resources Portal
> >>>>> http://www.cisco.com/web/learning/employer_resources/index.html
> >>>>> _______________________________________________
> >>>>> Gambas-user mailing list
> >>>>> Gambas-user at lists.sourceforge.net
> >>>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
> >>>>>
> >>>> ------------------------------------------------------------------------------
> >>>> Minimize network downtime and maximize team effectiveness.
> >>>> Reduce network management and security costs.Learn how to hire
> >>>> the most talented Cisco Certified professionals. Visit the
> >>>> Employer Resources Portal
> >>>> http://www.cisco.com/web/learning/employer_resources/index.html
> >>>> _______________________________________________
> >>>> Gambas-user mailing list
> >>>> Gambas-user at lists.sourceforge.net
> >>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
> >> ------------------------------------------------------------------------------
> >> Minimize network downtime and maximize team effectiveness.
> >> Reduce network management and security costs.Learn how to hire
> >> the most talented Cisco Certified professionals. Visit the
> >> Employer Resources Portal
> >> http://www.cisco.com/web/learning/employer_resources/index.html
> >> _______________________________________________
> >> Gambas-user mailing list
> >> Gambas-user at lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
>
> ------------------------------------------------------------------------------
> Minimize network downtime and maximize team effectiveness.
> Reduce network management and security costs.Learn how to hire
> the most talented Cisco Certified professionals. Visit the
> Employer Resources Portal
> http://www.cisco.com/web/learning/employer_resources/index.html
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
--
Kind regards,
Willy (aka gbWilly)
http://gambasshowcase.org/
http://howtogambas.org
http://gambos.org
More information about the User
mailing list