dbTalk Databases Forums  

Inserting files from a folder

comp.databases.filemaker comp.databases.filemaker


Discuss Inserting files from a folder in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Dan Fretwell
 
Posts: n/a

Default Re: Inserting files from a folder - 11-15-2005 , 09:48 AM






I think you will need to use variables. So if your filename is in a
field Filename then

Set[$$filename;Value; Table::Filename]
Insert File[Reference;Table::container;"$$filename"]

In the Insert File file dialog box you put the name of the variable
$$filename not the name of the field. Filename.


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

Default Re: Inserting files from a folder - 11-15-2005 , 08:39 PM






To insert an image into a container field using the "Set Field" command
you need to see what FileMaker thinks the path to an image should be
called, 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

If your "Set Field" sets the container field to the image name eg.
"image:../desktop/8ball.tif" then the image displayed in the container
field


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

Default Re: Inserting files from a folder - 11-15-2005 , 08:57 PM



Bill Marriott wrote:
Quote:
And you
describe a fairly convoluted workaround you had to devise to overcome the
limitations of their implementation. (If you can't get TroiFile to manage a
folder with 30,000 images, then you have to either have users segment them
manually, or write another tool to handle it.)
The issue with having 30,000 images in a folder isn't with Troi-File
but with FileMaker, in version 6 it was limited to only accepting
64,000 characters worth of filenames.

I would have to agree with Remi, Troi-File has always been a rock solid
plugin for me.
The only issue I've ever had with it was creating a folder on Windows
and then creating a file in that folder, if I didn't put in a pause it
sometimes failed. However, I suspect this was an OS issue since the
same script never had problems on the Mac.
The Toronto film library has about 1/2 million images that are being
managed by the Troi-File plugin and no issues in terms of it freezing
the computers.

Unfortunately I can't comment on it with version 7 or 8.



Reply With Quote
  #14  
Old   
Bill Marriott
 
Posts: n/a

Default Re: Inserting files from a folder - 11-15-2005 , 11:46 PM



It's been a while since I used it, but couldn't a plugin of this sort have
been engineered to handle filenames differently then putting them all into
one field?

Using the DIR technique, you would be importing file names into multiple
records, presumably.

In any event, that is not the point. The issue is that when you build a
solution around a plugin, you have a whole raft of additional
considerations, including cost and upgrades (or no upgrades). If you want to
be the lucky one of the 1 in 50 who experiences a problem with such a
plugin, be my guest.

Bill


"FP" <ab (AT) pottnerconsulting (DOT) ca> wrote

Quote:
Bill Marriott wrote:
And you
describe a fairly convoluted workaround you had to devise to overcome the
limitations of their implementation. (If you can't get TroiFile to manage
a
folder with 30,000 images, then you have to either have users segment
them
manually, or write another tool to handle it.)

The issue with having 30,000 images in a folder isn't with Troi-File
but with FileMaker, in version 6 it was limited to only accepting
64,000 characters worth of filenames.

I would have to agree with Remi, Troi-File has always been a rock solid
plugin for me.
The only issue I've ever had with it was creating a folder on Windows
and then creating a file in that folder, if I didn't put in a pause it
sometimes failed. However, I suspect this was an OS issue since the
same script never had problems on the Mac.
The Toronto film library has about 1/2 million images that are being
managed by the Troi-File plugin and no issues in terms of it freezing
the computers.

Unfortunately I can't comment on it with version 7 or 8.




Reply With Quote
  #15  
Old   
Remi-Noel Menegaux
 
Posts: n/a

Default Re: Inserting files from a folder - 11-16-2005 , 01:57 AM



Troi File Plugin
Quote:
It's been a while since I used it, but couldn't a plugin of this sort
have been engineered to handle filenames differently then putting them
all into one field?
I got long ago some considerations from Peter Baanen and/or Diana
Budding from Troi - you should have a look at www.troi.com, there is a
lot there - , saying that some limits to plugin design from FMI API
made some techniques somewhat mandatory. For example you may reference
only the path of the actual image file (or even the transfer of the
actual image), but only through a fixed field. They named it
"impouniq.gif" (stands for Import Unique). Then Troi made a system of
list of all the files of the folder to be 'imported' in one (other)
field and they substract one filename at a time when the actual
(referenced or true) import is made trhough 'impouniq'.
BTW I saw on their site that the Troi File exists now for FM7.
It's a good reliable product, but it may be less useful with the new
versions of FileMaker.
Remi-Noel




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.