New POILOGGER / POIWARNER OVERLAY Plugin

[wolfgang928]

Hallo _Dejan_,

i think a msi would not help you, there is another point to clear.

you can of course import poi's, but when the system doesn't know which category this pois are, what shall it display?

Solution: please go into poi.mdb, table category and insert a new category with an - up to then - unused category number.

i.e.ID,File,[Category],[CategoryNo],ZoomText,ZoomBmp,[Bitmap],
unknown,Fontsize,Fontcolor,Outlinecolor,Soundfile, Distance,DistanceDimension ,[Active], NAVIGONCatNo

make a new record
ID=200,
File = YourFilename.asc this must be the name you like to import
Category = YourDescription
CategoryNo = 999
Active = true

The central SQL to fetch data is:

SQLFetchAll = "SELECT POI.POI_ID, POI.Longitude, POI.Latitude, POI.City, POI.Street, POI.Direction, POI.active, Category.Category, Category.Bitmap, Category.Soundfile FROM POI INNER JOIN Category ON POI.CategoryNo = Category.CategoryNo WHERE (POI.active = True) AND (Category.active = True);

So in both tables there must be a record with the same category number, otherwise nothing will be displayed, because nothing is found.

The styles file is up to now only be used for the poi logging not for poi warning.
The poi warning refers only to the table category inside the access mdb.
Might be, that a melting of both information could be helpfull for the next version.

string QRYSQL = "SELECT CategoryNo FROM CATEGORY WHERE NAVIGONCatNo = " + pt._catID;
During saving a logged POI to database the system is searching for a category record which has a
categoryno out of the styles.txt file, convert it to the database category and insert the new poi into table POI.

Hope that helps, additionaly have a look to the source.

Wolfgang928

[cpufix]

Originally Posted by wolfgang928

Hi cpufix,

the only reason is that in german Windows C:\Programme is used and i found flux-media a little bit to long, nothing else.

You could change the target directory as you like.

Wolfgang928

I have tried changing the config file and styles.txt, but I get an error when CF starts cannot locate catergory file.
Where is the setting for the target directory ?

[_Dejan_]

Ok, thanks but doesent work.
Please check next files:
POI.mdb
Styles.txt
POI.RAR (My POI files with images)

I think Im import data corect into base but when i start POILogger I dont see anything:


What is wrong? Thanks for your help.

Bye, _Dejan_

[_Dejan_]

Originally Posted by cpufix

I have tried changing the config file and styles.txt, but I get an error when CF starts cannot locate catergory file.
Where is the setting for the target directory ?

On first page you must locate Categoryfile...

[cpufix]

Originally Posted by cpufix

I have tried changing the config file and styles.txt, but I get an error when CF starts cannot locate catergory file.
Where is the setting for the target directory ?

All sorted in settings, opened mouth before engaging.

Cheers

[wolfgang928]

Hallo _Dejan_,

please send (attach) me your error log file.

Thanks Wolfgang928

[_Dejan_]

Here is my log file:

10.9.2007 20:47:06
Could not find a part of the path 'C:\temp\LOGBUCH.LOG'.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
   at System.IO.StreamWriter.CreateFile(String path, Boolean append)
   at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize)
   at System.IO.StreamWriter..ctor(String path, Boolean append)
   at System.IO.File.AppendText(String path)
   at poilogger.poilogger.SavePOIPermanent()
   at poilogger.poilogger.Btn_Click(Object sender, MouseEventArgs e)
   at centrafuse.Plugins.CFControls.skinButton.fireClick(MouseEventArgs e)
   at centrafuse.Plugins.CFPlugin.CFPlugin_MouseUp(Object sender, MouseEventArgs e)
----------------------------------------------------------------------------------------------------------
10.9.2007 20:51:58
Retrieving the COM class factory for component with CLSID {B405D36C-76B3-43F0-98FD-4193F41B7A10} failed due to the following error: 80040154.
   at zBTHelper.BTHelper..ctor()
   at zBTHelper.BTHelper..ctor(Boolean useSecurity)
   at CFBluetoothControl.BluetoothControl.InitBluetooth()
   at CFBluetoothControl.BluetoothControl.CF_localskinsetup()
----------------------------------------------------------------------------------------------------------
10.9.2007 20:51:58
Object reference not set to an instance of an object.
   at poilogger.poiwarner.loadSettings()
   at poilogger.poiwarner.CF_pluginInit()
----------------------------------------------------------------------------------------------------------
10.9.2007 20:51:59
Object reference not set to an instance of an object.
   at sudoku.sudoku.CF_localskinsetup()
----------------------------------------------------------------------------------------------------------
10.9.2007 20:52:07
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at centrafuse.Plugins.CFPlugin.CF_setButtonOff(String wbutton)
----------------------------------------------------------------------------------------------------------
10.9.2007 21:04:15
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at centrafuse.Plugins.CFPlugin.CF_setButtonOff(String wbutton)
----------------------------------------------------------------------------------------------------------
10.9.2007 21:13:37
Retrieving the COM class factory for component with CLSID {B405D36C-76B3-43F0-98FD-4193F41B7A10} failed due to the following error: 80040154.
   at zBTHelper.BTHelper..ctor()
   at zBTHelper.BTHelper..ctor(Boolean useSecurity)
   at CFBluetoothControl.BluetoothControl.InitBluetooth()
   at CFBluetoothControl.BluetoothControl.CF_localskinsetup()
