View Single Post
rcull's Avatar
Posts: 299 | Thanked: 168 times | Joined on Jun 2006 @ Wales UK
#7
revwillie
could you post an extract of the GPX files you are trying to load?

Testing done tonight.

Poi_Loader0.0.2 installed on a different XP box.

sqlite-3_3_13.zip extracted into c:\windows\system32

gpsbabel-1.3.3.zip extracted into c:\Program Files\GPSBabel

tesco.ov2 downloaded from http://www.tomtomfree.com/ into c:\temp

poi.db copied from N800 to c:\temp

Poi_Loader started and File -> GPSBabel clicked. tesco.ov2 converted from .ov2 to .gpx

file selector used to load c:\temp\poi.db

file selector used to load c:\temp\tesco.gpx

Display/Edit clicked and all occurrencies of '>' replaced with ' '

'Add Category' clicked and "New' / 'Testing' inserted

'Get category' clicked and category 'New' selected ( correct category displayed with category number 16 and enabled )

option 'View' selected -> SQL statements displayed in listbox - with poi as database and 16 as category

option 'Output to file' selected -> SQL displayed in listbox and ( Bug here ) tesco..sql was created in c:\temp - with poi as database and 16 as category

option 'Direct to database' selected -> SQL displayed ( slowly ) in list box and when checked from the command line sqlite3 displayed correct records.

This is obviously not conclusive, as stated on initial post testing has been minimal, but I am willing to extend this if needed. There is no real parsing of the XML ( I dont even know of an XML parser for VB6 ) I am basically just extracting the <wpt lat= lon= >,<name> and <desc> fields.

Rick