You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 28 Next »

Installation Options

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

FMP Interface Installation Files
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

  • No labels