Solved

Linking Filemaker records to files on a hard disk

Posted on 2004-04-04
14
343 Views
Last Modified: 2010-04-27
Hi -

I have a FM database that has info on thousands of sound files. There is even a container field where I can import an mp3 so I can hear the sound.

Now that I have a hard disk big enough to hold all these files, is there a way to link all the soundfiles with their proper filemaker records so I can hear them from within FM?  The filename field in FM always is the same as the file name on the hard disk, except for the suffix (.mp3, .aif, .sd2 - etc.)

The alternative seems to be to go to a record, click import, search for the file and click OK - thousands of times!

It would be nice, but not essential to be awarded points, if the solution allowed for relatively easy updating - as when new files are added, or when files for some reason are moved.

Thanks
0
Comment
Question by:drburt1
  • 6
  • 5
14 Comments
 
LVL 28

Expert Comment

by:lesouef
ID: 10761403
2 ways:

1
Use the folder import: this will import all files in a folder without specifying their names while importing 1 by 1 requires the name. But, if you move files, the link is lost, and that won't work for existing records.
2
Far better, the Troi File plug-in which allows to import a file of which the name is extracted/calculated from a field.
Moving the files in this case would only be a matter of changing the calculated path. And still a valuable investment, fmaker 7 is the same as 6 for this matter.
0
 

Author Comment

by:drburt1
ID: 10777170
Hi -

Thanks for your quick response.

I have the Trois Plugin, but I don't see how that will solve my problem of creating a dynamic link between the sound files on the HD and the records in the FM database.

Files on the hard drive may be moved or added to.

Did you have in mind some kind of calculated field using Trois that would serve as the match field when Importing?

Thanks,
0
 
LVL 28

Expert Comment

by:lesouef
ID: 10777505
I am not sure I understand 100% yr question.
I am doing this with images, this may not fully apply to other type of media files.
I use FilereferenceToClip to import an image of which the path is calculated from other fields.
The restriction seems to be on the fact that it uses the clipboard.
What platform do you use? mac or pc? what type of sound file? supported by the OS (condition for FM to play it directly) or do you need an external app to play it?
When I'll have a bit of time, I'll try to simulate what you need, but this won't be before next WE.
In between let me know the anwsers to the above questions.
0
 

Author Comment

by:drburt1
ID: 10780371
Hi -

I'm using Mac OS 9.2.2, FM 6. The sound files are .mp3 which can be played from within my FM container field.
(I am anticipating trouble when and if other sound fornats are used, but that is not part of my question here.)

While waiting for your response, I will try to get  to know Filereference to CLip better.

Thanks
0
 

Author Comment

by:drburt1
ID: 11062972
Hi leseouf -

Did I miss your response? I thought you would be free in a week...

Still need h e l p...
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 28

Expert Comment

by:lesouef
ID: 11065834
No, I completely forgot about it! probably doing too mny things at the same time...
And I need to try that in the office, I only use a PC at home while I have both machines in the office. So, I'll try tonight.
0
 
LVL 28

Expert Comment

by:lesouef
ID: 11070286
Just tried, I am confused now because the regular Folder import does that for images and sounds/movies. So what more do you need?
File/Import/Folder...
You show which folder to import, and it can even strip the path and store it in a separate field while storing a link to the real sound file in the media field.
Only drawback: should not be moved afterwards, but if you sort them properly before importing, that should do it.
Do you need more?
The troi file plug-in (according to documentation, not tested) import also movies (therefore sounds), but not with 'reference to clip' which is dedicated to images. The only advantage with it is that you can move images, since the path is used to locate the mp3 files while the path you get from teh regular function of FM is just for info, altering it does not tell the sofwtare the image has moved!
let me know how you like the basic FM function (needs quicktime installed of course)


0
 

Author Comment

by:drburt1
ID: 11073131
Please remember that I already have a database with info on thousands of soundfiles. The regular  FM import procedure you describe would have to be done thousands (30,000!) times to import each soundfile into the proper record.

The database has only the filename, not the path to the file.

Is there a way to use match fields when importing in this case?

I also need to be able to refresh the link between the database record and the soundfile to accomodate moving the files, deleting files, and adding new files.

Quicktime is installed and the sound playback perfectly from within the database, so that is no problem at least.
0
 
LVL 28

Expert Comment

by:lesouef
ID: 11074243
If you use this folder import in a separate base, with name extracting, you can then link it to your existing one via the sound name to recurerate existing info? And this should be quicker than anything else.
But to accomodate moving files, nothing magic, except respecifying the path with the Troi file plugin.
The protolight file toolbox may be of some help for this too: http://www.geocities.com/SiliconValley/Network/9327/plPLUGs.html
0
 

Author Comment

by:drburt1
ID: 11504765
Hi -

I tried to add the following comment months ago - I am surprised to see it was not added:


I follow you about doing a one-time folder import into a separate database.

And I have gotten the two databases linked via the filename,

I lose you  where you suggest 'respecifying the path' with the Troi Plug In.

I need a step by step explanation of what this means.

(BTW, Will it help the problem of handling additions and updates?)

0
 
LVL 28

Accepted Solution

by:
lesouef earned 250 total points
ID: 11505072
The trio file plug-in is able to do file manipulation on files of which the path is in a field.
If you move files, and change the path field accordingly, it will still be able to access it.
If you want them to be automatically located, the plug-in had a locating function ('exactname')which is described in their example files (datain.fp5 contained in the demo zip file)
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now