Filemaker Pro 17 Configuration Guide

Chris Martin Filemaker Pro ,

Use these instructions to configure Filemaker Pro 17 to connect to the School of Arts and Sciences (SAS) Filemaker server. Note, that if you are working from a wifi connection and/or off-campus, you will first have to connect your Forticlient VPN client.

1 Upon opening, Filemaker Pro, click File->Hosts->Show Hosts…

2.) Click “Add App” and “From Hosts”

 

3.) Click the + sign to add a new favorite host

 

4.) For host’s internet address, enter: fms-2019.sas.upenn.edu

For Favorite Host’s Name, enter: KWH Filemaker Pro

Click save.

 

4.) Find KWH19 from the list of available FMP databases. Double click on it.

 

5.) You will be prompted for your KWH AD account. Your username will match your pennkey though the password may be different (depending on what you set for your AD account password.)

 

6.) You will now have access to the KWH database. For future connections, you will now by able to connect quickly to the KWH19 database by clicking on it in “My Apps” (File->Hosts) or by selecting File->Recent.

Getting Started with Forticlient VPN in SAS

Chris Martin accounts, VPN , , , ,

A Forticlient VPN connection is necessary to gain off-campus / wifi access to the Shared Drives, Filemaker Pro servers and some other services. Note that you do not need to use Forticlient VPN if you are using wired on-campus computers.

Forticlient

 

Request VPN access by filling out this form: https://upenn.co1.qualtrics.com/jfe/form/SV_d6lrw3Ta4gJ0Av3

  • If you’re in the Kelly Writers House or Creative / Critical Writing, use the following information when asked:
    • Local Support Provider (LSP) Name: Chris Martin
    • LSP Support Team: CPCW

You will hear back within a couple of days with instructions on how to install and configure Forticlient.

  • Note that PennKey Two-Step Verification using Duo Mobile push notifications (preferred) or Voice/Text notifications is required for FortiClient VPN access. To check on your Two-Step Verification setup please click here: https://twostep.apps.upenn.edu/
  • If you think you’ve forgotten your Forticlient password, make sure to try your Pennkey / O365 passwords — the passwords for these accounts match. If you still need to reset your password, resetting your Pennkey password will also reset your Forticlient VPN password (and your O365 password). Go here to do so: https://pennkeysupport.upenn.edu/help
  • If you haven’t yet installed or need to reinstall Forticlient, you can download the installer and instructions from here: https://upenn.box.com/v/FortiClient

Do you also need to get setup with a Shared Drive / FMP account? Click here for more information.

How to Log into the Zoom iOS app with your UPenn Account

Chris Martin accounts, Classroom Technology, Mobile Apps, Software

All School of Arts and Sciences staff and faculty are eligible for Zoom accounts. More information about Zoom in SAS is available here: https://www.sas.upenn.edu/computing/remote-teaching/zoom. If you haven’t already activated your account, be sure to visit this link: http://zoom.sas.upenn.edu/

Note that students DO NOT need a Zoom account nor to sign into the Zoom app to participate in a meeting — only the meeting host needs an account and to be signed in.

  1. Install the Zoom iOS app on your iPhone or iPad, from the App Store.
  2. Open the app and when signing in, select the SSO option:
  3. Enter “upenn” so the full company domain reads “upenn.zoom.us”

4. You will then be guided to log in with your Pennkey, which will log you into Zoom.

How to SSH to the Writing Server on a Windows PC

Chris Martin Writing Server ,
  1. In order to connect to the Writing server via SSH on a Windows PC, use SecureCRT, which is available for free to University staff and faculty. If you don’t yet have it, click here for more information and to download the SecureCRT installer.
  2. Open SecureCRT. If the “Connect” box pops-up automatically, click the “Quick Connect” icon. Otherwise, click File->Quick Connect.
  3. In the Quick Connect pop-up box, enter the following information:
    1. Protocol: SSH2
    2. Hostname: writing.upenn.edu
    3. Port: 22
    4. Firewall: none
    5. Username: your pennkey
    6. Authentication: check “Password” only
    7. Click “Connect”
  4. If you see a prompt for “New Host Key”, click “Accept and Save”
  5. You will then be prompted for your writing server password. Enter it here and click OK. It is NOT recommended to “Save password”.
  6. You will now be connected!
  7. Next time you open SecureCRT, the Writing Server connection settings should be saved in the “Connect” pop-up box. If it doesn’t pop-up automatically when you open SecureCRT, you can find it by going to File->Connect.

