|
Welcome to the Wi-Fi Hotspots Directory Help page for wi-fi
hotspots providers and owners
The Wi-Fi Hotspots Directory is part of the Wi-Fi
Technology Forum network of Wi-Fi Sites.
This is what your columns should have, keep the order as it is if
possible, but if you have them in different order, that's fine, after all,
we'll be inserting the columns in a master Excel file along with our other
internal columns.
| Live Status: YES / NO
note 5 |
US
State |
Country
ID: note 1 |
Unique ID see
note 2 |
Provider |
Name /Title |
Type |
Address
1 |
Address
2 |
City |
Zip / Code
note 3
|
Country
ISO Code. note 4 |
Location
Email |
Location Phone |
Website eg. http://.. |
SSID
/ Airport Code |
Wi-Fi Standard |
Notes /Instructions |
Coverage Area |
Other Details |
General: We expect to receive 20 columns IN
THE ABOVE ORDER for quick processing, names in Green
columns can not be left blank, although one
can expect few records
may not have a zip code for example (where zip do not apply in certain
countries), but the whole zip column can not be left
without zip codes. All columns should be formatted / set as TEXT in your
spreadsheet before inserting any records in them, see note
3. Pay particular attention to the grayed columns, for US State, put as
AL for Alabma, if the hotspot is not in the US, leave blank. Web addresses
and emails are not hyper-linked, for emails, the reason is obvious, we do not
want email harvesters intruding on your privacy or that of the hotspot owner.
For web addresses, we do it deliberately as we have a Links
Directory designated for that. For provider partners, we do hyperlink each
and every location to their subscription page (write us / to us with your
partnership proposal at editor@wi-fihotspotsdirectory.com).
Note 1
Your lists will be processed very quickly if you implemented the Country ID
as shown below. If you don't have the time, our staff will have to do it, but
may take longer, but please put the Two Letter ISO Country code there instead
if outside the US, if in the US, put the 2 letter ISO state name, AL for
Alabama for example (if you can't determine the state, put 1).
Country ID: We give each country and State (in
the US) a number for internal use, which serves as the category / country or
state identifier (state ID for US only) in which the hotspot is located. If
the Location is in the US, then each US State has its own number. If the
location is in the US but can't determine which State, then its Number is 1.
Now here are the internal Country / State codes (States in
the US are considered Countries on their own for the purpose of directory
management):
It's quite simple, just replace the name of the country (Or state if in the
US) with its corresponding ID number from the green
column in your own spreadsheet. If the hotspot is in the US but can't
determine which State, Record it as number 1 (State in
United States not known).
You need to record the ones in the Green column only in your
spreadsheet!
| 1 |
|
State
in United States not known |
| 237 |
United
States |
Alabama |
| 238 |
United
States |
Arizona |
| 239 |
United
States |
Arkansas |
| 240 |
United
States |
California |
| 241 |
United
States |
Colorado |
| 242 |
United
States |
Connecticut |
| 243 |
United
States |
Delaware |
| 244 |
United
States |
District
of Columbia |
| 245 |
United
States |
Florida |
| 246 |
United
States |
Georgia |
| 247 |
United
States |
Hawaii |
| 248 |
United
States |
Illinois |
| 249 |
United
States |
Indiana |
| 250 |
United
States |
Iowa |
| 251 |
United
States |
Kansas |
| 252 |
United
States |
Kentucky |
| 253 |
United
States |
Louisiana |
| 254 |
United
States |
Maryland |
| 255 |
United
States |
Massachusetts |
| 256 |
United
States |
Michigan |
| 257 |
United
States |
Minnesota |
| 258 |
United
States |
Mississippi |
| 259 |
United
States |
Missouri |
| 260 |
United
States |
Montana |
| 261 |
United
States |
Nebraska |
| 262 |
United
States |
Nevada |
| 263 |
United
States |
New
Hampshire |
| 264 |
United
States |
New
Jersey |
| 265 |
United
States |
New
Mexico |
| 266 |
United
States |
New
York |
| 267 |
United
States |
North
Carolina |
| 268 |
United
States |
North
Dakota |
| 269 |
United
States |
Ohio |
| 270 |
United
States |
Oklahoma |
| 271 |
United
States |
Oregon |
| 272 |
United
States |
Pennsylvania |
| 273 |
United
States |
Rhode
Island |
| 274 |
United
States |
South
Carolina |
| 275 |
United
States |
South
Dakota |
| 276 |
United
States |
Tennessee |
| 277 |
United
States |
Texas |
| 278 |
United
States |
Utah |
| 279 |
United
States |
Vermont |
| 280 |
United
States |
Virginia |
| 281 |
United
States |
Washington |
| 282 |
United
States |
Wisconsin |
| 283 |
United
States |
Wyoming |
| 284 |
United
States |
Alaska |
| 285 |
United
States |
Idaho |
| 286 |
United
States |
Maine |
| 287 |
United
States |
West
Virginia |
| 288 |
United
States |
US
Virgin Islands |
| 2 |
|
United
Kingdom |
| 3 |
|
Canada |
| 5 |
|
Australia |
| 6 |
|
France |
| 7 |
|
Germany |
| 8 |
|
Italy |
| 9 |
|
Netherlands |
| 10 |
|
New
Zealand |
| 11 |
|
Norway |
| 12 |
|
Spain |
| 13 |
|
Sweden |
| 14 |
|
Switzerland |
| 15 |
|
Belgium |
| 16 |
|
Denmark |
| 17 |
|
Portugal |
| 18 |
|
Andorra |
| 19 |
|
Angola |
| 20 |
|
Anguilla |
| 21 |
|
Antigua |
| 22 |
|
Argentina |
| 23 |
|
Armenia |
| 24 |
|
Aruba |
| 25 |
|
Austria |
| 26 |
|
Azerbaijan |
| 27 |
|
Bahamas |
| 28 |
|
Bahrain |
| 29 |
|
Bangladesh |
| 30 |
|
Barbados |
| 31 |
|
Barbuda |
| 32 |
|
Belarus |
| 33 |
|
Belize |
| 34 |
|
Benin |
| 35 |
|
Bermuda |
| 36 |
|
Bhutan |
| 37 |
|
Bolivia |
| 38 |
|
Botswana |
| 39 |
|
Brazil |
| 40 |
|
Brunei
Darussalam |
| 41 |
|
Bulgaria |
| 42 |
|
Burkina
Faso |
| 43 |
|
Burundi |
| 44 |
|
Cambodia |
| 45 |
|
Cameroon |
| 46 |
|
Cape
Verde |
| 47 |
|
Cayman
Islands |
| 48 |
|
Central
African Republic |
| 49 |
|
Chad |
| 50 |
|
Chile |
| 51 |
|
China |
| 52 |
|
Christmas
Island |
| 53 |
|
Cocos
Islands |
| 54 |
|
Colombia |
| 55 |
|
Comoros |
| 56 |
|
Congo |
| 57 |
|
Costa
Rica |
| 58 |
|
Ivory
Coast |
| 59 |
|
Croatia |
| 60 |
|
Cuba |
| 61 |
|
Cyprus |
| 62 |
|
Czech
Republic |
| 63 |
|
Djibouti |
| 64 |
|
Dominica |
| 65 |
|
Dominican
Republic |
| 66 |
|
Ecuador |
| 67 |
|
Egypt |
| 68 |
|
Equatorial
Guinea |
| 69 |
|
Estonia |
| 70 |
|
Ethiopia |
| 71 |
|
Faeroe
Islands |
| 72 |
|
Falkland
Islands |
| 73 |
|
Fiji |
| 74 |
|
Finland |
| 75 |
|
French
Polynesia |
| 76 |
|
Futuna
Island |
| 77 |
|
Gabon |
| 78 |
|
Gambia |
| 79 |
|
Georgia |
| 80 |
|
Ghana |
| 81 |
|
Gibraltar |
| 82 |
|
Greece |
| 83 |
|
Greenland |
| 84 |
|
Grenada |
| 85 |
|
Grenadines |
| 86 |
|
Guadaloupe |
| 87 |
|
Guyana |
| 88 |
|
Guam |
| 89 |
|
Guatemala |
| 90 |
|
Guinea |
| 91 |
|
Guinea-Bissau |
| 92 |
|
Guyana |
| 93 |
|
Haiti |
| 94 |
|
Herzegovina |
| 95 |
|
Holy
See |
| 96 |
|
Honduras |
| 97 |
|
Hong
Kong |
| 98 |
|
Hungary |
| 99 |
|
Iceland |
| 100 |
|
India |
| 101 |
|
Indonesia |
| 102 |
|
Iran |
| 103 |
|
Iraq |
| 104 |
|
Ireland |
| 105 |
|
Israel |
| 106 |
|
Jamaica |
| 107 |
|
Japan |
| 108 |
|
Jordan |
| 109 |
|
Kazakhstan |
| 110 |
|
Kenya |
| 111 |
|
Kiribati |
| 112 |
|
North
Korea |
| 113 |
|
South
Korea |
| 114 |
|
Kuwait |
| 115 |
|
Kyrgyzstan |
| 116 |
|
Laos |
| 117 |
|
Latvia |
| 118 |
|
Lebanon |
| 119 |
|
Lesotho |
| 120 |
|
Liberia |
| 121 |
|
Libyan
Arab Jamahiriya |
| 122 |
|
Liechtenstein |
| 123 |
|
Lithuania |
| 124 |
|
Luxembourg |
| 125 |
|
Macau |
| 126 |
|
Macedonia |
| 127 |
|
Madagascar |
| 128 |
|
Malawi |
| 129 |
|
Malaysia |
| 130 |
|
Maldives |
| 131 |
|
Mali |
| 132 |
|
Malta |
| 133 |
|
Malvinas |
| 134 |
|
Marshall
Islands |
| 135 |
|
Martinique |
| 136 |
|
Mauritania |
| 137 |
|
Mauritius |
| 138 |
|
Mexico |
| 139 |
|
Micronesia |
| 140 |
|
Miquelon |
| 141 |
|
Moldova |
| 142 |
|
Monaco |
| 143 |
|
Mongolia |
| 144 |
|
Montserrat |
| 145 |
|
Morocco |
| 146 |
|
| |