Christian,
As Gunnar says, 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. I am not sure if the following helps with your specific question, but if you want to try the Wizard I hope this helps. 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 havent used this a lot, but hopefully this may help. Regards, John Docherty From: [email protected] [mailto:[email protected]] On Behalf Of Gunnar Ekblad Sent: Thursday, 11 June 2009 10:19 p.m. To: RBASE-L Mailing List Subject: [RBASE-L] - SV: gateway export and Specification_file_name Christian Out of old habits I still QBC an makes the query from excel. I belive it should be possible with RGW file as well, the trick to this is to use the Export Wizard the first time to create RGW-file. But I have forgetn how to find gateway export wizard. Hope someone else can explain how to do that. Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För christian hjortmar Skickat: den 10 juni 2009 22:22 Till: RBASE-L Mailing List Ämne: [RBASE-L] - SV: gateway export and Specification_file_name Thank you, Gunnar! Well, I have tried the first half of what you have written, ie, have a predefined excelsheet. The ODBC thing I haven't tried, though. At one point I thought it was about delimiters. USA have a dot as a decimal delimiter while here in Sweden a comma is the norm. What I want to send out from my R:Base application is for example "cust_no, order_no, a_total", (4058,23456,'234.45Kr'). It must not be an excelfile, a textfile would do. Thing is, at work, I have complained about consultants not providing easy ways of emptying their applications when they for some reason get obsolete. So the application I am working on must of course have this option ;-) Exporting currency values through GATEWAY, rests at the moment in back of my head but I am grateful for all ideas and angels. Regards Christian Hjortmar ----- Original Message ----- From: Gunnar Ekblad <mailto:[email protected]> To: RBASE-L Mailing List <mailto:[email protected]> Sent: Wednesday, June 10, 2009 8:23 PM Subject: [RBASE-L] - SV: gateway export and Specification_file_name Christian I have tried to find a solution the way you asked for. I did not manage, maybee I was slow on my last razzak training!?, It might be there but I did not find it. However if you revrse the the issue, create an excelshett with predefinde columns with formats and then do an ODBC inquriy you should be able to achive what you want! Let me add I am happy to see user from sweden that I was not aware about. Dont heisitate to answer privatly if yo you have an issue with my reply! Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För christian hjortmar Skickat: den 5 juni 2009 21:04 Till: RBASE-L Mailing List Ämne: [RBASE-L] - gateway export and Specification_file_name Hi, all! When exporting to an excel sheet from GATEWAY. Is it posssible to specify the format of the target column within the SPECIFICATION_FILE_NAME option? I.e. an price column in excel should have 2 decimals. Thankyou Christian
