Filemaker Referenced file filepath
There is File: paths and filemac: paths and filewin: paths
These paths can be relative - meaning the database and referenced files (pictures or PDFs or etc) are in the Filemaker folder or subfolder (directory or subdirectory) or subsubfolder (subsubdirectory)
IF the location is NOT in the Filemaker folder, it must be defined as an ABSOLUTE path
The paths can be absolute (meaning the path goes from HD (or server) to folder (directory) to subfolder (subdirectory) to possible subsubfolder (subsubdirectory) to filename.ext
Absolute paths can be local (on your computer) or remote (on a server or network drive)
You can make a set of fields for file: and filemac: and filewin:
PathHD is the harddrive or servername
PathDir (or PathFolder) is the top enclosing folder or directory
PathDir2 is the next enclosing folder or directory
ETC (keeping the files near the top level of the harddrive or server is smart)
PathFileName is the name of the file.
These Global Fields apply to all the referenced files (PathFileName is not Global)
A calculation field concantenates the Global fields and filename to the container path.
Thus if the location of the referenced files is changed - to another folder or another server or another harddrive, only one or two or three Global fields need to be changed to change all the paths for referenced fields.
The path to a target file specified from the current database’s location. If the current database is opened remotely, the path starts from the local FileMaker Pro directory
Absolute Full local or remote (Mac OS)
The absolute path to a target file or folder, either local or on a remote volume, beginning at the top level of the file system
Full local (Windows)
The absolute path to a target file or folder in Windows, beginning at the top level of the file system
EXAMPLE Drive C: in directory “MyDatabase” in subdirectory “Images” contains images or files (MyFileName01 eg.)
Full remote (Windows)
The absolute path to a target file or folder on a Windows volume shared using Windows file sharing
The network path to a container has a reference path to a file? FileMaker Pro file
That clears up quite a bit, but I do have another question with this part:
"Thus if the location of the referenced files is changed - to another folder or another server or another harddrive, only one or two or three Global fields need to be changed to change all the paths for referenced fields."
Where are these Global fields located? I am very fresh to FileMaker, so I apologise if this knowledge is more run of the mill.
Its s storage option under your field storage options.
Would thos be located under File > Define > File References, or possibly File > Define > Database? I actually cannot get into those two menus as the account I have isn't the admin account, but I am hoping I will get a callback later today with that info.
I imagine the admin account would be nessecary to make these changes, right?
Scratch my previous message, I have the Admin account credentials now. I've also learned that they use a plugin called Troi to help with the linking of the files and the database, does that ring any bells?
Sure. I use Troi File all the time.
It would appear that some background on my issue is in order at this point, as I was already looking up the Troi information and noticed a few things.
In the previous environment they were running FileMaker 7 Server Advanced on their OSX 10.4 server, and FileMaker Pro 7 on their three workstations. Their server (among other maintenance) is now running 10.5, which I am told is not compatible with FM7 Server Adv. Plans to upgrade to FileMaker 10 are underway, but nothing has been ordered yet. To just get things up and running for now I threw a copy of FileMaker 7 Pro on the server so that it could be set up for network sharing.
It would appear that Troi is a server-only plugin, or at least it will not work on Pro, is that the case?
At second glance, I don't see the Troi file resident in any of the server Library directories underneath the extensions folder, and I find that I am also mistaken in my original thinking and that it does work in Pro. Is it possible that the plugin simply never was on the server? Does Troi require the existance of Server or Server Advanced on any node on the network, or can it work in a purely Pro network?
Basically what this all boils down to is I know the data has moved and I want to make sure I have all of the settings changed that I need before I bring this server back. On the "Documents" tab my documents all have an incorrect file path listed, but I am not sure how to change that.
Also, shouldn't the user be able to open the document just by clicking its icon?
It can work in a purely Pro network.
I dont know much about your setup or why you no longer have valid paths. Switching out from server to a pro as a host shouldnt really have any impact if your system used the plugin to copy the file to a shared drive.
Well, previous the server had two, small drives with their Library related files on their first drive and their documents on the other drive (I.e. all the docs and pdfs etc that are referenced in the database. This second drive was named Docserver, and a folder on the root of it was called CompanyDocs. On the Admin tab of FileMaker Pro 7 when I open the database it shows a path of "Docserver:CompanyDocs". I figured this needed to be changed, but for some reason it doesn't appear to be changing. What makes me think this is at the bottom of the Admin tab there is a text box that you can type in, and I have changed it to be "Company 500gb RAID: Docserver:CompanyDocs", (Note, while the quotes are actually in what I typed, the extra space after a colon is not and was added here to avoid making a smiley) with Docserver in this latter case simply a folder on the root of the drive. Essentially, its HDName:Subfolder:Subfolder. However, after I click update and close and reopen the file though the text I put in still shows beneath it I see a line of text displayed showing the old location.
However, a thought occurs. The Docserver drive is a share on the machines. Is it possible that the Troi plugin, running locally on the workstations, was seeing this Docserver share and the CompanyDocs folder within?
Given that Docserver was the server name, drive name, and share name I'm really trying to weed out what is what.
Possibly some pictures may be of help? Note that essentially when you see Company you can read it as Merit. The pathing below is actually Merit 500gb RAID: Docserver:MeritDocs, despite what the text says.
This is what I see now on a document:
You can see the path in that document is still the old location, so one concern of mine is how to change it.
"Is it possible that the Troi plugin, running locally on the workstations, was seeing this Docserver share and the CompanyDocs folder within?"
The only way to tell is follow the scripting.
I can not see your images because of a company firewall.
Would such scripting be client side? Also, how can it be accessed?
Well firs you would need an account that has access to the scripts. Then you can open the manage script window. Find the script and trace.