difficulty importing csv poi files into microsoft street/trips

 

I just recently purchased Microsoft street and trips and believe it is a good program , however....I can import gpx files with no issue but having some confusion and difficulty importing csv poi files......is there a protocol or "trick" to getting these to load???

AFAIK

AFAIK, you need to use the Data - Import Data Wizard to import CSV files into S&T. As you've found S&T has a specific menu item and function for importing GPX files but for other formats, including CSV, which S&T treats as a text file, you are required to go through the import data wizard facility.

I suppose you could also use Turboccc's Extra POI Editor software to easily convert the CSV file to a GPX file and then import that into S&T.

--
Nuvi 350, 760, 1695LM, 3790LMT, 2460LMT, 3597LMTHD, DriveLuxe 50LMTHD, DriveSmart 61, Garmin Backup Camera 40 and TomTom XXL540s.

several things here

rwhitrose wrote:

I just recently purchased Microsoft street and trips and believe it is a good program , however....I can import gpx files with no issue but having some confusion and difficulty importing csv poi files......is there a protocol or "trick" to getting these to load???

First of all, Just what kind of problem are you having? Just saying you have a problem doesn't help us help you.

A CSV file needs headers identifying what is in each column for S&T's Data Import Wizard. Did you add a header row to the file?

What did you state each column contained?

Once you label the columns, the wizard should have no problems.

--
Illiterate? Write for free help.

csv file

You shouldn't need to add a header to the file itself, S&T will let you ID each column at one point in the data wizard. Open the drop down data window, click data wizard, in the next window it will probably be defaulted to Excel files in the drop-down window at the bottom, change that to csv and point it to the folder that has the csv file, in the next window make sure the comma button is selected, click next, in the next window double click other data at the top of each column and pick from the list what each window is, the columns should be in the same order as in the csv file. I believe the last thing is to click finish and it will put the locations on the map. I'm doing this from memory so I hope I didn't miss any steps.

--
Anytime you have a 50-50 chance of getting something right, there's a 90% probability you'll get it wrong.