Nearest Store Data Structure
Our "Nearest Store" database structure is:
Name | Description |
---|---|
YourID | Your identifier, you can use to get full record from your database. UNIQUE REQUIRED Integer |
PostCode | The Postcode of your store. REQUIRED Please note PO BOxs are not supported as they have no location |
YourData1 | This can be loaded with any text you want to display. This could be loaded with the ID of your record, full address, directions, etc. This data is then merged with your template to expand to full HTML |
YourData2 | As YourData1 |
YourData3 | As YourData1 |
YourData4 | As YourData1 |
YourData5 | As YourData1 |
YourData6 | As YourData1 If using filters then can stop details being shown on pin click if set to "NODETAILS". This allows control over each Pin |
YourData7 | As YourData1 |
YourData8 | As YourData1 |
Longitude | We populate this for you when added to database |
Latitude | We populate this for you when added to database |
DataAdded | Date added to database. We assign this when added. format YYYYMMDD |
Type | Can be used to filter out certain kinds of locations, in nearest list and show different icons on a map Optional Char [See Example 5] TypeFilter will optionally filter out records from the nearest list. You could use "A" for major stores, "B" small stores and "C" for Petrol stations. Then if displayed on map they could all have different Pins. The actual list returned could only include "AB", so the petrol stations would not be listed. This field could also be loaded with codes, which relate to qualifications. Then the service is called with the type code (qualification code) to product a list of nearest consultants with curtail qualifications. |
Area | Allows you to display all Stores in a certain area. Optional String (2) To display a map for Area simple call theGetNearestToPostCodeTemplateAndMapwith ExtraFlags="AreaCode=Area" the TargetPostcode should be set to center the map [See Example 6,7] |