HomeSoftware


Who wants to help design an all-new trip planner from the ground up?
Ken in Regina
Try reading this:

https://productforums.google.com/forum/#!topic/gmail/MbHTlFI4of4

...ken...
Ken in Regina
Be sure to read the comments that follow the post in my link above.

...ken...
Ken in Regina
And here's a template for the CSV import field names if you need them:

http://beta.beantin.se/how-import-google-contacts-csv-template/

...ken...
Ken in Regina
Ooops, that last one is the format from 2011. As the author suggests, do what I suggested in my first response to see what they are today. Be sure to make your sample contact(s) contain data for every possible field you might ever want to use.

...ken...
GoneNomad
Too much trouble, I think.
S&T's >decade-old import wizard crushes google in this respect!
SpadesFlush
Quote:
Originally Posted by Ken in Regina
Just make a couple of contacts that contain the stuff you will be wanting and export a CSV from it. Seems reasonable to assume it will export the same format it wants to import.

...ken...
Ah, yes, "...reasonable..."

Actually, that works for places that have street addresses. There seems to be 103 columns (A to CA) but you only need two columns to populate a Google Contacts group: "Name", the A column, and "Address 1 -Formatted", the AU column. You can hide all the other columns.

However, I do not see any fields for lat/long which some POI CSV files use for location data.

Thanks for that, Ken.
SpadesFlush
Quote:
Originally Posted by Ken in Regina
And here's a template for the CSV import field names if you need them:

http://beta.beantin.se/how-import-google-contacts-csv-template/

...ken...
I am not sure this is current: when I exported to a CSV, I got slightly different column captions. But if you do an export now as I did, you will get a spreadsheet with the two crucial columns working.

Sorry, this may be overlapping with your advice to the same effect.
SpadesFlush
DISCOVERY: You can create a custom address type in addition to the default types of "Home" and "Work". For instance, I inserted "Business" in the "Address 1 - Type", column AT, and that imports and shows in the individual Contact entry as a prefix to the address. Unfortunately, this is little more than cosmetic. I cannot see a way of using this to filter, sort, or find the entries. Left blank, it yields "Other" which is OK, I suppose.
SpadesFlush
Quote:
Originally Posted by SpadesFlush
...

Actually, that works for places that have street addresses. There seems to be 105 columns (A to CA) but you only need two columns to populate a Google Contacts group: "Name", the A column, and "Address 1 -Formatted", the AU column. You can hide all the other columns.

However, I do not see any fields for lat/long which some POI CSV files use for location data.

...
As it turns out, Google Maps will find Google Contacts entries locations using lat/long co-ordinates if those are in the "Address 1 - Street" column AF and "Address 2- City" column AG respectively so a bit of cutting and pasting should do the trick for converted POI and/or GPX files to Google Contacts entries for route construction as discussed above. Of course, that entails using three columns.
Ken in Regina
Good catch! All sorts of hidden goodies to be found in Google's stuff.

...ken...
GoneNomad
Since a data connection is required to access either calendar.google.com or google.com/bookmarks, it seems to me that the best way to store long lists of POIs for access in either one of these is as an HTML file, either web page form or bookmark form.

A list of "Saved" places can be searched, sorted, or exported as HTML from google.com/bookmarks:


Items in the list can be renamed
("title"), labeled or have notations added:

..which also allows them to be sorted by the updated title...


...or grouped by label:


Renaming or labeling items in the list updates their "date&time"
(@ google.com/bookmarks),
which shows up when sorted by date here:




Unfortunately,
that updated date & time has no effect on the list of saved places in the
GoogleMaps app,
which is a non-sortable, and shows the newest entries first:




As previously discussed,
labels applied @
google.com/bookmarks:

...have no relationship to Your Places>"LABELED" in the
GoogleMaps app:



........
Attached Images
googlemaps.com-bookmarks-html-export-.png   googlemaps.com-bookmarks-rename-sort-date.png   googlemaps.com-bookmarks-rename-sort-label.png   googlemaps.com-bookmarks-rename-sort-title.png   googlemaps.com-bookmarks-rename-add-number-label-notes.png  

