The objective is to convert csv file to xml representation. Example:
The target message type is 2 columns that repeatable at node row.
Document Name is the target message type.
Document Namespace should be the namespace of the message type.
Recordset Strcuture is “row,*”. This mean the node “row” can be repeat unbounded time.
Parameter ignoreRecordsetName set to “true”, so that adapter will not default add another “Recordset” node, this is because for csv file, only have one structure only.
Parameter row.fieldSeparator = “|”, this is the delimiter of csv file. Fields will split whenever have this “|”.
Parameter row.endSeparator = ‘nl’, this is the new line character. Lines will split whenever have this ‘nl’.
Parameter row.fieldNames = “col1,col2”, this is the field names of node “row”.
Keep on posting!
File Adapter – Sender – Content Conversion to Convert CSV file to XML
Thanks
How about in the opposite way?,
idoc to CSV delimited?
119780|20181004T205509|ABC029938108|PC|SAPMaterialDesc|EA|500|KG|3000|USD|N|||E|TBD|TBD|TBD|TBD|4421919780|N|CN|MULTIPLE||3500|0|USD|0|0||0|0|N|N|N|0||0||TBD|TBD|TBD
Pingback:SAP PI/PO, SFTP to SOAP scenario, sending a csv file – Jaehoo Weblog