Extra POI Editor (EPE) Problems/Issues/Comments

 

Has anyone else noticed the change in the map for EPE?

Also Is anyone else getting a Script Error when trying to use the Street View (little man) and then cant leave that view unless you go to another record?

--
Bobkz - Garmin Nuvi 3597LMTHD/2455LMT/C530/C580- "Pain Is Fear Leaving The Body - Semper Fidelis"
1 2 3 4
<<Page 5

ASAP Utilities

jgermann wrote:

Many someone will jump in with a different way to do what I am about to suggest. I would use Notepad++ to compare two files.

I have already suggested saving the reordered file (distances from Alaska in the case of the Rest Areas file). Then after finding duplicates based on a distance of 0.01 KM from each other, I would do a "Check All" in the duplicates pane, then delete all the checked entries.

Once all duplicates were deleted, I would do a "Save As" of the remainder of the file.

Using Notepad++, I would compare the two file - recognizing that the "differences" would be all of the duplicates - one after the other. This would let me note those entries that I needed to delete, correct, or otherwise modify.

My Excel is 2003 so I do not have a version that may very well have a "compare" facility.

Somebody jump in with other ideas.

There is a Plug in for excel (I think it will work for all versions) It is Called ASAP Utilities
It can do a lot of things, one of them is to find Duplicates entries and highlight them for you. Another thing it can do is Remove all beginning and Trailing Spaces, and SO much more!

It is free for Personal use and can be found at:

http://www.asap-utilities.com/

--
Bobkz - Garmin Nuvi 3597LMTHD/2455LMT/C530/C580- "Pain Is Fear Leaving The Body - Semper Fidelis"

Find Duplicates

--
Frank Nuvi 3597LMT 37.322760, -79.511267

Finding Duplicates

When dealing with POI .csv files, there is a problem with "utilities" that find "duplicate values". This is because what the maintainers of POI files need to have is "Lon/Lat" combinations that are "essentially" at the same spot on earth.

As Bobkz pointed out relating to his Offbeat POI file, there may be entries that are literally only feet from one another (say, in the same building) but are not really duplicates. That is the reason I think that one should look for entries that are within 0.01 km of each other. Exact Coordinates matches will miss real duplicates that arise because the maintainer has moved the coordinates given by the "address" to, say, the entrance off the nearest major road.

Asap Utilities

As posted above ASAP Utilities can do many things. I have used it for years. Here is a method to check for duplicates and sort them together to view and do as necessary to complete your task.
http://www.asap-utilities.com/

1.Bring up your CSV file you want to check.
2.Highlight the columns you plan to sort.
3.Click on ASAP Utilities.
4.Select Range #5 and scroll down to #21. Count and/or color duplicates and click on it.
5.Next screen select yes for cell color and select the color you prefer.Then click OK.
6.Wait for program to find them it will give you a number.
7.While your columns are still highlighted click back on ASAP.
8.Select range #5 and scroll to advance sorting #2 and click on it.
9.In the sort by using the down arrow select the columns for sorting.A,B,C etc
10.In the value using down arrow.Change each one to cell color.Then click OK.
You will find the duplicates at or near the bottom of the file.

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

this excel formula will find duplicate records

jgermann wrote:

When dealing with POI .csv files, there is a problem with "utilities" that find "duplicate values". This is because what the maintainers of POI files need to have is "Lon/Lat" combinations that are "essentially" at the same spot on earth.

As Bobkz pointed out relating to his Offbeat POI file, there may be entries that are literally only feet from one another (say, in the same building) but are not really duplicates. That is the reason I think that one should look for entries that are within 0.01 km of each other. Exact Coordinates matches will miss real duplicates that arise because the maintainer has moved the coordinates given by the "address" to, say, the entrance off the nearest major road.

Paste this formula in next unused column e.g. E or F, drag down to last row, the formula will identify duplicate POI descriptions. Mind you, the POI descriptions must be exact match. After finding duplicate POI descriptions you would then review co-ordinates because they most likely don't match.

=IF(MAX(COUNTIF(C:C,C:C))>1,"Duplicate","Not Duplicate")

Also with different types of POIs..

jgermann wrote:

When dealing with POI .csv files, there is a problem with "utilities" that find "duplicate values". This is because what the maintainers of POI files need to have is "Lon/Lat" combinations that are "essentially" at the same spot on earth.

