Here is who to contact when an EWI web domain is unresponsive.

dew59@pitt.edu, cssd-nocmonitors@pitt.edu

Delete residents who have left

Export leaving residents

Import new residents to “Resident” table

make time cards for the current week for the new residents

Request that the leaving residents be deleted and the new residents added to the AD group: RX-FMS-CommunityResidents

Each year, at the beginning of July, a new class of pharmacy residents begin.  The following steps need to happen regarding this:

1. Remove leaving residents from email lists (rxschool, rxresident, pharmtherapeutics)
2. Update residents who are remaining so they are now connected to the correct program.
3. Delete leaving residents from the RxSchool DB
4. Add new residents to RxSchool DB
5. Add new residents to email lists (rxschool, rxresident, pharmtherapeutics)
6. Revise the residency pages to have correct list of residents

Steps-

Receive three spreadsheets from Residency coordinator- residents stating, arriving, leaving. Go into RxSchool DB and mark the remaining residents as MGT = “Stay.” Put the new program in the field::Notes.  for those residents who are leaving, set MGT =”Remove”

Take the “new residents” spreadsheet and turn it into a FMP database. Add these fields:

Type = Resident

Degree: PharmD

Title: Pharmacy Resident

Trigger: Monthly on a schedule, the registrar in Student Services does an export from the DataWarehouse/PeopleSoft and updates matching records in the RxStudent database.

Export of data process:

Import to RxStudent process:

1. Rename columns to match DB

Rename the fields:

Rename Peoplesoft ID to PeopleSoft_ID (must include the underscore)

“Home Address….” to “Paddress1, PAddress2, PCity, PState, PZip” (no spaces in the names)

Rename the fields “Mailing…” to “CAddress1, CAddress2, CCity, CState, CZip””

2)  Drag and open in FMP save as FMP file, then close.  (It needs to be sitting on your desktop)

3) Open the RxStudent DB

4) Select Script under Scripts:StudentServices: Update Address Information

5) Close RxStudent

6) Delete The Address Report DB you created in #2

Do an export of all Faculty and all GradStudents

• Import to the Annual Review table for these persons
  • Fields to import:
    • id -> id_Person
• Use id_Person as a match field to update existing records, make sure to check “add new records

Presentations

• Delete all records in the presentations table

Publications

• Delete all records in the publications table
• Delete all records in the person_publications table

Goals (Faculty)

Export Goals to new table and do these things:

• Change field names
• Progress to old_progress
• Text to progress
• Create/run script to change year to current year

In PharmSchool

delete all Goals records

import these fields from the new table

• id_Person
• Progress
• Year

AR Fields

• Find all AR records
• Run script  “AR Prep Set Competed”
• set field year to current year (not yet in a script)

Mark the students to be moved in PharmSchool

Some MS students should be removed as graduated in MS, but who remain in the PhD program- for these students, change their field “Program” to “PhD” and set “mgt” to “k”

others are graduated and should be moved. set their “mgt” to “move”

Export all [mgt = k OR move] as a FMP DB

Use the People table, the directory table and the Grad student table.

Export the photos!!!

In PharmSchool, find mgt = move, and delete these records

Import into the Alumni table

fields to match:

• nameFirst
• nameMiddle
• nameLast
• Advisor
• degree entering
• univID
• awards
• publications
• presentations
• degreeDisplay **
• photoContainer

Trigger: Current Class Presidents initiate a call for candidates in the Spring, in compliance with the policy and procedures listed in the PharmD Student Handbook.

A list of candidates is provided as a Word file.  The steps below are how to get that content ready for the students to vote:

The person posting has to be added as an instructor to a course for the professional year in question.

In CourseWeb, go into the course and select “Course Tools” in the left hand nav area.

Select “Tests, Surveys, and Pools”

Select “Survey”

**** It may be possible to select the “Elect Class Representatives poll from the year before and edit it.****

Select Build survey. Add a name, description and instructions, then “submit.”

Then create a question. The type is based on which office you are using the poll for. May be Multiple Choice or Multiple Answer.

Once finished, go to Course Documents and add the survey there.

To get the results, select “Full Grade Center”, scroll over to the survey on the far right. Click the chevron and choose “attempt statistics.”

Trigger: Do this on a monthly basis– currently set for the last Tuesday of the month

1. Open a plain text file to collect the content. Add to it the title and URL’s for the last five news stories in ePittPharmacy.

Example: Meet Rebecca Wytiaz: PittPharmacy Students Well Represented on PPA Board (http://www.pages.pharmacy.pitt.edu/epittpharmacy/2016/12/pittpharmacy-students-well-represented-on-ppa-board/)

1. Open an email window
2. Cut and paste your plain text from #1 into the body of the email.
3. Paste the following ABOVE this content

The notification form is a simple to complete web form to alert the School about awards, honors or other professional experiences you have had that may be newsworthy. The data collected is used for the annual report, honors convocation, and may be used in the PittPharmacy magazine, ePittPharmacy site, or other communications.

Notification Form: (https://www.intranet.pharmacy.pitt.edu/pitt-pharmacy-notification-form/)

1. Address message TO: rxschool@pharmacy.pitt.edu ReplyTo: webtech@pitt.edu
2. Go into the Body of the email and BOLD each news story title
3. Send email

Note the text above was edited by the communications team.

Sample Message:

These notes were added after having an issue with downloading container content from a Filemaker WebDirect connection.But they are applicable to testing any connectivity issue between boxes.

Open ports test via Telnet, this should show us if we are able to communicate between the two servers across the FileMaker ports.

I found a links with the Telnet instructions below:
http://blog.industrialnetworking.com/2011/09/using-telnet-to-test-open-ports.html
– Lets check the ports going from Database Server to Web Server first.
– Check to following ports 80, 443 and 5003. Then swap to Web Server and test the connection to Database server.