.csv format (fields for Basecamp)

Consider the last example above.

You might want to look at some examples on the factory - like Malls at http://www.poi-factory.com/node/20962. Download it and then look at it with Notepad or Wordpad.

that didn't answer my question. the problem i have is trying to get the adresses, cities, zip codes to properly display in the proper basecamp "waypont properties" fields.

Use EPE (Extra POI Editor) to change the .csv file to a .gpx file.

See
Downloading and Installing EPE
Configuring EPE

Thats what I'm using...

I am not a user of Basecamp but I do not think that Basecamp will import .csv.

Are you not able to get EPE to accept the .csv file in order to produce a .gpx file?

i am not importing a csv file. i use EPE to convert to a gpx, but the address, city etc fields do not import even though they are in the original csv file. So back to my original question......

Basecamp doesn't support CSV files, as jgermann has already mentioned. Therefore, you'll have to convert the CSV file into a GPX file to properly import it. To do the import though requires a bit of foresight and planning on your part, because in order for it to work you'll need to split the address up into individual columns.

The reason why the address needs to be split up into individual columns is to take advantage of EPE's M-Column CSV Fields Assignment feature. By having the various parts of the address in different columns, you can use that feature of EPE to map the columns to the equivalent fields in EPE for eventual output as a GPX file. For example, lets assume you have the following POI entry.

-xx.xxxxxx, yy.yyyyyy, Name, "Street, City, State, Post Code"

The sample entry given above consists of four columns according to Garmin. What you'll need to do is in notepad or (preferably) notepad ++, strip the quotation marks out of the entry. Depending on the file, you may or may not have to add a comma following the state. Once you are done stripping the quotation marks and adding commas where they need to be added, you should end up with the following.

-xx.xxxxxx, yy.yyyyyy, Name, Street, City, State, Post Code

This sample has been expanded from four columns to seven. Unlike the original version, "Street" is in its own column, followed by "City", "State", and "Post Code". At this point, open EPE but do not import your CSV. In EPE, open up the M-Column CSV Fields Assignment option and count your columns. Columns 1, 2, and 3, should not change, as they are the longitude, latitude, and the POI name. Column 4 in the entry above is "Street", so you would click on the drop-down menu next to the "Column 4" entry in EPE and map it to the "Address" field in EPE. Repeat this for the remaining columns, with Column 5 being mapped to "City", Column 6 mapped to "State", and Column 7 mapped to "Post Code".

Once you are done mapping the parts where you want them to go, select close, and then import your CSV. If done correctly, the various parts of the address should be mapped into the correct locations in the EPE data entry field. From there, export the file as a GPX and then attempt to import the GPX file into BaseCamp. If done correctly, the address information should then appear in the appropriate locations in BaseCamp.

not being a Basecamp user, I had to learn a bit.

I did a File > New > List

I then picked a POI file in GPX format that I knew:
http://www.poi-factory.com/node/43764

I downloaded the .gpx file and then back in Basecamp, I did
File > Import into "New List"
and navigated to the .gpx file I had just downloaded.

Double-clicking on an entry in "New List" shows good data.

What happens if you do the same?

Ok, let's try this one more time. I have a .csv file that contains lat, long, name, address, city, state etc. The lat and long are in the first two columns, all the other data is in the third column separated by commas. I convert it to a .gpx file and import it into Basecamp. The lat, long and name import properly but the rest do not. If you right click on a waypoint and select open, the address, city, state etc fields are not populated.

Bungy,

I know what you are trying to do and I believe you can do this with EPE. Make sure you have the latest version. I don't have EPE on the computer I am using at the moment but I remember struggling with this issue and I seem to recall I was able to do this by selecting the columns under options.

If not, then you may need to separate the address into columns using Excel first. In Excel you can highlight the column containing the address, select Text To Column under DATA, then Delimited and Select Comma as a delimiter. When done save as a CSV file and open in EPE to convert to GPX.

Wish I could be more help.

If the POI has no name, map the street to the name field using EPE, because in BaseCamp a name is required. See if that works.

thanks, that worked! I also had to assign the columns to the respective fields.

Just checking here: you say that "lat and long are in the first two columns". POI Loader expects "long" and then "lat" but you probably just reversed the two terms because , in school, most people refer to them as "lat and long".

I should have pointed you to another good FAQ - which you still may want to review.

Using Extra POI Editor To Create And Edit CSV Files
found at
http://www.poi-factory.com/node/41653

This FAQ gives instructions on how to customize EPE for a one step import of each .csv file.

Glad you got it to work for you.