on 09-23-2014 6:00 AM
Hello experts,
I have a new development wherein i have to consume .xlsx files in PI 7.31
i have gone through a lot of blogs but did not find any relevant JAR's specially for PI 7.31, I am planning to go for custom module development for conversion of .xlsx file into xml
so need your help for finding the JAR's for PI 7.31 and also some custom JAVA source code for conversion of excel spreadsheet into XML.
Regards,
Sushant.Shinde
Hi Sushant,
If you have the SAP Netweaver Developer Studio, for your PI and SP version, you will have the libraries. Check this link: NWDS Download Links - Java Development - SCN Wiki
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Inaki,
you mean to say that for every PI version we have a subsequent NWDS version ???
please correct me if i am wrong
and also if i download the version compatible with my PI version, i would get the needed libraries??
presently, i have a java source code and the PI jar's and i am using the traditional way to develop a module in NWDS, so by installing this new version of NWDS, do you mean to say the i dont have to search for the JAR's in my PI OS level???
eagerly waitin for your reply
thanks & regards,
sushant
Hi Sushant
If you are on PI 7.31, then you should use NWDS 7.31 - in general you should have the same SP and patch level if possible.
If you are on NWDS 7.31, the JAR files should already be bundled in, so you don't need to search and extract them from PI OS level.
Check out Anand's reply on the following thread
Issue in Excel to XML Conversion
Rgds
Eng Swee
Hi Sushant,
AFAIK you can download NWDS and all the external features in one page:https://nwds.sap.com/swdc/downloads/updates/netweaver/nwds/nw/731/index.html
Later you will need to add the libraries in your project.
Regards.
Hi Sushanth,
Please follow this blog for converting excel file to xml file.
http://www.saptechnical.com/Tutorials/XI/Adapter/Index.htm
You need these jar files
aii_af_mp.jar à the interface Moduleaii_af_ms_api.jar à Dealing with payload and attachmentaii_af_trace.jar à Writing Traceaii_af_svc.jar à Adapter Services aii_af_cpa.jar à Reading Channel Entriesaii_af_ms_spi.jar aii_af_cci.jar Please let us know if you need more details. ThanksJyothi AYou must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Jyothi,
i cant find these jar's in the PI OS level, according to my knowledge these jar's are for PI 7.1 or lesser versions, i have searched each and every folder in PI for the above mentioned jar files can't find them
If you can provide me the path for the files for PI 7.31 version, it would be of great help
Thanks & Regards,
Sushant
Meanwhile have you checked this
http://wiki.scn.sap.com/wiki/display/ABAP/Get+PI+Libraries+from+ABAP+Stack+using+ABAP+Program
Hi Jyothi,
I have developed a custom adapter module to read excel file and deployed it on my server.
I have mentioned below parameters in sender communication channel,
but i am stuckup with the following error.
Error: com.sap.engine.services.jndi.persistent.exceptions720.NameNotFoundException: Path to object does not exist. First missing component is [XLModule_EAR] the whole lookup name is [localEJBS/sap.com/XLModule_EAR/XLModule]
i have created the following objects in NWDS:
Package : com.ril
Project : XLModule_EAR
Enterprise bean and class name : XLModule
please let me know the parameters maintained in module tab of the communication channel level were correct or not.
Regards
Sushant
Hi Sushant,
These are jar files for PI 7.3 and higher. Except these you have to use the jars specific to your code.
Now regarding your error-
You remember a place where you would have given JNDI name in NWDS.
Suppose your JNDI name is "XLModule"
Then in the channel please use just "localejbs/XLModule"... i.e. localejbs/<JNDI Name>
Please try this, it will work
Regards,
Vikas Kumar Singh
Hi sushant,
The module key seems correct ffor you. But the blog you shared is cozy. I developed 4 adapter modules using a document. Please refer that.
And NWDS EHP1 is available you can use that to be perfectly sure on compatibility.
use the above document to verify the steps you followed-
Please provide following screenshots
NWA->configuration->infrastructure->Application Modules-> and search for *xlmodule*
if you find your module then click on it and at the bottom there will be a window with JNDI Name. Share that JNDI name and use that JNDI name in your Module. (localejbs/JNDIName).
Also go to NWA->TroubleShooting-> JNDI Browser and see where is your Adapter module situated. I mean under which directory. Either directly inside root/localejbs/ or root/localejbs/sap.com.
Please verify your steps according to that and redeploy and share result.
and Go to NWA- Site Map-> find Start & Stop
In that go to Java Applicaitons Tab and search for your module. It must be started. If it is stopped try starting it.
Regards,
Vikas
Hi Vikas,
I have checked all the paths and everything seems to be fine.
Now please find the error description as shown below.
I have downloaded .jxl jar from web/internet. I think the problem is in SAP PI server, system is not able to find the location of jxl jar. So please let me know where should i place this jar file manually on SAP PI server(because rest of the jar files were downloaded from native PI server OS level itself)
Regards
Sushant
Hi Sushanth,
Refer below links:
http://wiki.scn.sap.com/wiki/display/XI/XI+libraries+for+development
http://wiki.scn.sap.com/wiki/display/XI/Where+to+get+the+libraries+for+XI+development
Regards,
Aditya Vempati
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.