dbTalk Databases Forums  

fmp11adv linking pdfs/folder with database

comp.databases.filemaker comp.databases.filemaker


Discuss fmp11adv linking pdfs/folder with database in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
~consul
 
Posts: n/a

Default fmp11adv linking pdfs/folder with database - 12-08-2010 , 04:47 PM






I know that we can drap/drop a pdf file into the database so it resides within the database, but that will eventually make the file super large over time as it contains both the database and the pdf. A couple of years ago when I was in fmp6, I had about 30k records, and inserted 1pdf for about 3k records, and it caused instability and corruption of the file where random data in random records got lost.
Or would fmp11 not have this same size limit?

I was wondering if when you drag/drop you can just have the file location path?
I am reading that it has to be in the Web folder in the fmp11adv for it to link in the container.
Would fmp11server help out?
--
"... respect, all good works are not done by only good folk. For here, at the end of all things, we shall do what needs to be done."
--till next time, consul -x- <<poetry.dolphins-cove.com>>

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

Default Re: fmp11adv linking pdfs/folder with database - 12-09-2010 , 08:28 AM






On Dec 8, 11:47*pm, ~consul <con... (AT) dolphinsTAKEAWAY-cove (DOT) com> wrote:
Quote:
I know that we can drap/drop a pdf file into the database so it resides within the database, but that will eventually make the file super large overtime as it contains both the database and the pdf. A couple of years ago when I was in fmp6, I had about 30k records, and inserted 1pdf for about 3k records, and it caused instability and corruption of the file where random data in random records got lost.
Or would fmp11 not have this same size limit?

I was wondering if when you drag/drop you can just have the file locationpath?
I am reading that it has to be in the Web folder in the fmp11adv for it to link in the container.
Would fmp11server help out?
--
"... respect, all good works are not done by only good folk. For here, atthe end of all things, we shall do what needs to be done."
* *--till next time, consul -x- <<poetry.dolphins-cove.com
I have given up the filemaker container field, and use supercontainer
from www.360works.com instead. I use this for documents and images,
and also for webpublishing on my webpage www.bookingservice.no
Regards Nicolay

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

Default Re: fmp11adv linking pdfs/folder with database - 12-09-2010 , 04:36 PM



On 9/12/10 9:17 AM, ~consul wrote:
Quote:
I know that we can drap/drop a pdf file into the database so it resides
within the database, but that will eventually make the file super large
over time as it contains both the database and the pdf. A couple of
years ago when I was in fmp6, I had about 30k records, and inserted 1pdf
for about 3k records, and it caused instability and corruption of the
file where random data in random records got lost.
Or would fmp11 not have this same size limit?

I was wondering if when you drag/drop you can just have the file
location path?
I am reading that it has to be in the Web folder in the fmp11adv for it
to link in the container.

Have never had issues with PDF inserts. These days I usually create a
separate file for images and document tables, in addition to the main
data file (data separation model; user + 2 data files). That generally
allows emailing the main data file (smaller) if necessary.



drag and drop does not work for me

insert file as reference


create a calc (or auto enter text calc) field
GetAsText(<container_field>) to evaluate the path, example result:
file:a.pdf
filemac:/data/cortical/Desktop/a.pdf



Quote:
Would fmp11server help out?
the FM file can reside on the server if need be, and one can insert
referenced local files. If things change however (paths...) references
will of course be lost. So an auto enter text calc will retain the path
info, and manipulations can be undertaken...

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 - 2012, Jelsoft Enterprises Ltd.