*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
| Excerpt |
|---|
Making CCB's very important ChemGrades DB more robust, and enabling necessary increased functionality, especially for teaching faculty and students. Ensuring its long-term support and operation. Representing customer is Pat Hine 's (PatH). |
| Table of Contents |
|---|
See also
Links
When completed, here's the URL for the read-only web access:
...
Updates
9/13/13
Scheduling Faculty meeting to present web service, PatH and Dani
- Thur, 9/26/13, 2:30pm.
8/16/13
...
None, as of 9/13/13.
Projects anticipated to start-up, once everything is settled and working
...
- For all TAs and for all staff.
- Expect prep work in fall 2013.
- Thus, expect implementation/ cut-over no sooner than winter break.
...
- Any benefit in changing the current "export" process?
To do's for this project
See the following section for context related to these to-do's.
New as of 9/13/13:
Scheduling Faculty meeting to present web service
Lead(s): PatH
- Proposed date: Thur, 9/26/13, 2:30pm
- With assistance from Dani in presenting.
Add permission access to Grades web application
Lead(s): Tu
A control table in FMPro (or edit via web directly?) with who can see what via the Grades web application:
| Faculty | Grad TAs | Students |
|---|---|---|---|
Course1 |
|
|
|
Course2 |
|
|
|
Course3 |
|
|
|
Decide on date to turn on web application for student use
Lead(s): Pat
Do after 1st prelim. Maybe Oct 31st, Thur.?
Who do students contact if they have questions or concerns about the web site?
...
- Add (or find existing) field to hold TA name.
- In existing "TA" field (currently holding the TA name!), enter TA's NetID
- Ensure Pat enables ~"reset password on next use" checkbox.
Previous:
Done: Enable Pat's "push" capabilities so her DB info can be seen on the web
Lead(s): Tu
- Tu will work with Roger.
- Tu needs IP addresses. Roger can do the installs.
- And Roger may have better alternatives. :-)
Done: Confirm PatH's MacroExpress scripts work with server-based FMPro.
Lead(s): PatH
- PatH to confirm right away.
Test PatH's restore procedure.
...
- Do ~end of Sept? (No later, please!)
- To be done by PatH. Presumably via self-service. :-)
Try with course 3570 (no TA data). Do with Dani.
...
Ensure FMPro access by Cynthia
Lead(s): Oliver
- ChemIT must do this. Oliver must do or assign.
Done: Enable ChemIT staff's access to CCB FMPro DBs.
Lead(s): Roger
- Do via AD group. Enable only "Admin" accounts, not ChemIT staff's user accounts. (Right, Roger?)
- Roger to work with/ keep Tu informed.
Ensure FMPro access by TAs and a few staff
PatH, MichaelH, and Roger
- Report from Pat and Dan that Cynthia was not able to access the FM DB.
- Tu asks: Was Cynthia in the AD group <as-chm-GradAdm>? Answer: No!
- Oliver added her to the group, 9/13/13 and wrote her to tell her to try again.
- Tu asks: Was Cynthia in the AD group <as-chm-GradAdm>? Answer: No!
Done:Lead(s): PatH, MichaelH, and Roger
- 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, CynthiaK, and Sam's.
- MichaelH.
- 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
10/28/2013Mon: MichaelH completed this, following Oliver speaking with Becky and Pat.
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.
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!)
Done: Enable Pat's "push" capabilities so her DB info can be seen on the web
Lead(s)
...
: Tu
- Tu will work with Roger.
- Tu needs IP addresses. Roger can do the installs.
- And Roger may have better alternatives. :-)
Done: Confirm PatH's MacroExpress scripts work with server-based FMPro.
Lead(s): PatH
- PatH to confirm right away.
Done: Enable PatH's remote access
Lead(s): Oliver
- ChemIT must do this. Oliver must do or assign.
Done: Enable ChemIT staff's access to CCB FMPro DBs.
Lead(s): Roger
- Do via AD group. Enable only "Admin" accounts, not ChemIT staff's user accounts. (Right, Roger?)
- Roger to work with/ keep Tu informed.
Done: Shut off access to old ChemIT-run instance (Win7 VM). "Legacy Grades".
...
- 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.
- This keeps the access process the same as it was, but:
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.
- 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.
- In those cases, PatH will simply not "push" her final data to the web (varies by course).
...
- 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