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...@gmail.com> 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" <sunblast...@gmail.com> 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...@gmail.com> wrote: > >>>>>> > >>>>>>> Replace, > >>>>>>> Replace all the words that match the pattern > >>>>>>> Read the doc! > >>>>>>> Le 3 avr. 2013 01:10, "rocko" <sunblast...@gmail.com> 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" <sunblast...@gmail.com> 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@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@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@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@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@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@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@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@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@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 ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
