Setting up FileMaker Pro to read the K4 database. 

Once I developed my SQL command I found it easier to run the SQL command in FileMaker Pro rather than Excel. While I would have preferred to run the SQL command in 4th Dimension because my presentation and analysis database is written in 4D, I could not get my SQL command to work in 4D. So I run the SQL query in FileMaker Pro and then export the database.

  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
8133893-8980388-thumbnail.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_2.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
8133893-8980388-thumbnail.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_1.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
8133893-8980388-thumbnail.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_2.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
8133893-8980388-thumbnail.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
8133893-8980388-thumbnail.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_2.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
8133893-8980388-thumbnail.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_1.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
8133893-8980388-thumbnail.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_2.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
8133893-8980388-thumbnail.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.
Finder_4.jpg
  1. Open FileMaker Pro. I am currently using version 8.5.
  2. Create a table with the following fields

    ObjectName Text Indexed
    Status Text  
    User Text  
    ObjectDateTime Timestamp  
    ObjectVersion Number  
    ObjectDuration Time  
    ObjectDurationMinutes Calculation =ObjectDuration/3600
    ObjectTime Calculation =Time ( Hour ( ObjectDateTime ) ; Minute ( ObjectDateTime ) ; Seconds ( ObjectDateTime ) )
    ObjectDate Calculation Date ( Month ( ObjectDateTime ) ; Day ( ObjectDateTime ) ; Year ( ObjectDateTime ) )
    Parent Text  
    ObjectID Number  
    ObjectType Number Indexed
    MonthName Text  
  3. Select File->Import Records->ODBC Data Source. . .
  4. Select the K4 database
  5. Enter the K4 administrator name and password
  6. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

    FROM objects, status, users, objectVersions, issues

    WHERE issues.name = 'January'

        AND objectVersions.objectID = objects.id

        AND objectVersions.statusID = status.id

        AND objects.issueID = issues.id

        AND objectVersions.createdUserID = users.id


  7. Either manually enter the SQL Query using the Query Builder or paste into the SQL Query the query created in Excel. Below is an example. To change the issue to be imported into FileMaker change the issue.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index, objects.parentID, objects.id, objects.objectType, issues.name

  8. FileMaker Pro can now be used to analyze layout and article data.