i have a database called menagerie, i have a table inside called list, with fields: number, value and date. using a get tt string, what sql statement should i use from teleflow to get the number fields out put to the console?

I'm not sure what you are trying to accomplish, but I can suggest a couple things relating to what I think you might be after.

If you are using a "Get TT String" step to get an input from the caller, it doesn't do anything with SQL. You can use it to get a TeleFlow variable, such as @TT_INPUT, then use that in a SQL Statement step, such as:
SELECT
value,
date as MY_DATE
FROM
list
WHERE
number = @TT_INPUT

I'm not sure what you are looking for with output to console. Do you wish to output a value to the TeleFlow Monitor? If so, set @SYS_DATA = @VALUE in a "Set Global Variable" step after running the "SQL Statement" and "SQL Fetch" steps to get your row.

Feel free to clarify what you're after if I haven't touched on everything.

thank you for your assistance, however the statement didnt work, I am trying to build an application similar to the ticket file in the lottery demonstration. e.g "Fast food restaurant having a promotion. to redeem your voucher, at the touch tone enter the voucher 4 digit number".

I am looking for callers input, that will co-relate with the functions of the dbase file to output the voucher value back to the caller. I hope i have been able to properly explain. Thanks again.

Well, I didn't necessarily intend that SQL statement to work... I wasn't even sure the table you described was anything other than an example.

First off, you have to have an ODBC entry defined that points to the database or tables you are using, and you have to use a "DB Connect" step in your TeleFlow application to connect to it.

When you run the TeleFlow Simulator to test, click the "Show Log" button and check for what went wrong. If you can't figure out what the problem is from the log, post it here.

My mistake i had thought that was the command, well i couldnt really figure it out so i will post it here. Thank you for your assistance.

