Thanks for all you help. I figured out why it saves as .zip instead of .odt. Apparently there a spaces at the end of the names in the database I'm using. So it looks like this to the Shell: name .odt with a space before the .odt
So my next question is can I remove the spaces?? On 04/03/2013 10:55 AM, Willy Raets wrote: > On Wed, 2013-04-03 at 19:36 +0200, Willy Raets wrote: >> 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!! >> > Some hints: > 1. For command always try --help 0r -h and study the command before > coding. We have to do the same to help you. Bit strange don you think > 2. Always try running your planned command in a terminal before coding > in Gambas > 3. Study Gambas documentation on what to use best for getting the job > done. Read every word over and over as every detail is important. > 4. When testing in Gambas add a Print sCommand before Shell sCommand so > that when running you see the string in the console of IDE. > 5. If command doesn't work from Gambas try Copy/paste that string in > Gambas IDE console to a terminal and try it there. If it doesn't work > there, it will never work in Gambas, so back to terminal testing, > adapting your sCommand and test app again. > > Keep doing this until it works..mind the details!! > > Good luck.. ------------------------------------------------------------------------------ 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
