I can't get Teleflow to "talk to" MS Excel.

peterg99 · **Joined:** Sat Sep 15, 2007 6:22 am **Posts:** 2

See Subject.

Sorry for the terseness, but that's the short and long of it.

Chris · **Posted:** Mon Nov 26, 2007 10:54 am

How are you trying to establish communication between TeleFlow and MS Excel? (I.e. What step(s) are you using?)

When you use the steps you believe should work, what results/behavior are you seeing? A clipping of a log with some of the issue would probably help.

Thanks!

peterg99 · **Joined:** Sat Sep 15, 2007 6:22 am **Posts:** 2

How are you trying to establish communication between TeleFlow and MS Excel? (I.e. What step(s) are you using?)

Here are the sections from the an aborted Trans Log that shows my Excel/ODBC connection (underlined):

2008/01/02 11:39:00.125: ==>Main
2008/01/02 11:39:00.125: [1] START
2008/01/02 11:39:00.140: [2] Global Event
2008/01/02 11:39:00.140: Label is 'APPLICATION_ERROR'
2008/01/02 11:39:00.140: Setting system variable '@FATAL' to 'APPLICATION_ERROR'
2008/01/02 11:39:00.140: [3] Global Event
2008/01/02 11:39:00.140: Label is 'CALLER_GONE'
2008/01/02 11:39:00.140: Setting system variable '@HANGUP' to 'CALLER_GONE'
2008/01/02 11:39:00.140: [7] DB Connect
2008/01/02 11:39:00.140: Parameters is 'DSN=TE'
2008/01/02 11:39:00.140: ConnectString: DSN=TE
2008/01/02 11:39:01.125: SQL Error State: HY092
Native Error Code: 56
ODBC Error: [Microsoft][ODBC Excel Driver]Invalid attribute/option identifier
2008/01/02 11:39:01.125: [31] Run Flowchart
2008/01/02 11:39:01.125: Flowchart is 'DEFAULTS'

******************************

Here is the first SELECT Statement (underlined):

LoadSystem==>
DbSet
2008/01/02 11:45:19.046: [1] START
2008/01/02 11:45:19.046: [3] Set Global Variable
2008/01/02 11:45:19.046: Setting global variable '@DB_COUNTER' to '4'
2008/01/02 11:45:19.046: [2] FINISH
2008/01/02 11:45:19.046: LoadSystem<==DbSet
2008/01/02 11:45:19.046: [2] SQL Statement
2008/01/02 11:45:19.062: Handle is '1'
2008/01/02 11:45:19.062: Warning time threshold is ''
2008/01/02 11:45:19.062: Empty Warning time threshold defaults to '2000'
2008/01/02 11:45:19.062: <BEGIN>
SELECT
*
from
\Program Files\TeleFlow\Databases\ivrconfig

<END>
2008/01/02 11:45:19.125: Error code -1 returned from ODBC driver
2008/01/02 11:45:19.125: SQL Error State: 42000
Native Error Code: FFFFF24E
ODBC Error: [Microsoft][ODBC Excel Driver] Syntax error in FROM clause.

*****************************8

And attached below is the entire log from this session. Thanks for your help.
PG

