Xoutpost.com

Xoutpost.com (https://xoutpost.com/forums.php)
-   Navigation System (https://xoutpost.com/electronics/navigation-system/)
-   -   POI Maker (https://xoutpost.com/electronics/navigation-system/70775-poi-maker.html)

vince59it 02-26-2010 05:42 PM

Quote:

Originally Posted by KiwiJochen (Post 717584)
Of course you can copy/paste a column
PS: There are plenty of "How to use Excel" instructions on the Internet :D

...my dear friend...:confused:...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...

KiwiJochen 02-26-2010 05:48 PM

Quote:

Originally Posted by vince59it (Post 717689)
...my dear friend...:confused:...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)

fnc1 02-26-2010 10:28 PM

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

KiwiJochen 02-27-2010 03:16 AM

Quote:

Originally Posted by fnc1 (Post 717771)
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.

fnc1 02-27-2010 11:46 AM

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

KiwiJochen 02-27-2010 01:13 PM

Go for it then, patch navboot for multiple POIs and tell us how well it works

vince59it 02-28-2010 05:14 PM

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


http://i49.tinypic.com/zy8r3m.jpg

KiwiJochen 02-28-2010 09:27 PM

Quote:

Originally Posted by vince59it (Post 718260)
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

vince59it 03-06-2010 06:41 AM

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

KiwiJochen 03-06-2010 05:07 PM

Quote:

Originally Posted by vince59it (Post 720241)
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


All times are GMT -4. The time now is 12:41 PM.

vBulletin, Copyright 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.6.0
© 2017 Xoutpost.com. All rights reserved.