As Bobkz pointed out relating to his Offbeat POI file, there may be entries that are literally only feet from one another (say, in the same building) but are not really duplicates. That is the reason I think that one should look for entries that are within 0.01 km of each other. Exact Coordinates matches will miss real duplicates that arise because the maintainer has moved the coordinates given by the "address" to, say, the entrance off the nearest major road.

Another issue that I have with my Offbeat is when I get a email from someone letting me know of a Place that I should put in the file might already exist but the description and the Cords are off slightly. I need to manually check for these before I can update the File.

My method that I use when updating my poi file is:

The first thing I do is know what my 1st False Positive Duplication is in my Master file. I need to use that as my guild to what I do next. I do a Dup Search for .06 and take note what the 1st entry comes up with (They are 2 statues near each other - Reason I do .06 is due to the markers may not be exact to each entry and descriptions may be different. One might be the front door and the other might be in the back area.)

I create a smaller file with all my new entries in them. I do my mapping and description, etc.. Once this is done I save the file. Keeping the New small file open, I append my larger file to this file.

Now I "Append" my bigger file to this new file. I then do another Dup search for anything that is .06 away from each.

I unmark all the files then I look at all the Entries from top down until I Find My False Positive. This way I can look at only top lines and not worry about the rest. This is not a fool proof way since my markers could be farther away then .06 but it does help.

I then Manually mark all the Dups that I may find and delete them. Once this is done, I now can create ne new Master file for uploading here.

Hope this helps others out there!

--
Bobkz - Garmin Nuvi 3597LMTHD/2455LMT/C530/C580- "Pain Is Fear Leaving The Body - Semper Fidelis"

Be right back

I got distracted by other activities. I see that there is a need to help improve finding duplicates in EPE. Exporting the results seems to be a useful start. Will do something about it.

Still in distracted mode...

I may be distracted but I fixed the stupid bug when the EPE window is outside the screen and can't be seen. For once, it happened to me. The saved coordinates somehow became all negatives for no reason. I added a check to reset the values when this happened.

Not released yet but you'll see this coming with EPE v6.05. No need to do EPE -reset on command-line. Coming soon.

Turbo

EPE Cannot Find The Path To Google Earth

Oh Man. I am getting this error message again. I really wish Google would stop messing with me.

I noticed, after the fact, that GE Pro was updated {Under the covers} on 6 Feb, 2018.

The Install Location for GE is now
C:/Program Files (x86)/Google/Google Earth Pro/client
Note: additional sub-folder of "client"

I changed the key
HKEY_CURRENT_USER/Software/Google/Google Earth Plus to reflect the changed location.

The second RegKey
HKEY_LOCAL_MACHINE/SOFTWARE/Wow6432Node/Google

NO LONGER contains an entry for Google Earth, just Chrome crap.

Changing the 1st key has not fixed my problem this time around, still get same error message.

Correction: The Program Location, I just noticed is now in "Program Files", NOT "Program Files(x86)".

So, in addition to updating itself, GE also went 64bit.

Changed key accordingly, but still same error. I'm missing something obvious, I know it.

Need to use Google Earth Pro 32-bit with EPE

The 64 bit version will not work with EPE. You have to use the 32 bit version. BaseCamp has the same issue.

Download link for Google Earth Pro v7.3.1.4507 (32-bit)
https://dl.google.com/dl/earth/client/advanced/current/googl...

You don't have to uninstall the v7.3.1.4507 64-bit version first.

--
DriveAssist 50 (stolen), Nüvi 2595LMT

Thank-you WAASup

WAASup wrote:

The 64 bit version will not work with EPE. You have to use the 32 bit version. BaseCamp has the same issue.

Download link for Google Earth Pro v7.3.1.4507 (32-bit)
https://dl.google.com/dl/earth/client/advanced/current/googl...

You don't have to uninstall the v7.3.1.4507 64-bit version first.

Your answer worked like a charm - that's the second time you've bailed me out.

Thanks

Both Versions In Place

Just an observation for others after installing the 32bit flavour:

Both 32bit and 64bit are left installed, in their respective "Program Files" folder;

In Control Panel/Programs, only the latest one to be installed is reflected. Not separate entries for each. And no Start Menu shortcuts are created for either, at all.