2008/01/02 11:38:59.625: Loading language 'C:\Program Files\TeleFlow\Lang_English.dll'
2008/01/02 11:38:59.906: Setting system variable '@SYSDRIVE' to 'C:'
2008/01/02 11:38:59.906: Setting system variable '@SYSDIR' to '\Program Files\TeleFlow\Templates\Application\Golf Registration'
2008/01/02 11:38:59.906: TeleFlow Application: C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Registry-Excel.TAP
2008/01/02 11:38:59.937: Ver: 0200 S/N: 00000
2008/01/02 11:38:59.937: TeleFlow Voice Database: C:\Program Files\TeleFlow\Templates\Application\Golf Registration\TAM\VOICE.DBF
2008/01/02 11:38:59.937: Voice file search path: None
2008/01/02 11:38:59.953: TeleFlow Procedure: Tam\DbRetry.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:38:59.953: TeleFlow Procedure: Tam\DbSet.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:38:59.953: TeleFlow Procedure: Tam\Defaults.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:38:59.968: TeleFlow Procedure: Tam\InputMan.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:38:59.968: TeleFlow Procedure: Tam\LoadSystem.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:38:59.984: TeleFlow Procedure: > Tam\Main.tam
Ver: 0200 S/N: 00000
2008/01/02 11:38:59.984: TeleFlow Procedure: Tam\MainMenu.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:39:00.000: TeleFlow Procedure: Tam\MenuMan.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:39:00.000: TeleFlow Procedure: Tam\MenuSet.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:39:00.000: TeleFlow Procedure: Tam\SetDayScripts.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:39:00.015: TeleFlow Procedure: Tam\ValidateReqTime.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:39:00.031: TeleFlow Procedure: Tam\ReserveTime.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:39:00.031: TeleFlow Procedure: Tam\MemberLogin.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:39:00.046: TeleFlow Procedure: Tam\BuildSchedule.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:39:00.046: TeleFlow Procedure: Tam\SetNextTime.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:39:00.062: TeleFlow Procedure: Tam\Exit.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:39:00.062: TeleFlow Procedure: Tam\WaitForCall.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:39:00.062: TeleFlow Procedure: Tam\Logger.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:39:00.062: TeleFlow Procedure: Tam\MaintMode.Tam
Ver: 0200 S/N: 00000
2008/01/02 11:39:00.078: Setting system variable '@SYSDRIVE' to 'C:'
2008/01/02 11:39:00.078: Setting system variable '@SYSDIR' to '\Program Files\TeleFlow\Templates\Application\Golf Registration'
2008/01/02 11:39:00.078: Setting system variable '@P1' to '1'
2008/01/02 11:39:00.078: Setting system variable '@P2' to ''
2008/01/02 11:39:00.078: Setting system variable '@P3' to ''
2008/01/02 11:39:00.078: Setting system variable '@P4' to ''
2008/01/02 11:39:00.078: Setting system variable '@P5' to ''
2008/01/02 11:39:00.078: Setting system variable '@P6' to ''
2008/01/02 11:39:00.078: Setting system variable '@P7' to ''
2008/01/02 11:39:00.078: Setting system variable '@P8' to ''
2008/01/02 11:39:00.078: Setting system variable '@P9' to ''
2008/01/02 11:39:00.078: Setting system variable '@PROMPT' to 'C:\Program Files\TeleFlow\Languages\English'
2008/01/02 11:39:00.078: Setting global variable '@VOLUME' to '0'
2008/01/02 11:39:00.078: Setting global variable '@TIMEOUT' to '3000'
2008/01/02 11:39:00.078: Setting system variable '@FAXQPTR' to ''
2008/01/02 11:39:00.078: Setting system variable '@PORT' to '1'
2008/01/02 11:39:00.078: Setting system variable '@CALL_LINE' to ''
2008/01/02 11:39:00.078: Setting system variable '@SPELLTONES' to ''
2008/01/02 11:39:00.078: Setting system variable '@RECORD_RESULT' to ''
2008/01/02 11:39:00.078: Setting global variable '@SYS_DATA' to ''
2008/01/02 11:39:00.078: Setting system variable '@CHAR_SOH' to ''
2008/01/02 11:39:00.093: Setting system variable '@CHAR_STX' to ''
2008/01/02 11:39:00.093: Setting system variable '@CHAR_ETX' to ''
2008/01/02 11:39:00.093: Setting system variable '@CHAR_EOT' to ''
2008/01/02 11:39:00.093: Setting system variable '@CHAR_ENQ' to ''
2008/01/02 11:39:00.093: Setting system variable '@CHAR_ACK' to ''
2008/01/02 11:39:00.093: Setting system variable '@CHAR_BEL' to ''
2008/01/02 11:39:00.093: Setting system variable '@CHAR_BS' to ''
2008/01/02 11:39:00.093: Setting system variable '@CHAR_TAB' to ' '
2008/01/02 11:39:00.093: Setting system variable '@TAB' to ' '
2008/01/02 11:39:00.093: Setting system variable '@CHAR_LF' to '
'
2008/01/02 11:39:00.093: Setting system variable '@LINEFEED' to '
'
2008/01/02 11:39:00.093: Setting system variable '@CHAR_VT' to ''
2008/01/02 11:39:00.093: Setting system variable '@CHAR_FF' to ''
2008/01/02 11:39:00.093: Setting system variable '@FORMFEED' to ''
2008/01/02 11:39:00.093: Setting system variable '@CHAR_CR' to '
'
2008/01/02 11:39:00.093: Setting system variable '@CHAR_SO' to ''
2008/01/02 11:39:00.093: Setting system variable '@CHAR_SI' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_DLE' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_DC1' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_DC2' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_DC3' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_DC4' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_NAK' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_SYN' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_ETB' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_CAN' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_EM' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_SUB' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_ESC' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_FS' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_GS' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_RS' to ''
2008/01/02 11:39:00.109: Setting system variable '@CHAR_US' to ''
2008/01/02 11:39:00.109: Setting system variable '@SPACE' to ' '
2008/01/02 11:39:00.109: Setting system variable '@CHAR_DEL' to ''
2008/01/02 11:39:00.109: Setting system variable '@HANGUP' to ''
2008/01/02 11:39:00.109: Setting system variable '@FATAL' to ''
2008/01/02 11:39:00.109: Setting system variable '@CALL_SEIZED' to ''
2008/01/02 11:39:00.109: Setting system variable '@CALL_START' to ''
2008/01/02 11:39:00.109: Setting system variable '@CALL_END' to ''
2008/01/02 11:39:00.109: Setting system variable '@CALL_ELAPSE' to ''
2008/01/02 11:39:00.109: Setting system variable '@WEEKDAY' to ''
2008/01/02 11:39:00.125: Setting system variable '@DATE' to ''
2008/01/02 11:39:00.125: Setting system variable '@TIME' to ''
2008/01/02 11:39:00.125: Setting system variable '@UNIX_TIME' to ''
2008/01/02 11:39:00.125: Setting system variable '@HOOK_STATUS' to ''
2008/01/02 11:39:00.125: Setting system variable '@APPID' to '1001'
2008/01/02 11:39:00.125: Setting system variable '@CALLOUT_RESULT' to ''
2008/01/02 11:39:00.125: Setting system variable '@CALLOUT_REASON' to ''
2008/01/02 11:39:00.125: Setting system variable '@TRUNK_TYPE' to ''
2008/01/02 11:39:00.125: Setting system variable '@SYS_CALLREF' to ''
2008/01/02 11:39:00.125: Initializing...

