Adapter Module Development

Former Member · ‎09-16-2014

Hi Gurus,

I am creating a custom java module in sap nwds 7.3 for Excel to XML Conversion. But I am getting following error

Classpath dependency validator message.

Classpath entry will not be exported or published. Runtime ClassNotFoundExceptions may result.

I imported the Jars from a different PI system and i am using NWDS in local PC with creating a separate folder with all JARs and also imported them using build path option.

This issue is occuring for all the jars imported.

I am using following code.

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.InputStream;

import java.io.OutputStream;

import java.util.Map;

import com.sap.aii.mapping.api.StreamTransformation;

import com.sap.aii.mapping.api.AbstractTrace;

import java.util.HashMap;

import jxl.Cell;

import jxl.Workbook;

public class JavaMappingExcelToXML implements StreamTransformation{

private Map map = null;

private AbstractTrace trace = null;

public void setParameter(Map arg0) {

map = arg0; // Store reference to the mapping parameters

if (map == null) {

this.map = new HashMap();

}

/*

public static void main(String args[]) { //FOR EXTERNAL STANDALONE TESTING

try {

FileInputStream fin = new FileInputStream ("c:/ashu.xls"); //INPUT FILE (PAYLOAD)

FileOutputStream fout = new FileOutputStream ("C:/Users/ashutosh.a.upadhyay/My Documents/ashuXML2.xml"); //OUTPUT FILE (PAYLOAD)

JavaMappingXLStoXML mapping = new JavaMappingXLStoXML ();

mapping.execute(fin, fout);

}

catch (Exception e1) {

e1.printStackTrace();

}

}*/

public void execute(InputStream inputstream, OutputStream outputstream) {

String msgType = "Message Type name will come here";

String nameSpace = "Namespace Name will come here";

String xmldata = "";

try {

Workbook wb = Workbook.getWorkbook(inputstream);

xmldata ="<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n"+ "<ns0:"+msgType+" "+"xmlns:ns0=\""+nameSpace+"\n">";

Cell[] cells ;

Cell[] cellNames ;

cellNames = wb.getSheet(0).getRow(0);

for(int j=1;j<wb.getSheet(0).getRows();j++){

xmldata = xmldata+"\n<Record>\n";

cells = wb.getSheet(0).getRow(j);

for(int i=0;i<wb.getSheet(0).getColumns();i++){

xmldata = xmldata+"\t<"+cellNames[i].getContents()+">"+cells[i].getContents()+"</"+cellNames[i].getContents()+">\n";

}

xmldata = xmldata+"</Record>";

}

xmldata = xmldata+"\n</ns0:"+msgType+">";

System.out.print(xmldata);

xmldata.getBytes();

wb.close();

byte by[] = xmldata.getBytes();

outputstream.write(by);

inputstream.close();

outputstream.close();

System.out.println("\n"+"File processed");

}

catch (Exception e) {

e.printStackTrace();

}

Request you to guide how to resolve this issue.

Thanks in advance

anandvithal · ‎09-16-2014

Hi,

If you have NWDS 7.3 then try this

In the build path screen of the ejb project click add library

select XPI library

Select XPI adapter library

apart from the standard jars if you have any other jars, add them manually.

Thanks,

Anand

Former Member · ‎12-03-2014

Issue Resolved

Former Member · ‎10-31-2014

Hi Gurus ,

Issue has been resolved by using Audit Access class insted of audit and declaring Audit Access locally.

Now We are facing two issues.

1. Build folder is empty

2. Where to give JNDI name. In JNDI we are not getting any option of mentioning JNDI name.

Thanks in advance for Help.

Former Member · ‎10-06-2014

Hi

after using Audit Access I am getting following error.

Cannot make a static reference to the non-static method addAuditLogEntry(MessageKey, AuditLogStatus, String)

from the type AuditAccess

this error i am getting everywhere where addAuditLog Entry is getting used.

Request you to put some light on this issue.

Thanks

Mridul

Former Member · ‎10-01-2014

Hi gurus can i use

com.sap.engine.interfaces.messaging.api.auditlog.AuditAccess following class instead of

com.sap.aii.af.service.auditlog.Audit

as the audit class is unavailable

Thanks in advance

Former Member · ‎09-26-2014

HI Jyothi,

Can u please help in getting this JAR file.

Thanks

Mridul

Former Member · ‎09-23-2014

Hi Jyothi,

Also to inform You I am having one portable version of NWDS 7.3 which i downloaded from this location

https://nwds.sap.com/swdc/downloads/updates/netweaver/nwds/nw/730/doc/auto_latest_distributions.html

It contains a plugin folder which also doesnot contain the Jar file with the classes Audit and Audit Direction.

Thanks

Mridul

Former Member · ‎09-23-2014

Hi Jyothi

I checked at the location mentioned in all the folders but could not find the respective Jar file.

Thanks

Mridul Manchanda

Former Member · ‎09-23-2014

Hi gurus,

I am not finding following package

com.sap.aii.af.service.auditlog with class Audit and Audit Direction in my PI 7.3 setup. Can u please guide where i can find these 2 classes.

Thanks in advance

PI 7.0(3.0)	PI 7.1/7.3
aii_af_mp.jar	com.sap.aii.af.lib.mod.jar
aii_af_ms_api.jar	com.sap.aii.af.ms.ifc_api.jar
aii_af_trace.jar	sap.com~tc~logging~java~impl.jar
aii_af_svc.jar	com.sap.aii.af.svc_api.jar
aii_af_cpa.jar	com.sap.aii.af.cpa.svc.api.jar

Issue in Excel to XML Conversion

Accepted Solutions (1)

Accepted Solutions (1)

Adapter Module Development

Answers (8)

Answers (8)

Re: Building custom app at SAP S/4 public cloud

Formatted JSON Field in RAP Application

Re: Unable to override standard methods using Adap...

Re: Can SAP's OData Framework be used as API endpo...

How to configure Custom SAPUI5 app to Fiori launch...