PDA

View Full Version : Importing IDX info



Anonymous
05-06-2003, 12:59 PM
My client was frustrated with having to make two website updates...like many on this forum. I inquired about IDX and the MLS provider seems to be with it....and will give me IDX downloads.

I would like suggestions on how I can implement it. They are using the following sql sctructure:

IDX SQL Data View Classes & Fields

Residential

Id, bath_level, bath3_4,_level baths, baths3_4, bd1_size, bd2_size, bd3_size, bd4_size, bedrooms, book, color, den_size, dr_size, elem_school, flood_zone, found_size, fr_size, frontage, glaag, glaaga, glaagb, high_school, kt_size, lav_level, lavs, list_price, lister_agent_name, lister_office_name, lot, lot_size_acres, lr_size, map, midl_school, nof_cars, ot_size, page, parking, remark1, rooms, school_district, seasonal, status, surveyed, tax_years, taxes, town, water_body, water_frontage year_built, mls_zone, mod_date_time, p_mod_date_time, features, medium_photo

Condo

Id, bath_level, bath3_4_level, baths, baths3_4, bd1_size, bd2_size, bd3_size, bedrooms, book, building_no, color, den_size, dr_size, elem_school, flood_zone, floor_no, found_size, fr_size, glaag, glaaga, glaagb, high_school, kt_size, lav_level, lavs, list_price, lister_agent_name, lister_office_name, lot, lot_size_acres, lr_size, map, midl_school, nof_cars, ot_size, page, parking, remark1, rooms, school_district, seasonal, status, stg_size, subdivision, tax_years, taxes, town , unit_no, water_body, water_frontage, year_built, mls_zone, mod_date_time, p_mod_date_time, features, medium_photo

MultiFamily

Id, annual_expenses, baths_unit, bdrs_unit, book, color, deposit_u1, deposit_u2, deposit_u3, deposit_u4, elec_unit, elem_school, flood_zone, floor_loc_unit, found_size, frig_unit, frontage, glaag, glaaga, glaagb, gross_income, heat_expense, heat_unit, high_school, hot_water_unit, ins_expense, laundry_unit, list_price, lister_agent_name, lister_office_name, lot, lot_size_acres, lr_agreement_unit, maint_expense, management_expense, map, midl_school, misc_expense, near, nof_1br, nof_2br, nof_3br, nof_cars, nof_units, page, parking, range_unit, remark1, rent_date, changed_u1, rent_date_changed_u2, rent_date_changed_u3, rent_date_changed_u4, rent_due_u1, rent_due_u2, rent_due_u3, rent_due_u4, rent_u1, rent_u2, rent_u3, rent_u4, rooms_unit, school_district, seasonal, sewer_unit, show_u1, show_u2, show_u3, show_u4, snow_expense, sold_date, status, style_u1, style_u2, style_u3, style_u4, surveyed, tax_years, taxes,tenant_phone_u1, tenant_phone_u2, tenant_phone_u3, tenant_phone_u4, tenant_u1, tenant_u2, tenant_u3, tenant_u4, town, trash_expense, utilities_expense, water_body, water_frontage, water_unit, ws_expense, year_built, mls_zone, mod_date_time, p_mod_date_time, features, medium_photo

Land

Id, assess_yr, block, book, deed_type, easement, elem_school, flood_zone, frontage, high_school, list_price, lister_agent_name, lister_office_name, lot, lot_size, lot_size_acres, map, midl_school, near, open_space page, permit_no, pole_no, power_co, remark1, school_district, status, street_name, street_no, subdivision, surveyed_by, tax_rate, tax_reduction, tax_years, taxes, town, water_body, water_frontage, wf_owned, wf_shared , mls_zone, mod_date_time, p_mod_date_time, features, medium_photo
Commercial

Id, air_cond, available_sf, block, book, building_size, c_type, cable, cam, ceiling_height, class5, class7, cogs, deed_type, door_height, exclusion1, frontage, goi, insurance_exp, lease_amnt_per, lease_price, list_price, lister_agent_name, lister_office_name, lot, lot_size, lot_size_acres, map, max_flc, mgmt_res, near, nof_docks, nof_drive_doors, nof_floors, nof_parkings, nof_units, noi, office_sf, other_sf, page, phone_service, price_type, rail_serv,remark1, retail_sf, signage, status, street_name, street_no, taxes, town, traffic_cnt, vac, warehse, sf, year_built, mls_zone, mod_date_time, p_mod_date_time, features, medium_photo


Mobile Home

Id, assess_yr, assessment, bath_level, bath3_4, level, baths, baths3_4, bedrooms, book, color, elem_school, flood_zone, found_size, frontage, glaag, glaaga, glaagb, high_school, lav_level, lavs, list_price, lister_agent_name, lister_office_name, lot, lot_size, lot_size_acres, map, mb_fee, mb_make, mb_model, mb_park, mb_serial, mb_xfee, midl_school, nof_cars, page, parking, remark1, rooms, school_district, seasonal, status, surveyed, tax_years, taxes, town, water_body, water_frontage, year_built, mls_zone, mod_date_time, p_mod_date_time, features, medium_photo


Any help you can offer me would be very appreciated.....thanks!