2009/02/10 14:01:03.910: Loading language 'C:\Program Files\TeleFlow\Lang_English.dll'
2009/02/10 14:01:03.954: Setting system variable '@SYSDRIVE' to 'C:'
2009/02/10 14:01:03.957: Setting system variable '@SYSDIR' to '\Users\vixen\AppData\Roaming\TeleFlow\Applications'
2009/02/10 14:01:03.958: TeleFlow Application: C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\NewApplication.tap
2009/02/10 14:01:03.958: Ver: 0200 S/N: 00000
2009/02/10 14:01:03.959: TeleFlow Voice Database: C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Tam\Voice.dbf
2009/02/10 14:01:03.960: Voice file search path: None
2009/02/10 14:01:03.961: TeleFlow Procedure: > Tam\test.tam
Ver: 0200 S/N: 00000
2009/02/10 14:01:03.963: TeleFlow Procedure: Tam\DbSet.tam
Ver: 0200 S/N: 00000
2009/02/10 14:01:03.965: TeleFlow Procedure: Tam\DbRetry.tam
Ver: 0200 S/N: 00000
2009/02/10 14:01:03.966: TeleFlow Procedure: Tam\InputMan.tam
Ver: 0200 S/N: 00000
2009/02/10 14:01:03.968: TeleFlow Procedure: Tam\MM_MENU.tam
Ver: 0200 S/N: 00000
2009/02/10 14:01:03.970: TeleFlow Procedure: Tam\Defaults.tam
Ver: 0200 S/N: 00000
2009/02/10 14:01:03.973: TeleFlow Procedure: Tam\WaitForCall.tam
Ver: 0200 S/N: 00000
2009/02/10 14:01:03.975: TeleFlow Procedure: Tam\Exit.tam
Ver: 0200 S/N: 00000
2009/02/10 14:01:03.976: TeleFlow Procedure: Tam\MenuMan.tam
Ver: 0200 S/N: 00000
2009/02/10 14:01:03.978: TeleFlow Procedure: Tam\TICKET.tam
Ver: 0200 S/N: 00000
2009/02/10 14:01:03.980: TeleFlow Procedure: Tam\MenuSet.tam
Ver: 0200 S/N: 00000
2009/02/10 14:01:03.981: Setting system variable '@SYSDRIVE' to 'C:'
2009/02/10 14:01:03.982: Setting system variable '@SYSDIR' to '\Users\vixen\AppData\Roaming\TeleFlow\Applications'
2009/02/10 14:01:03.982: Setting system variable '@P1' to ''
2009/02/10 14:01:03.983: Setting system variable '@P2' to ''
2009/02/10 14:01:03.984: Setting system variable '@P3' to ''
2009/02/10 14:01:03.984: Setting system variable '@P4' to ''
2009/02/10 14:01:03.985: Setting system variable '@P5' to ''
2009/02/10 14:01:03.985: Setting system variable '@P6' to ''
2009/02/10 14:01:03.986: Setting system variable '@P7' to ''
2009/02/10 14:01:03.986: Setting system variable '@P8' to ''
2009/02/10 14:01:03.987: Setting system variable '@P9' to ''
2009/02/10 14:01:03.987: Setting system variable '@PROMPT' to 'C:\Program Files\TeleFlow\Languages\English'
2009/02/10 14:01:03.988: Setting global variable '@VOLUME' to '0'
2009/02/10 14:01:03.988: Setting global variable '@TIMEOUT' to '3000'
2009/02/10 14:01:03.989: Setting system variable '@FAXQPTR' to ''
2009/02/10 14:01:03.989: Setting system variable '@PORT' to '1'
2009/02/10 14:01:03.990: Setting system variable '@CALL_LINE' to ''
2009/02/10 14:01:03.990: Setting system variable '@SPELLTONES' to ''
2009/02/10 14:01:03.991: Setting system variable '@RECORD_RESULT' to ''
2009/02/10 14:01:03.991: Setting global variable '@SYS_DATA' to ''
2009/02/10 14:01:03.992: Setting system variable '@CHAR_SOH' to '
'
2009/02/10 14:01:03.999: Setting system variable '@CHAR_STX' to ''
2009/02/10 14:01:04.001: Setting system variable '@CHAR_ETX' to ''
2009/02/10 14:01:04.002: Setting system variable '@CHAR_EOT' to ''
2009/02/10 14:01:04.003: Setting system variable '@CHAR_ENQ' to ''
2009/02/10 14:01:04.004: Setting system variable '@CHAR_ACK' to ''
2009/02/10 14:01:04.004: Setting system variable '@CHAR_BEL' to ''
2009/02/10 14:01:04.005: Setting system variable '@CHAR_BS' to ''
2009/02/10 14:01:04.006: Setting system variable '@CHAR_TAB' to ' '
2009/02/10 14:01:04.006: Setting system variable '@TAB' to ' '
2009/02/10 14:01:04.007: Setting system variable '@CHAR_LF' to '
'
2009/02/10 14:01:04.008: Setting system variable '@LINEFEED' to '
'
2009/02/10 14:01:04.009: Setting system variable '@CHAR_VT' to ''
2009/02/10 14:01:04.010: Setting system variable '@CHAR_FF' to ''
2009/02/10 14:01:04.011: Setting system variable '@FORMFEED' to ''
2009/02/10 14:01:04.011: Setting system variable '@CHAR_CR' to '
'
2009/02/10 14:01:04.012: Setting system variable '@CHAR_SO' to ''
2009/02/10 14:01:04.013: Setting system variable '@CHAR_SI' to ''
2009/02/10 14:01:04.013: Setting system variable '@CHAR_DLE' to ''
2009/02/10 14:01:04.014: Setting system variable '@CHAR_DC1' to ''
2009/02/10 14:01:04.015: Setting system variable '@CHAR_DC2' to ''
2009/02/10 14:01:04.015: Setting system variable '@CHAR_DC3' to ''
2009/02/10 14:01:04.016: Setting system variable '@CHAR_DC4' to ''
2009/02/10 14:01:04.017: Setting system variable '@CHAR_NAK' to ''
2009/02/10 14:01:04.018: Setting system variable '@CHAR_SYN' to ''
2009/02/10 14:01:04.018: Setting system variable '@CHAR_ETB' to ''
2009/02/10 14:01:04.019: Setting system variable '@CHAR_CAN' to ''
2009/02/10 14:01:04.021: Setting system variable '@CHAR_EM' to ''
2009/02/10 14:01:04.022: Setting system variable '@CHAR_SUB' to ''
2009/02/10 14:01:04.022: Setting system variable '@CHAR_ESC' to ''
2009/02/10 14:01:04.023: Setting system variable '@CHAR_FS' to ''
2009/02/10 14:01:04.023: Setting system variable '@CHAR_GS' to ''
2009/02/10 14:01:04.024: Setting system variable '@CHAR_RS' to ''
2009/02/10 14:01:04.024: Setting system variable '@CHAR_US' to ''
2009/02/10 14:01:04.025: Setting system variable '@SPACE' to ' '
2009/02/10 14:01:04.026: Setting system variable '@CHAR_DEL' to ''
2009/02/10 14:01:04.026: Setting system variable '@HANGUP' to ''
2009/02/10 14:01:04.027: Setting system variable '@FATAL' to ''
2009/02/10 14:01:04.027: Setting system variable '@CALL_SEIZED' to ''
2009/02/10 14:01:04.028: Setting system variable '@CALL_START' to ''
2009/02/10 14:01:04.028: Setting system variable '@CALL_END' to ''
2009/02/10 14:01:04.029: Setting system variable '@CALL_ELAPSE' to ''
2009/02/10 14:01:04.030: Setting system variable '@WEEKDAY' to ''
2009/02/10 14:01:04.030: Setting system variable '@DATE' to ''
2009/02/10 14:01:04.031: Setting system variable '@TIME' to ''
2009/02/10 14:01:04.031: Setting system variable '@UNIX_TIME' to ''
2009/02/10 14:01:04.032: Setting system variable '@HOOK_STATUS' to ''
2009/02/10 14:01:04.033: Setting system variable '@APPID' to '1001'
2009/02/10 14:01:04.034: Setting system variable '@CALLOUT_RESULT' to ''
2009/02/10 14:01:04.034: Setting system variable '@CALLOUT_REASON' to ''
2009/02/10 14:01:04.035: Setting system variable '@TRUNK_TYPE' to ''
2009/02/10 14:01:04.035: Setting system variable '@SYS_CALLREF' to ''
2009/02/10 14:01:04.036: Initializing...

