Extra_POI_Editor - A tool to View/Edit/Convert POI/TourGuides (Part 1)

 

Well, I guess it's time I start an official thread about Extra_POI_Editor at POI Factory.

It does too many things for me to explain in a short post, so let's say it will allow you to view, edit and convert (new!) any GPX/CSV/OV2/JPG/KML/MGLN POI file to GPX/CSV/OV2/KML. Yes! Geocoded JPG can be imported too!

* There are preview windows specially designed to simulate a 4.3" widescreen GPS like a nuvi 760, but the program will work for other GPS; the display in the program will not match exactly the non-widescreen GPS.

* The tool will allow you to see the POIs on a map. You can drag also the marker on the map and update the new coordinate. This is very cool to fine tune the POI location.

* You can also preview linked images and sound files used in TourGuides.

* EPE can do batch geocoding and reverse geocoding. It has special filters to extract State, Postcode, Phone and more. You can create custom column formats for your CSV files input and output, ...

* You can open POI Loader, MapSource or GoogleEarth directly from EPE to see all POIs on the map.

This is it for now. It does more than that and will probably do more later. Please post your comments and suggestions here.

Turbo.

Oh yeah! For those who do not know, the download link is here:

http://turboccc.wikispaces.com/Extra_POI_Editor

If you find something missing, just post your requests. I will see what I can do.

4 5 6 7 ... 10 20 23
<<Page 3>>

v2.91 added Magellan .MGLN as file input

turboccc wrote:

v2.91
- Added Magellan .MGLN as file input....

Great! Thanks!

Error

I'm getting a Run time Error 91 in v2.93.
I click Add New POI and enter City then State then Geocoding.
If I enter in only the State it gives the same error, if I enter a City only it asks for more ino, so it's the State field that seems to be the culprit. Also on a side note the State field's tab order is not correct it goes Address, City, Post Code, Phone then State.

thanks
Paul

deppeler...

