on 07-14-2006 8:08 PM
I must get a .CSV file of Exchange Rates in the URL:
<http://www5.bcb.gov.br/pec/taxas/ingl/PtaxRPesq.asp?idpai=QUOTATIONS>
Is it possible on XI? If yes, how can i do it?
I'll use the information in this file to update fields in SAP R/3.
Regards,
Daniela
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If your file format is Excel sheet (.csv) with the help of Module processor, you can achieve this.
Refer this blog-
/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter
Moorthy
Moorthy,
My file won`t be in a directory.
It will be in a URL.
So, is it possible?
If so, you can not use File Adapter. You need to go for WebService /Http service. Sender SOAP adapter cofiguration is required here if you are using
WebService.
In the Webservice, you need to write a logic to get the file in xml format.
Regards
Thank you for your help.
Would you be more specific about the logic?
My data will be in a CSV. format. This file is in a Government site, because ìt's a list of Exchange Rates.
The site is http://www.bcb.gov.br/?TXTODAS
I have already use SOAP adapter to change information with a WebService, but what I need now is get a File in a Web Page (with is not my client webservice).
Is it possible?
Sorry, the correct link is http://www.bcb.gov.br/?TXTODAS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.