Installing FMP Interfaces

{panel:borderStyle=solid|borderColor=#CCCCCC|borderWidth=1|bgColor=#FFFFFF|title=Installation Options{color}}


FMP interfaces may installed on each user machine, or hosted on FMP Server.

* If installing on each user machine, simply follow the directions below, beginning with "FMP Interface Installation Files".
* If hosting FMP interfaces on FMP Server, you will only need to install the FMP software on each user machine, not the interfaces themselves.  Each interface hosted on FMP server will need to be configured for FMP network sharing via File > Sharing > Filemaker Network.  To access the interfaces, users will open FMP and select one of the hosted interfaces via File > Open Remote...

The following files are needed to install eSG Filemaker Pro interfaces:

1. FMP installation files (Win or Mac), updates, licenses
2. eSG FMP interfaces (latest versions)
3. ODBC driver - Win: http://dev.mysql.com/downloads/connector/odbc/ or Mac: http://www.actualtech.com/product_opensourcedatabases.php
4. FTPeek plugin (Win or Mac), licenses - [http://www.360works.com/ftp-plugin/]

   FMP Installation Steps 

   1. Install ODBC Driver

   ODBC driver may need to be installed on all machines accessing the database, not just FileMaker server. CASG discovered that the Execute SQL script step used in many of the FileMaker scripts will run only when a DSN on a local machine is present. CASG has not discovered a way to use the server DSN to run Execute SQL script.

   2. Add ODBC Data Source (you'll need to go through this twice, once for 'proposal_cycle_2' (RFP db) and once for 'mitsg' (PM db))

      

      Go -> Utilities -> ODBC Administrator
            System DSN
                 Add->Actual Open Source Database
                     License Key: #########################
                     Check for updates
                 Data Source Name: proposal_cycle_2 (for RFP data source), mitsg (for PM data source)
                 DSN Type: System
                 Description: proposal_cycle_2 (for RFP data source), mitsg (for PM data source)
                 Database Type: MySQL
                 Server: #####
                 Port: 3306
                 Checkbox 'Yes':  "Connect to server to obtain default settings…"
                 Login ID: fmpuser3cc / Password: *ask*
                 Database: proposal_cycle or mitsg
                 DONE

      

      

      Windows 7 : Start -> Run [C:\Windows\SysWoW64\Odbcad32.exe]
      Windows Vista and earlier : Start -> Control Panel -> Administrative Tools -> Data Sources (ODBC)
            System DSN
                 Add->MySQL ODBC 5.1 Driver->Finish
                 Data Source Name: proposal_cycle_2 (for RFP data source), mitsg (for PM data source)
                 Description: proposal_cycle_2 (for RFP data source), mitsg (for PM data source)
                 Server: #####
                 Port: 3306
                 User: fmpuser3cc / Password: *ask*
                 Database: proposal_cycle or mitsg
                 OK

   3. Install Filemaker Pro

   4. Install FTPeek plugin

       Copy appropriate plugin from folder '360Works+FTPeek-#' to 'extensions' folder of Filemaker Pro

   5. Register FTPeek plugin for this computer

       Open Filemaker Pro
       Filemaker Pro -> Preferences -> Plug-Ins
       select '360Works FTPeek' -> configure
       Registered to: ##############################
       License key: #####
       OK

   6. Clean-up