CSV File LookUp

[Former Member]

Hi all,

I am designing a scenario following the given blog:

<i><b>/people/kausik.medavarapu/blog/2005/12/29/csv-file-lookup-with-http-request-and-response-in-xi

In this blog i am mainly dealing with the first half i.e the CSV File Lookup part.

I have created the csv file as mentioned. Converted it into a jar and included that jar file in the repository under the Imported Archive tab.

I have done certain manipulation in the given code to suit my design:

<b>String price = "0";

try

{

Class.forName("<i>the name of my imported jar file</i>");

Connection con=DriverManager.getConnection("jdbc:driver:""/""/"+"pciib04530/users/");

PreparedStatement stmt=con.prepareStatement("select itemno,price from price where itemno=?");

stmt.setString(1,a);

ResultSet rs=stmt.executeQuery();

while(rs.next())

{

price = rs.getString("price");

}

con.close();

return price;

}

catch(Exception e)

{

return "-1";

}</b>

On testing the mapping the error msg i get is Method findPrice with 1 arguments not found in class com.sap.xi.tf._Request_MM_

where findPrice is the name of my method and Request_MM is my message mapping.

I dont know what is wrong.

Pls guide.

If anyone can mention help documents on CSV Lookup, it would be very helpful.

Thanks in advance

Regards

Neetu

[Former Member]

Hi Neetu,

Sorry for coming accross this soo late but can you explain to me how did you implement CSV file lookup and what was the solution to the issue which you had faced.

Thanks !!!

Warm Regards,

Anshul

[Former Member]

Hi Neetu,

After reading Abhy's response, I think you should take a look at this too..

http://help.sap.com/saphelp_nw04/helpdata/en/98/a5d99070464581b9c8e3494daad833/frameset.htm

cheers,

Prashanth

[Former Member]

Hi Neetu,

Mapping lookups are provided from SP13 onwards.The API supports access using soap,rfc and jdbc adapters.You cannot use a file adapter in this regard since it does not support sync calls.

Regards,

Abhy

[Former Member]

Hi Prashanth,

I have already gone through the both the blogs mentioned by you.

The first one speaks about CSV Lookup.

Here the author mentions about some driver <b><i>"it’s possible by means of a driver that makes the flat file (here CSV file) to appear as a database table to the API."</i></b>

But he does not mention the name of the driver.

The Blog is also not very elaborate.

Can you suggest the name of the driver?

Regards,

Neetu

[Former Member]

Hi Neetu,

Take a look at this too..

/people/sundararamaprasad.subbaraman/blog/2005/12/09/making-csv-file-lookup-possible-in-sap-xi

/people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

cheers,

Prashanth