Storing PDF OLE via Calculation - 08-18-2005 , 04:17 PM
I want to create a database where I store a PDF item in a container. I
want to get the PDF preview in my layout as when I drag the pdf into
the container field.
I have thousand of drawing items of which I want to create records of.
This would be to ardous a task to do manually. I want to be able to
create a calculation field that would automatically load the PDF into
the container based on the following. Each Record will have a field
Called "Item No". The files are stored in our server in a path like
\\My-Server\Drawings\ ( a folder with an item number)\(Item No).pdf
I have tried all kinds of combinations Calculation and Container
options to create this autocalculation but the best I get is a pdf
icon inside the container. I want to see the pdf preview so I can see
what the drawing is about.
Does anyone know how this can be done...if at all?
Re: Storing PDF OLE via Calculation - 08-19-2005 , 01:16 PM
Not sure if this is what your looking for, but you can insert the image
of a pdf into a container field using the "Set Field" command.
This does however require that you already have the path and image
To see what FileMaker thinks the path to an image is, do the following;
- create a container field "MyContainer" and insert a picture into it
manually using the store as reference option
- create a calc text field which has the calculation "My Container" (I
know this seems weird)
- when viewed on the layout the text field gives the image size and the
path to the image eg. "image:../test/3.pdf"
Using a script you can create the records and Set the field
"MyContainer" to the image paths eg. "image:../test/3.pdf". This
should display the image in the container field.
Re: Storing PDF OLE via Calculation - test.fp7 (0/1) - 08-19-2005 , 11:15 PM
Hi, thanks for the reply.
When I create a calculation field to be equal to the container field,
all it shows is a value of 0.
I also did try to make a field the same as the container field and all
I get is a ? as a return.
This is why it seems like I cannot create a container's content via a
calculated field. It is driving me nuts!! I am attaching the test
On 19 Aug 2005 11:16:05 -0700, "FP" <a (AT) pottnerconsulting (DOT) ca> wrote:
Re: Storing PDF OLE via Calculation - test.fp7 (0/1) - 08-20-2005 , 12:34 AM
In article <s6vcg1dsaqi2sevb83jmqtef57ruahudb7 (AT) 4ax (DOT) com>, not (AT) now (DOT) com
and so forth.
Your calculation is almost surely defined to return a number (the
Define it to be a container.
Re: Storing PDF OLE via Calculation - test.fp7 (1/1) - 08-20-2005 , 03:53 PM
In article <xeENe.1162$SW1.276@trndny09>, "Matt Wills" <I'm (AT) Witz (DOT) end>
As I said, many newservers simply drop off the attachment, so it
doesn't get copied to other newsservers around the world. ONLY
newsgroups with "binaries" in the title accept attachments (and even
then many newsservers are so hopeless that they never get all of a
Hopefully helping harassed humans happily handle handiwork hardships ;o)
Re: Storing PDF OLE via Calculation - 08-21-2005 , 05:55 AM
Images do work this way, but pdf's don't. My best guess is that you may be
able to mass convert all your pdf's into images.
"Maker Fan" <reef (AT) home (DOT) com> schreef in bericht
news:1gt9g1ld94n66ukp6lk8j2fpa55inq3e62 (AT) 4ax (DOT) com...