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

Groups > comp.databases.filemaker > #3127

Re: Container Problem: File Cannot be Found

Show all headers | View raw

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.
> 
> Helpful Harry  :o)
> 
as I wrote before, use a proper textfield to store your filepath. Use a 
script to open the file it points to.

Erik

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next 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