I want to zip files stored in my containers...
you will need a plugin
Take a look at base elements plugin
or MBS FileMaker Plugin
Monkeybread Software - MBS FileMaker Plugin: Component: Compression
A plug-in like MBS is probably the best route, but you can do all this zip programming for free if you can program Java a little and want to learn JDBC and use the FREE JDBC driver that comes with FMP. Free Zip APIs are a download away.
The only additional challenge is that FMP's JDBC driver is not that great with container fields and requires some "work-arounds" - but still do-able. (I've reported JDBC issues to FMP many months ago, but my reports have apparently little, if any, priority at FMI.)
Let me know if you are interested in learning how to program FMP with Java and I can send you some links!
HOPE THIS HELPS.
I am no JAVA expert.....but thanx a lot...if I could not find solution ..may be i will ask for it...
Using MBS function..I have to zip two doc files(in 2 different containers) as one, in third container....
MBS( "ZipFile.CompressFiles"; SourceFolder; ZipFilePath; FileList; Overwrite; CompressionLevel )
can i give two path? how?
I would check out MBS. Christian S. is hands-on with support and his plug-in has been around for a while. For what MBS costs, if you don't know Java, I think MBS would be a bargain.
OSX has zip command. Do you need on Windows?
yes ..I am working on win..
It may be a good time to switch to the Mac!
Typing "zip" at the mac command line, gives you the expected help text:
Copyright (c) 1990-2008 Info-ZIP - Type 'zip "-L"' for software license.
Zip 3.0 (July 5th 2008). Usage:
zip [-options] [-b path] [-t mmddyyyy] [-n suffixes] [zipfile list] [-xi list]
The default action is to add or replace zipfile entries from list, which
can include the special name - to compress standard input.
If zipfile and list are omitted, zip compresses stdin to stdout.
-f freshen: only changed files -u update: only changed or new files
-d delete entries in zipfile -m move into zipfile (delete OS files)
-r recurse into directories -j junk (don't record) directory names
-0 store only -l convert LF to CR LF (-ll CR LF to LF)
-1 compress faster -9 compress better
-q quiet operation -v verbose operation/print version info
-c add one-line comments -z add zipfile comment
-@ read names from stdin -o make zipfile as old as latest entry
-x exclude the following names -i include only the following names
-F fix zipfile (-FF try harder) -D do not add directory entries
-A adjust self-extracting exe -J junk zipfile prefix (unzipsfx)
-T test zipfile integrity -X eXclude eXtra file attributes
-y store symbolic links as the link instead of the referenced file
-e encrypt -n don't compress these suffixes
-h2 show more help
Since zip is available directly from the OS (or via right-click menu, etc.), you could even write a small shell script to zip files.
If you use "Winzip" on Windows, there's a free shell add-on called "wzzip". Using that extension adds ziping capability to the command line.
WinZip Command Line Support Add-On - WinZip Computing :: Knowledgebase
thanx a lot..I will
Another way on Windows is using vbscript. vbscript - Zip a folder up - Stack Overflow
export 2 field contents to a folder,
insert zip file insto 3rd container field.
Retrieving data ...