Bruce,
Once the temporary table is created successfully,
try the manual process to IMPORT
the exact gway_ReserveFundBalance.xlsx file, and see what you get.
Hope that provides you with some blue's clues ...
Vert Best R:egards,
Razzak
At 08:48 PM 8/16/2017, Bruce Chitiea wrote:
WIN10
Error Message:
[]
This in a GATEWAY IMPORT XLS routine which has
worked without drama for over two years. Relevant code:
DEBUG SET TRACE ON
SET ERROR MESSAGE 2038 OFF
  DROP TABLE Import_ReserveFundBalance_tt
SET ERROR MESSAGE 2038 ON
CREATE TEMP TABLE Import_ReserveFundBalance_tt +
   ( TReserveBalanceDATE  DATE NOT NULL, +
    TReserveBalanceCASH  CURRENCY NOT NULL, +
    TReserveBalanceCD   CURRENCY NOT NULL, +
    TReserveBalanceTOTAL CURRENCY NOT NULL, +
    TReserveWithdrawCUMUL CURRENCY NOT NULL, +
    TReserveAddCUMUL    CURRENCY NOT NULL, +
    TReserveContribCUMUL CURRENCY NOT NULL, +
    TReserveInflowNET   CURRENCY NOT NULL, +
    TReserveDailyCHANGE  CURRENCY NOT NULL )
GATEWAY IMPORT XLS +
 D:\00\GWAY\gway_ReserveFundBalance.xlsx +
 APPEND Import_ReserveFundBalance_tt +
 OPTION FIRST_ROW 2 +
 |ADD_MAPPING TReserveBalanceDATE = A +
 |ADD_MAPPING TReserveBalanceCASH = B +
 |ADD_MAPPING TReserveBalanceCD = C +
 |ADD_MAPPING TReserveBalanceTOTAL = D +
 |ADD_MAPPING TReserveWithdrawCUMUL = E +
 |ADD_MAPPING TReserveAddCUMUL = F +
 |ADD_MAPPING TReserveContribCUMUL = G +
 |ADD_MAPPING TReserveInflowNET = H +
 |ADD_MAPPING TReserveDailyCHANGE = I -- FAIL
The Excel source data is [Number(2)], no dollar sign, no comma.
The Excel data has been scrubbed, checked,
re-formatted; file deleted and new one created
three times; and the error repeated through one
unload/reload and ten follow-on tests.
Mystified. Thoughts? Course of action?
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are
subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop
receiving emails from it, send an email to
[email protected].
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