2008/01/02 11:39:00.125:
Initialization done

2008/01/02 11:39:00.125: ==>Main
2008/01/02 11:39:00.125: [1] START
2008/01/02 11:39:00.140: [2] Global Event
2008/01/02 11:39:00.140: Label is 'APPLICATION_ERROR'
2008/01/02 11:39:00.140: Setting system variable '@FATAL' to 'APPLICATION_ERROR'
2008/01/02 11:39:00.140: [3] Global Event
2008/01/02 11:39:00.140: Label is 'CALLER_GONE'
2008/01/02 11:39:00.140: Setting system variable '@HANGUP' to 'CALLER_GONE'
2008/01/02 11:39:00.140: [7] DB Connect
2008/01/02 11:39:00.140: Parameters is 'DSN=TE'
2008/01/02 11:39:00.140: ConnectString: DSN=TE
2008/01/02 11:39:01.125: SQL Error State: HY092
Native Error Code: 56
ODBC Error: [Microsoft][ODBC Excel Driver]Invalid attribute/option identifier
2008/01/02 11:39:01.125: [31] Run Flowchart
2008/01/02 11:39:01.125: Flowchart is 'DEFAULTS'
2008/01/02 11:39:01.140: Main==>
Defaults
2008/01/02 11:39:01.140: [1] START
2008/01/02 11:39:01.140: [122] Set Language
2008/01/02 11:39:01.140: Location of prompt recordings is ''
2008/01/02 11:39:01.140: Language module 'C:\Program Files\TeleFlow\Lang_English.dll' already loaded
2008/01/02 11:39:01.140: Setting system variable '@PROMPT' to 'C:\Program Files\TeleFlow\Languages\English'
2008/01/02 11:39:01.140: [86] Set Global Variable
2008/01/02 11:39:01.140: Setting global variable '@MENULOOP' to '3'
2008/01/02 11:39:01.140: [96] Set Global Variable
2008/01/02 11:39:01.140: Setting global variable '@DBLOOP' to '4'
2008/01/02 11:39:01.156: [100] Set Global Variable
2008/01/02 11:39:01.156: Setting global variable '@PLAY_VOLUME' to '0'
2008/01/02 11:39:01.156: [102] Set Global Variable
2008/01/02 11:39:01.156: Setting global variable '@REC_VOLUME' to '0'
2008/01/02 11:39:01.156: [107] Set Global Variable
2008/01/02 11:39:01.156: Setting global variable '@SYSLOC' to 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration'
2008/01/02 11:39:01.156: [104] Connect Point
2008/01/02 11:39:01.156: [105] Connect Point
2008/01/02 11:39:01.156: [88] Set Global Variable
2008/01/02 11:39:01.171: Setting global variable '@COUNTER' to '0'
2008/01/02 11:39:01.171: [98] Set Global Variable
2008/01/02 11:39:01.171: Setting global variable '@DB_COUNTER' to '0'
2008/01/02 11:39:01.171: [109] Set Global Variable
2008/01/02 11:39:01.171: Setting global variable '@VOLUME' to '0'
2008/01/02 11:39:01.171: [111] Compare
2008/01/02 11:39:01.171: First Value '@TRUNK_TYPE' evaluates to 'SIMULATED'
2008/01/02 11:39:01.171: Second Value is 'ANALOG'
2008/01/02 11:39:01.171: @TRUNK_TYPE = ANALOG?
2008/01/02 11:39:01.171: (string):SIMULATED = (string):ANALOG?
2008/01/02 11:39:01.171: FALSE
2008/01/02 11:39:01.187: [116] Set Global Variable
2008/01/02 11:39:01.187: Setting global variable '@PICKUP_RINGCOUNT' to '0'
2008/01/02 11:39:01.187: [118] Set Global Variable
2008/01/02 11:39:01.187: Setting global variable '@CONNECTION_DELAY' to '500'
2008/01/02 11:39:01.187: [129] Set Global Variable
2008/01/02 11:39:01.187: Setting global variable '@HANG_WAIT' to '1000'
2008/01/02 11:39:01.296: [131] Connect Point
2008/01/02 11:39:01.312: [132] Set Global Variable
2008/01/02 11:39:01.312: Setting global variable '@FIRSTSHIFT' to '09:00:00'
2008/01/02 11:39:01.312: [134] Set Global Variable
2008/01/02 11:39:01.312: Setting global variable '@LASTSHIFT' to '17:00:00'
2008/01/02 11:39:01.312: [138] Set Global Variable
2008/01/02 11:39:01.312: Setting global variable '@NOTICE_HOURS' to '1'
2008/01/02 11:39:01.312: [136] Set Global Variable
2008/01/02 11:39:01.328: Setting global variable '@INTERVAL' to '420'
2008/01/02 11:39:01.328: [2] FINISH
2008/01/02 11:39:01.328: Main<Defaults>
WaitForCall
2008/01/02 11:39:01.343: [1] START
2008/01/02 11:39:01.343: [10] Wait
2008/01/02 11:39:01.343: Delay '@HANG_WAIT' evaluates to '1000'
2008/01/02 11:39:01.343: Waiting 1000 milliseconds
2008/01/02 11:39:02.343: numWaitObjects = 5, WAIT_OBJECT_0 + 2 = 2, ret = 2 - @@@
2008/01/02 11:39:02.343: [7] Compare
2008/01/02 11:39:02.343: First Value '@TRUNK_TYPE' evaluates to 'SIMULATED'
2008/01/02 11:39:02.343: Second Value is 'ANALOG'
2008/01/02 11:39:02.343: @TRUNK_TYPE = ANALOG?
2008/01/02 11:39:02.343: (string):SIMULATED = (string):ANALOG?
2008/01/02 11:39:02.343: FALSE
2008/01/02 11:39:02.343: [5] Wait for Call
2008/01/02 11:39:02.343: TIMEOUT is '0'
2008/01/02 11:39:02.343: WARNING: TIMEOUT '0' evaluates to 0 and is interpreted as no timeout
2008/01/02 11:39:02.343: Rings '@PICKUP_RINGCOUNT' evaluates to '0'
2008/01/02 11:39:02.343: Connection Delay '@CONNECTION_DELAY' evaluates to '500'
2008/01/02 11:39:03.843: Wait for 0 rings and then pickup
2008/01/02 11:45:18.359: Setting global variable '@CALLER_ID' to ''
2008/01/02 11:45:18.359: Setting global variable '@DNIS' to ''
2008/01/02 11:45:18.359: Connection delay: 500 ms
2008/01/02 11:45:18.859: [2] FINISH
2008/01/02 11:45:18.859: Main<WaitForCall>
Logger
2008/01/02 11:45:18.859: [1] START
2008/01/02 11:45:18.875: [80] Create Folder
2008/01/02 11:45:18.875: Directory is 'Stats'
2008/01/02 11:45:18.890: WARNING: directory 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Stats' already exists
2008/01/02 11:45:18.906: [53] Set Local Variable
2008/01/02 11:45:18.906: Setting local variable '@LOG_VERSION' to '361'
2008/01/02 11:45:18.906: [55] Set Local Variable
2008/01/02 11:45:18.906: Setting local variable '@LOG_YEAR' to ''
2008/01/02 11:45:18.906: [57] Set Local Variable
2008/01/02 11:45:18.906: Setting local variable '@LOG_MONTH' to ''
2008/01/02 11:45:18.906: [59] Set Local Variable
2008/01/02 11:45:18.906: Setting local variable '@LOG_DAY' to ''
2008/01/02 11:45:18.921: [61] Set Local Variable
2008/01/02 11:45:18.921: Setting local variable '@LOG_TIME' to '11:45:18'
2008/01/02 11:45:18.921: [63] Set Local Variable
2008/01/02 11:45:18.921: Setting local variable '@LOG_DATE' to '2008/01/02'
2008/01/02 11:45:18.921: [65] Math
2008/01/02 11:45:18.921: Base value '@LOG_DATE' evaluates to '2008/01/02'
2008/01/02 11:45:18.921: Modifying value is '1'
2008/01/02 11:45:18.921: Number of characters to copy is '4'
2008/01/02 11:45:18.921: @LOG_YEAR = substr (@LOG_DATE, 1, 4)
2008/01/02 11:45:18.921: @LOG_YEAR = substr (2008/01/02, 1, 4)
2008/01/02 11:45:18.921: (integer): 4
2008/01/02 11:45:18.921: Setting local variable '@LOG_YEAR' to '2008'
2008/01/02 11:45:18.921: [66] Math
2008/01/02 11:45:18.921: Base value '@LOG_DATE' evaluates to '2008/01/02'
2008/01/02 11:45:18.953: Modifying value is '6'
2008/01/02 11:45:18.953: Number of characters to copy is '2'
2008/01/02 11:45:18.953: @LOG_MONTH = substr (@LOG_DATE, 6, 2)
2008/01/02 11:45:18.953: @LOG_MONTH = substr (2008/01/02, 6, 2)
2008/01/02 11:45:18.953: (integer): 2
2008/01/02 11:45:18.953: Setting local variable '@LOG_MONTH' to '01'
2008/01/02 11:45:18.953: [67] Math
2008/01/02 11:45:18.953: Base value '@LOG_DATE' evaluates to '2008/01/02'
2008/01/02 11:45:18.953: Modifying value is '9'
2008/01/02 11:45:18.953: Number of characters to copy is '2'
2008/01/02 11:45:18.953: @LOG_DAY = substr (@LOG_DATE, 9, 2)
2008/01/02 11:45:18.953: @LOG_DAY = substr (2008/01/02, 9, 2)
2008/01/02 11:45:18.953: (integer): 2
2008/01/02 11:45:18.953: Setting local variable '@LOG_DAY' to '02'
2008/01/02 11:45:18.953: [68] Set Local Variable
2008/01/02 11:45:18.953: Setting local variable '@LOG_FILE' to 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration'
2008/01/02 11:45:18.968: [78] Math
2008/01/02 11:45:18.968: Base value '@LOG_FILE' evaluates to 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration'
2008/01/02 11:45:18.968: Modifying value is '\Stats\TF'
2008/01/02 11:45:18.968: @LOG_FILE = @LOG_FILE CAT \Stats\TF
2008/01/02 11:45:18.968: @LOG_FILE = C:\Program Files\TeleFlow\Templates\Application\Golf Registration CAT \Stats\TF
2008/01/02 11:45:18.968: Setting local variable '@LOG_FILE' to 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Stats\TF'
2008/01/02 11:45:18.968: [74] Math
2008/01/02 11:45:18.968: Base value '@LOG_FILE' evaluates to 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Stats\TF'
2008/01/02 11:45:18.968: Modifying value '@LOG_YEAR' evaluates to '2008'
2008/01/02 11:45:18.968: @LOG_FILE = @LOG_FILE CAT @LOG_YEAR
2008/01/02 11:45:18.968: @LOG_FILE = C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Stats\TF CAT 2008
2008/01/02 11:45:18.968: Setting local variable '@LOG_FILE' to 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Stats\TF2008'
2008/01/02 11:45:18.968: [73] Math
2008/01/02 11:45:18.968: Base value '@LOG_FILE' evaluates to 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Stats\TF2008'
2008/01/02 11:45:18.968: Modifying value '@LOG_MONTH' evaluates to '01'
2008/01/02 11:45:18.984: @LOG_FILE = @LOG_FILE CAT @LOG_MONTH
2008/01/02 11:45:18.984: @LOG_FILE = C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Stats\TF2008 CAT 01
2008/01/02 11:45:18.984: Setting local variable '@LOG_FILE' to 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Stats\TF200801'
2008/01/02 11:45:18.984: [72] Math
2008/01/02 11:45:18.984: Base value '@LOG_FILE' evaluates to 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Stats\TF200801'
2008/01/02 11:45:18.984: Modifying value is '00.log'
2008/01/02 11:45:18.984: @LOG_FILE = @LOG_FILE CAT 00.log
2008/01/02 11:45:18.984: @LOG_FILE = C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Stats\TF200801 CAT 00.log
2008/01/02 11:45:18.984: Setting local variable '@LOG_FILE' to 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Stats\TF20080100.log'
2008/01/02 11:45:18.984: [70] Set Global Variable
2008/01/02 11:45:18.984: Setting global variable '@LOG_MESSAGE' to '2008/01/02,11:45:18,1,361,ANSWER,42318.359,0.625,,,,,,,'
2008/01/02 11:45:18.984: [76] Write Text
2008/01/02 11:45:18.984: Message '@LOG_MESSAGE' evaluates to '2008/01/02,11:45:18,1,361,ANSWER,42318.359,0.625,,,,,,,'
2008/01/02 11:45:18.984: 2008/01/02,11:45:18,1,361,ANSWER,42318.359,0.625,,,,,,,

