HOME

Excel Dialer Pro - Help

 

For common questions see  --->

For applications/samples see --->

* Why dialer does not dial when click on Excel spreadsheet?
* Using hotkey to dial from the spreadsheet
* How to use script?
* How can I use multiple calling cards within the same "Location"?
* Importing Address Book from csv file
* Importing Address Book from Excel spreadsheet
* Importing data into selected, single tab
* How to sort Speed Dials alphabetically?
* How to use the dialing pad to dial on the existing phone call?
* How to transfer a phone call?
* How to check that modem has ability to generate / receive DTMF tones?
* How to use Excel Dialer Pro from the command line?
* How to get rid of 'Run Busy Detect' startup message?
* How to check that modem has ability to record voice?
* How to override options?
* How to recover from errors?
* Using the test file to diagnose hardware or software problems
* Developers corner

 *Why dialer does not dial when click on Excel spreadsheet?
  
Excel Dialer Pro will not dial from the spreadsheet when one of the below condition occurs:

  •  'Enable Excel dialer' option is not selected in Tools>Options>Excel tab

  •  '<Excel Dialer>' menu is disabled on mouse right click on dialer's systray icon (right bottom corner of the screen)

  • There is the spreadsheet's name set in Options>Excel tab >Set Params but the actually used spreadsheet differs from it.

  • There is the column # (containing the phone numbers)  set in Options>Excel tab >Set Params and the actually clicked
    column is different from it.

  • The clicked spreadsheet's cell is empty or it does not contain a valid phone number.

  • It is the first attempt to dial from Excel spreadsheet and the dialer did not register the cell change. The dialer senses when selected cell has changed. It means that when you open spreadsheet and the cell (containing phone number) is active,  clicking on that cell will NOT start dialing. You need to click on another cell to make it active, then click again on the cell with phone number in it.

Note:
 To repeat dialing from the same cell user has to click somewhere else on spreadsheet and then click again on the same cell.
After that, clicking on any other cell containing phone number will start dialing.
            back to the top

 * Using hotkey to dial from the spreadsheet
  To use a hotkey the following conditions must be met:

  • In Tools>Options>Excel tab>Manual dialing>Set Params the option 'Use Hotkey to dial from spreadsheet' is set

  • In Tools>Options>Dialing tab the option 'Use HotKey to dial (from other docs) must be set and the appropriate (unique) keyboard keys combination selected (the selection cannot interfere with the other hotkeys in the system).

  • '<Excel Dialer>' menu must be disabled on mouse right click on dialer's systray icon (right bottom corner of the screen)
                back to the top

  * Importing Address Book from csv file
Imported entries are inserted into Phone Dialer Pro Index Mode and sorted alphabetically.
NOTE: To import Windows Address Book (WAB): 
- Open WAB and export data to text file (csv file)
- Import that file into Phone Dialer Pro
For csv acceptable formats see this
Warning:
Importing Address Book will erase all existing programmed Speed Dial buttons. To preserve existing buttons save the current profile, create the new profile and then import Address Book into it.

  * Importing Address Book from Excel spreadsheet
Imported entries are inserted into Phone Dialer Pro Index Mode and sorted alphabetically.
NOTE: Excel spreadsheet must be opened during this operation.
Warning:
Importing Address Book will erase all existing programmed Speed Dial buttons. To preserve existing buttons save the current profile, create the new profile and then import Address Book into it.

   * Importing data into selected, single tab
Data can be imported in any tab of your choice in Index Mode or Subject mode and it will be sorted alphabetically and added to existing entries.
Note: No existing Speed Dials will be erased.

 * How to sort Speed Dials alphabetically?
