Wednesday, September 4, 2013 Tip of the Day: Using File Gateway Specification Files Product.: R:BASE eXtreme 9.5 (32/64) Build...: 9.5.3.20829 or higher www.rupdates.com Keywords: GATEWAY, Import, Export, Specification File Section.: File Gateway
When using the File Gateway utility to import data into an existing table or when using the Export Wizard, specification files (.rgw) can be used to save your import/export options and settings to load from a previous data transfer. As part of the latest update, it is now easier to manage multiple specification files in the same working folder with an enhanced "Save As" button. During the import/export process, the "Specifications..." button is available. The specification file will store your import options for type, source file, fields, settings and mode. http://www.razzak.com/Tips/Specification.jpg The specification files can be loaded for the current data transfer and saved for future transfers. The specification files are stored in the current folder with the .RGW file extension. http://www.razzak.com/Tips/ImportSpecification.jpg Specification files can be utilized using both the File Gateway user interface and the GATEWAY. GATEWAY Import Example: GATEWAY IMPORT XLS Customer_New.xls APPEND Customer + OPTION SHEET_INDEX 1 + |SPECIFICATION_FILE_NAME Customer_Import.rgw + |FIRST_ROW 2 + |SHOW_PROGRESS ON + |MESSAGES OFF GATEWAY Export Example: GATEWAY EXPORT CSV Customer_Release.csv + SELECT Company,CustAddress,CustCity,CustState,CustZip FROM Customer + OPTION COL_NAMES OFF + |SHOW_PROGRESS ON + |MESSAGES OFF + |SPECIFICATION_FILE_NAME Customer_Release.rgw Stay productive, my friends! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase www.RazzakMemon.com -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