2008/01/02 11:45:19.000: [75] Write Text
2008/01/02 11:45:19.000: Message '@LOG_MESSAGE' evaluates to '2008/01/02,11:45:18,1,361,ANSWER,42318.359,0.625,,,,,,,'
2008/01/02 11:45:19.000: File '@LOG_FILE' evaluates to 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Stats\TF20080100.log'
2008/01/02 11:45:19.000: File path is 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Stats\TF20080100.log'
2008/01/02 11:45:19.031: [6] FINISH
2008/01/02 11:45:19.031: Main<Logger>
LoadSystem
2008/01/02 11:45:19.031: [1] START
2008/01/02 11:45:19.046: [143] Run Flowchart
2008/01/02 11:45:19.046: Flowchart is 'DBSET'
2008/01/02 11:45:19.046: LoadSystem==>
DbSet
2008/01/02 11:45:19.046: [1] START
2008/01/02 11:45:19.046: [3] Set Global Variable
2008/01/02 11:45:19.046: Setting global variable '@DB_COUNTER' to '4'
2008/01/02 11:45:19.046: [2] FINISH
2008/01/02 11:45:19.046: LoadSystem<==DbSet
2008/01/02 11:45:19.046: [2] SQL Statement
2008/01/02 11:45:19.062: Handle is '1'
2008/01/02 11:45:19.062: Warning time threshold is ''
2008/01/02 11:45:19.062: Empty Warning time threshold defaults to '2000'
2008/01/02 11:45:19.062: <BEGIN>
SELECT
*
from
\Program Files\TeleFlow\Databases\ivrconfig

