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

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

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.

How To Change Writing Server Password

Note: If you are setting up a new account, I will send you a default password separately via Penn’s Secure Share service.

To change your password:

On a Mac computer, open “Terminal” (in Applications->Utilities) and connect to the writing server by entering the following command:
ssh yourpennkeyhere@writing.upenn.edu

It will ask for your password. Enter your current password, if you know it — or — the default password I sent you.

Now that you are connected to the Writing server, enter the following command:
passwd

This will prompt you for your current password followed by a request for the new password you would like to use followed by the enter key. Note that your password cannot be based on a dictionary word, so you might have to be a bit creative. You will have to confirm your new password by entering it a second time.

Filemaker Pro 13 Configuration Guide

Use these instructions to configure Filemaker Pro 13 (or older) to connect to the School of Arts and Sciences (SAS) Filemaker server. Note you must use a wired campus computer –or– be connected to SAS via a Pulse connection in order for this to work. Click here if you need instructions for configuring Filemaker Pro 15.

1. From the initial Open screen, select ‘Manage Favorites’
2. Click the ‘+’ to add a Favorite
3. Select ‘Remote’
3b. Toggle the “View” to “Favorite Hosts”
4. Select ‘Add’
5. Type ‘fms-2015.sas.upenn.edu’ in the Internet Address field and select ‘Save’
6. Scroll down through the list of databases on the server to find the CPCW-CurrentContacts database
7. Click on the CPCW-CurrentContacts database(s) and click ‘Add to Favorites’. Repeat for any other databases you want to add (books and/or DAT tapes).
8. From the Open screen, the CPCW-CurrentContacts database should now appear under ‘Favorite Files’

Filemaker Pro 15 Configuration Guide

Use these instructions to configure Filemaker Pro 15 to connect to the School of Arts and Sciences (SAS) Filemaker server. Note you must use a wired campus computer –or– be connected to SAS via a Pulse connection in order for this to work.

 

1 Upon opening Filemaker Pro, you will be greeted with this “Get Started” screen:

 

2. Click File -> “Open Remote…”

 

 

3. Assuming you are connecting to the Kelly Writers House database, use the following settings:

Host internet address: fms-2015.sas.upenn.edu
Favorite Host’s Name:
FMS
File Settings -> Show Only These Files:
cpcw-kwhcurrentcontacts

 

4. If prompted, tick “Always permit connection to this host” and click “Connect”

 

5. Double click on the “cpcw-kwhcurrentcontacts” icon.

 

6. Enter your FMP account name and password and click OK.