[GeoNetwork-devel] Opening ".koi" file

GeoNetwork GeoNetwork Developer
1

hi guys

Does anybody knows how to open ".koi" file ?

In fact i want to manage th default GN DB in the
"geonetwork\web\geonetwork\WEB-INF\db\data" directory.

In fact i'm modifying GN and i want to delete all countries loaded at
startupas show here in the picture

http://osgeo-org.1803224.n2.nabble.com/file/n6472631/geonetwork_countries_pict.png

I want to
- locate the country by default in a specific country
- modify the dropdown list and show only what i want
- modify the default categories
- .....

I think that i'll surely modify somefile in the db/data directory. But i can
not open "koi" file.

Any idea ?

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Opening-koi-file-tp6472631p6472631.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

2

Mckoi has an sql query tool you can get at by:

java -cp <install_directory>/web/geonetwork/WEB-INF/lib/mckoi-1.0.2.jar com.mckoi.tools.JDBCQueryTool -url "jdbc:mckoi://localhost:9157" -u "username_from_geonetwork_config.xml" -p "password_from_geonetwork_config.xml"

You can delete from/insert into the McKoi tables etc using sql statements.

Cheers,
Simon

________________________________________
From: marcelsnews [marcelsnews@anonymised.com]
Sent: Tuesday, 14 June 2011 1:33 PM
To: geonetwork-devel@lists.sourceforge.net
Subject: [GeoNetwork-devel] Opening ".koi" file

hi guys

Does anybody knows how to open ".koi" file ?

In fact i want to manage th default GN DB in the
"geonetwork\web\geonetwork\WEB-INF\db\data" directory.

In fact i'm modifying GN and i want to delete all countries loaded at
startupas show here in the picture

http://osgeo-org.1803224.n2.nabble.com/file/n6472631/geonetwork_countries_pict.png

I want to
- locate the country by default in a specific country
- modify the dropdown list and show only what i want
- modify the default categories
- .....

I think that i'll surely modify somefile in the db/data directory. But i can
not open "koi" file.

Any idea ?

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Opening-koi-file-tp6472631p6472631.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.

_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net

GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

3

I've tried your solution but i got SQL errors

So i'm asking myself: from wich directory shall i execute the cmd you posted
?

I went on the <install_directory>/web/geonetwork/WEB-INF/db/data 1st and on
many other directories
but i still had the same SQL error. I'm working on it, but i want to be sure
that i'm executing the cmd from the rigth directory.

Spec:
- i don't have jar filepath resolution problem. But it's the SQL exception
the problem and i'll investigate why.
- i want to be sure that i'm executing the cmd you gave at the right place

Great thanks for your post :wink:

here is the error:
http://osgeo-org.1803224.n2.nabble.com/file/n6472900/error_mckoi.png

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Opening-koi-file-tp6472631p6472900.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

4

From your image link it looks like you are missing a colon in the url arg: you have jdbc:mckoi//localhost:9157 but it should be jdbc:mckoi://localhost:9157

Cheers,
Simon
____________________________________
From: marcelsnews [marcelsnews@anonymised.com]
Sent: Tuesday, 14 June 2011 4:25 PM
To: geonetwork-devel@lists.sourceforge.net
Subject: Re: [GeoNetwork-devel] Opening ".koi" file

I've tried your solution but i got SQL errors

So i'm asking myself: from wich directory shall i execute the cmd you posted
?

I went on the <install_directory>/web/geonetwork/WEB-INF/db/data 1st and on
many other directories
but i still had the same SQL error. I'm working on it, but i want to be sure
that i'm executing the cmd from the rigth directory.

Spec:
- i don't have jar filepath resolution problem. But it's the SQL exception
the problem and i'll investigate why.
- i want to be sure that i'm executing the cmd you gave at the right place

Great thanks for your post :wink:

here is the error:
http://osgeo-org.1803224.n2.nabble.com/file/n6472900/error_mckoi.png

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Opening-koi-file-tp6472631p6472900.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.

_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net

GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

5

Oh pretty nice

That was the solution. Now it works pretty good

thanks :wink:

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Opening-koi-file-tp6472631p6473073.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.