Question
GE
IN
Last activity: 19 Dec 2017 5:12 EST
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
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
Pegasystems Inc.
IN
Hi Bargavi,
How are you trying to achieve this?
Use Connect-File write from clipboard method to achieve this.
Regards,
Ujjwal
Pegasystems Inc.
IN
Hi Bargavi,
I tried with very small XML
<pagedata>
<Customer>Brüderkrankenhaus St. Josef 样品样品样品样品样品</Customer>
<Contact>mr dandnakka</Contact>
</pagedata>
Put that in a string and then use it in connect file as below:-
This Seems to work fine and I am able to get correct response.
Could you try this at your and let me know If you are trying something else.
Regards,
Ujjwal
GE
IN
This is the same approach i am following too. In the clipboard i am able to see the correct chars. in that location when i open the characters are not the same. It looks like encoded. I want the same chars that is present in my clipboard in the location xml also where i write it.
Pegasystems Inc.
IN
Hi Bargavi,
I believe you can open an SR for further troubleshoot.
@Vidyaranjan Thanks for notifying me on this.
Thanks,
Ujjwal