dbTalk Databases Forums  

Inserting Files into Muliple Fields

comp.databases.filemaker comp.databases.filemaker


Discuss Inserting Files into Muliple Fields in the comp.databases.filemaker forum.



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

Default Inserting Files into Muliple Fields - 06-15-2005 , 08:04 PM






I have FMP7 for mac. I have a very large database of records. Each
record corresponds to a sound file. I want to be able to "insert" each
file as a sound reference into a Field Container. I can do it one at a
time, manually. To do the whole database would take forever. Is there
anyway to set up a SCRIPT that is able to read a field of the database
(the sound files NAME as it appears on the HD), search for that sound
file on that external HD, then insert it into the proper Field
Container? Any help or ideas is greatly appreciated.
M


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

Default Re: Inserting Files into Muliple Fields - 06-16-2005 , 09:40 AM






This is merely a suggestion as to what to try. This technique works as
described in Winduhs. But until I can get a new Mac, I am still using FMP6
on OS 9.1, and have not seen it work on a Mac.

Rather than actually making the sound file part of the database, it
incorporates a reference to the sound file.

Look at "Defining File References" in Help.

If the file locations are definable as a calculation, you should be able
to create something like

File = "filemac:/volumeName/directoryName/" & SoundFileName

returned as a container, and (hopefully) there's your sound file in the
layout.

Matt

On 6/15/2005, mpollon wrote:

Quote:
I have FMP7 for mac. I have a very large database of records. Each
record corresponds to a sound file. I want to be able to "insert" each
file as a sound reference into a Field Container. I can do it one at a
time, manually. To do the whole database would take forever. Is there
anyway to set up a SCRIPT that is able to read a field of the database
(the sound files NAME as it appears on the HD), search for that sound
file on that external HD, then insert it into the proper Field
Container? Any help or ideas is greatly appreciated.
M

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.