Process Number: 103 |
Revision Date: 2/27/2001 10:21:00 AM |
Revision #: 1 |
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 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 |