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!

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

Recent content by jonschofield

  1. jonschofield

    Scripts on Terminal Emulator

    There is an error in the script I posted before: if "press CANCEL to quit -- press NEXT PAGE to continue" is genereated then the script goes to LABEL 4 rather than LABEL 3. I've altered that now so thats not the problem. The script is definitely getting as far as LABEL 3...I...
  2. jonschofield

    Scripts on Terminal Emulator

    The script is definitely getting as far as LABEL 3...I changed the step to stop the script and it did that ok. I checked the PBX.KEY file in the Terminal Emulator install directory and found the keystroke was right so I'm a but stuck now. HELP!
  3. jonschofield

    Scripts on Terminal Emulator

    All, I've made some modifications to my script based on your suggestions: CAPTURE C:\USAGE SET ext1 "" ARGFILE "C:\CAPEXT.TXT" LABEL 1 GETARG ext1 IF "ext1" == "1" GOTO 4 SEND "list usage extension ext1\r" LABEL 2 WAITFOR 300 "Extension...
  4. jonschofield

    Scripts on Terminal Emulator

    Here's my script. I can't use the print command since the switch has been upgraded but at the same time, I don't know how to send the keystroke for F7. As a consequence the script stops as soon as more than a page of data is listed. Anyone got any ideas how I can modify the script to send F7...
  5. jonschofield

    Scripts on Terminal Emulator

    I have scripts that I used on Terranova to perform the following command (where ext1 is an extension from an arg file): SEND "list usage extension ext1 print\r" Since this office has now moved to Voice over IP, the tracker has been taken out and I have to use Terminal Emulator to run...
  6. jonschofield

    Counting values which meet 2 criteria in Excel

    Thanks for all the help everyone! The pivot table suggestion seems to do what I need at the moment and is very easy to manipulate.
  7. jonschofield

    Counting values which meet 2 criteria in Excel

    Geoff Thanks for the help...so far! My intention is to have a summary sheet showing how many jobs aperson has either "in progress" or "complete" at one time. This means the actual data and the summary are seperate sheets in the same workbook. I've tried implementing...
  8. jonschofield

    Counting values which meet 2 criteria in Excel

    I've been wrestling with this problem for a while now so any help would be appreciated. I have a spreadsheet showing jobs that are assigned to different people and what status each of those jobs is at: "complete" or "in progress". I can count all the jobs that are either...
  9. jonschofield

    Macro to find and delete text

    I've tried running this macro but it doesn't seem to delete any rows where the specified string is found (which I have changed to "list", since I want to delete all the rows which start with "list". Any feedback would be appreciated.
  10. jonschofield

    Macro to find and delete text

    I know this may sound simple but I'm trying to write a macro for Excel that will find rows in a workbook containing certain strings of text and delete all those rows. Anyone got any ideas, hints or tips?
  11. jonschofield

    Writing Terranova scripts

    I found a way to loop the script so that it reads extension numbers from a txt file. The script will contine to run until there are no more extension numbers in the file. By doing this, the script can be adapted for any range of extensions without having to alter the script. CAPTURE c:\USAGE...
  12. jonschofield

    Writing Terranova scripts

    Thanks for the help so far. I've managed to get the script to read in an extension number from a file and use that extension in the "list usage extension" command. Can anyone tell me how to loop the script in a range of extensions, say 31000 to 31110? Thanks.
  13. jonschofield

    Writing Terranova scripts

    I'm trying to write a script for Terranova that runs the &quot;list usage extension <insert number here>&quot; command and dumps the output to either a text file or an Excel spreadsheet. I've read another post on this forum relating to Terranova scripts but I can't find much else on the net and...
See more

Part and Inventory Search

Back
Top