Versions Compared

Old Version 26

changes.mady.by.user W Benjamin Bray

Saved on

compared with

New Version 27

changes.mady.by.user W Benjamin Bray

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderColor#CCCCCC
bgColor#FFFFFF
borderWidth1
borderStylesolid

...

Installation Options

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

Section

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))

    Image Modified

   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

   

    Image Modified

Wiki Markup
_   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

Section