Thank you, Razzak.With a new, clean temp file, the manual process adds no records to the table.
Error Message at R>:
'-ERROR- Column TReserveBalanceCD must be a valid CURRENCY. ( 122)'
The formatted value in the TReserveBalanceCD cell within the Excel
source file is: '1404006.50' [Number(2)]
I will try a CSV import in the morning and report back. Bruce ------ Original Message ------ Sent: 8/16/2017 5:56:57 PM Subject: Re: [RBASE-L] - Error Message 122 - Gateway Import XLS Fail From: "A. Razzak Memon" <[email protected]> To: [email protected] Cc: 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. -- 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.
