Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #3128

Re: Container Problem: File Cannot be Found

Show all headers | View raw

On 2018-04-15 06:25:44 +0000, Erik Appeldoorn said:
> Op 15-4-2018 om 00:07 schreef Helpful Harry:
>> On 2018-04-14 18:59:56 +0000, Charles H. Sampson said:
>>> Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:
>>>> On 2018-04-09 16:23:16 +0000, Charles H. Sampson said:
>>>>> Charles H. Sampson <csampson@inetworld.net> wrote:
>>>>>> 
>>>>>> I'm creating a largish database that contains pointers to music files
>>>>>> (.aif) in containers. The database has reached over 1000 records in the
>>>>>> that use the containers. I've just noticed that over 500 of them now
>>>>>> display the message "The file cannot be found". I got this message once
>>>>>> before when I changed the name of the disc the files are located on.
>>>>>> (They're all on the same disk.) I managed to fix it then, but I don't
>>>>>> remember how. In any case, there have been no new disk name changes.
>>>>>> 
>>>>>> Any ideas? In previous posts, the feeling was that containers are a
>>>>>> mess.
>>>>> 
>>>>> I've been working on this problem for a while and I've discovered a lot.
>>>>> My big conclusion is that containers are such a mess as to be unusable,
>>>>> so I'm giving up on this database and reverting to an organization of
>>>>> audio files that I control.
>>>>> 
>>>>> Now, some details. First and foremost, my problems were caused by
>>>>> changing the name of the disk (partition) that the files were on. Of
>>>>> course, I had put only a reference to the files into the containers.
>>>> 
>>>> The field store the filepath, so that includes the drive / volume name.
>>>> Changing the drive's name means FileMaker can no longer find a drive by
>>>> that name.
>>> 
>>> Sort of. And that's why my script worked up to a point. But suddenly,
>>> the "filepath" returned by GetAsText didn't return the full filepath.
>>> What it did return was so minimally usable that I abandoned my script.
>> 
>> A very quick play with GetAsText shows that it returns two file paths - 
>> a truncated one and the full one.
>> 
>> The Container Field functions don't have anything to obtain the 
>> filepath (just the actual filename), which kind of shows that Continaer 
>> Field file storage / reference hasn't really been fully thought through 
>> properly.
> 
> as I wrote before, use a proper textfield to store your filepath. Use a 
> script to open the file it points to.

That would work if you want the file to be opened in another app, but 
not if you want it to work within FileMaker itself. For example, I have 
an old Star Wars database I downloaded years ago which plays the theme 
tune when you open the database (yes, it's annoying after the first 
couple of times, but it's only an example).

Helpful Harry   :o)

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

Thread

Container Problem: File Cannot be Found csampson@inetworld.net (Charles H. Sampson) - 2018-04-02 17:41 -0700
  Re: Container Problem: File Cannot be Found Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-04-03 13:36 +1200
    Re: Container Problem: File Cannot be Found ursus.kirk@gmail.com - 2018-04-03 10:09 +0200
  Re: Container Problem: File Cannot be Found csampson@inetworld.net (Charles H. Sampson) - 2018-04-09 09:23 -0700
    Re: Container Problem: File Cannot be Found Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-04-10 09:40 +1200
      Re: Container Problem: File Cannot be Found csampson@inetworld.net (Charles H. Sampson) - 2018-04-14 11:59 -0700
        Re: Container Problem: File Cannot be Found Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-04-15 10:07 +1200
          Re: Container Problem: File Cannot be Found Erik Appeldoorn <ursus.kirk@gmail.com> - 2018-04-15 08:25 +0200
            Re: Container Problem: File Cannot be Found Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-04-15 19:24 +1200

csiph-web