Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

MelBridgeman · 03-23-2010, 06:05 PM

Let's discuss this further...because from my point of view, there is no way to stop this from happening.

1. I get a daily CSV file from this MLS provider, each field is the fully qualified description. I do not get any lookup tables from the MLS provider. Just a decoded file.

2. The importer reads the file and builds the lookup tables based on the data. So for the city lookups, it will compare the city field in the CSV against whats in the lookups, based on the description, if its not in there it has to add it and assigns the generated lookup id to the listing, if its located it assigns the pk to that listing....So if cities are spelt wrong, there is nothing i can do initially.

Since the lookup id of the correct spelling of Fort Mac isn't gonna change, i can update the importer to fix the lookup data and the listings once the fresh data is in.

But on initial design and without having any control over the MLS app that realtors use to enter this data, there is nothing I can do about it.

03-23-2010, 06:05 PM	#45
MelBridgeman Lifetime Suspension Join Date: Mar 2007 Location: Calgary Exp:	Let's discuss this further...because from my point of view, there is no way to stop this from happening. 1. I get a daily CSV file from this MLS provider, each field is the fully qualified description. I do not get any lookup tables from the MLS provider. Just a decoded file. 2. The importer reads the file and builds the lookup tables based on the data. So for the city lookups, it will compare the city field in the CSV against whats in the lookups, based on the description, if its not in there it has to add it and assigns the generated lookup id to the listing, if its located it assigns the pk to that listing....So if cities are spelt wrong, there is nothing i can do initially. Since the lookup id of the correct spelling of Fort Mac isn't gonna change, i can update the importer to fix the lookup data and the listings once the fresh data is in. But on initial design and without having any control over the MLS app that realtors use to enter this data, there is nothing I can do about it. Last edited by MelBridgeman; 03-23-2010 at 06:10 PM.