Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Seeking an alternate means to capture data.

Status
Not open for further replies.

TMurdach

IS-IT--Management
Apr 18, 2003
61
US
I have been using the script below to capture in-use vectors on an Avaya switch to a blank capture file, which I then copy as a spreadsheet and use for easy searching of ROUTE TO numbers and MESSAGING split extensions, etc.

I am wondering if there is a better way to capture the data to automatically eliminate the excessive blank lines and empty vector steps.

proc main
string sLine
string vector1
fopen 0 "c:\vector.csv" READ TEXT
while not feof 0
fgets 0 sLine
strtok vector1 sLine "," 1
pause 1
transmit "disp vect "
pause 1
transmit vector1 ;vector1 is read from file vector.csv
pause 1
capture on
pause 1
transmit "^M" ;pressing ENTER to execute DISP VECT command
pause 1
capture off ;allows the current screen data to remain in the capture file
pause 1
capture on
pause 1
transmit "^[OV" ;pressing F7 for NEXT PAGE
pause 1
capture off
pause 1
capture on
pause 1
transmit "^[OV" ;pressing F7 for NEXT PAGE
pause 1
capture off
pause 1
transmit "^[OP" ;pressing F1 to exit to command line
pause 2
endwhile
fclose 0
endproc

Any suggestions would be appreciated!
 
Here is a sample of the capture file output. Notice the blank space...

display vector 1 Page 1 of 3
CALL VECTOR

Number: 1 Name: Operator
Multimedia? n Attendant Vectoring? n Meet-me Conf? n Lock? n
Basic? y EAS? y G3V4 Enhanced? y ANI/II-Digits? y ASAI Routing? y
Prompting? y LAI? y G3V4 Adv Route? y CINFO? y BSR? y Holidays? y
Variables? y
01 goto step 5 if time-of-day is all 17:00 to all 08:00
02 goto step 5 if time-of-day is sat 08:00 to sun 17:00
03 route-to number 10100 with cov y if unconditionally
04 stop
05 route-to number 2000 with cov y if unconditionally
06 stop
07
08
09
10
11





display vector 1 Page 2 of 3
CALL VECTOR


12
13
14
15
16
17
18
19
20
21
22









display vector 1 Page 3 of 3
CALL VECTOR


23
24
25
26
27
28
29
30
31
32










display vector 2 Page 1 of 3
CALL VECTOR

Number: 2 Name:
Multimedia? n Attendant Vectoring? n Meet-me Conf? n Lock? n
Basic? y EAS? y G3V4 Enhanced? y ANI/II-Digits? y ASAI Routing? y
Prompting? y LAI? y G3V4 Adv Route? y CINFO? y BSR? y Holidays? y
Variables? y
01 wait-time 0 secs hearing ringback
02 collect 5 digits after announcement 12071 for none
03 goto step 16 if digits = 0
04 route-to number 8043 with cov n if digit = 1
05 route-to number 8063 with cov n if digit = 2
06 goto step 14 if digits < 2000
07 goto step 12 if digits < 6000
08 goto step 14 if digits < 10000
09 goto step 12 if digits < 19000
10 goto step 14 if digits > 18999
11 goto step 16 if unconditionally





display vector 2 Page 2 of 3
CALL VECTOR

 
It looks like the problem is due to the script opening and closing the capture file multiple times. In this case, the "current" screen in Procomm will be written to the capture file. Is this being done since the screen is not being captured to the file otherwise? If so, you could use the clear command to clear the screen and force the current screen to the capture file.

aspect@aspectscripting.com
 
I replaced the CAPTURE ON lines with CLEAR and removed the CAPTURE OFF lines... but the white space is still there.

Is there any way to read specific lines on the screen into a text file? If I could capture lines 5-19 of the window into a text file that would clean up a lot of the white space.
 
to capture just some line's do a waitfor (space 04 space) captureon waitfor (space 19 space)capture off, simple to send those lines to a excel from there, if line 04 is not enough captureon at goto, pause 2 capture off

john poole
bellsouth business
columbia,sc
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top