Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #669

Re: Images & Container Fields

Show all headers | View raw

In article <41c4d$4f528633$535375e6$20653@cache50.multikabel.net>,
 <Ursus> wrote:

> Hou je goed / keep well,
> 
> Ursus
> "Keith"  schreef in bericht 
> news:5b4a30f9-b070-4483-88cb-8088448de3bb@s13g2000yqe.googlegroups.com...
> 
> Hello,
> 
> I'd like some help with container fields.
> 
> MAC, LION, FMP ADVANCED V11.0v4
> 
> I have a friend who wants to categorize a toy collection.
> 
> She has taken about 100 digital pictures of this collection & has
> transferred them into her MacBook Pro.
> 
> When in front of her machine, what I see is a screen showing these
> pictures in IPhoto
> 
> My goal is to place each of these images in its own corresponding
> record identified by an auto entered serial number which is already in
> the record.
> 
> Eventually, I would like to make a catalog which potential buyers
> could look through for a possible purchase.
> 
> I know absolutely nothing about digital cameras & even less about
> IPhoto so I am in need of detailed help such as :
> 
> - Do I need a separate 'jpg document' for each image ?
> - Should I make a separate table in her database to house the images ?
> - Is there a way to get the Id "in" the photo title automatically such
> as Foto#_ID#.jpg ?
> - What is the best way to 'import' or 'paste' the individual images in
> each record ?
> 
> It would be nice to offer any other suggestions you may think of.
> 
> Thanks very much for any help,
> 
> Francois
> -----------
> 
> create a table with the following fields
> 
> PhotoID (auto-entered id)
> file name (text)
> file path (text)
> image (container)
> 
> goto browse and goto menu File > Import Records > Folder
> click the button specify an dfind the folder that contains all the images
> select  include all enclosed folders if you have multiple folders inside the 
> parent folder
> Select File Type > Picture and movie files
> select Import only reference (smaller filemaker file, but you need the 
> images to be in place all te time) unselect it will import image files into 
> filemaker.
> click continue
> wait until next window appears (import Field Mapping)
> goto the field Arrange by and select Field Names
> Now click import
> Filemaker now imports all images
> where the file name gets to bi in the field with that name
> 
> happy filemaking, Ursus

I agree with Ursus, just want to comment a bit more about storing a 
reference to the picture in the container field vs storing a copy of the 
photo itself.

Staring only a reference makes the FileMaker database smaller then 
storing the actual picture. However, the reference has to remain valid 
in order to show the picture, which means you cannot move or alter the 
referenced pictures. This could be a problem especially if you want to 
copy the database to a different platform.

Storing the picture itself makes the database larger, but it also means 
the database is independent of the external picture file. You can then 
move or delete the external picture file, or move a copy of the database 
to a different location, and the pictures will still be there.

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Images & Container Fields Keith <francois7675@gmail.com> - 2012-03-03 05:16 -0800
  Re: Images & Container Fields <Ursus> - 2012-03-03 21:59 +0100
    Re: Images & Container Fields Bill <bbcollins@earthlink.net> - 2012-03-03 21:30 -0500
      Re: Images & Container Fields Martin Τrautmann <t-usenet@gmx.net> - 2012-03-04 05:43 +0000
  Re: Images & Container Fields HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-03-04 10:04 +1300
  Re: Images & Container Fields Keith <francois7675@gmail.com> - 2012-03-03 20:48 -0800
    Re: Images & Container Fields Martin Τrautmann <t-usenet@gmx.net> - 2012-03-04 05:52 +0000
  Re: Images & Container Fields Keith <francois7675@gmail.com> - 2012-03-04 11:11 -0800

csiph-web