POI Maker

KiwiJochen · #1 02-25-2010, 04:13 PM

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

Sponsored Links

vince59it · #2 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.

aise · #3 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 · #4 02-26-2010, 06:10 AM

Quote:

Originally Posted by aise

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

cX3 · #5 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 · #6 02-26-2010, 08:42 AM

Quote:

Originally Posted by cX3

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?

cX3 · #7 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 · #8 02-26-2010, 12:36 PM

Quote:

Originally Posted by vince59it

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

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