Home PageFacebookRSS News Feed
PocketGPS
Web
SatNav,GPS,Navigation
Pocket GPS World - SatNavs | GPS | Speed Cameras: Forums

Pocket GPS World :: View topic - Bulk editing of POI entry names
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

Bulk editing of POI entry names

 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Points Of Interest (POIs)
View previous topic :: View next topic  
Author Message
Andy_P
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jun 04, 2005
Posts: 19991
Location: West and Southwest London

PostPosted: Fri Aug 08, 2008 2:15 pm    Post subject: Bulk editing of POI entry names Reply with quote

I want to edit the names of a whole load of entries in some POI files (basically to either re-arrange the order of the words in the name or to abbreviate a certain word).

I can't think of any way to do this to the TomTom .ov2 files I'm using - POI Edit doesn't seem to have any way to do it except one by one.

So...I was going to do it by converting them to .csv, editing in Excel and then converting back.

Can anyone think of a quicker way?
Back to top
View user's profile Send private message
DennisN
Tired Old Man
Tired Old Man


Joined: Feb 27, 2006
Posts: 14901
Location: Keynsham

PostPosted: Fri Aug 08, 2008 2:18 pm    Post subject: Reply with quote

Word processor Search and Replace?
_________________
Dennis

If it tastes good - it's fattening.

Two of them are obesiting!!
Back to top
View user's profile Send private message
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Dec 08, 2004
Posts: 10643
Location: Suffolk, UK

PostPosted: Fri Aug 08, 2008 2:19 pm    Post subject: Reply with quote

Can you give an example of what you had in mind?

Before change, and final result.
_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1135
Back to top
View user's profile Send private message Visit poster's website
Darren
Frequent Visitor


Joined: 11/07/2002 14:36:40
Posts: 23848
Location: Hampshire, UK

PostPosted: Fri Aug 08, 2008 2:26 pm    Post subject: Reply with quote

CSV Search and replace would be my suggestion?
_________________
Darren Griffin
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Mullet
Frequent Visitor


Joined: Dec 12, 2005
Posts: 1051

PostPosted: Fri Aug 08, 2008 3:04 pm    Post subject: Reply with quote

Same in principle but I would prefer .xls using POIConverter.

PS, fed up of the long file names Andy?
Back to top
View user's profile Send private message
Andy_P
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jun 04, 2005
Posts: 19991
Location: West and Southwest London

PostPosted: Fri Aug 08, 2008 3:17 pm    Post subject: Reply with quote

Darren wrote:
CSV Search and replace would be my suggestion?

Yeah, that was my "plan A"...

Oldboy wrote:
Can you give an example of what you had in mind?

Before change, and final result.


Here's one example...
I recently updated my "pubs" POI, where I have merged the "Pubs", "Wetherspoon pubs" and "Dining pubs" categories.

I want to have them all in one category, and have done this successfully with other categories using a devious combination of combined and individual downloads to get the names how I want them, but it's not quite worked here...

So at the moment I'm getting (for example):
Rose and Crown, Ilford (i.e. Name,Town)
Wetherspoons, Royal Oak, Hampstead (i.e. Brand, Name, Town)
Dining Pub, Wandsworth, Kings Head (i.e. Brand, Town, Name)