2009/02/10 14:01:04.037:
Initialization done

2009/02/10 14:01:04.039: ==>test
2009/02/10 14:01:04.039: [1] START
2009/02/10 14:01:04.041: [3] Global Event
2009/02/10 14:01:04.042: Label is 'APPLICATION_ERROR'
2009/02/10 14:01:04.044: Setting system variable '@FATAL' to 'APPLICATION_ERROR'
2009/02/10 14:01:04.045: [4] Global Event
2009/02/10 14:01:04.046: Label is 'CALLER_GONE'
2009/02/10 14:01:04.047: Setting system variable '@HANGUP' to 'CALLER_GONE'
2009/02/10 14:01:04.048: [5] DB Connect
2009/02/10 14:01:04.049: Parameters is 'DSN=dBASE Files'
2009/02/10 14:01:04.049: ConnectString: DSN=dBASE Files
2009/02/10 14:01:04.124: SQL Error State: HY092
Native Error Code: 56
ODBC Error: [Microsoft][ODBC dBASE Driver]Invalid attribute/option identifier
2009/02/10 14:01:04.126: [10] Run Flowchart
2009/02/10 14:01:04.127: Flowchart is 'DEFAULTS'
2009/02/10 14:01:04.128: test==>
Defaults
2009/02/10 14:01:04.129: [1] START
2009/02/10 14:01:04.130: [122] Set Language
2009/02/10 14:01:04.131: Location of prompt recordings is ''
2009/02/10 14:01:04.132: Language module 'C:\Program Files\TeleFlow\Lang_English.dll' already loaded
2009/02/10 14:01:04.133: Setting system variable '@PROMPT' to 'C:\Program Files\TeleFlow\Languages\English'
2009/02/10 14:01:04.134: [86] Set Global Variable
2009/02/10 14:01:04.135: Setting global variable '@MENULOOP' to '3'
2009/02/10 14:01:04.136: [96] Set Global Variable
2009/02/10 14:01:04.137: Setting global variable '@DBLOOP' to '4'
2009/02/10 14:01:04.138: [100] Set Global Variable
2009/02/10 14:01:04.139: Setting global variable '@PLAY_VOLUME' to '0'
2009/02/10 14:01:04.141: [102] Set Global Variable
2009/02/10 14:01:04.142: Setting global variable '@REC_VOLUME' to '0'
2009/02/10 14:01:04.143: [107] Set Global Variable
2009/02/10 14:01:04.144: Setting global variable '@SYSLOC' to 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications'
2009/02/10 14:01:04.145: [104] Connect Point
2009/02/10 14:01:04.146: [105] Connect Point
2009/02/10 14:01:04.147: [88] Set Global Variable
2009/02/10 14:01:04.148: Setting global variable '@COUNTER' to '0'
2009/02/10 14:01:04.149: [98] Set Global Variable
2009/02/10 14:01:04.150: Setting global variable '@DB_COUNTER' to '0'
2009/02/10 14:01:04.151: [109] Set Global Variable
2009/02/10 14:01:04.152: Setting global variable '@VOLUME' to '0'
2009/02/10 14:01:04.155: [111] Compare
2009/02/10 14:01:04.156: First Value '@TRUNK_TYPE' evaluates to 'SIMULATED'
2009/02/10 14:01:04.157: Second Value is 'ANALOG'
2009/02/10 14:01:04.158: @TRUNK_TYPE = ANALOG?
2009/02/10 14:01:04.158: (string):SIMULATED = (string):ANALOG?
2009/02/10 14:01:04.159: FALSE
2009/02/10 14:01:04.159: [116] Set Global Variable
2009/02/10 14:01:04.160: Setting global variable '@PICKUP_RINGCOUNT' to '0'
2009/02/10 14:01:04.161: [118] Set Global Variable
2009/02/10 14:01:04.162: Setting global variable '@CONNECTION_DELAY' to '500'
2009/02/10 14:01:04.163: [129] Set Global Variable
2009/02/10 14:01:04.164: Setting global variable '@HANG_WAIT' to '1000'
2009/02/10 14:01:04.164: [131] Connect Point
2009/02/10 14:01:04.166: [2] FINISH
2009/02/10 14:01:04.167: test<==Defaults
2009/02/10 14:01:04.167: [18] Compare
2009/02/10 14:01:04.169: First Value '@HOOK_STATUS' evaluates to 'ON-HOOK'
2009/02/10 14:01:04.169: Second Value is 'OFF-HOOK'
2009/02/10 14:01:04.173: @HOOK_STATUS = OFF-HOOK?
2009/02/10 14:01:04.173: (string):ON-HOOK = (string):OFF-HOOK?
2009/02/10 14:01:04.174: FALSE
2009/02/10 14:01:04.174: [23] Set Local Variable
2009/02/10 14:01:04.175: Setting local variable '@FINISH_CALL_ACTION' to 'NEXT_CALL'
2009/02/10 14:01:04.176: [32] Run Flowchart
2009/02/10 14:01:04.177: Flowchart is 'WaitForCall'
2009/02/10 14:01:04.178: test==>
WaitForCall
2009/02/10 14:01:04.179: [1] START
2009/02/10 14:01:04.180: [10] Wait
2009/02/10 14:01:04.182: Delay '@HANG_WAIT' evaluates to '1000'
2009/02/10 14:01:04.183: Waiting 1000 milliseconds
2009/02/10 14:01:05.184: numWaitObjects = 5, WAIT_OBJECT_0 + 2 = 2, ret = 2 - @@@
2009/02/10 14:01:05.185: [7] Compare
2009/02/10 14:01:05.186: First Value '@TRUNK_TYPE' evaluates to 'SIMULATED'
2009/02/10 14:01:05.187: Second Value is 'ANALOG'
2009/02/10 14:01:05.187: @TRUNK_TYPE = ANALOG?
2009/02/10 14:01:05.188: (string):SIMULATED = (string):ANALOG?
2009/02/10 14:01:05.189: FALSE
2009/02/10 14:01:05.189: [5] Wait for Call
2009/02/10 14:01:05.190: TIMEOUT is '0'
2009/02/10 14:01:05.191: WARNING: TIMEOUT '0' evaluates to 0 and is interpreted as no timeout
2009/02/10 14:01:05.192: Rings '@PICKUP_RINGCOUNT' evaluates to '0'
2009/02/10 14:01:05.192: Connection Delay '@CONNECTION_DELAY' evaluates to '500'
2009/02/10 14:01:06.693: Wait for 0 rings and then pickup
2009/02/10 14:01:11.607: Setting global variable '@CALLER_ID' to ''
2009/02/10 14:01:11.609: Setting global variable '@DNIS' to ''
2009/02/10 14:01:11.610: Connection delay: 500 ms
2009/02/10 14:01:12.111: [2] FINISH
2009/02/10 14:01:12.112: test<==WaitForCall
2009/02/10 14:01:12.113: [7] Run Flowchart
2009/02/10 14:01:12.115: Flowchart is 'MM_MENU'
2009/02/10 14:01:12.117: test==>
MM_MENU
2009/02/10 14:01:12.118: [100] START
2009/02/10 14:01:12.119: [217] Play
2009/02/10 14:01:12.120: Script code is 'new'
2009/02/10 14:01:12.122: Script code 'new' corresponds to file 'Vox\Eng\Scripts\new.wav'
2009/02/10 14:01:12.125: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\new.wav'
2009/02/10 14:01:19.797: [156] Clear TT
2009/02/10 14:01:19.799: [209] Play
2009/02/10 14:01:19.800: Script code is 'mm'
2009/02/10 14:01:19.801: Script code 'mm' corresponds to file 'Vox\Eng\Scripts\mm.wav'
2009/02/10 14:01:19.802: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\mm.wav'
2009/02/10 14:01:23.943: [105] Play
2009/02/10 14:01:23.944: Script code is 'mmA'
2009/02/10 14:01:23.945: Script code 'mmA' corresponds to file 'Vox\Eng\Scripts\mm02.wav'
2009/02/10 14:01:23.946: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\mm02.wav'
2009/02/10 14:01:27.413: [107] Play
2009/02/10 14:01:27.415: Script code is 'PRESS01'
2009/02/10 14:01:27.417: Script code 'PRESS01' corresponds to file 'Vox\Eng\Scripts\press01.wav'
2009/02/10 14:01:27.418: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\press01.wav'
2009/02/10 14:01:28.891: [109] Play
2009/02/10 14:01:28.894: Script code is 'TT'
2009/02/10 14:01:28.895: Script code 'TT' corresponds to file 'Vox\Eng\Scripts\TT.wav'
2009/02/10 14:01:28.896: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\TT.wav'
2009/02/10 14:01:29.323: Interrupted by touch tone
2009/02/10 14:01:29.347: [111] Play
2009/02/10 14:01:29.349: Script code is 'PRESS02'
2009/02/10 14:01:29.350: Script code 'PRESS02' corresponds to file 'Vox\Eng\Scripts\press02.wav'
2009/02/10 14:01:29.350: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\press02.wav'
2009/02/10 14:01:29.351: Interrupted!
2009/02/10 14:01:29.351: [117] Play
2009/02/10 14:01:29.352: Script code is 'LG'
2009/02/10 14:01:29.353: Script code 'LG' corresponds to file 'Vox\Eng\Scripts\LG.wav'
2009/02/10 14:01:29.354: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\LG.wav'
2009/02/10 14:01:29.354: Interrupted!
2009/02/10 14:01:29.355: [119] Play
2009/02/10 14:01:29.356: Script code is 'PRESS03'
2009/02/10 14:01:29.357: Script code 'PRESS03' corresponds to file 'Vox\Eng\Scripts\press03.wav'
2009/02/10 14:01:29.358: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\press03.wav'
2009/02/10 14:01:29.358: Interrupted!
2009/02/10 14:01:29.359: [129] Menu
2009/02/10 14:01:29.360: TIMEOUT is ''
2009/02/10 14:01:29.362: Empty TIMEOUT defaults to '@TIMEOUT', and evaluates to '3000'
2009/02/10 14:01:29.362: Grammar is ''
2009/02/10 14:01:29.363: Grammar Text is ''
2009/02/10 14:01:29.363: Got: '2'
2009/02/10 14:01:29.364: [150] Run Flowchart
2009/02/10 14:01:29.365: Flowchart is 'TICKET'
2009/02/10 14:01:29.366: MM_MENU==>
TICKET
2009/02/10 14:01:29.367: [1] START
2009/02/10 14:01:29.368: [7] Run Flowchart
2009/02/10 14:01:29.369: Flowchart is 'MenuSet'
2009/02/10 14:01:29.369: TICKET==>
MenuSet
2009/02/10 14:01:29.371: [100] START
2009/02/10 14:01:29.372: [102] Set Global Variable
2009/02/10 14:01:29.374: Setting global variable '@COUNTER' to '3'
2009/02/10 14:01:29.376: [101] FINISH
2009/02/10 14:01:29.377: TICKET<==MenuSet
2009/02/10 14:01:29.378: [3] Play
2009/02/10 14:01:29.379: Script code is 'TICKET01'
2009/02/10 14:01:29.381: Script code 'TICKET01' corresponds to file 'Vox\Eng\Scripts\ticket01.wav'
2009/02/10 14:01:29.382: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\ticket01.wav'
2009/02/10 14:01:34.130: Interrupted by touch tone
2009/02/10 14:01:34.209: [5] Get TT String
2009/02/10 14:01:34.210: TIMEOUT is ''
2009/02/10 14:01:34.211: Empty TIMEOUT defaults to '@TIMEOUT', and evaluates to '3000'
2009/02/10 14:01:34.212: Maximum TTs is '6'
2009/02/10 14:01:34.212: Allowable TTs is '1234567890'
2009/02/10 14:01:34.214: Termination TTs is '*#'
2009/02/10 14:01:34.215: Setting global variable '@TT_INPUT' to ''
2009/02/10 14:01:39.468: Got: '789674'
2009/02/10 14:01:39.471: Setting global variable '@TT_INPUT' to '789674'
2009/02/10 14:01:39.472: [45] Run Flowchart
2009/02/10 14:01:39.472: Flowchart is 'dbset'
2009/02/10 14:01:39.473: TICKET==>
DbSet
2009/02/10 14:01:39.475: [1] START
2009/02/10 14:01:39.475: [3] Set Global Variable
2009/02/10 14:01:39.476: Setting global variable '@DB_COUNTER' to '4'
2009/02/10 14:01:39.477: [2] FINISH
2009/02/10 14:01:39.478: TICKET<==DbSet
2009/02/10 14:01:39.479: [9] SQL Statement
2009/02/10 14:01:39.480: Handle is '1'
2009/02/10 14:01:39.481: Warning time threshold is ''
2009/02/10 14:01:39.482: Empty Warning time threshold defaults to '2000'
2009/02/10 14:01:39.483: <----- BEGIN ----->
SELECT
prize,
issue
FROM
voucher
WHERE
number = 789674



