Arts and Science IT's FMPro server

• filemaker.chem.cornell.edu (v11 FMPro server)
• fm14.chem.cornell.edu (v14 FMPro server)

Update from April 2017

Chemistry IT (only!) upgraded their 2 FMPro DB's (Inventory, Billing) to A&S's v14 serve

• ChemIT staff are to use the v16 client to access those servers.
• v11 client is still required to access older FMPro DBs used throughout department (and college).

Usage Tricks

• Operators for refining search requests:
  • http://help.filemaker.com/app/answers/detail/a_id/13715/~/refining-find-requests-in-filemaker-pro-using-find-operators
• Replace value of a field within a found set (CAUTION!):
  • https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/replacing-field-contents.html

Version 16 Install (ChemIT usage)

• Grab application file from the file share ("\\chemit.chem.cornell.edu\chemit-files" and select Windows→Applications→FileMaker→FileMaker16→FMPro16 (both Windows and MacOS options are included there))
• Move to the desktop; Keep access to the file share 
• Run the Application, it will install a folder with the setup on the desktop
• Run the setup file found in the folder 
• Once prompted, the username, organization, and license keys are found in the licensing file within the FileMaker16 folder on the file share

The program will also request to download Bonjour for windows; DO NOT allow it.

Once finished, FileMaker Pro 16 should be accessible and usable. Delete the original application file and folder on the desktop. 

Prior Info

Version 11, not 12, for ChemIT's use.

To install FileMaker Pro:

1. Under "Computer," click "Map network drive" at the top bar
2. For folder, type "\\chemit.chem.cornell.edu\chemit-files"
3. Select Windows>Applications>FileMaker>FileMaker11>FMPro11 (For windows) or Macintosh>Filemaker>Filemaker11 (For Macs)
   1. Enter your log in credentials (your netID). You may need to be added to the ChemIT permissions group first.
4. Complete installation with on screen prompts
   1. The license key is provided in a text document in the FileMaker11 folder
5. Update FM11 using the updater in the same folder as the installer. Use the latest version.

To access the inventory file:

fmnet:/filemaker.physics.cornell.edu/IT-ChemInventory

OR

fmnet:/filemaker.chem.cornell.edu/IT-ChemInventory

1. Mount "\\files.cornell.edu\AS\CHM\DEPT"
2. In "Chem IT" > "Inventory" copy over "Inventory auto" file to your desktop.
3. Open and enjoy.

For filemaker 11 under MacOS Sierra:

• If you get an error saying the app was incorrectly installed follow the steps below
• Remove the installed version of filemaker.
• Make a copy of the installer on the desktop.
• Right click (Ctrl+click) and click on show package contents.
• Copy out the Assisted Installer.txt file and open it.
• Input the license code (fileshare) and the Name (Chemistry and Chemical Biology) along with the organization (Cornell University) in the .txt file.
• Copy the file back over to the installer and launch it.

Keywords

FM, FMPro, File Maker Pro, FileMakerPro, FileMaker.