What does the date format look like in csv file?
Sent from my Samsung Epic™ 4G Touchpat peake <[email protected]> wrote: 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: 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
