dbTalk Databases Forums  

Storing PDF OLE via Calculation

comp.databases.filemaker comp.databases.filemaker


Discuss Storing PDF OLE via Calculation in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Maker Fan
 
Posts: n/a

Default Storing PDF OLE via Calculation - 08-18-2005 , 04:17 PM






Hi All,

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?

Many thanks.
ECC

Reply With Quote
  #2  
Old   
FP
 
Posts: n/a

Default 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
names.
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.


Reply With Quote
  #3  
Old   
Nando
 
Posts: n/a

Default 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
file here....


On 19 Aug 2005 11:16:05 -0700, "FP" <a (AT) pottnerconsulting (DOT) ca> wrote:

Quote:
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
names.
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.


Reply With Quote
  #4  
Old   
42
 
Posts: n/a

Default 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
says...
Quote:
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.
Calculations have "types" too. They can be numbers, text, containers,
and so forth.

Your calculation is almost surely defined to return a number (the
default).

Define it to be a container.

Quote:
I also did try to make a field the same as the container field and all
I get is a ? as a return.
How did you try to "make a field the same" as the container field?

Quote:
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
file here....
Please don't.


Reply With Quote
  #5  
Old   
Matt Wills
 
Posts: n/a

Default Re: Storing PDF OLE via Calculation - test.fp7 (1/1) - 08-20-2005 , 06:12 AM



Well well well.

Looks like we can attach binaries after all.

Matt


Reply With Quote
  #6  
Old   
Helpful Harry
 
Posts: n/a

Default 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>
wrote:

Quote:
Well well well.

Looks like we can attach binaries after all.
No, you can't. The attachment never came through to my newserver, for
example.

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
large attachment).

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)


Reply With Quote
  #7  
Old   
ursus.kirk
 
Posts: n/a

Default 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.

Ursus

"Maker Fan" <reef (AT) home (DOT) com> schreef in bericht
news:1gt9g1ld94n66ukp6lk8j2fpa55inq3e62 (AT) 4ax (DOT) com...
Quote:
Hi All,

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?

Many thanks.
ECC



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.