[RBASE-L] - [FWD: [RBASE-L] - Gateway Import CSV: Dropped and Shifted Columns]

[Bruce Chitiea]

All: Update

The same result obtains:

1. If I try to import as XLS, with or without blank first column;

2. If I perform explicit column mapping with "ADD_MAPPING", with or without blank first column.

In all attempts, the autonumbered column performs as expected.

Bruce

SafeSectors, Inc.

-------- Original Message --------
Subject: [RBASE-L] - Gateway Import CSV: Dropped and Shifted Columns
From: "Bruce Chitiea" <rby...@safesectors.com>
Date: Tue, November 27, 2012 4:55 pm
To: rbase-l@rbase.com (RBASE-L Mailing List)

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