<----- END ----->
2009/02/10 14:01:39.498: Error code -1 returned from ODBC driver
2009/02/10 14:01:39.499: SQL Error State: 42S02?Å
Native Error Code: FFFFFAE7
ODBC Error: [Microsoft][ODBC dBASE Driver] The Microsoft Office Access database engine could not find the object 'voucher'. Make sure the object exists and that you spell its name and the path name correctly.
2009/02/10 14:01:39.501: Elapsed Time: 0.021
2009/02/10 14:01:39.502: FAILURE
2009/02/10 14:01:39.503: ERROR: Missing next step
2009/02/10 14:01:39.504: FATAL
2009/02/10 14:01:39.504: Attempting to jump to Fatal Error Global Event label: 'APPLICATION_ERROR'
2009/02/10 14:01:39.505: MM_MENU<==TICKET
2009/02/10 14:01:39.505: test<==MM_MENU
2009/02/10 14:01:39.508: Setting system variable '@FATAL' to ''
2009/02/10 14:01:39.508: [8] Label
2009/02/10 14:01:39.510: Label: APPLICATION_ERROR
2009/02/10 14:01:39.512: [17] Run Flowchart
2009/02/10 14:01:39.512: Flowchart is 'Exit'
2009/02/10 14:01:39.513: test==>
Exit
2009/02/10 14:01:39.514: [1] START
2009/02/10 14:01:39.515: [8] Global Event
2009/02/10 14:01:39.515: Label is 'EXIT_END'
2009/02/10 14:01:39.517: Setting system variable '@FATAL' to 'EXIT_END'
2009/02/10 14:01:39.517: [11] Global Event
2009/02/10 14:01:39.518: Label is 'EXIT_END'
2009/02/10 14:01:39.518: Setting system variable '@HANGUP' to 'EXIT_END'
2009/02/10 14:01:39.519: [13] Compare
2009/02/10 14:01:39.520: First Value '@HOOK_STATUS' evaluates to 'OFF-HOOK'
2009/02/10 14:01:39.521: Second Value is 'OFF-HOOK'
2009/02/10 14:01:39.522: @HOOK_STATUS = OFF-HOOK?
2009/02/10 14:01:39.523: (string):OFF-HOOK = (string):OFF-HOOK?
2009/02/10 14:01:39.523: TRUE
2009/02/10 14:01:39.524: [3] Play
2009/02/10 14:01:39.525: Script code is 'PROB_TECHNICAL'
2009/02/10 14:01:39.525: ERROR: Script code 'PROB_TECHNICAL' is not in the Voice Script Manager
2009/02/10 14:01:39.526: FATAL
2009/02/10 14:01:39.526: Attempting to jump to Fatal Error Global Event label: 'EXIT_END'
2009/02/10 14:01:39.527: Setting system variable '@FATAL' to ''
2009/02/10 14:01:39.528: [12] Label
2009/02/10 14:01:39.529: Label: EXIT_END
2009/02/10 14:01:39.530: [2] FINISH
2009/02/10 14:01:39.531: test<==Exit
2009/02/10 14:01:39.532: [2] FINISH
2009/02/10 14:01:39.533: End of application.
2009/02/10 14:01:39.533: Hanging up
2009/02/10 14:01:42.535:


