Is there a way to ether force Streets and Trips 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 through 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.
The data files are comma separated files that are downloaded from a third party webpage. No other formats are available.