<END>
2008/01/02 11:45:19.125: Error code -1 returned from ODBC driver
2008/01/02 11:45:19.125: SQL Error State: 42000
Native Error Code: FFFFF24E
ODBC Error: [Microsoft][ODBC Excel Driver] Syntax error in FROM clause.
2008/01/02 11:45:19.140: Elapsed Time: 0.078
2008/01/02 11:45:19.140: FAILURE
2008/01/02 11:45:19.156: [144] Run Flowchart
2008/01/02 11:45:19.156: Flowchart is 'dbretry'
2008/01/02 11:45:19.156: Setting local variable '@FAIL_HANDLE' to '1'
2008/01/02 11:45:19.156: LoadSystem==>
DbRetry
2008/01/02 11:45:19.156: [1] START
2008/01/02 11:45:19.156: [41] Compare
2008/01/02 11:45:19.156: First Value '@FAIL_HANDLE' evaluates to '1'
2008/01/02 11:45:19.156: @FAIL_HANDLE is empty?
2008/01/02 11:45:19.156: (integer):1 is empty?
2008/01/02 11:45:19.156: FALSE
2008/01/02 11:45:19.156: [44] SQL End
2008/01/02 11:45:19.156: Handle '@FAIL_HANDLE' evaluates to '1'
2008/01/02 11:45:19.234: [11] Math
2008/01/02 11:45:19.234: Base value '@DB_COUNTER' evaluates to '4'
2008/01/02 11:45:19.234: Modifying value is '1'
2008/01/02 11:45:19.234: @DB_COUNTER = @DB_COUNTER - 1
2008/01/02 11:45:19.234: @DB_COUNTER = (integer):4 - (integer):1
2008/01/02 11:45:19.234: Setting global variable '@DB_COUNTER' to '3'
2008/01/02 11:45:19.234: [12] Wait
2008/01/02 11:45:19.234: Delay is '1000'
2008/01/02 11:45:19.234: Waiting 1000 milliseconds
2008/01/02 11:45:20.234: numWaitObjects = 5, WAIT_OBJECT_0 + 2 = 2, ret = 2 - @@@
2008/01/02 11:45:20.234: [13] Compare
2008/01/02 11:45:20.234: First Value '@DB_COUNTER' evaluates to '3'
2008/01/02 11:45:20.234: Second Value is '0'
2008/01/02 11:45:20.234: @DB_COUNTER > 0?
2008/01/02 11:45:20.234: (integer):3 > (integer):0?
2008/01/02 11:45:20.234: TRUE
2008/01/02 11:45:20.234: [2] FINISH
2008/01/02 11:45:20.234: LoadSystem<==DbRetry
2008/01/02 11:45:20.234: [2] SQL Statement
2008/01/02 11:45:20.234: Handle is '1'
2008/01/02 11:45:20.234: Warning time threshold is ''
2008/01/02 11:45:20.234: Empty Warning time threshold defaults to '2000'
2008/01/02 11:45:20.234: <BEGIN>
SELECT
*
from
\Program Files\TeleFlow\Databases\ivrconfig

