Importing Auth Codes

[AOSupport]

Hi,

I have to import about 3000 Auth codes into the PBX. I have these codes in a CSV file. Is there a procomm script that can be used to import all these codes so I don't have to do then one at a time.

Thank you,

 

[BkMesser]

You can use the mail merge feature of word to help you write the script for this.

1. Capture the script (using the camera button on procomm) of you building 1 authcode.
2. Copy and paste that script into word. You may want to add some pauses "~" to let the switch keep up. Delete proc main from the start of the script.
3. Go to tools-letters and mailings-mail merge
4. Click on next until you get to select recipients then click browse and get to your excell doc.
5. Finish the mail merge. Word will open your script in a new window.
6. Add endproc to the end of the script and main proc to the start.
7. Copy and paste it into a new procomm script. There may be a # of lines limit to scripts in procomm, so you may want to do a couple hundred at a time.

Once you get this down it works great. I have used it for a ton of stuff.

 

[AOSupport]

Thanks, I'll give this a try. Do you have a sample of the script you used ?

 

[BkMesser]

Here is one I used mail merge to build. It changes the ncos of some of my trunks to 7. The ^M = Enter and the ~ = pause. It takes some debugging to get it to work, but if you do it before you do the mail mergeit is well worth the time spent.

I delete some of the middle channel stuff to save space.

PROC MAIN
transmit "CHG^M~"
waitfor "TYPE "
transmit "TIE^M~"
waitfor "TN "
transmit "066 01^M~"
waitfor "DES "
transmit "^M~"
waitfor "PDCA "
transmit "^M~"
waitfor "PCML "
transmit "^M~"
waitfor "NCOS "
transmit "7^M~"
waitfor "RTMB "
transmit "^M~"
waitfor "MNDN "
transmit "^M~"
waitfor "TGAR "
transmit "^M~"
waitfor "AST "
transmit "^M~"
waitfor "CLS "
transmit "^M~"
waitfor "TKID "
transmit "^M~~~~~"
transmit "CHG^M~"
waitfor "TYPE "
transmit "TIE^M~"
waitfor "TN "
transmit "066 02^M~"
waitfor "DES "
transmit "^M~"
waitfor "PDCA "
transmit "^M~"
waitfor "PCML "
transmit "^M~"
waitfor "NCOS "
transmit "7^M~"
waitfor "RTMB "
transmit "^M~"
waitfor "MNDN "
transmit "^M~"
waitfor "TGAR "
transmit "^M~"
waitfor "AST "
transmit "^M~"
waitfor "CLS "
transmit "^M~"
waitfor "TKID "
transmit "^M~~~~~"
transmit "CHG^M~"
waitfor "TYPE "
transmit "TIE^M~"
waitfor "TN "
transmit "066 23^M~"
waitfor "DES "
transmit "^M~"
waitfor "PDCA "
transmit "^M~"
waitfor "PCML "
transmit "^M~"
waitfor "NCOS "
transmit "7^M~"
waitfor "RTMB "
transmit "^M~"
waitfor "MNDN "
transmit "^M~"
waitfor "TGAR "
transmit "^M~"
waitfor "AST "
transmit "^M~"
waitfor "CLS "
transmit "^M~"
waitfor "TKID "
transmit "^M~~~~~"
endproc

 

[sammmcs]

this can help you

http://www.tek-tips.com/viewthread.cfm?qid=1239384

____________________________________________________________

string info

proc main
fopen 0 "D:\Program Files\Procomm Plus\Capture\aut.txt" read text

transmit "new^M"
waitfor "TYPE "
transmit "aut^M"
waitfor "CUST "
transmit "0^M"
waitfor "SPWD "
transmit "0000^M"
waitfor "CODE "
read_next:
fgets 0 info
if feof 0
exit
endif
; strdelete info 5 2 ;Optional if txt file
transmit info
transmit "^M"
waitfor "CODE " 1
if success
goto read_next
endif
transmit "^M"
waitfor "CLAS "
transmit "0^M" ;or whatever
waitfor "CODE "
transmit info
transmit "^M"
waitfor "SARC "
transmit "^M"
waitfor "CLAS "
transmit "0^M"
waitfor "CODE "
goto read_next
endproc



____________________________________________________________

*firebird can help you for any script*

Samo

 

[Firebird Scrambler]

I've done a script for this and it's already on the FAQ section at..

http://www.tek-tips.com/faqs.cfm?fid=7254

It's got a pretty GUI screen and you should find it easy to import your data for the CLASS and codes etc.

All the best

Firebird Scrambler
Meridian Programmer in the UK

http://www.linkedin.com/in/davidbromley

If it's working, then leave it alone!.

 

[AOSupport]

firebird, what version of procomm do I have to run this on. Is says my version is outdated.

This would be great, thanks

 

[sammmcs]

it's working in procomm plus 4.8 good

Samo

 

[Firebird Scrambler]

I use the latest version of 4.8. What version are you using?

All the best

Firebird Scrambler
Meridian Programmer in the UK

http://www.linkedin.com/in/davidbromley

If it's working, then leave it alone!.

 

[johnpoole]

i just used a direct paste for the same task.. 3 columns, 1st one for the new codes, second one blank for the 2nd return, third one for the class.. then a short script to set textpace to 90, copy those three col's and paste.. my 81 ran that error free.. i only added 300..


excel has a return at the end of each col, which makes that one work great.. same thing for a list of keys.. adding 20 bfs keys to a dozen phones is a lot quicker then using delimited files

john poole
bellsouth business
columbia,sc

 

[AOSupport]

I'm using 4.8 as well. So do I log into the PBX and then just paste this in the procomm windows or do I need to save it as a script file ?

Thanks

 

[AOSupport]

Guys,

Ok, so I think I have lost complete faith in my vendor. Who in NYC wants to take on the job for this weekend. Willing to pay very well for a few hours of work. NO BS,

Please let me know.

If interest, pleae provide me an e-mail address and I will provide the details.

Thanks,

 

[BkMesser]

I'm interested...

brian_crystal@hotmail.com

 

[AOSupport]

BK, thanks for the internest. I managed to get the work done with the help of firebird. But i will keep your e-mail address and project like this do come up from time to time.

Thanks again,