Data file formats
The files containing property
details should be prepared according to the structures and formats defined for
each property section. In each case the data file will be a BAR DELIMITED TEXT
(.txt) FILE.
Data file
names
The
naming of data is the same for each property section, as follows:
EA_code-DATA.txt [where EA_code is the unique Estate Agent's code used in the data file itself]
e.g.
RH-DATA.txt, C21ST-DATA.txt
UK Residential
Sales Upload File Structure
Language|Era|Type|Bedrooms|Bathrooms|Price|Currency_id|Price_Euros|Units_remain|Date_avail|PropertyID|Street_level|City|Postcode|Country|Floors|Description|Neighbourhood_name|School|Garden_area|Garden_facing|Constr_status|Air_cond|Alarm|Balcony|Carpets|Fitted_kitchen|Controlled_access|Off_street_parking|CH|House_area_sqft|Stripped_wooden_floors|Fireplace||Estate_Agent|Contact_name|Contact_address|Contact_phone|Contact_fax|Contact_email|Upload_date|Expiry_date|Receptions|Roof_terrace|Double_glazing|Orig_windows|Title|Price_range|Multimap_url||Image_main|Image2|Image3|Image4|Image5|Image6|Image7|Image8|Image9|Plan1|Plan2|Plan3|Plan4|Plan5|Region|EA_code|Description_short|Property_url
|Recent|Flat|2|2|254000|GBP||||RH-islandrow-es4|Island
Row|London|E14|UK||"<font face=verdana color=#003366 size=-1>We are
pleased to offer you this 2 bedroom apartment, 2 bath ( 1 bed en-suite ) in
Commercial Wharf, with spacious reception and 2 balconies, secure underground
car parking , near to Limehouse and Westferry DLR stations<p>
<b>Measurements</b>
<ul><li>Reception : 17ft7 x 9ft6
<ul><li>Glass door to the balcony. Fully
carpeted ( color beige ), wall paper</ul>
<li> Kitchen : 8ft3 x 6ft8
<ul><li>Gas hob, washing drier machine, dish
washer, wood work top, cupboard floor/wall, fridge freezer, ½ ceramic wall tiles, stone
floor</ul>
<li>Bedroom 1: 12ft5 x 9ft10
<ul><li>Glass door to Balcony, beige carpet,
building wardrobe, gas radiator
<li>En-suite
6ft6 x 6ft
<ul><li>Shower, 2 pce with, ½l ceramic wall
tiles, ceramic floor tiles, gas
radiator</ul>
</ul> <li> Bedroom2: 12ft x 9ft2
<ul><li>2 Wardrobe, gas radiator, beige
carpet</ul>
<li> Bathroom:
7ft2 x 6ft5
<ul><li>Mirror in the wall, 3 pce white with
shower, ceramic floor tiles, ½ ceramic
wall tiles, gas radiator, wood top</ul>
<li> Hallway
<ul><li>Gas radiator, central heating in
cabinet</ul>
<li> Other
<ul><li>Secure underground car
parking</ul></ul></font>"|||||Existing|||yes|yes|yes|yes||yes|||||P4L
River Habitat|Aziza Shah|655 Commercial Road E14|0207 791 9830|0207 791
9831|info@p4l.co.uk|17/01/02|24/01/02|1||||Commercial Wharf, Island Row E14, 2
bed £254,000|£250,000 - £349,000||||||||||||||||||East London|RH|We are pleased
to offer you this 2 bedroom apartment, 2 bath ( 1 bed en-suite ) in Commercial
Wharf, with spacious reception and 2 balcony, secure underground car parking ,
near to Limehouse and Westferry DLR station.|http://www.p4l.co.uk/
RH-islandrow-es4.html
|Other|House|3|1|170000|GBP||||RH-fordstreet-es3|Ford
Street|London|E16|UK|2|"<font face=verdana color=#003366 size=-1>We
are delighted to offer you this 3 bedroom house with garden, central heating, 5
minutes from Canning town Station.<p>
Details:<ul><li>Reception 1: 20ft8 x
10ft10</li>
<ul><li>Gas Radiator, carpet, large
room.</li>
</ul><li>Kitchen: 9ft7 x 8ft2</li>
<ul><li>Electrical hob, cupboard floor/wall, gas
radiator.</li>
</ul><li>Bedroom 1: 12ft2 x 11ft</li>
<ul><li>Gas radiator, carpet.</li>
</ul><li>Bedroom 2: 11ft x 8ft</li>
<ul><li>Gas radiator,
carpet.</li></ul>
<li>Bedroom 3: 9ft6 x 8ft4</li>
<ul><li>Gas radiator,
carpet.</li></ul>
<li>Bathroom: 4ft8 x 8ft4</li>
<ul><li>3 pce
suite.</li></ul></font>"|||||Existing||||yes||||yes|||||P4L
River Habitat|Minya Haler|655 Commercial Road E14|0207 791 9830|0207 791
9831|info@p4l.co.uk|17/01/02|24/01/02|||||Ford Street , 3 bed, E16,
£170,000|£150,000 - £249,000||||||||||||||||||East London|RH|We are delighted
to offer you this 3 bedroom house with garden, central heating, 5 min. from
Canning Town Station.|http://www.p4l.co.uk/ RH-fordstreet-es3.html