<END>
2008/01/02 11:45:20.250: Error code -1 returned from ODBC driver
2008/01/02 11:45:20.250: SQL Error State: 42000
Native Error Code: FFFFF24E
ODBC Error: [Microsoft][ODBC Excel Driver] Syntax error in FROM clause.
2008/01/02 11:45:20.250: Elapsed Time: 0.016
2008/01/02 11:45:20.250: FAILURE
2008/01/02 11:45:20.250: [144] Run Flowchart
2008/01/02 11:45:20.250: Flowchart is 'dbretry'
2008/01/02 11:45:20.250: Setting local variable '@FAIL_HANDLE' to '1'
2008/01/02 11:45:20.250: LoadSystem==>
DbRetry
2008/01/02 11:45:20.250: [1] START
2008/01/02 11:45:20.265: [41] Compare
2008/01/02 11:45:20.265: First Value '@FAIL_HANDLE' evaluates to '1'
2008/01/02 11:45:20.265: @FAIL_HANDLE is empty?
2008/01/02 11:45:20.265: (integer):1 is empty?
2008/01/02 11:45:20.265: FALSE
2008/01/02 11:45:20.265: [44] SQL End
2008/01/02 11:45:20.265: Handle '@FAIL_HANDLE' evaluates to '1'
2008/01/02 11:45:20.265: [11] Math
2008/01/02 11:45:20.265: Base value '@DB_COUNTER' evaluates to '3'
2008/01/02 11:45:20.265: Modifying value is '1'
2008/01/02 11:45:20.265: @DB_COUNTER = @DB_COUNTER - 1
2008/01/02 11:45:20.265: @DB_COUNTER = (integer):3 - (integer):1
2008/01/02 11:45:20.265: Setting global variable '@DB_COUNTER' to '2'
2008/01/02 11:45:20.265: [12] Wait
2008/01/02 11:45:20.281: Delay is '1000'
2008/01/02 11:45:20.281: Waiting 1000 milliseconds
2008/01/02 11:45:21.281: numWaitObjects = 5, WAIT_OBJECT_0 + 2 = 2, ret = 2 - @@@
2008/01/02 11:45:21.281: [13] Compare
2008/01/02 11:45:21.281: First Value '@DB_COUNTER' evaluates to '2'
2008/01/02 11:45:21.281: Second Value is '0'
2008/01/02 11:45:21.281: @DB_COUNTER > 0?
2008/01/02 11:45:21.281: (integer):2 > (integer):0?
2008/01/02 11:45:21.281: TRUE
2008/01/02 11:45:21.281: [2] FINISH
2008/01/02 11:45:21.281: LoadSystem<==DbRetry
2008/01/02 11:45:21.281: [2] SQL Statement
2008/01/02 11:45:21.281: Handle is '1'
2008/01/02 11:45:21.281: Warning time threshold is ''
2008/01/02 11:45:21.281: Empty Warning time threshold defaults to '2000'
2008/01/02 11:45:21.281: <BEGIN>
SELECT
*
from
\Program Files\TeleFlow\Databases\ivrconfig

