Monday, September 24, 2012
Tip of the Day: Gateway Import XLS/XLSX Spreadsheet Column Mapping
Product: R:BASE eXtreme 9.5 (32/64), R:BASE eXtreme 9.1 (32/64)
Section: GATEWAY, Import, Commands, XLS, XLSX
Did you know that you can map R:BASE columns to XLS/XLSX spreadsheet columns in
order to control the data import into specific locations?
Using R:BASE eXtreme 9.5 (32/64) and R:BASE eXtreme 9.1 (32/64), you
can include
the ADD_MAPPING parameter in the GATEWAY command syntax to map an R:BASE column
to the spreadsheet column.
Here's how:
-- This command will only append Cell B, Cell C and Cell D data into the
-- Company, CustAddress and CustState columns of the Customer table from
-- the Customer.xls file.
GATEWAY IMPORT XLS Customer.XLS APPEND Customer +
OPTION ADD_MAPPING Company=B|ADD_MAPPING CustAddress=C|ADD_MAPPING CustState=D
Stay productive, my friends!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
www.Razzak.com
www.RazzakMemon.com