To be able to sort Speed Dials alphabetically the Dialer should have at least one Sub-Title button, always the first speed dial button on any page, which has had an asterisk (*) typed in as the first character - with or without any other name or instead of a name.
Note: Sorting happens between one asterisk button and the next, If you prefer to have any first page (either in alphabetical or Subject Heading modes) unsorted to display speed dial buttons you do not wish to be sorted and to remain at the start of that page as you entered them by choice, do not place an asterisk in the first speed button of that page.
Upon clicking on the Asterisk button the dialer should ask for permission to sort all the underlying Speed Dials. Underlying means all buttons belonging to that subtitle. If there is only one Sub-Title Button all the Speed Dials buttons under that single Tab will be put in alphabetical order (starting from button #2 to the last button #996).
If you have marked another Sub-Title - under the next Subject Heading tab for example, then only those Speed Dials belonging to that Sub-Title and Heading will be sorted. Thus, between the speed dial button you have clicked to trigger the sort and the next valid Asterisk button.
A Sub-Title can only be the first Speed Dial button on any page which will not be used to dial but to trigger sorting of your Speed Dials within a Tab/Heading.
Again, to create a Sub-Title simply place an asterisk (*) in front of the first Speed Dial button's title, in the same way you would enter a name. Clicking on the Sub-Title button will reveal a new window asking for confirmation to sort, see the picture below:

Figure 4.

back to the top


  * How to use the dialing pad to dial on the existing phone call?
 User can send additional digits using the dialing pad when:
1. modem supports sending DTMF tones
2. Phone call was made in 'Voice' mode (Tools>Options>Voice tab).
This can be useful in situations when the user does not want to send additional digits together with the phone number.
back to the top

  * How to transfer a phone call?
In Tools > Options > Dialing tab, the option: "Enable Call Transfer" must be selected.
When that option is selected, the EDP second phone book (II) becomes Call Transfer Phone Book.
To transfer the call EDP has to make an outgoing call or receive an incoming call. When the oval Progress Call Window displays that call, clicking on the Speed Dial button in the Call Transfer Phone Book should transfer the call.
Note: That option may not be supported by some hardware (modems) or by the phone co. 
back to the top

* How to check that modem has ability to send / receive DTMF tones?
  Most of the voice modems have that functionality.
If you want to make sure that your modem is capable of sending and receiving DTMF tones:
1.
Use the test file and and send TapiLog.txt log file to author.
or
2.
Using this dialer make a phone call to the voice mail (for example your bank) and using dialer's dialpad try to navigate the voice mail.
If you can, your modem is capable.           
back to the top

 * Using script
A script is a plain text file where each line contains an individual command.
To see the list of available commands and a sample script, click on the Help button beside that option.
Note:
Script can be invoked by 2 methods:
1.
 - select this option and specify the script file.
 - save Options by clicking on OK button.
 - make outgoing call:
      -when the script begins with dial: command  ---> close dialer and start it from the command prompt
       -in all other cases input the phone number in the field provided above the keypad and click DIAL button.
 When the call changes to 'Connected' state, script execution will begin.
2.
 - start dialer from the command line using one of the following commands:
        <path>phoneex.exe /script     (this will use the script file specified in Options)
       <path>phoneex.exe /script:<full path to the script file>     (this will use the script file specified on this line)
Important:
When using scripts it is very important to synchronize timing between commands by using the <wait: # > command.
<monitor_dtmf: #> or <monitor_dtmf> commands must be always followed by the <wait: #> command.
See samples by using Help button beside the 'Use Script' option.
Using Script Simulator:
Click TEST button to start Script Simulator. A new window will pop open showing the real time script execution.
When the script waits for the keypad input, click on the desired key on the EDP keypad.
This is the best way to test your script, fine tune it and make sure that it does what the script was intended to do.
Note:
<dial> command starts a simulated action; it will not use the modem and phone line.
Remarks:
Because Script Simulator does not use a modem at all,  it is possible to test scripts even if the modem is not a voice modem or the modem is not able to generate (or receive) DTMF tones.

Script commands accepted by Excel Dialer Pro

COMMAND TASK

err_key:#

when a specified key is pressed,  the <monitor_dtmf: #> or <monitor_dtmf> action will stop and the err_mess will be played.
err_message: <file> message to be played when err_key (above) is invoked.
err_wrong_key_message: # when not expected key is pressed,  the last played message will play again if the value # is 0 <default>
err_wait: # time delay in seconds: must be long enough to play error message
(65 secs max)
err_line: # when err_key is invoked, the script will continue from the specified line after err_wait time delay (above).
err_timeout: # when no response is received, monitoring DTMF tones will stop after # seconds (default is 65 seconds) and the next line command after <wait:# > command will be executed.
dial:<phone number> make outgoing phone call.
When a call already exists this command will be ignored.
autodial: # it will use phone list for dialing.
# is the position on phone list script will start dialing from
     monitor_dtmf:# <action> wait for specified tone# and perform action.
<action> can be any valid script command except <play:>.
Often, it will be <go_line:#> or <hangup>
This command (or group) must be followed by <wait:# > command.
monitor_multi_dtmf:# <action> wait for specified series of tones# and perform action.
<action> can be any valid script command except <play:>.
Often, it will be <goto_line:#> or <hangup>
This command (or group) must be followed by <wait:# > command.
monitor_dtmf store all keystrokes in file tones.txt, until # (pound) key is pressed.
This command must be followed by a <wait:# > command
dialdtmf:<0...9,#,*> send DTMF tones
wait:# program waits # of secs before executing next command
go_line:# jumps to specified script line
go_line:# loop:# repeated jumping to specified line # times (loop #)
go_line:# loop:# go_line:## after # times (loop #) jumping to script line #, it will continue script execution from line ##.
recordstart starts recording voice (accordingly with the rec params set in Options)
recordstop stops recording
alert:<file> this is one of the <action>.  It will play the selected file over PC speakers to alert the operator.
callerid:<CallerID> <go_line:#> when the Caller ID matches expected value, then
the script execution will jump to the specified script line
callerid this command will put Caller ID on clipboard
answer:<#> incoming call will be answered after # of rings
runapp:<path to executable> it will launch the specified file
runapp:<path to executable>/callerid it will launch the specified file with the Caller ID as a trailing parameter
savelog:<text to be logged> when using Excel spreadsheet and there is a Log column specified in options the indicated text will be logged into sheet.
flash it will perform flashook or off-hook
hangup disconnect and drop the phone line
end disconnect, drop the phone line and end script processing
delete delete the script file
// this line is ignored (it is used for making comments)
   

 Important:
     err_... commands when used, should precede all other commands.
                but it is not necessary to use them at all.
     Script must end with <end> command. 

Ask me, if you need another command or action. 
Script will be invoked automatically the next time Excel Dialer Pro is called or manually by using systray EDP icon's pop-up menu.            back to the top


 * How to use Excel Dialer Pro from the command line?
Excel Dialer Pro uses the same commands as Phone Dialer Pro.
To see a list of available commands click here.

* How to check that modem has ability to record voice?
  Make the following check:
.    In Windows>Control Panel find:
          Windows XP/Vista ---> Sounds, Speech and Audio Devices ---> Sounds and Audio Devices ---> Audio tab
          Windows 2000 ---> Sounds and Multimedia  or
          Windows 98 ---> Multimedia
     and check if you can see your modem's wave driver as one of  recording devices.
     Usually the modem's wave driver will look like this:  Modem #0 Line Record.
     This driver should be seen as a selected recording device in Tools>Options>Record tab.

     Also see this:
    
Using the test file to diagnose hardware or software problems
                                                                                                                     back to the top
 * How to recover from errors?
Resetting EDP options to default values may help.
To do that start EDP with "default" as a trailing parameter:
   [...] \phoneex.exe /default 
Note:
If you have a problem when using Excel 2000 or older version follow these steps:
     1. Close all opened spreadsheets
     2. Using Windows Task Manager check for EXCEL.EXE process and terminate it, when exists.
     3. Open the spreadsheet you want to use it as a phone list.
     4. Start dialer
.           
back to the top

  * Using the test file to diagnose hardware or software problems
 
1. Click  here to download the test file (371 kB)
 2. Run it and use it the same way you were using the original file, until the problem (error) appears.
 3. Close program.
 4. Find Tapi.txt log file in the same folder the test file was run from.
 5. Send that file to
author.
     Please make sure to add comments saying what you are doing externally and where you think the problem is.
          
back to the top

* How to get rid of 'Run Busy Detect' startup message?
 A properly detected busy signal is very important for the determination of the Connected phone line state.
It is recommended to use the Detect Busy utility. See it in the Tools>Options>Hardware tab.
If for some reason your device cannot detect busy (for example, your phone company may provide voice mail instead of a busy signal), there are 3 other methods you can use:
1.
Disconnect phone line from your modem and c
lick on Start button beside this option. Enter any number when asked.
Click OK and wait until no dialtone detection will end.  Real time call progress is displayed in small box beside the Start button.
2.
Make a phone call and measure the time it takes to the first audible ring. Manually insert that number into the Busy Detect option in the Tools>Options>Hardware tab and click OK to save the options. The value should be between 8-13 seconds for most modems.
3.
 Find the phoneex.ini file located in:
Windows XP:
C:\Documents and Settings\<user name>\Application Data\Excel Dialer Pro\phonex.ini
Windows Vista and Windows 7:
C:\Users\<user name>\AppData\Roaming\Excel Dialer Pro\phonex.ini

 Open it in a word editor (Notepad, MsWord) and do the following:
 - find Busy Detect=0 and change it to Busy Detect=1
 - find Busy Delay Timer and change it to Busy Delay Timer=13
Note:
The busy detect value is stored into phoneex.ini on dialer's termination.                                 
back to the top

* How to override options?
 Find the phoneex.ini file located in:
Windows XP:
C:\Documents and Settings\<user name>\Application Data\Excel Dialer Pro\phonex.ini
Windows Vista and Windows 7:
C:\Users\<user name>\AppData\Roaming\Excel Dialer Pro\phonex.ini

Open it in a word editor (Notepad, MsWord) and edit the entries you are interested in.

To set all options to default values run application with /default suffix:  <path>phoneex.exe /default
       
back to the top

* Developers corner
 Dialer can be controlled by using the following 3 methods:
   * from the command line prompt:  see How to use Excel Dialer Pro from the command line?
   * Simple VB code sample how to invoke dialer and make a phone call.
   * Windows text messaging by using SendMessage() API
Note:
     1.
       For the list of available commands see: http://www.phonedialerpro.com/faq_pdp.htm#command_line
     2.
       When using SendMessage() API:

   LRESULT SendMessage(      
    HWND hWnd,
    UINT Msg,
    WPARAM wParam,
    LPARAM lParam
   );

    hWnd
          retrieve and use the value stored in Windows registry: HKEY_CURRENT_USER\Software\Jacek Kozlowski\Excel Dialer Pro\hkey
     Msg
          use WM_COPYDATA
     wParam
          0
     lParam
           structure containing information to be send
           .lpData   should contain command
           .dwData = 1 use only with commands: "", "min" and "setup"
           .dwData = 2 use only with "script...." command
           .dwData = 3 use with all other commands                                            back to the top

 


© 2008 Phone Dialer Pro - Home -   - Contact Us -   - Advertisers -   - Support -   - Site Map -

Copyright © 1999-2008 . All rights reserved.
Last revised: February 14, 2010