Is there a way to insert custom code to change the FCC comma delimited (.csv) into an Excel file in the receiver communication channel file adapter? If so, how do I do this in XI? Thanks.
I created my mapping using the SAP XI GUI mapping and used the File adapter's FCC comma delimited in the Receiver comm channel.
Is there a way to plug in custom code in XI to convert the comma delimited file to Excel before the File adapter FTPs the file to the target? Would I use the module to do this?
If changing the content type wouldn't work, what do you suggest? Is XSLT mapping the only way to create an Excel file from XML?
I already did my mapping using the SAP XI GUI so I would prefer to reuse this mapping rather than the XSLT mapping. How can I create an Excel file using the SAP XI GUI mapping?
> I already did my mapping using the SAP XI GUI so I would prefer to reuse this mapping rather than the XSLT mapping. How can I create an Excel file using the SAP XI GUI mapping?
But what exactly is your requirement? Do you need exactly the .xls(x) file as your output? If you dont care about this, then try saving the file with extension .csv By default the comma separated value file can be rendered in MS-Excel in separate columns.
The target can only handle Excel 2003. It cannot accept the .csv file.
How would I go about creating the adapter module? Do I assume its going to be from the csv file then transform that message to Excel? Or will it be from the XML file generated by my SAP XI GUI mapping?
well there are many java apis available that can help you create an excel file. So in that case you will ahve to use these apis in a module and manipulate your payload to get the desired output.
> The target can only handle Excel 2003. It cannot accept the .csv file.
> How would I go about creating the adapter module? Do I assume its going to be from the csv file then transform that message to Excel? Or will it be from the XML file generated by my SAP XI GUI mapping?
it would be the XMl created by the GUI mapping that will be input to the module
>>Do I assume its going to be from the csv file then transform that message to Excel? Or will it be from the XML file generated by my SAP XI GUI mapping?
It is really your choice here. If you want to convert the xml file to excel, then all you need is an adapter module that makes use of one of the Java APIs to do the trick. But if you want to convert the xml file to csv and then finally to a excel file, you can achieve this using standard sap adapter module (forgot the exact name, I guess it is XMLtoplain bean) I believe this option would be easier.
> It is really your choice here. If you want to convert the xml file to excel, then all you need is an adapter module that makes use of one of the Java APIs to do the trick. But if you want to convert the xml file to csv and then finally to a excel file, you can achieve this using standard sap adapter module (forgot the exact name, I guess it is XMLtoplain bean) I believe this option would be easier.
Ideally, I just want to convert the XML to Excel. Which way would be the better route to do this without having to use XSLT mapping because I want to reuse the SAP XI GUI mapping I already created.
I did not mean you to use XSLT mapping. You can write your adapter module that will either process the XML file (direct from your GUI Mapping) or CSV file (using GUI mapping again but passed through another standard adapter module that converts your xml file to csv) This method is preferable coz in your adapter module it will be easier for you to parse and get the fields.
> I did not mean you to use XSLT mapping. You can write your adapter module that will either process the XML file (direct from your GUI Mapping) or CSV file (using GUI mapping again but passed through another standard adapter module that converts your xml file to csv) This method is preferable coz in your adapter module it will be easier for you to parse and get the fields.
>
> Regards
> Jai
Thanks Jai. I will try your recommendation from GUI mapping to CSV to Excel.
Can you please confirm if I understand the process correctly...
GUI Mapping -> Adapter Module 1 that converts XML to CSV -> Adapter Module 2 that converts CSV to Excel -> File Adapter (FTP)
Questions:
1. Is there a standard SAP XI adapter module that can do Module 1?
2. Is there a standard SAP XI adapter module that can do Module 2?
Please give me more information about the modules because I haven't used them before. Thank you for all your help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.