We have noticed that many fields contain 'web signals' and it is causing us some downstream problems. The 'web signal's' we speak are: &, ’, –,&apos and others. They appear when we download the data via any format (ie Compact, Compact Decoded, Standard). Is this a known issue? Can this get rectified in the RETS database?
That is normal since data is escaped when it is sent out as UTF-8 to make sure it a valid XML. Generally the client XML parser would un-escape the data on the receiving end.
Update 2016-11-15 17:40 CST - Looking further into this issue.
First, we do not download in XML, and just compact format in RETS download, second, from paragon web into download server is in your side, not us. We just from your download server to get txt data.
This should be clean while data from web into SQL server or use trigger to clean it after server get data.
The currently, it download in txt file not XML. The problem is there a lot of HTML code inside some field component. We need you clean in server side. for example: Field name: LR_remarks55 Clean HTML code: &’–—“”…‘.........
For clean “HTML code”, I list the detail message to you according to each download field name. ( we have hundreds “HTML code” in our system )
1) Field name: #LM_char100_6
Clean HTML code: & &apos
2) Field name: LM_Char10_2
Clean HTML code: & &apos
3) Field name: LM_Dec_1(RE_1) LM_D
4) Field name: LM_Dec_3 (RU_2,RE_1) LM_int4_35 (CM_4) Clean HTML code: &apos
5) Field name: LM_Char25_4 (RU_2,RE_1) Clean HTML code: &apos
6) Field name: LR_remarks55 Clean HTML code: &’–—“”…‘ •½
6) Field name: LR_remarks55 Clean HTML code: &’–—“”…‘ •½¼®²éçè ì¡ Ø¾'"><
7) Field name: LR_remarks66 Clean HTML code: &"'’“–—‘” …®² ×<>
8) Field name: VT_ExtVTourURL5 Clean HTML code: &
9) Fie
9) Field name: VT_VTourURL Clean HTML code: &é
10) Field name: VT_ExtVTourURL1, VT_ExtVTourURL3, VT_ExtVTourURL2 Clean HTML code: &'
Comments
Is there an update on this matter?
Can you give me a specific MLS and listing with this issue?
We are using http://rebrae.retsiq.com/contact/rets... for our RETS URL Edmonton (Alberta, Canada) is the MLS.
E4029372, E4039101, E4040843, E4041511 are just a few examples