2009/02/10 14:01:42.574: All memory released. Exiting...

Thanks

Here are the standout issues I see:

and


There is nothing specifically wrong with the first quoted section, as it does make a connection, but it is a little odd to have a data source named "dBASE Files" that refers to an MS Access database.

I would suggest you review the ODBC data source referenced in the "DB Connect" step. Does the "dBASE Files" data source refer to your database? Does it actually reference the database file, directory, server ip, name itself(which of these is required varies based on the database in use)? Does that database contain a table named "voucher"?

in my odbc i have 2 dbase driver files 1 with "microsoft access dBASE driver", other "driver do microsoft access", 1 excel and 1 MS Access Database.

i have been actaully trying to connect directly from the odbc administrator to my particular database but i keep failing, tells me connection failed,

So i guess thats why it doesnt locate the database to run the statement against.

Do you have any suggestions on how i can connect my MS access database to the odbc without using teleflow, cos if i can do this then the proper db connection wil be made as i dont think teleflow is actually connecting to the right database. yes i do have a table in my database called voucher and also the db name i called vouucher as well.

Please Advice
Thank you.

I'm afraid I can't tell you why it's failing. In my MS Access ODBC setup, I don't even see an option to test the connection at all, so I can't necessarily provide you pointers in that regard. I can tell you this is how I would set up the ODBC entry... maybe this will help.
(In Windows XP)

