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.