I also noted that the desktop shortcut to 64bit was deleted and replaced with a shortcut to the 32bit.

As EPE was finding GEpro before, then I must have way-back already run into this issue and installed 32bit. (70th year, suffering Oldtimers. I can however, remember perfectly everything that happened before age 12, so there).

When an under-the-covers silent update happened beginning of February, I did not notice the update had happened, but I did notice that my GEpro shortcut had moved on my Desktop. I assumed it was "just a Windows glitch" at the time.

So, I am assuming that every time GE decides to update itself, it will switch to 64bit, and I will have to go get, and reinstall the 32bit.

Hopefully WAASup or others will be around to remind me in 6 months time when it next happens.

Thanks.

Interesting..

I'll look into it myself and see if I notice the same thing aswell.

Seems like

I've got the Google Earth not found from EPE on a fresh Win10 64bit machine with fresh GE v7.3.1.4507 (64-bit) and EPE v6.04 installs.

Seems like the best fix would be if Turbo could add a Preferences dialog box so you could browse for the googleearth.exe yourself? That or write the path into an EPE registry value so it can be manually changed there.

Like the icons and startup paths.
grin

--
It's about the Line- If a line can be drawn between the powers granted and the rights retained, it would seem to be the same thing, whether the latter be secured by declaring that they shall not be abridged, or that the former shall not be extended.

32-bit GE must be manually installed

JD4x4 wrote:

I've got the Google Earth not found from EPE on a fresh Win10 64bit machine with fresh GE v7.3.1.4507 (64-bit) and EPE v6.04 installs.

Google Earth Pro V7.3.1.4507 introduced 64-bit support, and it is the 64-bit version which is installed by default. As I mentioned above this will NOT work with EPE, which is a 32-bit program.

The 32-bit version of Google Earth Pro V7.3.1.4507 must be manually installed for it to work with EPE (and also with Garmin BaseCamp).

--
DriveAssist 50 (stolen), Nüvi 2595LMT

auto-updating 32-bit version of Google Earth Pro

oldboy wrote:

So, I am assuming that every time GE decides to update itself, it will switch to 64bit, and I will have to go get, and reinstall the 32bit.

Hopefully WAASup or others will be around to remind me in 6 months time when it next happens.

The link to the 32-bit version I previously posted will NOT auto-update.

Here is a link to an auto-updating 32-bit version:
https://dl.google.com/tag/s/appguid%3D%7B65E60E95-0DE9-43FF-...

If you want to skip needing a reminder, re-install Google Earth Pro using this new link smile

--
DriveAssist 50 (stolen), Nüvi 2595LMT

Thanks

WAASup wrote:

Google Earth Pro V7.3.1.4507 introduced 64-bit support, and it is the 64-bit version which is installed by default. As I mentioned above this will NOT work with EPE, which is a 32-bit program.

The 32-bit version of Google Earth Pro V7.3.1.4507 must be manually installed for it to work with EPE (and also with Garmin BaseCamp).

Thanks, but I read that and I'm on the fence if I want 2 copies of GE on my computer, one 32 bit copy, or leave everything as-is and simply generate the kml or kmz files from BaseCamp and EPE to manually load into GE.

Can't imagine why a 32 bit program couldn't issue an execute command with a filename to a 64 bit program, but I'm not going to sweat it. Just thought I'd make a suggestion for Turbo if he's so inclined.

--
It's about the Line- If a line can be drawn between the powers granted and the rights retained, it would seem to be the same thing, whether the latter be secured by declaring that they shall not be abridged, or that the former shall not be extended.

Only one GE version after 32-bit install

JD4x4 wrote:

Thanks, but I read that and I'm on the fence if I want 2 copies of GE on my computer, one 32 bit copy, or leave everything as-is and simply generate the kml or kmz files from BaseCamp and EPE to manually load into GE.

When I installed GE 32-bit it removed the 64-bit version and updated the Start Menu and desktop shortcuts. It seems oldboy had different results...

--
DriveAssist 50 (stolen), Nüvi 2595LMT

WikiSpaces Closing

When I went to TurboCCC download area I gopt a message WikiSpaces is closing. I would hate to lose EPE because Wiki closes.

WikiSpaces Closing