*Start >> Settings >> Control Panel >> Administrative Tools >> Data Sources (ODBC)
* Switch to System DSN tab
* Click "Add..."
* Select "Microsoft Access Driver (*.mdb)" and click "Finish"
* Make the "Data Source Name:" something meaningful that relates to your database and/or project/application.
* Click "Select..."
* Locate the database file on disk and select it.
* Ensure that your DB Connect step in TeleFlow uses the data source name you specified in the ODBC Data Source Administrator.

If you can't make connections successfully at that point, you might want to look to Microsoft help/support resources to get the data source properly defined before attempting to use it in TeleFlow.


A final point: MS Access may work fine for testing, but we recommend against using it in production. We tried in the past, and there are some problems that you can only create workarounds for, and even then, they can occassionally stall your lines.

Hi there,

Thanks for your help as the info you provided me was of uttermost assistance,

I finally got the service working as the major problem i had, was my odbc connector was not pointing directly to my Database. with i solved using mysql odbc connector 3.51 version as the 5.1 version still experiences parameter bugs.

Please how do i connect the Teleflow application to a telephone number, so it does the functions of an ivr.

Thank you.

Hi,

I noticed in the deploy teleflow app in the manual it has something to do with teleflow line list, when i try to open my saved application which was saved in application folder, i do not find it only the AnswerTest seems to be visible.