(I understand how a combined category will have the "brand name" at the front but an individual download won't, but I'm not sure how I've ended up with example 2 and 3 being different here!)

What I fancy is:
Rose and Crown, Ilford
WS, Royal Oak, Hampstead
DP, Kings Head, Wandsworth
or something like that (maybe putting the abbreviations at the end instead, but the principle is the same).

.csv and Excel seems to be the way....
Back to top
View user's profile Send private message
Andy_P
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jun 04, 2005
Posts: 19991
Location: West and Southwest London

PostPosted: Fri Aug 08, 2008 3:22 pm    Post subject: Reply with quote

Mullet wrote:
Same in principle but I would prefer .xls using POIConverter.

I've not tried POIConvertor, I will now....

Mullet wrote:
PS, fed up of the long file names Andy?

If you mean the "pocketgps uk gatso 30" etc. category names, I think you know my thoughts on those, but gave up trying to get them changed long ago Very Happy
Back to top
View user's profile Send private message
Darren
Frequent Visitor


Joined: 11/07/2002 14:36:40
Posts: 23848
Location: Hampshire, UK

PostPosted: Fri Aug 08, 2008 4:21 pm    Post subject: Reply with quote

Andy_P wrote:
If you mean the "pocketgps uk gatso 30" etc. category names, I think you know my thoughts on those, but gave up trying to get them changed long ago Very Happy

Good, it ain't happening Wink
_________________
Darren Griffin
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Andy_P
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jun 04, 2005
Posts: 19991
Location: West and Southwest London

PostPosted: Fri Aug 08, 2008 4:39 pm    Post subject: Reply with quote

I couldn't resist a final feeble dig though... Twisted Evil
Back to top
View user's profile Send private message
nivek22
Lifetime Member


Joined: Mar 09, 2006
Posts: 194
Location: Barnsley, South Yorkshire.

PostPosted: Fri Aug 08, 2008 7:44 pm    Post subject: Reply with quote

You could try A.F.5 Rename your files from fauland.

I often use it to rename the camera files Wink

Oh! and it's free
Back to top
View user's profile Send private message
Mullet
Frequent Visitor


Joined: Dec 12, 2005
Posts: 1051

PostPosted: Fri Aug 08, 2008 8:33 pm    Post subject: Reply with quote

Sure that would rename the file, but the question was about the contents of a POI file.
Back to top
View user's profile Send private message
Oldie
Pocket GPS Moderator
Pocket GPS Moderator


Joined: 22/11/2002 13:33:48
Posts: 992
Location: Surrey, UK

PostPosted: Sat Aug 09, 2008 7:05 am    Post subject: Reply with quote

Andy_P wrote:
Darren wrote:
CSV Search and replace would be my suggestion?

Yeah, that was my "plan A"...

Oldboy wrote:
Can you give an example of what you had in mind?

Before change, and final result.


Here's one example...
I recently updated my "pubs" POI, where I have merged the "Pubs", "Wetherspoon pubs" and "Dining pubs" categories.

I want to have them all in one category, and have done this successfully with other categories using a devious combination of combined and individual downloads to get the names how I want them, but it's not quite worked here...

So at the moment I'm getting (for example):
Rose and Crown, Ilford (i.e. Name,Town)
Wetherspoons, Royal Oak, Hampstead (i.e. Brand, Name, Town)
Dining Pub, Wandsworth, Kings Head (i.e. Brand, Town, Name)

(I understand how a combined category will have the "brand name" at the front but an individual download won't, but I'm not sure how I've ended up with example 2 and 3 being different here!)

What I fancy is:
Rose and Crown, Ilford
WS, Royal Oak, Hampstead
DP, Kings Head, Wandsworth
or something like that (maybe putting the abbreviations at the end instead, but the principle is the same).

.csv and Excel seems to be the way....


Yes I would use either Excel to add the WS, and DP, to the front of the Name field or a good text editor like TextPad. Excel will be more straightforward as the CSV data is separated into columns.

My POIConverter program will not be much help in this instance. It can be used to merge the CSV files but you can do that in Excel anyway.
_________________
Various TomToms, Garmin eTrex Legend, GPSMAP 60CSx, Oregon 550t, Forerunner 405
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Mullet
Frequent Visitor


Joined: Dec 12, 2005
Posts: 1051

PostPosted: Sat Aug 09, 2008 11:29 am    Post subject: Reply with quote

Oldie wrote:

My POIConverter program will not be much help in this instance.

I disagree, POIConverter is the lightweight means of converting the POI file (.ov2) to a variety of different formats (.xls) and back.
IMHO the familiarity of .xls is visually the easiest to deal with, using the "Replace All" function within Excel to change the entries.

PS, didnt know it was yours, thanks for a great app Richard.
Back to top
View user's profile Send private message







Posted: Today    Post subject: Pocket GPS Advertising

Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Points Of Interest (POIs) All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Make a Donation



CamerAlert Database

Click here for the PocketGPSWorld.com Speed Camera Database

Download Speed Camera Database
22.105 (30 Oct 24)



WORLDWIDE SPEED CAMERA SPOTTERS WANTED!

Click here to submit camera positions to the PocketGPSWorld.com Speed Camera Database


12mth Subscriber memberships awarded every week for verified new camera reports!

Submit Speed Camera Locations Now


CamerAlert Apps



iOS QR Code






Android QR Code







© Terms & Privacy


GPS Shopping