Ask Your Question
0

Web Signals appearing in fields

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

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

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

Comments

Is there an update on this matter?

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

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

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

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

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

2 Answers

Sort by » oldest newest most voted
1

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

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

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
0

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

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

Comments

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: &’–—“”…‘.........

charles@ereb.com gravatar imagecharles@ereb.com ( 2016-12-08 10:34:33 -0500 )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

charles@ereb.com gravatar imagecharles@ereb.com ( 2016-12-08 10:37:06 -0500 )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: &’–—“”…‘ •½

charles@ereb.com gravatar imagecharles@ereb.com ( 2016-12-08 10:37:24 -0500 )edit

6) Field name: LR_remarks55 Clean HTML code: &’–—“”…‘ •½¼®­²éçè 졠ؾ'"><

charles@ereb.com gravatar imagecharles@ereb.com ( 2016-12-08 10:38:03 -0500 )edit

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

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

9) Fie

charles@ereb.com gravatar imagecharles@ereb.com ( 2016-12-08 10:38:20 -0500 )edit

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

10) Field name: VT_ExtVTourURL1, VT_ExtVTourURL3, VT_ExtVTourURL2 Clean HTML code: &'

charles@ereb.com gravatar imagecharles@ereb.com ( 2016-12-08 10:38:39 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 132 times

Last updated: Nov 15 '16