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)

KiwiJochen 02-25-2010 04:13 PM

POI Maker
 
Make POI IDX and URL files for the Mk4 nav easily with POI Maker

An Excell spreadsheet that generates the IDX and URL files at a click of a button

POI Maker Website

vince59it 02-25-2010 05:26 PM

Kiwi, that was really a very nice present for everybody that wishes to understand something more about how to create POIs. I really appreciated this and and believe others will, as well. :thumbup: :rofl:

aise 02-26-2010 05:55 AM

nice! how can i make it to display POI_POLICE.PNG icon for my added locations?

1 typo in the file "5-series E38"

vince59it 02-26-2010 06:10 AM

Quote:

Originally Posted by aise (Post 717514)
nice! how can i make it to display POI_POLICE.PNG icon for my added locations?

1 typo in the file "5-series E38"

This has nothing to do with POI maker.
You have to put your icon into the appropriate folder and update the reference into the xxx.lsc file.

question for Kiwi:
as the POI list is really long (more than a thousand items) is there any "easy" way to import data form .asc/.csv. or any other format into your excel column?
I tried several ways but it is not possible to cut-and-paste just a single column. Typing manually would require agesssssssssss :rolleyes:

cX3 02-26-2010 08:01 AM

Hello. Good job Kiwi. I tested yesterday, looks OK. Before, I opened asc/csv with excel to edit than saved and converted with asc2url. Now similiar I can opened asc/csv with excel but I used copy/paste of each column to your spreadsheet than one clik and the IDX and URL files are generated. What I see is difference with IDX file size using this 2 methods, yours is much smaller because consists only POI names. Is it OK? Do you have also macro for reverse operation from IDX/URL to excel?

vince59it 02-26-2010 08:42 AM

Quote:

Originally Posted by cX3 (Post 717524)
Hello. Good job Kiwi. I tested yesterday, looks OK. Before, I opened asc/csv with excel to edit than saved and converted with asc2url. Now similiar I can opened asc/csv with excel but I used copy/paste of each column to your spreadsheet than one clik and the IDX and URL files are generated. What I see is difference with IDX file size using this 2 methods, yours is much smaller because consists only POI names. Is it OK? Do you have also macro for reverse operation from IDX/URL to excel?

Just a question, how did you copy a single column (let's say longitude) from the asc/csv file into the Kiwi spredasheet column? :dunno:

cX3 02-26-2010 11:17 AM

Exactly what I said, using excel to open asc/csv, edit what I need, than copy/paste columns to Kiwi's spreadsheet one by one. I will try to make macro to do it automatically later today, this shouldn't be difficult.

KiwiJochen 02-26-2010 12:36 PM

Quote:

Originally Posted by vince59it (Post 717515)
question for Kiwi:
as the POI list is really long (more than a thousand items) is there any "easy" way to import data form .asc/.csv. or any other format into your excel column?
I tried several ways but it is not possible to cut-and-paste just a single column. Typing manually would require agesssssssssss :rolleyes:

Of course you can copy/paste a column

Mark the cells you want to copy
Copy them
Go to POI Maker, highlight the top cell
Paste

PS: There are plenty of "How to use Excel" instructions on the Internet :D

KiwiJochen 02-26-2010 12:37 PM

Quote:

Originally Posted by cX3 (Post 717524)
What I see is difference with IDX file size using this 2 methods, yours is much smaller because consists only POI names. Is it OK?

Smaller than what?
If you think something is not right, send me (email) your IDX files for analysis

Quote:

Originally Posted by cX3 (Post 717524)
Do you have also macro for reverse operation from IDX/URL to excel?

Of course :-)

KiwiJochen 02-26-2010 12:44 PM

Quote:

Originally Posted by aise (Post 717514)
1 typo in the file "5-series E38"

Fixed in v1.0.1, now available


All times are GMT -4. The time now is 10:05 PM.

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