Weekly Consulting Report Generation Instructions

Michelle's Workflow

• Generating a Metadata Consulting Weekly Report
  • Add RW's tasks to timekeeping database
    • Add Tasks Completed last week
      • Open Completed Report name="YYYY-MM-DDcompleted"
      • Edit Completed Report
        • Add Project ID's to Report (use crib sheet ProjectIDs.csv)
        • Add new column to Report named "Staff"
        • Fill in the new "Staff" column with value="rwolfe"
        • Add new column to report named "Status"
        • Fill in the new "Status" column with value ="Closed"
        • Remove the character "m" from the values in the "Duration" column (select all the values in the column, then use find and replace to remove the "m". Be sure to restrict your replacement to "Current Selection Only")
        • Save Report
      • Import Completed Report tasks into "task" table of "timekeeping" FM Pro database
        • Open "timekeeping" Filemaker Pro database
        • Open "Task List" layout
        • From the File menu select "Import Records" in submenu choose "File..."
        • Choose the Completed Report file
        • Map the following fields from the Completed Report to fields in the "Task" table
          • Task for Time DB --> Don't import this field
          • Task --> task_name
          • Project ID --> associated_project_uniqueID
          • Project --> Don't import this field
          • Due Date --> task_estimated_completion_date
          • Completion Date --> task_completion_date
          • Duration --> task_time_old
          • Notes --> task_notes
          • Staff --> task_staff
          • Status-->task_status
        • Choose Import Action "Add new records"
        • Select "Don't import first record (contains field names)"
        • Click "Import" Button
        • Select "Perform auto-enter options while importing"
        • Click "Import Button"
        • Verify that the tasks made it into the Filemaker Pro database, You should see just the tasks that you added in the "Task List" layout
      • Export newly added records from Filemaker Pro database
        • From the File menu select "Export Records"
        • Choose Type "Comma-Separated Text"
        • Save file as "YYYY-MM-DDtask4time"
        • Choose "Current Table ("tasks") as the source of fields to export from the drop down menu
        • Select the following fields to export:
          • task_uniqueID
          • task_name
        • Click "Export"
      • Add new task_uniqueIDs to Completed Report
        • Open "YYYY-MM-DDtask4time"
        • Copy the contents of column A into the column "Task for Time DB" in the Completed Report (you will need to match up column B from "YYYY-MM-DDtask4time" with the column "Task" from the Completed Report in order to copy the contents of column A into the correct row of the Completed Report)
        • Save the Completed Report
      • Import Completed Report to "time" table of "timekeeping" FM Pro databse
        • Open "Time Detail" layout in the Filemaker Pro Database
        • From the File menu select "Import Records" in submenu choose "File..."
        • Choose the Completed Report file
        • Map the following fields from the Completed Report to fields in the "time" table
          • Task for Time DB --> associated_task_uniqueID
          • Task --> Nothing, don't import this field
          • Project ID --> Nothing, don't import this field
          • Project --> Nothing, don't import this field
          • Due Date --> Nothing, don't import this field
          • Completion Date --> time_date
          • Duration --> time_amount
          • Notes --> time_notes
          • Staff --> time_staff
        • Choose Import Action "Add new records"
        • Select "Don't Import first record (contains field names)"
        • Click "Import Button"
        • Select "Perform auto-enter options while importing"
        • Click "Import Button"
        • Verify that the tasks made it into the Filemaker Pro database, You should see be able to browse through just the records that you added to the "time" table.
    • Add Tasks Due this week
      • Delete rwolfe's open tasks in FM Pro