State / Province Info for CSV Files

 

I've installed a software update that analyzes POI files and shows the US states and Canadian provinces that have locations in the file.

The tool is accurate to within about 5 miles. Some locations near state / province borders may be uncertain.

Right now, the tool only works with CSV files.

JM

tool

sounds good , where is the tool located

--
Everyday is a GREAT day :)

file pages

on every file page you will see what states are included;)

Miss POI

New File

Sounds cool cool

And when the file maintainer uploads an updated file, will the new software re-analyze the file for additions and deletions or will the upload process be changing?

--
Tampa, FL - Garmin nüvi 660 (Software Ver 4.90), 2021.20 CN NA NT maps | Magellan Meridian Gold

I noticed

I noticed in the MedExpress file there was additional info like: "may be near a border". Cool! smile

--
sewisdom - Drive carefully. The life you save... may be someone who owes you money!

Updates

Gary A wrote:

....when the file maintainer uploads an updated file, will the new software re-analyze the file for additions and deletions?

Yes. The location count and areas are automatically updated as the new file is submitted.

JM

Re: Updates

This is great!

And automation means less fat fingers.

--
Metricman DriveSmart 76 Williamsburg, VA

New Upgrade

Jon like the new upgrade. One question I was looking on my Wingers poi and it said one unsable file. Does that mean one of the lines is not working or is off?

--
johnm405 660 & MSS&T

Blank line

It was having troubles with an extra blank line at the bottom. I removed the extra line, uploaded, and it looks happy now smile

We'll have to see what other sorts of issues turn up, and then I may need to make a few adjustments to the tool.

JM

near a border

sewisdom wrote:

I noticed in the MedExpress file there was additional info like: "may be near a border" ...

This means one or more locations were too close to a border for the tool to determine the state/province with certainty.

It's not necessarily an international border. It might just be a border between states or provinces.

JM

Blank Line

Thanks Jon. I think it will be a great asset when people look at what poi's they want to download.

--
johnm405 660 & MSS&T

Checked my files

When I checked my files, I found my Batteries Plus file also showed "2 unusable lines" in it. So I opened the source file on my PC and sure enough redface I had fat-fingered an entry and didn't know it. It even loaded on my 660 with no error - double redface redface

I corrected the error, uploaded the new replacement file and your software instantly reported those errors as no longer there. Problem solved. Way cool exclaim grin

It also reported 2 locations outside the US/Canada which is true. There are 2 stores in Puerto Rico.

Nice upgrade to the website, Jon! Really, really super cool

--
Tampa, FL - Garmin nüvi 660 (Software Ver 4.90), 2021.20 CN NA NT maps | Magellan Meridian Gold

apostrophes

It looks like the tool can also have troubles handling lines that have apostrophes / single quotes (').

If the location count seems very low, it might be that the tool got stuck on a location name like Sammy's.

Single quotes are okay if double quotes are used to enclose the column data in the CSV file.

JM

Double Quotes

I have gotten in the habit of always putting the data in columns 3 & 4 in double quotes, whether or not there are any commas (or other punctuation) in the data.

--
Tampa, FL - Garmin nüvi 660 (Software Ver 4.90), 2021.20 CN NA NT maps | Magellan Meridian Gold