My saved application works fine with the simulator but when i click into the other folders, like the tam, vox and log they are all empty, how is that. because when i open the AnswerTest file, i see the folders in there are populated.

Please also remember i duplicated steps from one of the demonstartions on teleflow and then just saved it in the application folder as "NewApplication".

I hope you do understand my gibberish as i feel as though its all over the place.

Please assist.

If you follow the help chapters and topics relating to configuring and deploying, this will get you well on your way to your goal.

Specifically, start with the following chapters and topics:
- 3 - Configure TeleFlow Server

* TeleFlow Line List
* TeleFlow Config
* TeleFlow Register (NOTE: This is needed only if you are licensing TeleFlow, which is not required for initial setup. You can run in demo mode if you skip this step.)

- 4 - Running TeleFlow Server as a Service

As for why you can't locate your TeleFlow Application on disk, I'm not sure. I suggest the following:

* Open your application in TeleFlow Designer.
* Click "File", then "Open Application Folder in Explorer". This should take you to the correct path and file for your application.

The topics I suggest don't address hardware, other than to tell you how to configure TeleFlow to run the hardware you are using. What telephony hardware are you intending to run your application(s) on?

Hello,

I was able to locate the path of application on my hard drive by opening it with windows explorer, thanx. so i have been able to build the teleflow line list.

