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

Great! Thanks!

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

[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

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.

Will also give it a try!

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.

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 one specific example I can try, because it works for me here. I will see what is hapenning.

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.

**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.

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

Tried the Google Earth feature and it worked nice.

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.

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?

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 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 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

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

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

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

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?

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

Turboccc, that seems to work.

Thanks for a great program!!!!

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,

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.

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.

**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

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.

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?

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 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.

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

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

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

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. Will post tonight (in 4 hours)...

thanx

**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

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

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 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!

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

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"