----------------------------------------------------------------------------------------------------------
10.9.2007 21:13:38
Object reference not set to an instance of an object.
   at poilogger.poiwarner.loadSettings()
   at poilogger.poiwarner.CF_pluginInit()
----------------------------------------------------------------------------------------------------------
10.9.2007 21:13:38
Object reference not set to an instance of an object.
   at sudoku.sudoku.CF_localskinsetup()
----------------------------------------------------------------------------------------------------------
10.9.2007 21:13:38
Convertion GPS coordniates to location failed
Input string was not in a correct format.
----------------------------------------------------------------------------------------------------------
10.9.2007 21:14:15
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at centrafuse.Plugins.CFPlugin.CF_setButtonOff(String wbutton)
----------------------------------------------------------------------------------------------------------
10.9.2007 21:14:20
Could not find a part of the path 'C:\temp\LOGBUCH.ASC'.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
   at System.IO.StreamWriter.CreateFile(String path, Boolean append)
   at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize)
   at System.IO.StreamWriter..ctor(String path, Boolean append)
   at System.IO.File.AppendText(String path)
   at poilogger.poilogger.SavePOIPermanent()
   at poilogger.poilogger.Btn_Click(Object sender, MouseEventArgs e)
   at centrafuse.Plugins.CFControls.skinButton.fireClick(MouseEventArgs e)
   at centrafuse.Plugins.CFPlugin.CFPlugin_MouseUp(Object sender, MouseEventArgs e)
----------------------------------------------------------------------------------------------------------
10.9.2007 21:14:21
The process cannot access the file 'C:\Program Files\Flux Media\Centrafuse\Plugins\POILogger\LOG.log' because it is being used by another process.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
   at System.IO.StreamWriter.CreateFile(String path, Boolean append)
   at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize)
   at System.IO.StreamWriter..ctor(String path, Boolean append)
   at System.IO.File.AppendText(String path)
   at poilogger.poilogger.SavePOIPermanent()
   at poilogger.poilogger.Btn_Click(Object sender, MouseEventArgs e)
   at centrafuse.Plugins.CFControls.skinButton.fireClick(MouseEventArgs e)
   at centrafuse.Plugins.CFPlugin.CFPlugin_MouseUp(Object sender, MouseEventArgs e)
----------------------------------------------------------------------------------------------------------
10.9.2007 21:34:33
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at centrafuse.Plugins.CFPlugin.CF_setButtonOff(String wbutton)
----------------------------------------------------------------------------------------------------------
10.9.2007 21:34:41
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at centrafuse.Plugins.CFPlugin.CF_setButtonOff(String wbutton)
----------------------------------------------------------------------------------------------------------
10.9.2007 21:35:57
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at centrafuse.Plugins.CFPlugin.CF_setButtonOff(String wbutton)
----------------------------------------------------------------------------------------------------------
10.9.2007 21:36:09
Could not find a part of the path 'C:\temp\LOGBUCH.ASC'.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
   at System.IO.StreamWriter.CreateFile(String path, Boolean append)
   at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize)
   at System.IO.StreamWriter..ctor(String path, Boolean append)
   at System.IO.File.AppendText(String path)
   at poilogger.poilogger.SavePOIPermanent()
   at poilogger.poilogger.Btn_Click(Object sender, MouseEventArgs e)
   at centrafuse.Plugins.CFControls.skinButton.fireClick(MouseEventArgs e)
   at centrafuse.Plugins.CFPlugin.CFPlugin_MouseUp(Object sender, MouseEventArgs e)
----------------------------------------------------------------------------------------------------------

[wolfgang928]

Hallo _Dejan_

first step: please set a correct OUTPUT file in setup page 1 "OUTPUT"
you don't have a path like C:\TEMP
the file itself will be created new!

then this two messages would not appear any more:
1.) Could not find a part of the path 'C:\temp\LOGBUCH.LOG'.
2.) Could not find a part of the path 'C:\temp\LOGBUCH.ASC'.

The rest i think i will find a give you further info.

Bye Wolfgang928 (good night)

[wolfgang928]

Solution:

Sorry for this trouble.
you are using category numbers from 100 to 110. in the first developing days
i have used an undocumented feature inside the config.xml

please set these three lines to your requirements
the default category is used inside the setup page, the other two settings
are only available direct in config.xml.

<CATEGORYMINNR>100</CATEGORYMINNR>
<CATEGORYMAXNR>120</CATEGORYMAXNR>
<DEFAULTCATEGORY>100</DEFAULTCATEGORY>

Sorry i have forgeotten this. This should have been used as a kind of category limiter for the Logger part of the plugin.

Greetings Wolfgang928

[_Dejan_]

Originally Posted by wolfgang928

Hallo _Dejan_

first step: please set a correct OUTPUT file in setup page 1 "OUTPUT"
you don't have a path like C:\TEMP
the file itself will be created new!

then this two messages would not appear any more:
1.) Could not find a part of the path 'C:\temp\LOGBUCH.LOG'.
2.) Could not find a part of the path 'C:\temp\LOGBUCH.ASC'.

The rest i think i will find a give you further info.

Bye Wolfgang928 (good night)

Ok Im create temp folder...
Now I can see my Categoryes but I can't see POI:


Here is my conf file and I think now is good configured: config.XML
And error file:error.txt