Process Number: 103

Revision Date: 2/27/2001 10:21:00 AM
Revision #: 1
Back | Access Password:
 

S02.LOAD.ASCII

Office Responsible: DCS - District - Computing Services Process Type: internal
Position Title: Programmer Author: CGreen
Cross Trained Staff: Manager: DHarris Vice Pres.: RTemple

Timeline (Deadlines or Time-Constraints) :
What must be done before this process is started:
I receive an ASCII file of SSN`s in the form of e-mail, a diskette or Excel.
Which processes are waiting for this process:
Source documents or communication with information needed for this process:
What is the end-result of this process, or the hand-off
This program produces a Datatel file called DMARTIN that has a data field for the ID numbers and I-Descriptors that include SSN, Adress, DOB, Age, gender, ethnic, Ed. Goal, phone.
What steps must be taken independent of the computer system (Manual Process)
Which steps must be taken on a computer (Electronic Process):
1. FTP the file from diskette, Excel or e-mail to my home directory.
2. Modify the OPENFILE path to the name you called the file.
3. At the colon prompt; enter BASIC CCGREEN S02.
Related Documents to Process (e.g. Datatel documentation, Government code books, etc.)
Notes (Cautions, suggestions for improvement, etc.)
1. If the file is SSN`s, you need to put the dashes in its proper places in the SSN`s. This can be done by the following UNIX command:
a. At the UNIX prompt; cat | awk `{s=$1; print substr(s,1,3) "-" substr(s,4,2) "-" substr(s,6,4)}` >
2. Also, you need to put 4 zeroes in front of the SSN`s:
a. At the UNIX prompt , vi the filename
b. Hold down the shift key and hit the colon (:) key
c. The cursor will go to the bottom of the screen next to a colon prompt, enter; :%s/^/0000/g

Process Number: 103

Revision Date: 2/27/2001 10:21:00 AM
Revision #: 1
Back | Access Password:

 
© 2013 San Bernardino Community College District - All Rights Reserved