All:
R:BASE eXtreme 9.1 (64) 9.1.6.21115
Win7Ult SU Non-Networked
This should not be happening after lots of various gateway import operations.
Source file gway_cashbal.csv:
ColA: date
ColB: Number
ColC: Number
ColD: Number
ColE: Number
Total 61 rows.
Target Table: opcashbalance:
cashbalid: INTEGER AUTONUMBER
cashdate: DATE
cashbal: CURRENCY
cashavg: CURRENCY
cashdelta: CURRENCY
cashmin: CURRENCY
Command:
GATEWAY IMPORT CSV +
d:\00\gway\gway_cashbal.csv +
APPEND opcashbalance +
OPTION AUTONUM ON
Result:
cashbalid: [ autonum ok ]
cashdate: [ -0- ]
cashbal: [ value for ColC (cashavg) ]
cashavg: [ value for ColD (cashdelta) ]
cashdelta: [ value for ColE (cashmin) ]
cashmin: [ -0- ]
In other words, cashdate and cashbal values disappear and the final three import columns shift one column to the left.
Attempting the import with a null column inserted as the first column of the CSV file makes no difference.
I know I can map columns specifically, but ... ??
Bruce
SafeSectors, Inc.
eCondoMetrics
