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.
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.
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.
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
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.