Thanks for the input Tim :) I will be using a separate file for the PDF´s. It is a requirement from the tax authorities to keep it on a hard disk. But I also need to be able to see it "on-the-fly" during daily routines hence the container fields....
It wont be that much, maybe a few hundred over the each year and each PDF under 100kb. I think I will use the applescript method to mount the MacMini volume. Since each PDF is only one A4 it would be even better to store it as a picture so I could see the invoice in one layout. But when I use the steps Go to field(container) and then Insert picture(myfile) it can not find the file. But Insert file(myfile) works. If(Get(SystemPlatform)=1;"filemac:";"filewin:") & Get ( TemporaryPath ) & Invoices::_id & " - JobRef.pdf" Any ideas on that? Regards, Aki From: Tim Mansour <[email protected]> To: [email protected] Date: 10.11.2011 23:23 Subject: Re: PDF into a container field, email it and save on a disk - all within the same script? On 10 November 2011 21:47, Aki Armann Jonsson <[email protected]> wrote: > It would also be nice to be able to save the PDF's in a designated folder on > the MacMini. I hope this is not a silly question... If you're going to save the PDFs into a FileMaker container field then why would you bother also saving them on the file system? I wonder if choosing between one of those methods might be better? In my experience, while it's convenient to have stuff stored in container fields, over time it means your database can get big and cause headaches for backups (another suggestion is to give serious consideration to having the container field in a separate FileMaker file). Saving to your Mac mini server can be done by exporting the container field contents to the mounted volume; you can make sure the volume is mounted first quite easily via an AppleScript. Kind regards, Tim. -- Tim Mansour <[email protected]> Neologica Print & Promotions ABN 63 904 335 408 Certified FileMaker 10 Developer PO Box K1163 : Haymarket NSW 1240 Mobile 0405 500 846
