Or we assume that it does.īelieve me, it is spectacularly easier than it was under FileMaker 6.ĮTA 9 PM: saw a missing close parenthesis in formula.- Use filemaker pro to upload database files from your local drive to filemaker server- if a database uses container fields that store data externally filemaker pro also uploads the externally stored data- important database files must be closed before you can upload them- if you have a database open in filemaker pro choose file menu gt close. Maybe you have the path stored in fields somewhere so you don't have to, but if the images are being stored in container fields as references you might reconsider that.ī) tries to include the full path when calculating the other platform's path you need to use Substitute, as I did above, to get rid of the part that's wrong for whatever platform you're on at the moment and if you're on the same platform as was used to store the file in the first place, you only want the stored path, you don't want to alter it, it already works. $StoredPath=Middle($StringSource Position($StringSource "¶" 1 1)+1 Length($StringSource))] Ĭase(PatternCount ($StoredPath, "filemac")>0, $StoredPath, Substitute($StoredPath, "filemac", "filewin:/D:"),Ĭase(PatternCount ($StoredPath, "filewin")>0, $StoredPath, Substitute( ($StoredPath, "filewin:/D:", "filemac")Ī) does not use GetAsText to abstract out the path.
$StringSource = GetAsText(YourTable::ContainerField) You need a field, Displa圜ontainer, which is a calc field, of result type container, unstored, with this formula: So now let us say furthermore that IF the image had been stored in the container field by someone using a Mac instead, it would have been stored as this path instead:įilemac:/DATABASE/9276/Files/rfi/example.pdf Middle($StringSource Position($StringSource "¶" 1 1)+1 Length($StringSource)) $StringSource = GetAsText(XORelated::ContainerField) So since it's only the second line's worth of that that we want, we abstract it out, like so: What it would return is something more like this:įilewin:/D:/Database/9272/files/rfi/example.pdf
If you asked for GetAsText (YourTable::Containerfield), it would not return this:įilewin:/D:/Database/9276/files/rfi/example.pdf Let's say your container field contains this file, stored as a reference, and the file was stored on the PC: It works fine, you're just going about it wrong!
0 kommentar(er)