[quote=deppeler
I loaded this file and found a character (cr?) at the end of each line (except the last) in column 4, I removed these and it loaded fine. Of course the whole address (& description etc) was in the address field.

Paul

Paul,
How did you open the file to see these characters?
I create everything in Notepad so that may be the issue.

Thanks,
Chuck

--
Nuvi 2595 & 760 | http://www.chucksphotospot.com

I used...

cpjanda wrote:

[quote=deppeler
I loaded this file and found a character (cr?) at the end of each line (except the last) in column 4, I removed these and it loaded fine. Of course the whole address (& description etc) was in the address field.

Paul

Quote:

Paul,
How did you open the file to see these characters?
I create everything in Notepad so that may be the issue.

Thanks,
Chuck

I opened it up in Excel.

Mix-up between Zip code and phone number

Tried 2.93 today. For many (but not all) POI, the detection of the phone number is mixed-up and the program picks up the zip code instead. It seems to be for the POI that include a ZIP+4 zip code.

Not all 7 digit numbers are phone numbers. You may have to analyze the format of the number before you select it as a phone number: xxxxx-xxxx should be interpreted as a zip code.

Thanks

Will also give it a try!

Extra_POI Editor

I downloaded Extra POI Editor and played with it. I also bought GeePex.

There are some points worth noting. Extra POI is a free editor and does have some good capabilities. It's obvious from the list of bug fixes that it's a work in progress. It is geared to the wider 4.3 screen, but the descriptions and the displays will work for the smaller units.

GeePex is about $19-22, but I find that this is not an excessive price for a very well written program. I recently created some fairly significant POIs and used GeePex.
-Map is five times bigger, and also will shift between map view and satellite. However, if you're trying to get precision, the larger map, makes it very easy to pull the indicator directly to the point.
-Preview: Automatically scales itself to the actual size of screen for whatever Garmin is selected.
-Google Earth: Simply pressing F9 will automatically open Google earth and load all the points into Google Earth. Very nice feature if you're wanting to see where the POI is relation to other areas.

--
NUVI2555LMT, NUVI350

deppler

Do not remove the <CRLF> in your csv file. I will add this functionality to my program. It should not be a big dear. I alreay handle the <CR> alone. I will see hat is causing the issue.

Please, give me an example...

deppeler wrote:

I'm getting a Run time Error 91 in v2.93.
I click Add New POI and enter City then State then Geocoding.
If I enter in only the State it gives the same error, if I enter a City only it asks for more ino, so it's the State field that seems to be the culprit. Also on a side note the State field's tab order is not correct it goes Address, City, Post Code, Phone then State.

thanks
Paul

Please, give me one specific example I can try, because it works for me here. I will see what is hapenning.

Oups! Unknown case...

jale wrote:

Tried 2.93 today. For many (but not all) POI, the detection of the phone number is mixed-up and the program picks up the zip code instead. It seems to be for the POI that include a ZIP+4 zip code.

Not all 7 digit numbers are phone numbers. You may have to analyze the format of the number before you select it as a phone number: xxxxx-xxxx should be interpreted as a zip code.

Ouch! I did not know that... That makes thing a bit complex, but since it is very specific, I can probably fix this in a few minutes.

v2.94...

**Changes from v2.93 to v2.94**
* Improved phone detection against xxxxx-xxxx zipcode and others.
* Improved CSV file parsing containing CRLF in fields.
* Added ability to load all loaded POI in GoogleEarth in Tools menu.

Very cool!

I really like it! I'll provide more feedback once I get a chance to play more with it.

For now, I couldn't get the "Open with Google Earth" to work, maybe I am missing something.

Thanks

--
GARMIN nuvi 760 sites.google.com/site/lschwabe/

Tried the Google Earth

Tried the Google Earth feature and it worked nice.

--
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. Android Here WeGo - Offline Maps & GPS.

Now...

turboccc wrote:
deppeler wrote:

I'm getting a Run time Error 91 in v2.93.
I click Add New POI and enter City then State then Geocoding.
If I enter in only the State it gives the same error, if I enter a City only it asks for more ino, so it's the State field that seems to be the culprit. Also on a side note the State field's tab order is not correct it goes Address, City, Post Code, Phone then State.

thanks
Paul

Please, give me one specific example I can try, because it works for me here. I will see what is hapenning.

Well it's not happening now...wierd but I have a new issue, whenever I Add a New POI and put any Street and city in Oklahoma and Country (USA) it gives me the wrong town and it doesn't matter what city I put in.
In other words it is taking me to a totally different town.

v2.94 Run time error 91

Hi,

v2.94 - Reproducible crash - Run time error 91

Loaded the Redlight-Beta.csv file, double clicked to edit an entry, clicked on the "Geocoding" button, crashed with the message:

Run time error 91

'Object variable or With block variable not set'

Also crashed with the .csv file converted to .gpx.

It's probably because there's no "Contact Info" in the boxes leading to the "Geocode" button and so may be acting as designed, but it does crash the program, might be better to capture the error with a message of "No relevant data" or something?

Wrong geocoding location

deppeler wrote:

Well it's not happening now...wierd but I have a new issue, whenever I Add a New POI and put any Street and city in Oklahoma and Country (USA) it gives me the wrong town and it doesn't matter what city I put in.
In other words it is taking me to a totally different town.

Go at this link and try your adddress and tell me if it points at the right place.

http://code.google.com/apis/maps/documentation/examples/geoc...

I have also tried a couple addresses and I got one not at the expected location although my address information was correct. Let me know.

Run time error 91

gpsaccount wrote:

Hi,

v2.94 - Reproducible crash - Run time error 91

Loaded the Redlight-Beta.csv file, double clicked to edit an entry, clicked on the "Geocoding" button, crashed with the message:

Run time error 91

'Object variable or With block variable not set'

Also crashed with the .csv file converted to .gpx.

It's probably because there's no "Contact Info" in the boxes leading to the "Geocode" button and so may be acting as designed, but it does crash the program, might be better to capture the error with a message of "No relevant data" or something?

I will handle the empty contact information to avoid the crash.

I am not sure about your csv to gpx crash. I am doing this massively without problems. Can you give me the link to the csv file? I will have a look. There is something in the fields that may cause the problem.

That works...

turboccc wrote:
deppeler wrote:

Well it's not happening now...wierd but I have a new issue, whenever I Add a New POI and put any Street and city in Oklahoma and Country (USA) it gives me the wrong town and it doesn't matter what city I put in.
In other words it is taking me to a totally different town.

Go at this link and try your adddress and tell me if it points at the right place.

http://code.google.com/apis/maps/documentation/examples/geoc...

I have also tried a couple addresses and I got one not at the expected location although my address information was correct. Let me know.

I got the correct location that way.
Also I don't know if this helps but it keeps returning this location:
(Lon, Lat) = -97.092877, 35.007752

thanks

Calling Google Earth

There are 2 Google Earth product. I support currently only Google Earth Pro.

I will add both Google Earth and Google Earth Pro tonight.

Bad Geocoding - need one example

deppeler,

Can you give me one example of address not giving you the right location in my program? Thanks.

Here you go...

turboccc wrote:

deppeler,

Can you give me one example of address not giving you the right location in my program? Thanks.

City: Enid
State: Oklahoma
gives me (Lon, Lat) = -97.092877, 35.007752

Should give (close to::
(Lon, Lat) = -97.872219, 36.405534

RedLight-Beta CSV to GPX crash

turboccc wrote:
gpsaccount wrote:

Hi,

v2.94 - Reproducible crash - Run time error 91

Loaded the Redlight-Beta.csv file, double clicked to edit an entry, clicked on the "Geocoding" button, crashed with the message:

Run time error 91

'Object variable or With block variable not set'

Also crashed with the .csv file converted to .gpx.

It's probably because there's no "Contact Info" in the boxes leading to the "Geocode" button and so may be acting as designed, but it does crash the program, might be better to capture the error with a message of "No relevant data" or something?

I will handle the empty contact information to avoid the crash.

I am not sure about your csv to gpx crash. I am doing this massively without problems. Can you give me the link to the csv file? I will have a look. There is something in the fields that may cause the problem.

I found the file. It works for me.

Did you set the fields in the Option->CSV Field menu? I tried to change the assignation, but could not reproduce your error. Can you give me the steps you used to create the problem?

Bad geocoding - Oh man! A bug!

deppeler wrote:

City: Enid
State: Oklahoma
gives me (Lon, Lat) = -97.092877, 35.007752

Should give (close to::
(Lon, Lat) = -97.872219, 36.405534

Thanks. It seems I forgot to include the City field in the string... Ooops! I corrected it and it works fine. I will release it with the other requests tonight.

Thank you for your help.

Great

turboccc wrote:
deppeler wrote:

City: Enid
State: Oklahoma
gives me (Lon, Lat) = -97.092877, 35.007752

Should give (close to::
(Lon, Lat) = -97.872219, 36.405534

Thanks. It seems I forgot to include the City field in the string... Ooops! I corrected it and it works fine. I will release it with the other requests tonight.

Thank you for your help.

No worries, glad to help smile

GREAT!!!!!

turboccc wrote:

Do not remove the <CRLF> in your csv file. I will add this functionality to my program. It should not be a big dear. I alreay handle the <CR> alone. I will see hat is causing the issue.

Turboccc, that seems to work.

Thanks for a great program!!!!

--
Nuvi 2595 & 760 | http://www.chucksphotospot.com

2.94 Much better

turboccc wrote:

**Changes from v2.93 to v2.94**
* Improved phone detection against xxxxx-xxxx zipcode and others.
...

The phone detection in 2.94 is much better. It still gets confused sometimes. For example, the Texas Roadhouse POI http://www.poi-factory.com/node/2248 second line doesn't have a punctuation between the zip code and the phone number and the Extra_POI_Editor 2.94 grabs everything as a phone number. The format is "...Montgomery, AL 36117 (334) 395-4475;...." so I guess the fault is in the file, not the program. This is a good file for this kind of tests as it contains a lot of information with different formats.

TurboCCC you're doing a fantastic job - Thank you!!!

Jale - Phone Number extraction

Jale,

I can do better than this. I did the 'lazy' approach. I will now include some robustness. The cases that failed are not so hard to handle.

Run time error 91

turboccc wrote:
gpsaccount wrote:

Hi,

v2.94 - Reproducible crash - Run time error 91

Loaded the Redlight-Beta.csv file, double clicked to edit an entry, clicked on the "Geocoding" button, crashed with the message:

Run time error 91

'Object variable or With block variable not set'

Also crashed with the .csv file converted to .gpx.

I am not sure about your csv to gpx crash. I am doing this massively without problems. Can you give me the link to the csv file? I will have a look. There is something in the fields that may cause the problem.

Hi,

Misunderstanding, sorry I probably wasn't clear enough. What I meant was that I converted the .csv file to a .gpx file (which worked fine) and retested the crash condition in the .gpx file with the same result. I didn't mean that I had a problem converting to .gpx, just that the crash happened in both types of files. I had no problem converting a .csv to .gpx.

v2.95 = Phone + Geocoding + Google Earth

**Changes from v2.94 to v2.95**
* Improved phone detection - more to come
* Corrected the missing City name in Geocoding leading to wrong coordinates
* Opens now Google Earth or Google Earth Plus

I am still struggling with the Run time error 91 'Object variable or With block variable not set' which does not seem to happen to everybody. I am currently testing a debug code with someone getting the issue.

thanks for the info

thanks for the info

thanks

turboccc wrote:

**Changes from v2.94 to v2.95**
* Improved phone detection - more to come
* Corrected the missing City name in Geocoding leading to wrong coordinates
* Opens now Google Earth or Google Earth Plus

I am still struggling with the Run time error 91 'Object variable or With block variable not set' which does not seem to happen to everybody. I am currently testing a debug code with someone getting the issue.

thanks smile

Run time error 91 is gone!

Changes from v2.95 to v2.96

Corrected the Run time error '91: Object Variable or With block variable not set" when Geocoding. It was intermittent, but now it should work for all.

Run time error 91

Hmmm,

Still crashes for me.
- POI Editor v2.96 - size 835,584 090311 22:41
- Redlight-Beta.csv - size 251,114 090304 11:12

- Opened the .csv file in the editor
- Double clicked on the first entry in the top left window - RLC Hwy99 & 196th, WA Lynnwood
- In the edit window immediately clicked the "Geocoding" button
- Crashed - Run time error 91

Am I hexed? wink

Well maybe not...

turboccc wrote:

Changes from v2.95 to v2.96

Corrected the Run time error '91: Object Variable or With block variable not set" when Geocoding. It was intermittent, but now it should work for all.

This is wierd I have both the same versions at home and work (2.96).
I open Extra_POI (blank), click Add POI, put in a City and State and click Geocoding.
At home it's fine.
At work I still get a Runtime 91 error.
I also tried loading a POI and then clicking geocoding but I got the same error.
Both computers are XP sp2.

If no-one else is getting this error then it must be my system.

Thank You...

turboccc wrote:

Well, I guess it's time I start an official thread about Extra_POI_Editor at POI Factory.

http://turboccc.wikispaces.com/Extra_POI_Editor

Thank You for being such a wonderful POI community member.

I know I am late in thanking you, but it took me some time before i could finish reading all your messages and replies to questions and suggestions.

Still enjoying TTS Editor and now this one... I am sure everyone appreciates your GREAT contributions to the community as I do. Also, a quick thanks to all who contributed in improvements. Thanks a lot.

Hmm..

I am getting the runtime 91 error as well in Windows 7.

Could be work computer network

If it works at home it could be work computer network. My work computer running XP does some weird things like this.

.

turboccc wrote:

**Changes from v2.94 to v2.95**
* Improved phone detection - more to come
* Corrected the missing City name in Geocoding leading to wrong coordinates
* Opens now Google Earth or Google Earth Plus

Hi TurboCCC,
You probably accounted for these phone number formats already, just my 2 cents.

(xxx) xxx xxxx
(xxx)-xxx-xxxx
(xxx).xxx.xxxx
xxx xxx xxxx
xxx-xxx-xxxx
xxx.xxx.xxxx

Runtime Error 91

This is not caused by a computer configuration. It has something to do with the web browser object I am using. When the object is busy (like loading an html page) it causes this error. I need to slow things down and make sure the object is ready. The .busy object I am using is reported not to be valid on all system It seems MS knows about this. I will find a parade...

Sorry for the inconvenience.

Edit: cool! I am getting the error at the office too. This will makes things much easier to resolve.

I 'm not going nuts...

turboccc wrote:

This is not caused by a computer configuration. It has something to do with the web browser object I am using. When the object is busy (like loading an html page) it causes this error. I need to slow things down and make sure the object is ready. The .busy object I am using is reported not to be valid on all system It seems MS knows about this. I will find a parade...

Sorry for the inconvenience.

Edit: cool! I am getting the error at the office too. This will makes things much easier to resolve.

Glad (not really) that you are getting the error too....

Found a fix to the geocoding error issue

Found a fix. Will post tonight (in 4 hours)...

:)

turboccc wrote:

Found a fix. Will post tonight (in 4 hours)...

thanx

Finally!

**Changes from v2.96 to v2.97**

* Corrected the Run time error '91: Object Variable or With block variable not set" when Geocoding.Now it should work for all.
* Fixed small issue when navigating with the arrows.

:)

turboccc wrote:

**Changes from v2.96 to v2.97**

* Corrected the Run time error '91: Object Variable or With block variable not set" when Geocoding.Now it should work for all.
* Fixed small issue when navigating with the arrows.

thanx

v2.97

deppeler wrote:
turboccc wrote:

**Changes from v2.96 to v2.97**

* Corrected the Run time error '91: Object Variable or With block variable not set" when Geocoding.Now it should work for all.
* Fixed small issue when navigating with the arrows.

thanx

Ditto! Now gives me a soothing baby blue (ice blue?) screen with the co-ordinates of the North Pole 0.000, 0.000 wink

Edit: Actually, on zooming out the map it appears to be on the equator off West Africa, silly me. Guess that's why I could use a GPS wink

C'mon guys... Give me a break...

LOL! Most of the time, it is because it could not find any location.

Does it do that all the time?

Actually I think it is

Actually I think it is working as designed. The data I fed it was blank, so it gave me the equivalent location (0.000, 0.000), seems logical to me.

I was the one who translated that to the North Pole, the editor put me in the right place (on the Greenwich Meridian at the Equator). I think you've licked this one! wink

One great program

One great program turboccc.You sure don't waste anytime putting the changes out.

--
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. Android Here WeGo - Offline Maps & GPS.

v2.97 problem

This version seems to have an issue when opening a csv file with the following data:

-79.37938, 43.84521,"Host Fine Indian,"(905)709-7070"
-79.37760, 43.84716,"Taj Mahal Restaurant","115 York Blvd
Richmond Hill, ON
905-709-6260"
-79.37752, 43.84922,"The Jaipur Indian Cuisine","165 E Beaver Creek Rd,
Richmond Hill, ON
905-709-3773"

I think it has something to do with phone number being by itself in the 4th parameter.

--
GARMIN nuvi 760 sites.google.com/site/lschwabe/

Maybe

LSchwabe wrote:

This version seems to have an issue when opening a csv file with the following data:

-79.37938, 43.84521,"Host Fine Indian,"(905)709-7070"
-79.37760, 43.84716,"Taj Mahal Restaurant","115 York Blvd
Richmond Hill, ON
905-709-6260"
-79.37752, 43.84922,"The Jaipur Indian Cuisine","165 E Beaver Creek Rd,
Richmond Hill, ON
905-709-3773"

I think it has something to do with phone number being by itself in the 4th parameter.

Is this just a typo in the post or is there a " missing after Indian before the comma.
-79.37938, 43.84521,"Host Fine Indian,"(905)709-7070"

4 5 6 7 ... 10 20 23
<<Page 3>>