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

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
  #1  
Old 03-08-2010, 06:14 AM
Member
 
Join Date: Mar 2010
Location: Germany
Posts: 4
ROCKER is on a distinguished road
what is this excel sheet for? i mean, you can download several speedcam lists in the web, why do them yourself?
Reply With Quote
  #2  
Old 03-08-2010, 06:25 AM
Member
 
Join Date: Dec 2006
Location: Switzerland
Posts: 2,575
KiwiJochen is on a distinguished road
Quote:
Originally Posted by ROCKER View Post
what is this excel sheet for? i mean, you can download several speedcam lists in the web, why do them yourself?
Because POIs are more than just speed cameras

AND the speed camera lists on the web are very simple with very little data (really they are quite incomplete)

With POI Maker, you can
- add all POI data to the POI. Eg street name, house number, speed limit data for speed cameras, direction of camera (for speed cameras), and whatever other data you want
- add ANY POI data, eg McDonalds Restaurants, Family and Friends, Company Locations, etc etc etc

Last edited by KiwiJochen; 03-08-2010 at 07:03 AM.
Reply With Quote
  #3  
Old 03-08-2010, 07:04 AM
Member
 
Join Date: Sep 2006
Location: Estonia
Posts: 94
aise is on a distinguished road
iīve just sent you the files. i didnīt edit the SF_xxx.HTM file (didnīt know that i had to). iīll give it another try. one thing i saw is that if no data under ENTP1 formulas need to be deleted or it will include the 166666666 values in .url file.

Last edited by aise; 03-08-2010 at 07:25 AM.
Reply With Quote
  #4  
Old 03-08-2010, 07:44 AM
Member
 
Join Date: Dec 2006
Location: Switzerland
Posts: 2,575
KiwiJochen is on a distinguished road
Quote:
Originally Posted by aise View Post
iīve just sent you the files. i didnīt edit the SF_xxx.HTM file (didnīt know that i had to). iīll give it another try. one thing i saw is that if no data under ENTP1 formulas need to be deleted or it will include the 166666666 values in .url file.
Well, your index IDX file has these fields in it

ID:I:3|POS:P:8|POLICE:S:16

As you said you did not edit the SF_xxxx.HTM, the SF file will still be looking for the original name (like NAME, SELNAME, etc)

You changed the name to POLICE and that is why the data cannot be displayed.

Please read and follow the instructions:
"Enter the title of the NAME field as per your SF_XXXX.HTM file. The NAME field varies: SELNAME, NAME_sco, or just NAME are examples of what you might see."
Reply With Quote
  #5  
Old 03-08-2010, 10:12 AM
vince59it's Avatar
Member
 
Join Date: Mar 2009
Location: italy
Posts: 217
vince59it is on a distinguished road
Quote:
Originally Posted by aise View Post
iīve just sent you the files. i didnīt edit the SF_xxx.HTM file (didnīt know that i had to). iīll give it another try. one thing i saw is that if no data under ENTP1 formulas need to be deleted or it will include the 166666666 values in .url file.
print out the lsc.file and you will realize why. Anyway there is a good english documents that explains very well how and where modify files. What Kiwi is trying to tell you is that it is not just a copy and paste procedure, but you have to replace the reference in all the files. I did by myself form the scratch and it works perfectly and I did my own display menu.
__________________
I could show my BMW but I prefer to show my wife boobs...but, sorry, only by pic.
Reply With Quote
  #6  
Old 03-08-2010, 08:00 AM
Member
 
Join Date: Sep 2006
Location: Estonia
Posts: 94
aise is on a distinguished road
ok. i need to enter SELNAME to excel (all .idx files on 2010 DVD have SELNAME:S and generate new files. then it should work.
Reply With Quote
  #7  
Old 03-08-2010, 01:42 PM
Member
 
Join Date: Dec 2006
Location: Switzerland
Posts: 2,575
KiwiJochen is on a distinguished road
Email me the ASC file so i can see the format
Reply With Quote
  #8  
Old 03-09-2010, 05:26 AM
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
Email me the ASC file so i can see the format
Actually it is a simple .asc file generated by POIedit - nothing more nothing less - then I just open the file with excel but I got only single rows, this is way.
BTW I modified your excel wsheet to have the .idx and .url heading as required (I know it is not a critical item) but it was to understand a little bit more about VBA.
Now I have added other sheets in the POI maker from where I can pick up the data already converted in columns.
My goal is now to "push a button" to convert one row data into three columns. I'm studying VBA...
__________________
I could show my BMW but I prefer to show my wife boobs...but, sorry, only by pic.

Last edited by vince59it; 03-09-2010 at 09:33 AM.
Reply With Quote
  #9  
Old 03-09-2010, 09:19 AM
Member
 
Join Date: Sep 2006
Location: Estonia
Posts: 94
aise is on a distinguished road
i still havenīt managed to get this thing working. 2010 HIGH has different field names (original .url files contain POSWGS:S:19|NAME:S:35|STREET:S:44|HOUSENUMBER:S:4| CITY:S:52|ZIP:S:8|PHONE:S:17|FNM:S:0|NT:S:1|FACPAG E:S:67|_:S:3 but POI_Maker .url files contain POSWGS:S:19|NAME:S:16|VILLAGE:S:0|CITY:S:3|STREET: S:3|HOUSENUMBER:S:3|PHONE:S:11|COUNTRY:S:5|BRANDNA ME:S:3|NSW1:S:1|IMPORTANCE:S:1|ENTP1:S:19|ENTP2:S: 0|ENTP3:S:0|ENTP4:S:0|_:S:1)
Reply With Quote
  #10  
Old 03-09-2010, 09:41 AM
vince59it's Avatar
Member
 
Join Date: Mar 2009
Location: italy
Posts: 217
vince59it is on a distinguished road
Quote:
Originally Posted by aise View Post
i still havenīt managed to get this thing working. 2010 HIGH has different field names (original .url files contain POSWGS:S:19|NAME:S:35|STREET:S:44|HOUSENUMBER:S:4| CITY:S:52|ZIP:S:8|PHONE:S:17|FNM:S:0|NT:S:1|FACPAG E:S:67|_:S:3 but POI_Maker .url files contain POSWGS:S:19|NAME:S:16|VILLAGE:S:0|CITY:S:3|STREET: S:3|HOUSENUMBER:S:3|PHONE:S:11|COUNTRY:S:5|BRANDNA ME:S:3|NSW1:S:1|IMPORTANCE:S:1|ENTP1:S:19|ENTP2:S: 0|ENTP3:S:0|ENTP4:S:0|_:S:1)
so what? you only need to fill the one that you need. For POI basic infos are lat,long and name tha is it.
__________________
I could show my BMW but I prefer to show my wife boobs...but, sorry, only by pic.
Reply With Quote
Reply

Bookmarks


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 04:22 AM.
vBulletin, Copyright 2026, 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.