Question

5
Replies
133
Views
Bargavi. Member since 2015 7 posts
GE
Posted: 2 years ago
Last activity: 2 years 9 months ago
Closed

Encoding XML and place file in a location - with Non-english Characters

Hi,

I have a few clipboard properties with non-english chars eg - Brüderkrankenhaus and 样品样品样品样品样品.

When i form the excel and check in the clipboard it looks like this

<?xml version="1.0"?>
<pagedata>
<pxQueryTimeStamp>20171116T104015.253 GMT</pxQueryTimeStamp>
<pxMore>false</pxMore>
<pyMaxRecords>100</pyMaxRecords>
<pxSQLStatementPre>SELECT pzPVStream AS "pzPVStream" from {CLASS:GE-QRM-PostMarket-Work-Complaint} WHERE ( PYSTATUSWORK = {pyReportParameters_temp.pyPreparedValues(1)} ) AND ( PYID = {pyReportParameters_temp.pyPreparedValues(2)} ) AND ( pxObjClass = {pyReportParameters_temp.pyPreparedValues(3)} ) </pxSQLStatementPre>
<pyTempText>hybridVL</pyTempText>
<pxObjClass>Code-Pega-List</pxObjClass>
<pxTotalResultCount>0</pxTotalResultCount>
<pyObjClass>abc-cgd-hchjf</pyObjClass>
<pxPageCount>0</pxPageCount>
<pxSQLStatementPost>abc-cgd-hchjf</pxSQLStatementPost>
<pxResultCount>1</pxResultCount>
<pzStatus>valid</pzStatus>
<pyMapping REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>.CountryOccured</pyPropertyName>
</rowdata>
<rowdata REPEATINGINDEX="2">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>.pyStatusWork</pyPropertyName>
</rowdata>
<rowdata REPEATINGINDEX="3">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>.pyID</pyPropertyName>
</rowdata>
<rowdata REPEATINGINDEX="4">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>CustomersIssueDescription</pyPropertyName>
</rowdata>
<rowdata REPEATINGINDEX="5">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>FEsIssueDescription</pyPropertyName>
</rowdata>
<rowdata REPEATINGINDEX="6">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>RepairTestInspectionData</pyPropertyName>
</rowdata>
<rowdata REPEATINGINDEX="7">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>ActionsTakenRepairs</pyPropertyName>
</rowdata>
</pyMapping>
<pzPerformanceSettings REPEATINGTYPE="PropertyList"/>
<pxResults REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<pyStatusWork>Translate</pyStatusWork>
<CustomerTranslated>N</CustomerTranslated>
<ActionsTakenRepairs>Brüderkrankenhaus St. Josef 样品样品样品样品样品</ActionsTakenRepairs>
<ActionTakenTranslated>N</ActionTakenTranslated>
<CustomerAddressTranslated>N</CustomerAddressTranslated>
<CustomersIssueDescription>Brüderkrankenhaus St. Josef 样品样品样品样品样品</CustomersIssueDescription>
<FEsIssueDescription>Brüderkrankenhaus St. Josef 样品样品样品样品样品</FEsIssueDescription>
<pxObjClass>abc-cgd-hchjf</pxObjClass>
<CountryOccured>India</CountryOccured>
<pyID>COM-11355859</pyID>
<CustomerContactTranslated>N</CustomerContactTranslated>
<CustomerIssueTranslated>N</CustomerIssueTranslated>
<RepairInspectionTranslated>N</RepairInspectionTranslated>
<RepairTestInspectionData>Brüderkrankenhaus St. Josef 样品样品样品样品样品</RepairTestInspectionData>
<FEIssueTranslated>N</FEIssueTranslated>
<CustomerPage>
<pxObjClass>GE-FW-PostMarketFW-Data-Customer</pxObjClass>
<Address>No 6, Dubai Main road, Dubai</Address>
<Customer>Picachu</Customer>
<Contact>mr dandnakka</Contact>
</CustomerPage>
</rowdata>
</pxResults>
</pagedata>
but the same data in that location it looks like this

