John, I found the answer to the pennies problem. It seems if you do Gateway export XLSW the pennies show correctly. If you do gateway Export XLS the pennies do Not show. Go Figure.
Thanks for your help. Bill Eyring -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Eyring Sent: Tuesday, December 02, 2008 9:15 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: XLS Specification File *.RGW John, Thanks for your advice. I was able to export the data that I needed into an XLS spredsheet. However, the currency columns do not export with 2 decimal places. Any ideas as to how I can fix this ? Bill Eyring -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Docherty Sent: Monday, December 01, 2008 8:17 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: XLS Specification File *.RGW Bill, You have to use the Wizard to create the RGW file and after that you can include the file name in a command file as the SPECIFICATION_FILE NAME. This is not something I have used before, but Razzak did cover this at the SAT after the Conference so I can pass on my limited knowledge, and my attempts today, to suggest the following as a starting point:- To use the Wizard select Use Export Wizard as the response to the Select Format option. Then click on Specifications after you have selected the Excel WORKBOOK option, click on SAVE and enter a file name for the RGW file and then proceed to set up the options for each column then export the data. (If you want to reuse the rgw file via Gateway you have to Load the file, and then make sure you are still using a Workbook for the output format as far as I can see.) I note that Excel 2007 gives me a warning about the file format when opening the file, but it certainly appears to be OK I am sure that someone else will give you some better, more accurate information, but this may at least get you started. Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Eyring Sent: Tuesday, 2 December 2008 1:36 p.m. To: RBASE-L Mailing List Subject: [RBASE-L] - XLS Specification File *.RGW Can anyone help me understand/direct how to create an XLS specification file when using Gateway Export ? I have been playing around with this, but I guess I'm having a brain cramp since I can get a working specification file going. Many thanks, Bill Eyring
