TeleFlow Forums http://teleflow.org/phpbb/ |
|
I can't get Teleflow to "talk to" MS Excel. http://teleflow.org/phpbb/viewtopic.php?f=10&t=481 |
Page 1 of 1 |
Author: | peterg99 [ Thu Nov 22, 2007 2:32 pm ] |
Post subject: | I can't get Teleflow to "talk to" MS Excel. |
See Subject. Sorry for the terseness, but that's the short and long of it. |
Author: | Chris [ Mon Nov 26, 2007 10:54 am ] |
Post subject: | |
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! |
Author: | peterg99 [ Wed Jan 02, 2008 11:54 am ] |
Post subject: | |
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... |
Author: | Chris [ Wed Jan 02, 2008 12:40 pm ] |
Post subject: | |
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) |
Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |