See also

• CCB Instruction's ChemGrades FMPro DB support procedures

Links

When completed, here's the URL for the read-only web access:

...

A control table in FMPro (or edit via web directly?) with who can see what via the Grades web application:

Decide on date to turn on web application for student use

...

• Ensure that all "single account set up for a whole course for use by many TAs" is cleaned up. (Legacy capability which is no longer needed. And confuses things now.)
  • Dani and PatH
• Ensure works from systems at: TA room, DanL, and Sam's.
  • MichaelH.

Previous:

Done: Establish procedure for PatH to update web-hosted data. "Push the button".

As of 10/17/16, this was done several years ago. (As of 8/16/13, function doesn't exist for PatH.)

• Requires ODBC connection. Not possible at FMPro server; must be set up at FMPro client's computer.
  • Do for PatH's computer. As backup, do on Sam's computer.
  • Current plan: For each computer, set ODBC up as system's Admin (vs. user) so ODBC accessible/ configured for any computer account.

Done: Fulfilled Becky's needs of Grades DB

...

LabSer's AD group (3 staff) added to access FMPro DB with read-only access. Access is done for specific classes:

• Setup AS-CHM-LabSvc to read only access of 1560, 2070, 2080, 2090, 2150, 2510, and 3010.

Becky confirmed access to relevant course via <grades.chem.cornell.edu>, within her FMPro (Mac) DB, and successful import.

Access is done for specific classes.

Past notes:

• Any benefit in changing the current "export" process?
• Create appropriate "read-only" account for Becky to allow her to continue doing exports herself.
  • Roger (working with Becky)
  • Outline some options, for later focus. (Unlikely do any other changes right now!)

...

• Change all TA access to be by NetID (and FMPro p/w), instead of their name.
  • This keeps the access process the same as it was, but:
    • Enables the correct access restrictions via the web application.
    • Facilitates transition to trueNetID-based access, as a future project.

Establish

...

As of 8/16/13, function doesn't exist for PatH.

• Requires ODBC connection. Not possible at FMPro server; must be set up at FMPro client's computer.
  • Do for PatH's computer. As backup, do on Sam's computer.
  • Current plan: For each computer, set ODBC up as system's Admin (vs. user) so ODBC accessible/ configured for any computer account.

Establish semester-start procedures and processes. Includes:

...

• PatH pulls the final data from the backups.
  • NOTE: If an edit is done, must wait until that edit shows up in a backup (~ half a work day) and then that backup becomes the "final data" for that course.
• PatH zeroed out each of the ChemGrades DBs before the start of their next use.
  • PatH does this within FMPro, when she needs it done (varies by course).
• Cut off TA's access to FMPro.
  • PatH does this within FMPro, when she needs it done (varies by course?).
• Some courses must not show the grade of the final exam, per faculty member's requirement.
  • In those cases, PatH will simply not "push" her final data to the web (varies by course).
    • For these courses, grade changes for a student done after the last push (right before final exam grades entered into FMPro, ideally) will thus not show up on the web.
      • These are edge/ rare cases and PatH will inform the student of this fact.

...

• What is done now for the Waiting List web application? Do same thing?
• Would it not be PatH's office? If so, how communicate on the page?

Keywords, for searching results

• FileMakerPro