Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there a way to ether force streets and trip to always pin by address even if long/lat data is present, or to have streets and trips pin by address for rows that are missing long/lat data?

We download our routing data from a third party where there is no guarantee that all rows will have long/lat data but will always have an address. However when using the import wizard in streets and trips (versions 2011 thru 2013), if streets detects long and lat columns it will default to pinning by long/lat data and skip any rows that do not have long/lat data.

So far the only workarounds I have found for this issue are overly complicated for employees who are not computer savvy. I'm hoping there is a setting that can force streets to only use the address, or use the address in cases where long/lat data is missing. I have posted this in the Streets and Trips forum, but I noticed there seems to be very little activity there and I'm doubtful I will get any replies.

Some extra info I should have included, the data files are comma separated files that are downloaded from a third party webpage. No other formats are available.

share|improve this question
    
what workarounds are you referring to? maybe they can be scripted/macro'ed somehow? –  Lorenzo Von Matterhorn Jan 10 '13 at 16:32
    
@Znau Only two methods I've found so far are to open the data file (csv) in open office and delete the long/lat columns or change the long/lat columns in the data import wizard to not selected. Both seem like easy things to do but can be surprisingly overwhelming for some of our employees. –  gSamp Jan 10 '13 at 16:43
    
@nixda i am not the QA, i think you meant gSamp. –  Lorenzo Von Matterhorn Jan 10 '13 at 17:14
1  
@gSamp Can you provide an anonymized example of an input and the according output file (@Znau: sry :p) –  nixda Jan 10 '13 at 17:17
    
@nixda I have added an example csv file. –  gSamp Jan 10 '13 at 17:50

1 Answer 1

up vote 1 down vote accepted

It seems the answer, according to my research, is there is no way to modify the default behavior of Streets and Trips, at least for this one feature. The only way to change the way streets will route is to modify the data before importing or changing the column types in the import data dialog. If Streets knows long/lat data is present, it will route only by long/lat data, skipping any rows that do not have long/lat data. As an added bonus, Streets will not produce any warning or indication that rows were skipped or that the map is incomplete. I have confirmed this with versions 2009, 2011, and 2013.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.