<END>
2008/01/02 11:45:21.296: Error code -1 returned from ODBC driver
2008/01/02 11:45:21.296: SQL Error State: 42000
Native Error Code: FFFFF24E
ODBC Error: [Microsoft][ODBC Excel Driver] Syntax error in FROM clause.
2008/01/02 11:45:21.296: Elapsed Time: 0.015
2008/01/02 11:45:21.296: FAILURE
2008/01/02 11:45:21.296: [144] Run Flowchart
2008/01/02 11:45:21.296: Flowchart is 'dbretry'
2008/01/02 11:45:21.296: Setting local variable '@FAIL_HANDLE' to '1'
2008/01/02 11:45:21.296: LoadSystem==>
DbRetry
2008/01/02 11:45:21.296: [1] START
2008/01/02 11:45:21.312: [41] Compare
2008/01/02 11:45:21.312: First Value '@FAIL_HANDLE' evaluates to '1'
2008/01/02 11:45:21.312: @FAIL_HANDLE is empty?
2008/01/02 11:45:21.312: (integer):1 is empty?
2008/01/02 11:45:21.312: FALSE
2008/01/02 11:45:21.312: [44] SQL End
2008/01/02 11:45:21.312: Handle '@FAIL_HANDLE' evaluates to '1'
2008/01/02 11:45:21.312: [11] Math
2008/01/02 11:45:21.312: Base value '@DB_COUNTER' evaluates to '2'
2008/01/02 11:45:21.312: Modifying value is '1'
2008/01/02 11:45:21.312: @DB_COUNTER = @DB_COUNTER - 1
2008/01/02 11:45:21.312: @DB_COUNTER = (integer):2 - (integer):1
2008/01/02 11:45:21.312: Setting global variable '@DB_COUNTER' to '1'
2008/01/02 11:45:21.312: [12] Wait
2008/01/02 11:45:21.328: Delay is '1000'
2008/01/02 11:45:21.328: Waiting 1000 milliseconds
2008/01/02 11:45:22.328: numWaitObjects = 5, WAIT_OBJECT_0 + 2 = 2, ret = 2 - @@@
2008/01/02 11:45:22.328: [13] Compare
2008/01/02 11:45:22.328: First Value '@DB_COUNTER' evaluates to '1'
2008/01/02 11:45:22.328: Second Value is '0'
2008/01/02 11:45:22.328: @DB_COUNTER > 0?
2008/01/02 11:45:22.328: (integer):1 > (integer):0?
2008/01/02 11:45:22.328: TRUE
2008/01/02 11:45:22.328: [2] FINISH
2008/01/02 11:45:22.328: LoadSystem<==DbRetry
2008/01/02 11:45:22.328: [2] SQL Statement
2008/01/02 11:45:22.328: Handle is '1'
2008/01/02 11:45:22.328: Warning time threshold is ''
2008/01/02 11:45:22.328: Empty Warning time threshold defaults to '2000'
2008/01/02 11:45:22.328: <BEGIN>
SELECT
*
from
\Program Files\TeleFlow\Databases\ivrconfig

<END>
2008/01/02 11:45:22.343: Error code -1 returned from ODBC driver
2008/01/02 11:45:22.343: SQL Error State: 42000
Native Error Code: FFFFF24E
ODBC Error: [Microsoft][ODBC Excel Driver] Syntax error in FROM clause.
2008/01/02 11:45:22.343: Elapsed Time: 0.015
2008/01/02 11:45:22.343: FAILURE
2008/01/02 11:45:22.343: [144] Run Flowchart
2008/01/02 11:45:22.343: Flowchart is 'dbretry'
2008/01/02 11:45:22.343: Setting local variable '@FAIL_HANDLE' to '1'
2008/01/02 11:45:22.343: LoadSystem==>
DbRetry
2008/01/02 11:45:22.343: [1] START
2008/01/02 11:45:22.359: [41] Compare
2008/01/02 11:45:22.359: First Value '@FAIL_HANDLE' evaluates to '1'
2008/01/02 11:45:22.359: @FAIL_HANDLE is empty?
2008/01/02 11:45:22.359: (integer):1 is empty?
2008/01/02 11:45:22.359: FALSE
2008/01/02 11:45:22.359: [44] SQL End
2008/01/02 11:45:22.359: Handle '@FAIL_HANDLE' evaluates to '1'
2008/01/02 11:45:22.359: [11] Math
2008/01/02 11:45:22.359: Base value '@DB_COUNTER' evaluates to '1'
2008/01/02 11:45:22.359: Modifying value is '1'
2008/01/02 11:45:22.359: @DB_COUNTER = @DB_COUNTER - 1
2008/01/02 11:45:22.359: @DB_COUNTER = (integer):1 - (integer):1
2008/01/02 11:45:22.359: Setting global variable '@DB_COUNTER' to '0'
2008/01/02 11:45:22.359: [12] Wait
2008/01/02 11:45:22.359: Delay is '1000'
2008/01/02 11:45:22.375: Waiting 1000 milliseconds
2008/01/02 11:45:23.375: numWaitObjects = 5, WAIT_OBJECT_0 + 2 = 2, ret = 2 - @@@
2008/01/02 11:45:23.375: [13] Compare
2008/01/02 11:45:23.375: First Value '@DB_COUNTER' evaluates to '0'
2008/01/02 11:45:23.375: Second Value is '0'
2008/01/02 11:45:23.375: @DB_COUNTER > 0?
2008/01/02 11:45:23.375: (integer):0 > (integer):0?
2008/01/02 11:45:23.375: FALSE
2008/01/02 11:45:23.375: [3] Write Text
2008/01/02 11:45:23.375: Message is 'ERROR: Database operation failed.'
2008/01/02 11:45:23.375: ERROR: Database operation failed.