How to Set Up the Concur App at Penn

Chris Martin Miscellaneous , , , , , , , ,

concur mobile app

Concur is often used by staff and faculty at the University of Pennsylvania to submit expenses for reimbursement (either personal or travel card expenses).

In order to setup the Concur app at the University of Pennsylvania, follow the instructions below. The login process is not transparent. Special thanks to Brian Kirk for sharing this information.

Install the CONCUR mobile app from your App Store.

Sign in using Company SSO method.  It will ask for the Company Code

UPenn Company Code: LJACRC

Concur Username: yourpennkeyname@upenn.edu

Replace “yourpennkeyname” with your pennkey name.

It will bounce you to a UPenn Pennkey login screen.  Login there using your pennkey username/password as usual, and your two-step authentication code – you can trust the browser.

Once done, it will send you back to the Concur App.  You should now be logged in.

How to forward O365 email address to a different account

Chris Martin Email, O365
    1. Log-in to the Penn O365 webmail here: http://outlook.office.com
      Note that your user name is in the following form: pennkey@upenn.edu
    2. In the top right corner, click on the Gear icon. Scroll down down and click “View all Outlook settings” from the drop down.
    3. Click on the “Forwarding” section, check “Enable forwarding”, enter the email address you would like to forward to and click “Save.”

 

How to Export Apple Contacts and Import into O365 via OWA (Web Interface)

Chris Martin Uncategorized

I’m sure there is a better way to do this — perhaps by setting up the user’s O365 account in the Contacts app on the Mac and dragging and dropping local contacts to the O365 contacts.

 

Nonetheless, this is the process I used to copy a user’s MacOS Contacts into their O365 address book (a.k.a. “People”):

 

1.) Open the user’s Apple Contacts application on their computer.

2.) Select all of the contacts and dragged them into a blank Apple Pages spreadsheet (there’s no way to export direct to CSV from Apple Contacts).

3.) Export a sample CSV file from OWA to figure out the column structure. Clear out all of the entries, leaving only the column headers.

4.) From the Apple Pages spreadsheet, copy and paste 200 rows of user data into OWA CSV and save off the file as CSV.

5.) Clear the data and copy and pasted the next batch of 200 and saved off the file. Repeat as necessary.

6.) Upload the CSV files via the OWA interface into the “People” section.

 

Why 200 at a time? OWA claims to support up to 2,000 contacts per upload but, in my experience, it would time out before completing.

 

Also, possibly of note, I only bothered copying and pasting in First Name, Last Name and email address into the CSV files I was uploading into OWA — I left out other data because it wasn’t necessary and kept the file sizes smaller (which I thought might help with OWA’s time out habits).

Kelly Writers House 6Poem Tips

Chris Martin Uncategorized

To update option 1 in 6Poem, you must dial the line using your phone and entering the proper password.

To update options 2, 3 and 4 in the 6Poem phone answering system system, follow these instructions:

  • Log in to: https://depot.isc-seo.upenn.edu/wfr
  • Choose the group PCOM-KELLY-WRITERS
  • Click the “Action Menu” and choose “Upload file”
    • Note: Be sure your file is named using the kelly#.mp3 naming convention protocol
  • The 6Poem number will sync any changes made at midnight.

Creating properly formatted files for 6Poem

  • We recommend the audio program Audacity (http://audacity.sourceforge.net/) for recording / editing audio files. For some reason or other, the required format is 8-bit μ-law WAV with a sampling rate of 8 kHz. The method I found for creating them is slightly cumbersome:
    • Audacity allows you to specify μ-law encoding, but not sampling rate or bit depth (so far as I know). And iTunes lets you set the sampling rate and bit depth, but it doesn’t allow you to specify exotic WAV encoding formats. So I created 8-bit, 8-kHz WAVs in iTunes, then opened them in Audacity and saved them as μ-law files. You can choose μ-law encoding under the “Other uncompressed files” option in the “Export…” dialog box.