google-maps-app-labeled-places-header-home-work.png  
GoneNomad
While google calendar entries work well for some things, especially since upcoming calendar events automatically show up in the "Upcoming" list in the GoogleMaps app, there is one drawback:

The
GoogleMaps app needs a data connection to show that "Upcoming" lis, even if it was already "populated" the last time there was a data connection.

Even if
the GoogleMaps app has remained running in the foreground the entire time, when you try to view the "Upcoming" list without a data connection, here's what you get:

..and eventually, this:


------------------------

But the "LABELED" &
"SAVED" lists DO work without any data connection,
even if the GoogleMaps app is not running...




...of course, it needs a data connection to UPDATE these two lists, but the point is that what was already there is remains accessible, unlike the "UPCOMING" list.

Maybe they will fix that soon, but due to the more time-sensitive nature of the "Upcoming" list, I wouldn't count on it.



This makes the the "LABELED" & "SAVED" lists the best choice for places that you want to be able to access regardless of whether or not you have a data connection.



.......

Attached Images
google-maps-app-saved-places-r1.png   google-maps-app-labeled-places-r1.png   google-maps-app-upcoming-places-without-data-conn-2.png   google-maps-app-upcoming-places-without-data-conn-1.png  
GoneNomad
Also, it's only one step from google.com/bookmarks to get to the POI info, which has this "Add A Label" button.
( this "Label" is the one that shows up in the GoogleMaps app, unlike the "label" that can be applied directly to a place in google.com/bookmark)


It takes two steps to get from a google.com/calendar entry
the POI info, which has this button:

Of course, they can each be used for what they're best at, and of course, the calendar is better suited for arranging places in a schedule.

Too bad that list from the calendar are not available in GoogleMaps "Upcoming" without a data connection.
Attached Images
add-label.png  
GoneNomad
Since the only lists that work without a data connection are the "LABELED" list and the "SAVED" list, it seems like the "LABELED" list would be the best place to save each stop on a route, if you wanted to be able to retrieve it without a data connection. Places can be labeled without "starring" them as "SAVED" places, so one list is not dependent upon, or a subset of, the other.

On the left is the "LABELED" list @ google.com/maps.
(The stops were added in the same order shown above, in other words, it didn't have to sort them.)
On the right is the same "LABELED" @ the GoogleMaps app.



Oh well, if using the
"LABELED" list for stops on a route, there can't be too many items on it. And if the route is not part of a round trip, sorted by distance would be what you'd want.

Next I'll see how easy it is to build a multi-stop route in GoogleMaps app using places on
the "LABELED" list. The first strop is always easy, and it turns out that additional stops are not too bad: have to do a text search for specific # (e.g.: "#1") if that's how the stops were labeled. Using the word "Stop" in the label works better.
GoneNomad
A comparison of how four mapping sites and Streets & Trips 2013 handle an intentionally difficult route.

START:

1200 Main St, Imperial, MO 63052

Waypoint 1
Whitehaven Welcome Center
1845 Lone Oak Rd, Paducah, KY 42003
37.051110, -88.653367

END
204 Largo Dr, Nashville, TN 37211

Alternate END
1530 Collins Avenue, Miami Beach, FL 33139


This has been one of my test routes for quite a while.
Most of the map sites now handle the first leg (to Whitehaven Welcome Center) correctly... or almost correctly:
S&T2013 still doesn't quite get this right.

While almost any POI in Paducah, KY would be OK, the Whitehaven Welcome Center was chosen because it is as close as possible to the interstate highway that continues on to the subsequent destinations.
Even S&T now finds the Whitehaven Welcome Center as a named place. But as you can see in the screen caps below, only BING MAPS directs you to the correct exit.

If you were just following their instructions of all the others, you'd miss the exit.
True, in this case, there's another entrance after the first one, but that's not always the case.

WINNER:
bing.com/maps - It found the correct exit.



google.com/maps


wego.here.com


mydrive.tomtom.com


Streets & Trips 2013





..........
laptopgpsworld.com About