It looks like we will have it for a few more months. I seem to recall that TurboCCC had these files somewhere else long ago and it too went away and he found this place to host his files. Hopefully he will locate another place in the near future. We can also support TurboCCC by donating now and then.

--
"There's no substitute for local knowledge" nüvi 750, nüvi 3597

error returned

Recently, any time I put in an address and hit the geocoding button I get "The requested search did not return any relevant result. I am running EPE 6.04 on a Win 7 system. Any ideas what I am doing wrong or how to get around this problem?

Administrator

Panache wrote:

Recently, any time I put in an address and hit the geocoding button I get "The requested search did not return any relevant result. I am running EPE 6.04 on a Win 7 system. Any ideas what I am doing wrong or how to get around this problem?

Turbo could not figure out why - but when I run EPE as Administrator, my geocoding works - versus the same message you are getting.

Be interested to know whether running as administrator works for you.

John

spotty

I tried it in Admin mode. once it worked then it wouldn't. I tried then putting the complete address in the address block and it worked (once). got out and started non admin. put all in address got error. Tried putting in street, city and state blocks. Worked once. I am not seeing the pattern of the problem. Appears to be random working, most error.

More "no relevant results"

Panache wrote:

Recently, any time I put in an address and hit the geocoding button I get "The requested search did not return any relevant result. I am running EPE 6.04 on a Win 7 system. Any ideas what I am doing wrong or how to get around this problem?

Had the same thing about a week ago, for each one of about 6 addresses.
I assumed at the time it was simply incomplete full addresses, or confusion with Canadian address details.
I used GPSVisualizer site and all worked OK.
Kinda forgot about it after, but as it is not just me, maybe I will try some variations to try and find a pattern.

No Relevant Results - Cont'd

Based on a test of ONE:

I still get this for a Canadian address.

If I slip "Canada" into the street address, then it works OK.

But, previously, just a street address, with a 2-char Province used to be fine.

Me too

I'm seeing this more frequently lately. I really think it is something Google is doing with how in interprets the address. I've noted that if I plug the same addy into GE, it also complains. If I massage the address a bit, it sometimes finds it. I need to pay more attention for those that EPE can't resolve, does GE or Google Maps fail also with the same address consistently?

--
"There's no substitute for local knowledge" nüvi 750, nüvi 3597

What's Weird Is...

If I use the GPS Visualizer site: http://www.gpsvisualizer.com/geocode

and put in the same Canadian address, without 'Canada' in it, and ask for 'Google Map' it works just fine.

Does this mean it's using a different Google API?

Me Too Part 2

I've paid more attention the past couple of days. If I paste an address into EPE, it often fails to geocode to a location, but if I then paste the same address into Google Maps, Google displays the correct location. I can then copy the coordinates from Google and paste them into EPE so that I can complete that POI. It does seem that another Google update has interfered with how EPE can interface with it. Turbo must feel like he's playing Whack-a-Mole with this.

--
"There's no substitute for local knowledge" nüvi 750, nüvi 3597

A possible issue with the Google Maps again

I just tried to use EPE and there may be a issue with the map screen again.

In the Google map part of the screen it says "This page can't load Google Maps Correctly. Then when you click OK, The Screen goes darker and across the screen it says "For Development purposes only"

Anyone else having this issue?

--
Bobkz - Garmin Nuvi 3597LMTHD/2455LMT/C530/C580- "Pain Is Fear Leaving The Body - Semper Fidelis"

Google Maps now Pay As You Go

bobkz wrote:

In the Google map part of the screen it says "This page can't load Google Maps Correctly. Then when you click OK, The Screen goes darker and across the screen it says "For Development purposes only"

So, the good news is that everything still works (for now), in spite of the error message.

The bad news is that it appears Turbo would need to change some EPE
code to use a new Google API key. The key would provide free $200 monthly usage, and requires a credit card.

Some relevant Google Maps info:

https://cloud.google.com/maps-platform/pricing/
On July 16, 2018, a new pay-as-you-go pricing plan went into effect for Maps, Routes, and Places

https://developers.google.com/maps/documentation/javascript/...
A darkened map, or ‘negative’ Street View image, watermarked with “for development purposes only” is returned when any of the following is true:

