Did you try inserting a null column after the autonum column of the opcashbalance table before import?
Pat From: [email protected] To: [email protected] Subject: [RBASE-L] - Gateway Import CSV: Dropped and Shifted Columns Date: Tue, 27 Nov 2012 16:55:54 -0700 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: dateColB: NumberColC: NumberColD: NumberColE: Number Total 61 rows. Target Table: opcashbalance: cashbalid: INTEGER AUTONUMBERcashdate: DATEcashbal: CURRENCYcashavg: CURRENCYcashdelta: CURRENCYcashmin: 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 ... ?? BruceSafeSectors, Inc.eCondoMetrics
