Ask Your Question

Web Signals appearing in fields

asked 2016-10-12 15:34:05 -0600

updated 2016-10-20 16:40:44 -0600

We have noticed that many fields contain 'web signals' and it is causing us some downstream problems. The 'web signal's' we speak are: &amp, &#8217, &#8211,&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?

edit retag flag offensive close merge delete


Is there an update on this matter?

Edmonton gravatar imageEdmonton ( 2016-10-17 13:54:11 -0600 )edit

Can you give me a specific MLS and listing with this issue?

bwolven gravatar imagebwolven ( 2016-10-20 10:46:56 -0600 )edit

We are using for our RETS URL Edmonton (Alberta, Canada) is the MLS.

E4029372, E4039101, E4040843, E4041511 are just a few examples

Edmonton gravatar imageEdmonton ( 2016-10-20 12:24:25 -0600 )edit

2 Answers

Sort by » oldest newest most voted

answered 2016-10-21 17:53:58 -0600

updated 2016-11-15 17:33:32 -0600

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.

edit flag offensive delete link more

answered 2016-10-26 12:34:47 -0600

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.

edit flag offensive delete link more


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: &’–—“”…‘......... gravatar ( 2016-12-08 10:34:33 -0600 )edit

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: &amp &apos

2) Field name: LM_Char10_2

Clean HTML code: &amp &apos

3) Field name: LM_Dec_1(RE_1) LM_D gravatar ( 2016-12-08 10:37:06 -0600 )edit

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: &’–—“”…‘ •½ gravatar ( 2016-12-08 10:37:24 -0600 )edit

6) Field name: LR_remarks55 Clean HTML code: &’–—“”…‘ •½¼®­²éçè 졠ؾ'">< gravatar ( 2016-12-08 10:38:03 -0600 )edit

7) Field name: LR_remarks66 Clean HTML code: &"'’“–—‘” …®² ×<>

8) Field name: VT_ExtVTourURL5 Clean HTML code: &amp

9) Fie gravatar ( 2016-12-08 10:38:20 -0600 )edit

9) Field name: VT_VTourURL Clean HTML code: &é

10) Field name: VT_ExtVTourURL1, VT_ExtVTourURL3, VT_ExtVTourURL2 Clean HTML code: &' gravatar ( 2016-12-08 10:38:39 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-10-12 15:34:05 -0600

Seen: 682 times

Last updated: Nov 15 '16