Question

5
Replies
141
Views
Bargavi. Member since 2015 7 posts
GE
Posted: November 16, 2017
Last activity: December 19, 2017
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.