Bruce,
Check your connected database CURRENCY settings.
SHOW CURRENCY
Very Best R:egards,
Razzak
At 09:52 PM 8/16/2017, Bruce Chitiea wrote:
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?
--
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.