2008/01/02 11:45:23.375: [40] Fatal Stop
2008/01/02 11:45:23.375: FATAL
2008/01/02 11:45:23.375: Attempting to jump to Fatal Error Global Event label: 'APPLICATION_ERROR'
2008/01/02 11:45:23.375: LoadSystem<==DbRetry
2008/01/02 11:45:23.375: Main<LoadSystem>
Exit
2008/01/02 11:45:23.390: [1] START
2008/01/02 11:45:23.390: [8] Global Event
2008/01/02 11:45:23.390: Label is 'EXIT_END'
2008/01/02 11:45:23.390: Setting system variable '@FATAL' to 'EXIT_END'
2008/01/02 11:45:23.390: [11] Global Event
2008/01/02 11:45:23.390: Label is 'EXIT_END'
2008/01/02 11:45:23.390: Setting system variable '@HANGUP' to 'EXIT_END'
2008/01/02 11:45:23.390: [13] Compare
2008/01/02 11:45:23.390: First Value '@HOOK_STATUS' evaluates to 'OFF-HOOK'
2008/01/02 11:45:23.390: Second Value is 'OFF-HOOK'
2008/01/02 11:45:23.390: @HOOK_STATUS = OFF-HOOK?
2008/01/02 11:45:23.406: (string):OFF-HOOK = (string):OFF-HOOK?
2008/01/02 11:45:23.406: TRUE
2008/01/02 11:45:23.406: [3] Play
2008/01/02 11:45:23.406: Script code is 'PROB_TECHNICAL'
2008/01/02 11:45:23.406: Script code 'PROB_TECHNICAL' corresponds to file 'Vox\Eng\Scripts\PROB_TECHNICAL.Wav'
2008/01/02 11:45:23.406: Playing 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Vox\Eng\Scripts\PROB_TECHNICAL.Wav'
2008/01/02 11:45:29.937: [5] Wait
2008/01/02 11:45:29.937: Delay is '500'
2008/01/02 11:45:29.937: Waiting 500 milliseconds
2008/01/02 11:45:30.437: numWaitObjects = 5, WAIT_OBJECT_0 + 2 = 2, ret = 2 - @@@
2008/01/02 11:45:30.437: [6] Play
2008/01/02 11:45:30.437: Script code is 'DISCONNECT01'
2008/01/02 11:45:30.437: Script code 'DISCONNECT01' corresponds to file 'Vox\Eng\Scripts\DISCONNECT01.Wav'
2008/01/02 11:45:30.437: Playing 'C:\Program Files\TeleFlow\Templates\Application\Golf Registration\Vox\Eng\Scripts\DISCONNECT01.Wav'
2008/01/02 11:45:33.156: [9] Wait
2008/01/02 11:45:33.187: Delay is '1500'
2008/01/02 11:45:33.187: Waiting 1500 milliseconds
2008/01/02 11:45:34.718: numWaitObjects = 5, WAIT_OBJECT_0 + 2 = 2, ret = 2 - @@@
2008/01/02 11:45:34.718: [10] Hang Up
2008/01/02 11:45:34.734: Hanging up
2008/01/02 11:45:34.734: [2] FINISH
2008/01/02 11:45:34.734: Main<==Exit
2008/01/02 11:45:34.734: [22] FINISH
2008/01/02 11:45:34.734: End of application.
2008/01/02 11:45:37.750:

2008/01/02 11:45:37.750: All memory released. Exiting...

Chris · **Posted:** Wed Jan 02, 2008 12:40 pm

We have never used the Excel ODBC driver, and I suspect that you will find it more trouble than it is worth trying to figure out how to make it work for you.

However, after a little experimentation, I was able to get "some" results from an Excel workbook into my TeleFlow application. I wasn't able to figure out how to do much, but it is a start, and with further experimentation, you may get what you want.

Here is an article I used to get some data into TeleFlow:
http://support.microsoft.com/kb/q195951/

The key aspect seems to be the named range, as the named range is what you must name in the FROM segment of your query. I don't think you need the <BEGIN> <END> in your query, either.

Having said that, I would suggest, if at all possible, moving to a proper database and using ODBC and SQL to get data into your application. In the long run, this will work better. (especially since it appears that the ODBC driver takes exclusive access of the XLS file, which means only one port of TeleFlow could access the workbook at any one time, I believe)