on 10-24-2014 5:55 PM
Hi Experts,
I have a File to Proxy scenario.
Converting *.txt file to XML ,in moni i am getting the below error:
and in my Data type there are no mandatory fields,can some on help me what is the problem here?
If i put the same payload in test tab of message mapping its working fine.
If error is due to file content how do i fix it.
Br,
Manoj
PAYLOAD:
<?xml version="1.0" encoding="utf-8" ?>
<ReceiveSpeakerVendor>
<SpeakerVendor>
<Records>
<Methods>C</Methods>
<CompanyCode>CN06</CompanyCode>
<AccountGroup>ZCN1</AccountGroup>
<SAPVendorNumber />
<Name1>Jia Yizhen test11</Name1>
<SearchTermA>YIZHEN2</SearchTermA>
<PostalCode>201222</PostalCode>
<City>Shanghai</City>
<Country>CN</Country>
<Street>East Hospital of Shanghai test3</Street>
<Region>020</Region>
<SearchTermB>4211002665</SearchTermB>
<Language>ZH</Language>
<Email>test3@novartis.com</Email>
<Mobile>13012345638</Mobile>
<ContactName>Yangshuo TEST</ContactName>
<ContactTelephone>13112345678</ContactTelephone>
<ReconAccount>400000</ReconAccount>
<Sortkey>001</Sortkey>
<Authorization>ZCNP</Authorization>
<CashMngmntGroup>A1</CashMngmntGroup>
<PrevAcctNo>4211002665</PrevAcctNo>
<PaymentTerm>CN00</PaymentTerm>
<PaymentMethods>C</PaymentMethods>
<DoubleInvoiceValidation>X</DoubleInvoiceValidation>
<HouseBank>CTBSC</HouseBank>
<IndividualPayment>X</IndividualPayment>
<AcctgClerk>ED</AcctgClerk>
<BlockFlag />
</Records>
<Records>
<Methods>C</Methods>
<CompanyCode>CN09</CompanyCode>
<AccountGroup>ZCN1</AccountGroup>
<SAPVendorNumber />
<Name1>test111</Name1>
<SearchTermA>test</SearchTermA>
<PostalCode>201222</PostalCode>
<City>Shanghai</City>
<Country>CN</Country>
<Street>East Hospital of Shanghai test4</Street>
<Region>020</Region>
<SearchTermB>4211002666</SearchTermB>
<Language>ZH</Language>
<Email>test4@novartis.com</Email>
<Mobile>13012345638</Mobile>
<ContactName>Yangshuo TEST</ContactName>
<ContactTelephone>13112345678</ContactTelephone>
<ReconAccount>400000</ReconAccount>
<Sortkey>001</Sortkey>
<Authorization>ZCNP</Authorization>
<CashMngmntGroup>A1</CashMngmntGroup>
<PrevAcctNo>4211002666</PrevAcctNo>
<PaymentTerm>CN00</PaymentTerm>
<PaymentMethods>C</PaymentMethods>
<DoubleInvoiceValidation>X</DoubleInvoiceValidation>
<HouseBank>CTBSC</HouseBank>
<IndividualPayment>X</IndividualPayment>
<AcctgClerk>ED</AcctgClerk>
<BlockFlag />
</Records>
<Records>
<Methods>E</Methods>
<CompanyCode>CN09</CompanyCode>
<AccountGroup />
<SAPVendorNumber>22000006</SAPVendorNumber>
<Name1 />
<SearchTermA />
<PostalCode />
<City />
<Country />
<Street />
<Region />
<SearchTermB />
<Language />
<Email />
<Mobile />
<ContactName />
<ContactTelephone />
<ReconAccount>400000</ReconAccount>
<Sortkey>001</Sortkey>
<Authorization>ZCNP</Authorization>
<CashMngmntGroup>A1</CashMngmntGroup>
<PrevAcctNo>4211002666</PrevAcctNo>
<PaymentTerm>CN00</PaymentTerm>
<PaymentMethods>C</PaymentMethods>
<DoubleInvoiceValidation>X</DoubleInvoiceValidation>
<HouseBank>CTBSC</HouseBank>
<IndividualPayment>X</IndividualPayment>
<AcctgClerk>HP</AcctgClerk>
<BlockFlag />
</Records>
<Records>
<Records>
<Methods>U</Methods>
<CompanyCode>CN06</CompanyCode>
<AccountGroup />
<SAPVendorNumber>22000004</SAPVendorNumber>
<Name1>Jia Yizhen 333</Name1>
<SearchTermA>YIZHEN2</SearchTermA>
<PostalCode>201222</PostalCode>
<City>Shanghai</City>
<Country>CN</Country>
<Street>East Hospital 2 of Shanghai test</Street>
<Region>020</Region>
<SearchTermB>4211002665</SearchTermB>
<Language>ZH</Language>
<Email>test1@novartis.com</Email>
<Mobile>13012345555</Mobile>
<ContactName>Yangshuo TEST</ContactName>
<ContactTelephone>13112345678</ContactTelephone>
<ReconAccount>400000</ReconAccount>
<Sortkey>001</Sortkey>
<Authorization>ZCNP</Authorization>
<CashMngmntGroup>A1</CashMngmntGroup>
<PrevAcctNo>4211002665</PrevAcctNo>
<PaymentTerm>CN00</PaymentTerm>
<PaymentMethods>C</PaymentMethods>
<DoubleInvoiceValidation />
<HouseBank>CTBSC</HouseBank>
<IndividualPayment>X</IndividualPayment>
<AcctgClerk>ED</AcctgClerk>
<BlockFlag />
</Records>
</SpeakerVendor>
</ReceiveSpeakerVendor>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Harish,
As you suggested i went through the text file but couldn't find any Unicode Char, but when i copy pasted the same content in hex editor i found 2 special char at the start of the file . How is that possible that unicode not visible in .txt file but its visible in hex editor.
TXT file :
No char at start of file i.e before 'Methods'
HEX editor :
You can see 2 special char at in the screenshot before 'METHODS'.
Br,
Manoj
Hi Manoj,
This happenes because your Text editor does not support all different types of Text Encodings.
You can check the below:
computer forensics - Text editor capable of viewing invisibles? - Stack Overflow
Regards,
Nabendu.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.