<?xml version="1.0"?>

<pagedata>
<pxQueryTimeStamp>20171116T103013.740 GMT</pxQueryTimeStamp>
<pxMore>false</pxMore>
<pyMaxRecords>100</pyMaxRecords>
<pxSQLStatementPre>abc-cgd-hchjf</pxSQLStatementPre>
<pyTempText>hybridVL</pyTempText>
<pxObjClass>Code-Pega-List</pxObjClass>
<pxTotalResultCount>0</pxTotalResultCount>
<pyObjClass>abc-cgd-hchjf</pyObjClass>
<pxPageCount>0</pxPageCount>
<pxSQLStatementPost>abc-cgd-hchjf</pxSQLStatementPost>
<pxResultCount>1</pxResultCount>
<pzStatus>valid</pzStatus>
<pyMapping REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>.CountryOccured</pyPropertyName>
</rowdata>
<rowdata REPEATINGINDEX="2">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>.pyStatusWork</pyPropertyName>
</rowdata>
<rowdata REPEATINGINDEX="3">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>.pyID</pyPropertyName>
</rowdata>
<rowdata REPEATINGINDEX="4">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>CustomersIssueDescription</pyPropertyName>
</rowdata>
<rowdata REPEATINGINDEX="5">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>FEsIssueDescription</pyPropertyName>
</rowdata>
<rowdata REPEATINGINDEX="6">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>RepairTestInspectionData</pyPropertyName>
</rowdata>
<rowdata REPEATINGINDEX="7">
<pxObjClass>Embed-ReportMapping</pxObjClass>
<pyClassName>abc-cgd-hchjf</pyClassName>
<pyPropertyName>ActionsTakenRepairs</pyPropertyName>
</rowdata>
</pyMapping>
<pzPerformanceSettings REPEATINGTYPE="PropertyList"/>
<pxResults REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<pyStatusWork>Translate</pyStatusWork>
<CustomerTranslated>N</CustomerTranslated>
<ActionsTakenRepairs>Brüderkrankenhaus St. Josef æ ·å“æ ·å“æ ·å“æ ·å“æ ·å“</ActionsTakenRepairs>
<ActionTakenTranslated>N</ActionTakenTranslated>
<CustomerAddressTranslated>N</CustomerAddressTranslated>
<CustomersIssueDescription>Brüderkrankenhaus St. Josef æ ·å“æ ·å“æ ·å“æ ·å“æ ·å“</CustomersIssueDescription>
<FEsIssueDescription>Brüderkrankenhaus St. Josef æ ·å“æ ·å“æ ·å“æ ·å“æ ·å“</FEsIssueDescription>
<pxObjClass>abc-cgd-hchjf</pxObjClass>
<CountryOccured>India</CountryOccured>
<pyID>COM-11355859</pyID>
<CustomerContactTranslated>N</CustomerContactTranslated>
<CustomerIssueTranslated>N</CustomerIssueTranslated>
<RepairInspectionTranslated>N</RepairInspectionTranslated>
<RepairTestInspectionData>Brüderkrankenhaus St. Josef æ ·å“æ ·å“æ ·å“æ ·å“æ ·å“</RepairTestInspectionData>
<FEIssueTranslated>N</FEIssueTranslated>
<CustomerPage>
<pxObjClass>GE-FW-PostMarketFW-Data-Customer</pxObjClass>
<Address>No 6, Dubai Main road, Dubai</Address>
<Customer>jhsfgkjsfkfsjjk</Customer>
<Contact>mr Dandnka</Contact>
</CustomerPage>
</rowdata>
</pxResults>
</pagedata>

Wondering how to place the same char representation in the File location as XML.

Like

Original data - Brüderkrankenhaus St. Josef 样品样品样品样品样品

after file creation - Brüderkrankenhaus St. Josef æ ·å“æ ·å“æ ·å“æ ·å“æ ·å“

Both needs to be the same. #helpme

Data Integration Java and Activities
Moderation Team has archived post
Share this page LinkedIn