When i open the TFconfig, it already selects the dialogic, i added the app from the line list and selected start tf server automatic mode and click ok, i get a message saying i have to restart TFserver from the service control manager, which i have done.

As i read on it says to configure the TFserver i have to have hardware installed. BUt as i opened the service control to restart TFserver i noticed a telephony service running.

Please does this mean i probable have voice card insalled or i definitely have to buy and install a proper voice/telephony card?

Please explain
Thanx.

If the service you are referring to is named "Telephony", this is a service for TAPI, and won't allow you to run anything live(I.e. on a telephone line) with TeleFlow.

So yes, you will need to buy and install a proper voice/telephony card in order to connect a phone line.

If you can describe your anticipated needs (in terms of simultaneous calls, and the types of application(s) you intend to run), I can provide some advice in terms of what cards might work for you.

Looking to run an app. where x amount of inbound calls come in to query a database. No intended transferred calls but would like to make provision for the transfer call option just in case the need arises.

Also looking to run the setup from a laptop, is this possible using a voice modem or what would you recommend?

Please Advise,
Thanx

The "x" calls is important to the determination of the appropriate card. If you expect to only ever have 1 or 2 simultaneous calls at one time, this is much different than 10-20 simultaneous calls.

So, your expected functionality is all "basic IVR"? (I.e. Answer the phone, accept touch-tone inputs, get/put data from/in the database, possibly do call transfers)

TeleFlow doesn't work with modems, you will need a telephony card. TeleFlow has support for Dialogic, NMS, and Ai-Logix cards, although active applications (those that answer calls) are primarily run on Dialogic or NMS hardware.

Those cards won't fit in a laptop, and in fact, you even have to be careful about a server-grade computer you intend to put a telephony card in, because many of these haven't the room in the case for some of the larger (full-length) cards.

I expect that there could be as many as 20 simultaneous call coming in at the same time and it a basci ivr app. what u think wil be the best board for this?

When choosing a server type computer, what exact specifications do u recommend be built, that will function with teleflow?

Thanks

For 20 simultaneous calls, your best bet would be to get a PRI (ISDN), which is good for up to 23.

I would recommend an NMS CG 6060 card. If you have a reasonable expectation that you will get to a higher number of calls relatively quickly, you might want to consider getting a dual card (I.e. One capable of hosting 2 ISDN spans, for a total of 46 channels/simultaneous calls)

Just so you know: When it comes to transfers on ISDN, you have to have some channels dedicated to making outbound calls.

For assistance with pricing/purchasing a card, please contact sales@engenic.com.

As for the server, the following link should provide the details you are looking for:
TeleFlow System Requirements