SILS iSchool

15 Jan 2019

meets Tuesday and Thursday from 0800-0915

in Carolina Hall 220

Contact options

office hours in Manning 112


Value Added | daily

Class Schedule

Basics | sessions 01-05

10 Jan | intro
15 Jan | clients | Open Source | VPN | file transfer | SFTP | GitHub | next session
17 Jan | servers
22 Jan | networks
24 Jan | basics lab

Web Development | sessions 06-11

29 Jan | structural layer
31 Jan | presentational layer
05 Feb | working with layers
07 Feb | behavior layer
12 Feb | images & design
14 Feb | website lab

Document Markup | sessions 12-14

19 Feb | document markup
21 Feb | tools that read markup
26 Feb | document markup lab

Spreadsheets | sessions 15-19

28 Feb | spreadsheets
05 Mar | formulas & functions
07 Mar | data display

 09-17 Mar | Spring Break 

19 Mar | database tools
21 Mar | spreadsheets lab

Relational Database | sessions 20-26

26 Mar | relational databases
28 Mar | tables
02 Apr | relationships
04 Apr | input & output
09 Apr | SQL
11 Apr | complex queries
16 Apr | databases lab

Presentation | sessions 27-30

18 Apr | presentation design
23 Apr | presentation delivery
25 Apr | presentation lab
30 Apr | 0800-1100 | final in class presentation





Use a File Transfer Protocol tool to move files
from your client to a server and from a server to your client.

Another tool we need on our laptops is a file transfer program

Using the File Transfer Protocol (FTP) to manage your files

FTP requires two computers, one running an FTP server, the other running an FTP client. The exchange is initiated by the client which logs in under an accepted user name and password. Once this occurs, a session is opened and stays open until closed by either the client or the server, or until it times out. While the session is open, the client may execute numerous FTP commands on the server. These include commands to change directories, list files, get files and put files.

You have access to servers which provide storage space for some of your data. These may be, among others, normal data files or HTML files that support web pages.

You may hear both the terms FTP and SFTP.
The difference is in the level of security each type of connection affords.
We will be using the SFTP capability exclusively.

If you are associated with SILS,
you can use your Onyen login to access storage on SILS servers.

Use of these servers will necessitate your instructor arranging for you to obtain a SILS account. But to use them, you must have an SFTP client on your personal computer.

back to top

Mac users

You have many choices. Fetch, Cyberduck, or Filezilla are all good FTP clients to use in a Mac to server environment.

back to top

Linux users

You can use one of several SFTP tools to manage your files. Note that Filezilla is also recommended for Linux users.

back to top

Windows users

Filezilla is also a player here, but the recommendation is to use the SSH/SFTP Secure Shell Client. This tool provides you both a terminal (we'll discuss it in the next session) as well as an SFTP capability. ITS shows how to use SSH/SFTP to manage your files, but replace all references to isis.unc.edu with opal.ils.unc.edu.

back to top

We will use SSH/SFTP for in-class examples.

If you need to transfer files from the client computer you are using to the server, or from the server to the client computer, you will need to use an FTP client. Assuming you use SSH/SFTP, start the program and connect to opal.ils.unc.edu. The resultant window displays a telnet connection, but you will want to select the File Transfer Window.

Fetch behaves nearly the same

If you need to transfer files from the client computer you are using to the server, or from the server to the client computer, you will need to use an SFTP client. Assuming you use Fetch, start the program and connect to opal.ils.unc.edu using your Onyen and password. It is important that you select SFTP (Secure FTP) during this step.

Fetch terminal window with log-in prompt

In the following window, open the folder marked public_html. From here, you can click and drag files and folders into the Fetch window to transfer them onto the ITS server. (Alternatively, you can use the "Put" button in the menu bar.)

Fetch menu bar

If you choose to use Cyberduck, the protocol is very similar: Choose "Open Connection" from the menu bar, select SFTP, and connect to opal.ils.unc.edu

Remember that when you upload to or download from the server,
you are only transferring copies of the original files.
This is an excellent way to manage files on your remote site.

back to top