DOCUMENT:Q197634 26-AUG-1999 [automap] TITLE :How to Create Pushpins by Importing Addresses from a Text File PRODUCT :Microsoft Automap PROD/VER:WINDOWS: OPER/SYS: KEYWORDS:kbtool kbui kbimu ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Expedia Streets 98 - Microsoft Expedia Trip Planner 98 ------------------------------------------------------------------------------- SUMMARY ======= This article describes how to create new pushpins in Expedia Streets 98 or Expedia Trip Planner 98 by importing addresses from a text file. MORE INFORMATION ================ The information in this article is divided into the following sections: - Address List File Requirements - Importing a Pushpin Set from an Address List File - Creating an Address List File - Using Latitude and Longitude Address List File Requirements ------------------------------ To import addresses from a text file, the file must meet the following requirements: - The file must be a plain-text (ASCII) file. Comma delimited (.csv) text files are also acceptable. - The file must use a reserved character to separate the fields in each line. Usually, the reserved character is a comma or a TAB character. - The file can contain a maximum of 1,000 lines. - Each line in the file must end with a paragraph mark. - Each line in the file can contain a maximum of 1,500 characters. - Each line in the file must contain the same number of fields and list the fields in the same order. - Each line in the file must contain enough geographic information to locate a unique address using one of the following combinations of fields, listed from highest to lowest accuracy: - Name, Latitude, and Longitude - Name, Street Address, City, State, and ZIP Code - Name and ZIP Code (State optional) - Name and City (State optional) - Name and State NOTE: Streets and Trip Planner cannot import ZIP+4 postal codes. The ZIP Code field must contain only 5-digit ZIP codes. - Each line in the file may also include a Name 2 field, an Altitude field, or special additional fields for specific types of pushpins. - The value in the Altitude field must be expressed in kilometers. - If you want to create Text Balloon pushpins, each line in the file may also include a Text field containing additional text to include in the pushpin. - If you want to create Web Link pushpins, each line in the file may also include a Web Link field containing the address of a Web site you want to associate with the pushpin. - If you want to create Full-Sized Attachment pushpins, each line in the file may also include a Rich Text File field, containing the path to and name of the .rtf file you want to associate with the pushpin. NOTE: Each line may also include Text and Web Link fields. NOTE: For the best results, enclose each field within standard quotation marks ("). Do not use curly quotation marks. Importing a Pushpin Set from an Address List File ------------------------------------------------- To import a pushpin set from an address list file, follow these steps: 1. Confirm that the address list file you want to import is properly formatted. For information about how to do this, refer to the "Address List File Requirements" section earlier in this article. 2. On the File menu, click Import Pushpins, and then click From Text File. 3. In the File Name box, type the path to and name of the text file you want to import, and then click Open. 4. Under Select A Pushpin Type, click the type of pushpin you want to create. 5. In the Symbol box, click the symbol you want to use for the pushpins you are importing. 6. To add the new pushpins to an existing set, click the pushpin set you want to use in the Set box, and then click Next. To create a new pushpin set, click New Set, type a name for the new pushpin set, click OK, and then click Next. 7. Under Separator, click the appropriate separator for the text file. 8. If the first line in the text file contains header information, click to select the First Row Contains Column Headings check box. 9. Click Next. 10. Under Data Preview, click to select the appropriate heading for each column, and then click Next. 11. Click Next, and then click Finish. 12. If you are prompted to resolve an ambiguous address, use one of the following methods: - Click the correct address in the list of found addresses. - Click Skip to skip the entry. - Click Automatic to have the program select the best match. Creating an Address List File ----------------------------- For the best results, use a spreadsheet or database program to create the address list file. Use one of the following combinations of geographic information, listed from highest to lowest accuracy: - Name, Latitude, Longitude - Name, Street Address, City, State, ZIP Code - Name, ZIP Code - Name, City, State - Name, State When you finish creating the address table, save it to a tab-delimited or comma-delimited text file, or copy the entire table, paste it into Notepad, and then save the text file in Notepad. If a spreadsheet or database program is not installed on your computer, follow these steps to create an address list file in Notepad: 1. Start Notepad. 2. Type the following line, and then press ENTER " NameStreet AddressCityStateZIP Code" (without the quotation marks) where is the TAB key on the keyboard. 3. Follow these steps to type the name and address for each pushpin you want to create: a. Type a name for the pushpin, and then press the TAB key. b. Type the street address, and then press the TAB key. c. Type the city, and then press the TAB key. d. Type the state, and then press the TAB key. e. Type the five digit ZIP code, and then press ENTER. 4. When you finish typing the address list, save the file, and then quit Notepad. To create an address list file using a different set of fields, follow the steps described above, substituting one of the following sets of fields: - NameLatitudeLongitude - NameZIP Code - NameCityState - NameState Using Latitude and Longitude ---------------------------- Latitude measures how far north or south of the Equator a place is located. The Equator is at 0 degrees, the North Pole is at 90 degrees North latitude, and the South Pole is at 90 degrees South latitude. Longitude measures how far east or west of the Prime (Greenwich) Meridian a place is located, from 0 degrees to 180 degrees East or West. NOTE: The Prime Meridian runs through Greenwich, England. When you import a text file as a Pushpin set, you must use decimal degrees for latitude and longitude values. Use positive numbers for North or East values, and negative numbers for South or West values. To calculate the decimal degrees for a value expressed in degrees, minutes, and seconds, use the following formula: Decimal degrees = Degrees + (Minutes/60) + (Seconds/360) NOTE: Streets and Trip Planner truncate latitude and longitude values longer than 15 decimal places. Additional query words: multi multi-media media mm auto-map amap push pins ====================================================================== Keywords : kbtool kbui kbimu Technology : kbHomeProdSearch kbExpediaSearch Version : WINDOWS: Issue type : kbhowto ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 1999.