Drew, would you mind providing a little more information on how to use this with Delorme's Street Atlas? I cannot figure out how to import the csv. Thanks.
Sorry for not responding sooner, but I was away from the PC that has the Delorme software on it. I don’t use Delorme as my primary mapping software (I use Streets and Trips) so I’m not familiar with all of the bells and whistles. I use it primarily to plot vacations by merging GPS data from their Blue Logger GPS, with their picture taking utility and creating a map of sites visited.
To Import a Database (from the Delorme Street Atlas 2007 help file with comments)
Use the following steps to import a database into the current Map File.
1. Click the XData tab to open the XData dialog area. Any dataset(s) included in the current Map File display(s) under Available Datasets.
Note: A check mark in a check box indicates that the dataset is being displayed on the map. Clear the check box to hide the dataset's symbols on the map.
2. Click Import to open the Import Wizard.
3. On the Select Data Source screen, click Data Source to locate and select the desired file from the Open dialog box and then click Next.
Note: If your file is not available in the directory as expected, you may need to change the file type in the Files of Type drop-down list.
4. If your data source is a .csv or .txt file, complete this step. If not, proceed to step 5.
The Select Schema screen displays. Verify how the data displays in the columns. If it is not displaying correctly, under Schema Type, select the option which separates your data into the appropriate columns. If your first row is not a header row, clear the First Row is Header check box. Click Next. The Assign Field Types screen displays
*****Follow the directions in my previous post for the schema. There is no header info in the CSV file provided.
• Select Other under Schema Type to use a non-standard file schema definition. You can then select any combination of Tab, Space, Comma, and Other. If you select Other under Delimiter, type the character(s) that separate your data in the text entry box.
• The First Row is Header check box is selected by default. The program attempts to automatically assign field names based on the data in the first row.
5. Select which column you want to display as a label on the map using the available radio buttons.
Note: You can clear a selection to have no label displayed on the map.
6. Click the Assignment header for each column and select the appropriate field option from the shortcut menu. The Status text box indicates how your data will be geoplaced on the map.
7. Select how you want to locate your field information (street address or ZIP/Postal Code).
Note: The available Locate By options are based on which fields have been assigned to the columns.
8. Click Next. The Select Data Symbol screen displays.
9. Under Match Status, click Lat/Lon, Street Name, Area, or ZIP/Postal Center and then select the unique symbol and text properties you want to display for each match status. Assigning different symbols/text to your records based on match status shows a visual representation on the map of which records in your dataset were geoplaced exactly, only by street name, only by area, or only by ZIP/Postal Center.
Under Match Status, select the Use the same symbol/text for all categories check box to identify all of your records on the map using the same symbol (without taking match status into consideration).
Note: Click Edit to use XSym to create a new symbol or edit an existing symbol. For more information, see topics listed under Custom Symbols in the Draw section of this Help file.
10. Click Next. The Data Options screen displays.
11. Type the desired name for the dataset along with any additional identifying comments. The date and time of creation are automatically recorded.
12. Click Finish. A progress bar displays with the status of matched records. When the import process is complete, the dialog box automatically closes, the dataset name displays in the Available Datasets list, and the symbol you chose displays on the map for every record which was geolocated.
Note: Datasets have .dds extensions and are saved to C:\DeLorme Docs\Datasets by default.