one of those little, awesome things, instantly useful.
Thanks!
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 m
------ Original Message ------
From: "A. Razzak Memon" <raz...@rbase.com>
To: rbase-l@googlegroups.com
Sent: 10/12/2017 11:00:00 PM
Subject: [RBASE-L] - Tip of the Day: Gateway Export Append Support to
Spreadsheets
Friday, October 13, 2017
Tip of the Day: Gateway Export Append Support to Spreadsheets
Product.......: R:BASE X and R:BASE X Enterprise (Version 10)
Build.........: 10.0.3.11010 or higher
Section.......: File Gateway
Keywords......: Gateway, Export, Spreadsheet, Append, Merge, XLS, XLSX
Did you know that merge support has been implemented for the File
Gateway EXPORT process
when exporting data into spreadsheets?
The XLS/XLSX Export process has been enhanced to support merging data to
an existing file,
and will add a new sheet to the spreadsheet, if exists.
When using the GUI, the "APPEND Data to Existing File" check box is now
enabled for the MS
Excel Spreadsheet and Workbook formats.
http://www.razzak.com/tips/FileGateway_Export_Append.jpg
When using the command syntax, the MERGE_DATA parameter can be specified
where the exported
data will be added to the specified file as a new sheet.
-- Example:
CONNECT RRBYW19
IF (CHKFILE('C:\Temp')) <> 1 THEN
MKDIR C:\Temp
ENDIF
CLS
GATEWAY EXPORT XLSW C:\Temp\EmployeeArchive.xlsx +
SELECT * FROM Employee ORDER BY EmpLName,EmpFName +
OPTION COL_NAMES ON +
|TAB_NAME Employees 2017 +
|SHOW_PROGRESS ON +
|MERGE_DATA ON +
|ACTION OPENVIEW
RETURN
One of the most important aspects in business growth is your company's
data, and no one else
has more invested in your success than R:BASE Technologies. Invest
forward with R:BASE!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
-- For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
--- You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.