The request is missing an API key.
Billing has not been enabled on your account.
The provided billing method is invalid (for example an expired credit card).
A self-imposed daily limit has been exceeded.

If you are the website owner, you can fix this by getting an API key and enabling billing on your account, or by increasing your daily limit. For help on finding error messages, see the section on checking errors in your browser.

--
DriveAssist 50 (stolen), Nüvi 2595LMT

Google can't leave things alone

bobkz wrote:

I just tried to use EPE and there may be a issue with the map screen again.

In the Google map part of the screen it says "This page can't load Google Maps Correctly. Then when you click OK, The Screen goes darker and across the screen it says "For Development purposes only"

Anyone else having this issue?

Ah nutz, Google is messing around again. You have to look quick before the map screen goes dark.

--
"There's no substitute for local knowledge" nüvi 750, nüvi 3597

Oh well

Well, it was a handy tool, but I can see where it would take a lot of time, and money, to keep developing this application.

I'll manage without the map feature and use it as is for awhile, but when that fails, I'll delete the program.

--
I never get lost, but I do explore new territory every now and then.

Here We Go Again

Paging TurboCCC?

Is it just me or did Google finally break it for good?

I no longer see any map, just a white window when I open any csv or gpx file in EPE. Did Google finally break the map link completely?

--
"There's no substitute for local knowledge" nüvi 750, nüvi 3597

Still the grey map for me...

TXRVer wrote:

I no longer see any map, just a white window when I open any csv or gpx file in EPE. Did Google finally break the map link completely?

I see a normal map briefly, less than a second, then the Google message and a greyed-out map.

It is still usable if doing only one or two POIs, but it is hard on the eyes. Minor corrections are about all I can tolerate (70yr-old eyes!).

I would really like to have a solution for this, as I find EPE indispensable when creating a new file list.

Could some form of subscription plan help us here. I've gone to the applicable Google site for info, but have no idea what dollar costs are in reality, either to EPE itself, or individual users.

Developer Burden

Pretty much, the developer of the software has to license the Google data from Google. He has to decide how many licenses he wishes to purchase. Then the developer has to turn around and sell you a license to access that data on an individual basis.

I don't think Turbocc is well enough or inclined to start being a clearing house for license fees. After all, the software was written to help out POI members. Maintaining any more than what he has in the past is too much of a financial burden, and would create the need for extensive software rewrites.

It's possible for you use Google Maps or Google Earth on your own and use the data back to EPE, but you will be on your own.

--
Frank Nuvi 3597LMT 37.322760, -79.511267

When and if TurboCCC is well

When and if TurboCCC is well enough to do so, he should consider looking into alternatives. For example, Here offers 250,000 API calls, I don't recall if per month or per day, for free. I'm sure they don't have a satellite option, but I'm also sure there's a way to feed the coordinates to Google Earth without requiring a Google API if needed.

--
"Anyone who is capable of getting themselves made President should on no account be allowed to do the job." --Douglas Adams

Totally agree

phranc wrote:

Pretty much, the developer of the software has to license the Google data from Google. He has to decide how many licenses he wishes to purchase. Then the developer has to turn around and sell you a license to access that data on an individual basis.

I don't think Turbocc is well enough or inclined to start being a clearing house for license fees. After all, the software was written to help out POI members. Maintaining any more than what he has in the past is too much of a financial burden, and would create the need for extensive software rewrites.

It's possible for you use Google Maps or Google Earth on your own and use the data back to EPE, but you will be on your own.

I totally agree with phranc.

This would be huge burden for turbocc. I simply go to Google Earth and find the location, drag the marker to the right spot and transfer to EPE.

Not nearly as convenient as before, but it is what it is.

Turbocc is a great friend to POI Factory. I simply wish him the best and get well soon.

--
NUVI2555LMT, NUVI350

Sorry to hear about Turbo

Was just checking to see what the word was about the EPE map display and I see Turbo isn't well? Very, very sorry to hear that. He put in a huge amount of effort for the gps community and never charged a dime for any of it. Anyone here know more details, or if we can help somehow? You're in my prayers, Turbo.

--
It's about the Line- If a line can be drawn between the powers granted and the rights retained, it would seem to be the same thing, whether the latter be secured by declaring that they shall not be abridged, or that the former shall not be extended.
1 2 3 4
<<Page 5