Home Forums Articles How To's FAQ Register
Go Back   Xoutpost.com > Electronics > Navigation System
Arnott
User Name
Password
Member List Premier Membership Search Today's Posts Mark Forums Read

Xoutpost server transfer and maintenance is occurring....
Xoutpost is currently undergoing a planned server migration.... stay tuned for new developments.... sincerely, the management


Reply
 
LinkBack Thread Tools Display Modes
  #11  
Old 02-26-2010, 05:42 PM
vince59it's Avatar
Member
 
Join Date: Mar 2009
Location: italy
Posts: 217
vince59it is on a distinguished road
Quote:
Originally Posted by KiwiJochen View Post
Of course you can copy/paste a column
PS: There are plenty of "How to use Excel" instructions on the Internet
...my dear friend......fact is that if I open the asc or csv file with excel I get single rows that include all data...when I need data to be separated in single cells. Do I make myself clear?
I mean I have the whole POI's string (long, lat,name and so on) in one single cell..while I would like to have them in separate cells, that makes separate colums....

I have to post a pic...
__________________
I could show my BMW but I prefer to show my wife boobs...but, sorry, only by pic.
Reply With Quote

Sponsored Links

  #12  
Old 02-26-2010, 05:48 PM
Member
 
Join Date: Dec 2006
Location: Switzerland
Posts: 2,575
KiwiJochen is on a distinguished road
Quote:
Originally Posted by vince59it View Post
...my dear friend......fact is that if I open the asc or csv file with excel I get single rows that include all data...when I need data to be separated in single cells. Do I make myself clear?
I mean I have the whole POI's string (long, lat,name and so on) in one single cell..while I would like to have them in separate cells, that makes separate colums....

I have to post a pic...
Excel Lesson #105:
You need to set the separator character in the ASC / CSV file to the same as what your PC is using (refer to your regional settings)
Reply With Quote
  #13  
Old 02-26-2010, 10:28 PM
Member
 
Join Date: Jun 2009
Location: DFW
Posts: 31
fnc1 is on a distinguished road
Very Nice Work Jochen...

Hopefully people will make avail some of their created/modified files

Maybe someone will make a POIson-like patch.exe appliction, next... that we can use for enabling our own customized sounds, instead of ONLY patching for Military_POIs as sound alerts (since the author wont release the source code to the original, i guess a Diff before and after might help... hmmm so much to do..)
Reply With Quote
  #14  
Old 02-27-2010, 03:16 AM
Member
 
Join Date: Dec 2006
Location: Switzerland
Posts: 2,575
KiwiJochen is on a distinguished road
Quote:
Originally Posted by fnc1 View Post
Maybe someone will make a POIson-like patch.exe appliction, next... that we can use for enabling our own customized sounds, instead of ONLY patching for Military_POIs as sound alerts (since the author wont release the source code to the original, i guess a Diff before and after might help... hmmm so much to do..)
Anybody can change any sounds they want using PoiSon, so I don't understand what you are wanted re customised sounds.

And there is only ONE unused POI category that can be hacked, and that is Military Bases.
Reply With Quote
  #15  
Old 02-27-2010, 11:46 AM
Member
 
Join Date: Jun 2009
Location: DFW
Posts: 31
fnc1 is on a distinguished road
Right.. there is only one, because the Military Bases is the only ONE that the PATCH changes... The same logic can be applied to other POI's or even new categories..
Reply With Quote
  #16  
Old 02-27-2010, 01:13 PM
Member
 
Join Date: Dec 2006
Location: Switzerland
Posts: 2,575
KiwiJochen is on a distinguished road
Go for it then, patch navboot for multiple POIs and tell us how well it works
Reply With Quote
  #17  
Old 02-28-2010, 05:14 PM
vince59it's Avatar
Member
 
Join Date: Mar 2009
Location: italy
Posts: 217
vince59it is on a distinguished road
see what the problem is?

I tried sevaral ways. Succedeed in dividing data form one column in three separate columns, but now I have the problem with the lat and long digits


__________________
I could show my BMW but I prefer to show my wife boobs...but, sorry, only by pic.
Reply With Quote
  #18  
Old 02-28-2010, 09:27 PM
Member
 
Join Date: Dec 2006
Location: Switzerland
Posts: 2,575
KiwiJochen is on a distinguished road
Quote:
Originally Posted by vince59it View Post
see what the problem is?

I tried sevaral ways. Succedeed in dividing data form one column in three separate columns, but now I have the problem with the lat and long digits
Looks fine to me. Just correct the formatting of the lat / long from text to decimal notation
Reply With Quote
  #19  
Old 03-06-2010, 06:41 AM
vince59it's Avatar
Member
 
Join Date: Mar 2009
Location: italy
Posts: 217
vince59it is on a distinguished road
Well, taking advantage from the bad weather in Roma I did not go sailing but stayed in front of the fireplace...messing up with the excel POI maker.
Great work by Kiwi. I studied the macro and learned a lot.
I only have one question so far. The heading of the file is always "Gphi" even if I select HIGH. Nevertheless I modified the macro to have "Glambda". I guess it is not a critical item, but it is just to understand why it does not work...soon I will test the output files and post the results.
__________________
I could show my BMW but I prefer to show my wife boobs...but, sorry, only by pic.
Reply With Quote
  #20  
Old 03-06-2010, 05:07 PM
Member
 
Join Date: Dec 2006
Location: Switzerland
Posts: 2,575
KiwiJochen is on a distinguished road
Quote:
Originally Posted by vince59it View Post
The heading of the file is always "Gphi" even if I select HIGH. Nevertheless I modified the macro to have "Glambda". I guess it is not a critical item, but it is just to understand why it does not work...
Because I do not understand the difference between phi and lambda
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





All times are GMT -4. The time now is 06:57 AM.
vBulletin, Copyright 2019, Jelsoft Enterprises Ltd. SEO by vBSEO 3.6.0
2017 Xoutpost.com. All rights reserved. Xoutpost.com is a private enthusiast site not associated with BMW AG.
The BMW name, marks, M stripe logo, and Roundel logo as well as X3, X5 and X6 designations used in the pages of this Web Site are the property of BMW AG.
This web site is not sponsored or affiliated in any way with BMW AG or any of its subsidiaries.