Questions about S&T 2010 PushPins

[Paul Randall]

Hi
I create pushpins by importing CSV files to S&T 2010, formatted like this:
Flying J - Clive (W. Des Moines),11820 Hickman Road,I-80 & I-35 Exit
125,Clive,IA,50325,41.613611,-93.780833

If I import a file with this one record, S&T does not recognize some of the
columns, especially the last two items as latitude and longitude, but does
allow me to specify them with column headings by having the following as the
first line of the file:
NAME,ADD1,HIGHWAY LOCATION,CITY,STATE,ZIP CODE,LATITUDE,LONGITUDE

When done importing, I have a map with one pushpin. I can then double click
that pushpin which opens a balloon box that displays the info.

Question1: the balloon box contains two separator lines, perhaps meant to
the balloon box into three areas.
Is there any documentation about this feature? I haven't seen anything
about it in the S&T help file, but I don't have access to the MapPoint help
file. I like the idea of having separator lines, but don't know how to
create them where I want them.

I can manually edit the balloon box to insert a link to a web URL or local
computer html file that opens when I click the link in the balloon box; like
many links on web pages, the text of the link is displayed in blue. What
heading must I specify in the CSV file to have a column imported as a link,
or is it even possible? What column heading would MapPoint use?

After some experimentation, I found that I could trick S&T into displaying
my link in the balloon box, as a working blue text link: I just named that
column in my header line, using text for that header which is not used
elsewhere in the header, but is one of the standard header valuess that S&T
recognizes. The following two-line CSV set works:
NAME,add2,ADD1,HIGHWAY LOCATION,CITY,STATE,ZIP CODE,LATITUDE,LONGITUDE
Flying J - Clive (W. Des Moines),http://www.microsoft.com,11820 Hickman
Road,I-80 & I-35 Exit 125,Clive,IA,50325,41.613611,-93.780833

But in the balloon box this labels the URL "add2:"; I'd rather have it
labelled something like "URL:", or maybe have no label and display it
between the two separator lines in the balloon box.

Thanks. Any help will be appreciated.

-Paul Randall

[Dee Earley]

Post by Paul Randall
When done importing, I have a map with one pushpin. I can then double click
that pushpin which opens a balloon box that displays the info.
Question1: the balloon box contains two separator lines, perhaps meant to
the balloon box into three areas.
Is there any documentation about this feature? I haven't seen anything
about it in the S&T help file, but I don't have access to the MapPoint help
file. I like the idea of having separator lines, but don't know how to
create them where I want them.

One of them is the address (full street address) that was used to match
its location.
Sadly, I couldn't find a way to change any others than the first one.

[Chester Harris]

Paul,

If you have the lat/long coordinates then don't use the "Address"
column but instead match the Address to <Other Data>. Do the same
(use <other Data>) with anything else that doesn't fit the pre-defined
list of column headers.

Important: The info in the <other data> will not show up in the
balloon on the map by default. To display this information right-
click on the pushpin set name in the legends and overview pane and
choose properties. Go to the Balloon tab and make sure all boxes are
checked.

Hope that helps,
Chester

[Paul Randall]

Post by Chester Harris
Paul,
If you have the lat/long coordinates then don't use the "Address"
column but instead match the Address to <Other Data>. Do the same
(use <other Data>) with anything else that doesn't fit the pre-defined
list of column headers.
Important: The info in the <other data> will not show up in the
balloon on the map by default. To display this information right-
click on the pushpin set name in the legends and overview pane and
choose properties. Go to the Balloon tab and make sure all boxes are
checked.

Thanks for your input.
The poorly organized info in the help file seems to have a number of blatant
errors. I've been experimenting with violating some of the erroneous info
on pushpins.

I will try the right click & checkbox thing. It may help me get the format
I want.
Also, by using the headers I want and then within the import data wizard,
telling it the first row is header info and setting the column type to one
of the defaults in the dropdown box, I find that the balloon box puts my
header value in bold, (for example Add1:) followed by the value. I can
currently even have multiple URLs in the baloon box.

-Paul Randall

[Paul Randall]

Post by Chester Harris
Paul,
If you have the lat/long coordinates then don't use the "Address"
column but instead match the Address to <Other Data>. Do the same
(use <other Data>) with anything else that doesn't fit the pre-defined
list of column headers.
Important: The info in the <other data> will not show up in the
balloon on the map by default. To display this information right-
click on the pushpin set name in the legends and overview pane and
choose properties. Go to the Balloon tab and make sure all boxes are
checked.

Thanks for your input.
The poorly organized info in the help file seems to have a number of blatant
errors. I've been experimenting with violating some of the erroneous info
on pushpins.

I will try the right click & checkbox thing. It may help me get the format
I want.
Also, by using the headers I want and then within the import data wizard,
telling it the first row is header info and setting the column type to one
of the defaults in the dropdown box, I find that the balloon box puts my
header value in bold, (for example Add1:) followed by the value. I can
currently even have multiple URLs in the baloon box.

-Paul Randall