[GeoNetwork-users] customise template and regions list

karibu · July 28, 2009, 2:45pm

Hi,
I was trying to customise a template and I added some new attributes in the
XML file. For example: <gmd:SatelliteName>
<gco:CharacterString>Satellite</gco:CharacterString>
</gmd:SatelliteName>

when I look at these changes in the default view, the attribute gets
displayed as gmd:SatelliteName. Which other files need to be changed to
display the attribute as Satellite Name instead of gmd:SatelliteName? And
where can I add a tooltip description for the attribute?

I also tried to update the regions list in the geographic search and the
descriptive keywords places. I know this has been discussed before and
Francois wrote that Region and Regionsdesc needs to be updated in the
database, in order to make changes. But where do I find these two files
Region and Regionsdesc?

Thanks for your help.
--
View this message in context: http://n2.nabble.com/customise-template-and-regions-list-tp3343295p3343295.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

Jason_Pickering1 · July 28, 2009, 3:23pm

HI there. I cannot respond to your first query, but can respond regarding your second, I think.

I have just been updating the two tables in the database (Regions and RegionsDes). The Regions table provides a bounding box for each region listed in the RegionsDes table. In the RegionsDes table you will need to add/modify the regions to your requirements, being sure that there is a corresponding entry in the Regions table. I did this directly in the SQL database, first by modifying the Regions table, and then making adjustments to the RegionsDes table since there is a foreign key contraint on the Regions table.

Just one thing that I came across anyway. I actually dropped the RegionsDes table, and recreated it with a modified version. My MySQL database was particular about the case of the foreign key contraints. I think the code should be modified from ..

ALTER TABLE `RegionsDes`
ADD CONSTRAINT `regionsdes_ibfk_1` FOREIGN KEY (`idDes`) REFERENCES `regions` (`id`),
ADD CONSTRAINT `regionsdes_ibfk_2` FOREIGN KEY (`langId`) REFERENCES `languages` (`id`);

to
ALTER TABLE `RegionsDes`
ADD CONSTRAINT `regionsdes_ibfk_1` FOREIGN KEY (`idDes`) REFERENCES `Regions` (`id`),
ADD CONSTRAINT `regionsdes_ibfk_2` FOREIGN KEY (`langId`) REFERENCES `Languages` (`id`);

that is, if your tables actually have upper-case characters. Otherwise, inserts into the RegionsDes table will fail. I am not sure if my table names are standard/correct as we have been through a long and painful migration process from an older version. Anyway, just something to keep in mind.

Regards,
Jason

________________________________

From: karibu [mailto:kat_lore@anonymised.com]
Sent: Tue 2009-07-28 16:45
To: geonetwork-users@lists.sourceforge.net
Subject: [GeoNetwork-users] customise template and regions list

Hi,
I was trying to customise a template and I added some new attributes in the
XML file. For example: <gmd:SatelliteName>
<gco:CharacterString>Satellite</gco:CharacterString>
</gmd:SatelliteName>

when I look at these changes in the default view, the attribute gets
displayed as gmd:SatelliteName. Which other files need to be changed to
display the attribute as Satellite Name instead of gmd:SatelliteName? And
where can I add a tooltip description for the attribute?

I also tried to update the regions list in the geographic search and the
descriptive keywords places. I know this has been discussed before and
Francois wrote that Region and Regionsdesc needs to be updated in the
database, in order to make changes. But where do I find these two files
Region and Regionsdesc?

Thanks for your help.
--
View this message in context: http://n2.nabble.com/customise-template-and-regions-list-tp3343295p3343295.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Mathieu_Coudert · July 28, 2009, 3:37pm

Hi Karibu,

On Tue, Jul 28, 2009 at 4:45 PM, karibu <kat_lore@anonymised.com> wrote:

Hi,
I was trying to customise a template and I added some new attributes in the
XML file. For example: <gmd:SatelliteName>
<gco:CharacterString>Satellite</gco:CharacterString>
</gmd:SatelliteName>

Did you also change the schema (xsd file corresponding to the standard you
want to modify ie : iso19139...)?
Your metadata will not be valid anymore if you're adding customize elements
and attributes....

when I look at these changes in the default view, the attribute gets
displayed as gmd:SatelliteName. Which other files need to be changed to
display the attribute as Satellite Name instead of gmd:SatelliteName? And
where can I add a tooltip description for the attribute?

Concerning labels and descriptions for schema elements, they are defined
here : /web/geonetwork/xml/schemas/A_STANDARD/loc/A_LANGUAGE/labels.xml
For instance, if you would like to add your element gmd:SatelliteName for
schema ISO 19139 and diplayed label in english, you will have to add these
lines in this file : /web/geonetwork/xml/schemas/iso19139/loc/en/labels.xml

<element name="gmd:SatelliteName">
<label> Satellite Name </label>
<description>Tooltip description of the Satellite Name</description>
</element>

I also tried to update the regions list in the geographic search and the
descriptive keywords places. I know this has been discussed before and
Francois wrote that Region and Regionsdesc needs to be updated in the
database, in order to make changes. But where do I find these two files
Region and Regionsdesc?

You will find these files into /gast/setup/db/ repository.

HTH,

Ciao,

Mathieu

Thanks for your help.
--
View this message in context:
http://n2.nabble.com/customise-template-and-regions-list-tp3343295p3343295.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

karibu · July 29, 2009, 1:49pm

Hi,
I customised the Regions.ddf and RegionsDes.ddf, but when I open Geonetwork
the places list is still the same. Do I have to change any other file?
Thanks for your help.

--
View this message in context: http://n2.nabble.com/customise-template-and-regions-list-tp3343295p3349823.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

Jose_Garcia · July 29, 2009, 2:33pm

Hi Karibu

The ddf files are loaded in the GeoNetwork database using GAST.

The problem is that loading these files with GAST will delete your actual Geonetwork data and replace it with the content of default datafiles (geonetwork\gast\setup\db\*.ddf), so if you have metadata or customizations (custom users, groups, ...) in GeoNetwork this method is not right for you.

In this case te best solution is that you connect to the GeoNetwork database with some SQL client and add the custom data to the Regions and RegionsDes tables.

Regards,
Jose

----- Original Message ----- From: "karibu" <kat_lore@anonymised.com>
To: <geonetwork-users@lists.sourceforge.net>
Sent: Wednesday, July 29, 2009 3:49 PM
Subject: Re: [GeoNetwork-users] customise template and regions list

Hi,
I customised the Regions.ddf and RegionsDes.ddf, but when I open Geonetwork
the places list is still the same. Do I have to change any other file?
Thanks for your help.

--
View this message in context: http://n2.nabble.com/customise-template-and-regions-list-tp3343295p3349823.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Mathieu_Coudert · July 29, 2009, 2:57pm

Hi,
On Wed, Jul 29, 2009 at 4:33 PM, Jose García <josegar74@anonymised.com> wrote:

Hi Karibu

The ddf files are loaded in the GeoNetwork database using GAST.

The problem is that loading these files with GAST will delete your actual
Geonetwork data and replace it with the content of default datafiles
(geonetwork\gast\setup\db\*.ddf), so if you have metadata or customizations
(custom users, groups, ...) in GeoNetwork this method is not right for you.

You could also use Druid to update only these two tables accessing your
database using jdbc functionnality.
Given that ddf is the default Druid format and means "database druid
format", Druid seems to be the best tool to do such a thing.

Druid project : http://druid.sourceforge.net/

In this case te best solution is that you connect to the GeoNetwork
database
with some SQL client and add the custom data to the Regions and RegionsDes
tables.

Indeed, that's another solution.

Cheers,

Mathieu

Jason_Pickering1 · July 29, 2009, 3:30pm

HI there. I know I sent a message previously about what I thought was the solution to this problem, but now I must admit that I am a bit confused. I have customized the Regions and RegionsDesc tables in my MySQL database, but the drop down menu to select the regions in the Geonetwork main page still contain the old entries. Is this information cached someplace? Is it located anywhere inside of an XML file someplace besides the database? If so, then there are other issues for me that I will have to dig depper into.

Thanks for the confirmation.

Best regards,
Jason

________________________________

From: Jose García [mailto:josegar74@anonymised.com]
Sent: Wed 2009-07-29 16:33
To: karibu
Cc: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] customise template and regions list

Hi Karibu

The ddf files are loaded in the GeoNetwork database using GAST.

The problem is that loading these files with GAST will delete your actual
Geonetwork data and replace it with the content of default datafiles
(geonetwork\gast\setup\db\*.ddf), so if you have metadata or customizations
(custom users, groups, ...) in GeoNetwork this method is not right for you.

In this case te best solution is that you connect to the GeoNetwork database
with some SQL client and add the custom data to the Regions and RegionsDes
tables.

Regards,
Jose

----- Original Message -----
From: "karibu" <kat_lore@anonymised.com>
To: <geonetwork-users@lists.sourceforge.net>
Sent: Wednesday, July 29, 2009 3:49 PM
Subject: Re: [GeoNetwork-users] customise template and regions list

Hi,
I customised the Regions.ddf and RegionsDes.ddf, but when I open
Geonetwork
the places list is still the same. Do I have to change any other file?
Thanks for your help.

--
View this message in context:
http://n2.nabble.com/customise-template-and-regions-list-tp3343295p3349823.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Jose_Garcia · July 29, 2009, 3:37pm

Re: [GeoNetwork-users] customise template and regions listHi

Have you tried to restart geonetwork after the table changes? Regions data should be cached as normally doesn't change.

Regards,
Jose
  ----- Original Message -----
  From: Pickering, Jason Paul
  To: Jose García ; karibu
  Cc: geonetwork-users@lists.sourceforge.net
  Sent: Wednesday, July 29, 2009 5:30 PM
  Subject: RE: [GeoNetwork-users] customise template and regions list

HI there. I know I sent a message previously about what I thought was the solution to this problem, but now I must admit that I am a bit confused. I have customized the Regions and RegionsDesc tables in my MySQL database, but the drop down menu to select the regions in the Geonetwork main page still contain the old entries. Is this information cached someplace? Is it located anywhere inside of an XML file someplace besides the database? If so, then there are other issues for me that I will have to dig depper into.

Thanks for the confirmation.

Best regards,
Jason

------------------------------------------------------------------------------
  From: Jose García [mailto:josegar74@anonymised.com]
  Sent: Wed 2009-07-29 16:33
  To: karibu
  Cc: geonetwork-users@lists.sourceforge.net
  Subject: Re: [GeoNetwork-users] customise template and regions list

Hi Karibu

The ddf files are loaded in the GeoNetwork database using GAST.

  The problem is that loading these files with GAST will delete your actual
  Geonetwork data and replace it with the content of default datafiles
  (geonetwork\gast\setup\db\*.ddf), so if you have metadata or customizations
  (custom users, groups, ...) in GeoNetwork this method is not right for you.

  In this case te best solution is that you connect to the GeoNetwork database
  with some SQL client and add the custom data to the Regions and RegionsDes
  tables.

Regards,
Jose

  ----- Original Message -----
  From: "karibu" <kat_lore@anonymised.com>
  To: <geonetwork-users@lists.sourceforge.net>
  Sent: Wednesday, July 29, 2009 3:49 PM
  Subject: Re: [GeoNetwork-users] customise template and regions list

  >
  > Hi,
  > I customised the Regions.ddf and RegionsDes.ddf, but when I open
  > Geonetwork
  > the places list is still the same. Do I have to change any other file?
  > Thanks for your help.
  >
  >
  >
  >
  >
  >
  >
  >
  >
  >
  >
  > --
  > View this message in context:
  > http://n2.nabble.com/customise-template-and-regions-list-tp3343295p3349823.html
  > Sent from the GeoNetwork users mailing list archive at Nabble.com.
  >
  > ------------------------------------------------------------------------------
  > Let Crystal Reports handle the reporting - Free Crystal Reports 2008
  > 30-Day
  > trial. Simplify your report design, integration and deployment - and focus
  > on
  > what you do best, core application coding. Discover what's new with
  > Crystal Reports now. http://p.sf.net/sfu/bobj-july
  > _______________________________________________
  > GeoNetwork-users mailing list
  > GeoNetwork-users@lists.sourceforge.net
  > https://lists.sourceforge.net/lists/listinfo/geonetwork-users
  > GeoNetwork OpenSource is maintained at
  > http://sourceforge.net/projects/geonetwork
  >

  ------------------------------------------------------------------------------
  Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
  trial. Simplify your report design, integration and deployment - and focus on
  what you do best, core application coding. Discover what's new with
  Crystal Reports now. http://p.sf.net/sfu/bobj-july
  _______________________________________________
  GeoNetwork-users mailing list
  GeoNetwork-users@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/geonetwork-users
  GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Luca_Casagrande · July 29, 2009, 5:36pm

Hi Mathieu,

2009/7/29 Mathieu Coudert <mathieu.coudert@anonymised.com>:

Hi,
On Wed, Jul 29, 2009 at 4:33 PM, Jose García <josegar74@anonymised.com> wrote:

Hi Karibu

The ddf files are loaded in the GeoNetwork database using GAST.

The problem is that loading these files with GAST will delete your actual
Geonetwork data and replace it with the content of default datafiles
(geonetwork\gast\setup\db\*.ddf), so if you have metadata or customizations
(custom users, groups, ...) in GeoNetwork this method is not right for you.

You could also use Druid to update only these two tables accessing your
database using jdbc functionnality.
Given that ddf is the default Druid format and means "database druid
format", Druid seems to be the best tool to do such a thing.

Druid project : http://druid.sourceforge.net/

I didn't know about Druid..thank you for this suggestion!
How can I open a ddf for editing?

Ciao
Luca

--
Dott. Ing. Luca Casagrande
Open Source GIS analyst and developer

Gfosservices SA

http://www.gfosservices.com
skype: lucacasagrande

Jason_Pickering1 · July 29, 2009, 6:08pm

HI there. Well, the sysadmin told me he restarted it, but I am not 100% sure. I just want to be sure that there are no files that get cached to disk, and then need to be deleted and rebuilt (similar to the Lucence files).

Thanks,
Jason

________________________________

From: Jose García [mailto:josegar74@anonymised.com]
Sent: Wed 2009-07-29 17:37
To: Pickering, Jason Paul; karibu
Cc: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] customise template and regions list

Hi

Have you tried to restart geonetwork after the table changes? Regions data should be cached as normally doesn't change.

Regards,
Jose

  ----- Original Message -----
  From: Pickering, Jason Paul <mailto:pickeringj@anonymised.com>
  To: Jose García <mailto:josegar74@anonymised.com> ; karibu <mailto:kat_lore@anonymised.com…461…>
  Cc: geonetwork-users@lists.sourceforge.net
  Sent: Wednesday, July 29, 2009 5:30 PM
  Subject: RE: [GeoNetwork-users] customise template and regions list

  HI there. I know I sent a message previously about what I thought was the solution to this problem, but now I must admit that I am a bit confused. I have customized the Regions and RegionsDesc tables in my MySQL database, but the drop down menu to select the regions in the Geonetwork main page still contain the old entries. Is this information cached someplace? Is it located anywhere inside of an XML file someplace besides the database? If so, then there are other issues for me that I will have to dig depper into.

  Thanks for the confirmation.

  Best regards,
  Jason

________________________________

  From: Jose García [mailto:josegar74@anonymised.com]
  Sent: Wed 2009-07-29 16:33
  To: karibu
  Cc: geonetwork-users@lists.sourceforge.net
  Subject: Re: [GeoNetwork-users] customise template and regions list

  Hi Karibu

  The ddf files are loaded in the GeoNetwork database using GAST.

  The problem is that loading these files with GAST will delete your actual
  Geonetwork data and replace it with the content of default datafiles
  (geonetwork\gast\setup\db\*.ddf), so if you have metadata or customizations
  (custom users, groups, ...) in GeoNetwork this method is not right for you.

  In this case te best solution is that you connect to the GeoNetwork database
  with some SQL client and add the custom data to the Regions and RegionsDes
  tables.

  Regards,
  Jose

  ----- Original Message -----
  From: "karibu" <kat_lore@anonymised.com>
  To: <geonetwork-users@lists.sourceforge.net>
  Sent: Wednesday, July 29, 2009 3:49 PM
  Subject: Re: [GeoNetwork-users] customise template and regions list

  >
  > Hi,
  > I customised the Regions.ddf and RegionsDes.ddf, but when I open
  > Geonetwork
  > the places list is still the same. Do I have to change any other file?
  > Thanks for your help.
  >
  >
  >
  >
  >
  >
  >
  >
  >
  >
  >
  > --
  > View this message in context:
  > http://n2.nabble.com/customise-template-and-regions-list-tp3343295p3349823.html
  > Sent from the GeoNetwork users mailing list archive at Nabble.com.
  >
  > ------------------------------------------------------------------------------
  > Let Crystal Reports handle the reporting - Free Crystal Reports 2008
  > 30-Day
  > trial. Simplify your report design, integration and deployment - and focus
  > on
  > what you do best, core application coding. Discover what's new with
  > Crystal Reports now. http://p.sf.net/sfu/bobj-july
  > _______________________________________________
  > GeoNetwork-users mailing list
  > GeoNetwork-users@lists.sourceforge.net
  > https://lists.sourceforge.net/lists/listinfo/geonetwork-users
  > GeoNetwork OpenSource is maintained at
  > http://sourceforge.net/projects/geonetwork
  >

  ------------------------------------------------------------------------------
  Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
  trial. Simplify your report design, integration and deployment - and focus on
  what you do best, core application coding. Discover what's new with
  Crystal Reports now. http://p.sf.net/sfu/bobj-july
  _______________________________________________
  GeoNetwork-users mailing list
  GeoNetwork-users@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/geonetwork-users
  GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Mathieu_Coudert · July 30, 2009, 7:16am

Hi Luca,

On Wed, Jul 29, 2009 at 7:36 PM, Luca Casagrande
<luca.casagrande@anonymised.com>wrote:

Hi Mathieu,

2009/7/29 Mathieu Coudert <mathieu.coudert@anonymised.com>:
> Hi,
> On Wed, Jul 29, 2009 at 4:33 PM, Jose García <josegar74@anonymised.com>
wrote:
>
>> Hi Karibu
>>
>> The ddf files are loaded in the GeoNetwork database using GAST.
>>
>> The problem is that loading these files with GAST will delete your
actual
>> Geonetwork data and replace it with the content of default datafiles
>> (geonetwork\gast\setup\db\*.ddf), so if you have metadata or
customizations
>> (custom users, groups, ...) in GeoNetwork this method is not right for
you.
>>
>
> You could also use Druid to update only these two tables accessing your
> database using jdbc functionnality.
> Given that ddf is the default Druid format and means "database druid
> format", Druid seems to be the best tool to do such a thing.
>
> Druid project : http://druid.sourceforge.net/

I didn't know about Druid..thank you for this suggestion!
How can I open a ddf for editing?

With your preferred text editor (vi, gedit, ...) cause ddf files are text
files.

ciao,

Mathieu

Ciao
Luca

--
Dott. Ing. Luca Casagrande
Open Source GIS analyst and developer

Gfosservices SA

http://www.gfosservices.com
skype: lucacasagrande

Jason_Pickering1 · July 31, 2009, 8:16am

Hi there. I have some further questions regarding the customization of place names, and specifically what the following file does...

geonetwork/loc/en/xml/countries.xml

which looks something like this..

<?xml version="1.0" encoding="UTF-8"?>
<countries>
<country iso2="af" id="1">Afghanistan</country>
<country iso2="al" id="2">Albania</country>
....

I assume that the Regions and RegionsDesc tables in the database are used to populate the search drop-down box. Assuming that I can get my application restarted (still working on that) the new regions that I have added to these tables should show up there. Is this the only step that I need to perform or does a file that might be cached to disk also need to be removed and rebuilt?

What is the relationship, if any with the countries.xml file stored in each of the /loc/ directories to any of the database tables? We have very specific requirements regarding country/place names, and therefore I want to be sure that what all the country names are correct throughout the entire application. I assume that this file needs to be modified as well? If so, does the id in this XML file need to match a corresponding ID in the database? Do the ISO codes also need to match in the corresponding table in the database?

Thanks for any pointers.

Jason

________________________________

From: Mathieu Coudert [mailto:mathieu.coudert@anonymised.com]
Sent: Thu 2009-07-30 09:16
To: Luca Casagrande
Cc: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] customise template and regions list

Hi Luca,

On Wed, Jul 29, 2009 at 7:36 PM, Luca Casagrande
<luca.casagrande@anonymised.com>wrote:

Hi Mathieu,

2009/7/29 Mathieu Coudert <mathieu.coudert@anonymised.com>:
> Hi,
> On Wed, Jul 29, 2009 at 4:33 PM, Jose García <josegar74@anonymised.com>
wrote:
>
>> Hi Karibu
>>
>> The ddf files are loaded in the GeoNetwork database using GAST.
>>
>> The problem is that loading these files with GAST will delete your
actual
>> Geonetwork data and replace it with the content of default datafiles
>> (geonetwork\gast\setup\db\*.ddf), so if you have metadata or
customizations
>> (custom users, groups, ...) in GeoNetwork this method is not right for
you.
>>
>
> You could also use Druid to update only these two tables accessing your
> database using jdbc functionnality.
> Given that ddf is the default Druid format and means "database druid
> format", Druid seems to be the best tool to do such a thing.
>
> Druid project : http://druid.sourceforge.net/

I didn't know about Druid..thank you for this suggestion!
How can I open a ddf for editing?

With your preferred text editor (vi, gedit, ...) cause ddf files are text
files.

ciao,

Mathieu

Ciao
Luca

--
Dott. Ing. Luca Casagrande
Open Source GIS analyst and developer

Gfosservices SA

http://www.gfosservices.com/>
skype: lucacasagrande

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Jason_Pickering1 · August 3, 2009, 7:10am

Hi there. I am not sure if anyone can help me here. I have sent a few messages to the list on this topic, and I thought i would provide a bit more detail. I have customized the Regions and RegionsDesc table by deleting some entries, renaming some existing entries, and adding a few entries. Now, the drop-down box on the Geonetwork main page does not work. It returns this error

4672314 [http-8081-8] INFO main.home - Returning search data
4672319 [http-8081-8] INFO jeeves.service - -> transforming with stylesheet : (DELETED FOR SECURITY) webapps/geonetwork/xsl/main-page.xsl
4672655 [http-8081-8] INFO jeeves.service - -> end transformation for : main.home
4672656 [http-8081-8] INFO jeeves.service - -> output ended for : main.home
4672656 [http-8081-8] INFO jeeves.service - -> dispatch ended for : main.home
4683209 [http-8081-19] INFO jeeves.request - ==========================================================
4683209 [http-8081-19] INFO jeeves.request - HTML Request (from 158.232.12.166) : /geonetwork/srv/es/main.home
4683209 [http-8081-19] DEBUG jeeves.request - Method : GET
4683209 [http-8081-19] DEBUG jeeves.request - Content type : null
4683209 [http-8081-19] DEBUG jeeves.request - Accept : */*
4683209 [http-8081-19] INFO jeeves.service - Dispatching : main.home
4683209 [http-8081-19] DEBUG jeeves.service - -> no input parameters
4683209 [http-8081-19] INFO jeeves.service - -> dispatching to output for : main.home
4683304 [http-8081-19] INFO main.home - Returning search data
4683331 [http-8081-19] ERROR jeeves.service - Exception executing gui service : java.lang.NullPointerException
4683332 [http-8081-19] ERROR jeeves.service - (C) Stack trace is :
java.lang.NullPointerException
        at org.fao.geonet.lib.LocalLib.retrieve(LocalLib.java:216)
        at org.fao.geonet.lib.LocalLib.retrieve(LocalLib.java:124)
        at org.fao.geonet.guiservices.regions.Get.exec(Get.java:51)
        at jeeves.server.dispatchers.guiservices.Call.exec(Call.java:75)
        at jeeves.server.dispatchers.AbstractPage.invokeGuiService(AbstractPage.java:119)
        at jeeves.server.dispatchers.AbstractPage.invokeGuiServices(AbstractPage.java:104)
        at jeeves.server.dispatchers.ServiceManager.dispatchOutput(ServiceManager.java:588)
        at jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:382)
        at jeeves.server.JeevesEngine.dispatch(JeevesEngine.java:616)
        at jeeves.server.sources.http.JeevesServlet.execute(JeevesServlet.java:163)
        at jeeves.server.sources.http.JeevesServlet.doGet(JeevesServlet.java:88)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
        at java.lang.Thread.run(Thread.java:619)

Not particularly helpful. Any idea what is going on here?

Thanks and best regards,
Jason

________________________________

From: Pickering, Jason Paul [mailto:pickeringj@anonymised.com]
Sent: Wed 2009-07-29 20:08
To: Jose García; karibu
Cc: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] customise template and regions list

HI there. Well, the sysadmin told me he restarted it, but I am not 100% sure. I just want to be sure that there are no files that get cached to disk, and then need to be deleted and rebuilt (similar to the Lucence files).

Thanks,
Jason

________________________________

From: Jose García [mailto:josegar74@anonymised.com]
Sent: Wed 2009-07-29 17:37
To: Pickering, Jason Paul; karibu
Cc: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] customise template and regions list

Hi

Have you tried to restart geonetwork after the table changes? Regions data should be cached as normally doesn't change.

Regards,
Jose

        ----- Original Message -----
        From: Pickering, Jason Paul <mailto:pickeringj@anonymised.com>
        To: Jose García <mailto:josegar74@anonymised.com> ; karibu <mailto:kat_lore@anonymised.com>
        Cc: geonetwork-users@lists.sourceforge.net
        Sent: Wednesday, July 29, 2009 5:30 PM
        Subject: RE: [GeoNetwork-users] customise template and regions list

        HI there. I know I sent a message previously about what I thought was the solution to this problem, but now I must admit that I am a bit confused. I have customized the Regions and RegionsDesc tables in my MySQL database, but the drop down menu to select the regions in the Geonetwork main page still contain the old entries. Is this information cached someplace? Is it located anywhere inside of an XML file someplace besides the database? If so, then there are other issues for me that I will have to dig depper into.

        Thanks for the confirmation.

        Best regards,
        Jason

________________________________

        From: Jose García [mailto:josegar74@anonymised.com]
        Sent: Wed 2009-07-29 16:33
        To: karibu
        Cc: geonetwork-users@lists.sourceforge.net
        Subject: Re: [GeoNetwork-users] customise template and regions list

        Hi Karibu

        The ddf files are loaded in the GeoNetwork database using GAST.

        The problem is that loading these files with GAST will delete your actual
        Geonetwork data and replace it with the content of default datafiles
        (geonetwork\gast\setup\db\*.ddf), so if you have metadata or customizations
        (custom users, groups, ...) in GeoNetwork this method is not right for you.

        In this case te best solution is that you connect to the GeoNetwork database
        with some SQL client and add the custom data to the Regions and RegionsDes
        tables.

        Regards,
        Jose

        ----- Original Message -----
        From: "karibu" <kat_lore@anonymised.com>
        To: <geonetwork-users@lists.sourceforge.net>
        Sent: Wednesday, July 29, 2009 3:49 PM
        Subject: Re: [GeoNetwork-users] customise template and regions list

        >
        > Hi,
        > I customised the Regions.ddf and RegionsDes.ddf, but when I open
        > Geonetwork
        > the places list is still the same. Do I have to change any other file?
        > Thanks for your help.
        >
        >
        >
        >
        >
        >
        >
        >
        >
        >
        >
        > --
        > View this message in context:
        > http://n2.nabble.com/customise-template-and-regions-list-tp3343295p3349823.html
        > Sent from the GeoNetwork users mailing list archive at Nabble.com.
        >
        > ------------------------------------------------------------------------------
        > Let Crystal Reports handle the reporting - Free Crystal Reports 2008
        > 30-Day
        > trial. Simplify your report design, integration and deployment - and focus
        > on
        > what you do best, core application coding. Discover what's new with
        > Crystal Reports now. http://p.sf.net/sfu/bobj-july
        > _______________________________________________
        > GeoNetwork-users mailing list
        > GeoNetwork-users@lists.sourceforge.net
        > https://lists.sourceforge.net/lists/listinfo/geonetwork-users
        > GeoNetwork OpenSource is maintained at
        > http://sourceforge.net/projects/geonetwork
        >

        ------------------------------------------------------------------------------
        Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
        trial. Simplify your report design, integration and deployment - and focus on
        what you do best, core application coding. Discover what's new with
        Crystal Reports now. http://p.sf.net/sfu/bobj-july
        _______________________________________________
        GeoNetwork-users mailing list
        GeoNetwork-users@lists.sourceforge.net
        https://lists.sourceforge.net/lists/listinfo/geonetwork-users
        GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Jason_Pickering1 · August 4, 2009, 5:58am

Hi there. I managed to solve this issue, and am just going to document it for the list. I needed to make a number of modifications to the regions drop down selection box on the search panel. I started by making modifications to the RegionsDesc table, modifying country names, adding a few entries, and removing others. I added new entries (with a corresponding bounding lat/long) to the Regions table, but did not delete the corresponding entries to the Regions table. After a restart, the drop-down list in the search panel stopped working, and gave the error listed below.

I poked around in the code a bit, and it seems that there must be at least a one-to-many relationship between the Regions and RegionsDesc tables. I had a number of entries that had been deleted from the RegionsDesc table, with corresponding entries still present in the Regions table. This seems to have caused the error documented below. By removing all entries in these orphaned entries in the Regions table, everything started to work again.

FYI in case anyone else needs to do this.

Regards,
Jason

________________________________

From: Pickering, Jason Paul [mailto:pickeringj@anonymised.com]
Sent: Mon 2009-08-03 09:10
To: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] customise template and regions list

Hi there. I am not sure if anyone can help me here. I have sent a few messages to the list on this topic, and I thought i would provide a bit more detail. I have customized the Regions and RegionsDesc table by deleting some entries, renaming some existing entries, and adding a few entries. Now, the drop-down box on the Geonetwork main page does not work. It returns this error

4672314 [http-8081-8] INFO main.home - Returning search data
4672319 [http-8081-8] INFO jeeves.service - -> transforming with stylesheet : (DELETED FOR SECURITY) webapps/geonetwork/xsl/main-page.xsl
4672655 [http-8081-8] INFO jeeves.service - -> end transformation for : main.home
4672656 [http-8081-8] INFO jeeves.service - -> output ended for : main.home
4672656 [http-8081-8] INFO jeeves.service - -> dispatch ended for : main.home
4683209 [http-8081-19] INFO jeeves.request - ==========================================================
4683209 [http-8081-19] INFO jeeves.request - HTML Request (from 158.232.12.166) : /geonetwork/srv/es/main.home
4683209 [http-8081-19] DEBUG jeeves.request - Method : GET
4683209 [http-8081-19] DEBUG jeeves.request - Content type : null
4683209 [http-8081-19] DEBUG jeeves.request - Accept : */*
4683209 [http-8081-19] INFO jeeves.service - Dispatching : main.home
4683209 [http-8081-19] DEBUG jeeves.service - -> no input parameters
4683209 [http-8081-19] INFO jeeves.service - -> dispatching to output for : main.home
4683304 [http-8081-19] INFO main.home - Returning search data
4683331 [http-8081-19] ERROR jeeves.service - Exception executing gui service : java.lang.NullPointerException
4683332 [http-8081-19] ERROR jeeves.service - (C) Stack trace is :
java.lang.NullPointerException
        at org.fao.geonet.lib.LocalLib.retrieve(LocalLib.java:216)
        at org.fao.geonet.lib.LocalLib.retrieve(LocalLib.java:124)
        at org.fao.geonet.guiservices.regions.Get.exec(Get.java:51)
        at jeeves.server.dispatchers.guiservices.Call.exec(Call.java:75)
        at jeeves.server.dispatchers.AbstractPage.invokeGuiService(AbstractPage.java:119)
        at jeeves.server.dispatchers.AbstractPage.invokeGuiServices(AbstractPage.java:104)
        at jeeves.server.dispatchers.ServiceManager.dispatchOutput(ServiceManager.java:588)
        at jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:382)
        at jeeves.server.JeevesEngine.dispatch(JeevesEngine.java:616)
        at jeeves.server.sources.http.JeevesServlet.execute(JeevesServlet.java:163)
        at jeeves.server.sources.http.JeevesServlet.doGet(JeevesServlet.java:88)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
        at java.lang.Thread.run(Thread.java:619)

Not particularly helpful. Any idea what is going on here?

Thanks and best regards,
Jason

________________________________

From: Pickering, Jason Paul [mailto:pickeringj@anonymised.com]
Sent: Wed 2009-07-29 20:08
To: Jose García; karibu
Cc: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] customise template and regions list

HI there. Well, the sysadmin told me he restarted it, but I am not 100% sure. I just want to be sure that there are no files that get cached to disk, and then need to be deleted and rebuilt (similar to the Lucence files).

Thanks,
Jason

________________________________

From: Jose García [mailto:josegar74@anonymised.com]
Sent: Wed 2009-07-29 17:37
To: Pickering, Jason Paul; karibu
Cc: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] customise template and regions list

Hi

Have you tried to restart geonetwork after the table changes? Regions data should be cached as normally doesn't change.

Regards,
Jose

        ----- Original Message -----
        From: Pickering, Jason Paul <mailto:pickeringj@anonymised.com>
        To: Jose García <mailto:josegar74@anonymised.com> ; karibu <mailto:kat_lore@anonymised.com>
        Cc: geonetwork-users@lists.sourceforge.net
        Sent: Wednesday, July 29, 2009 5:30 PM
        Subject: RE: [GeoNetwork-users] customise template and regions list

        HI there. I know I sent a message previously about what I thought was the solution to this problem, but now I must admit that I am a bit confused. I have customized the Regions and RegionsDesc tables in my MySQL database, but the drop down menu to select the regions in the Geonetwork main page still contain the old entries. Is this information cached someplace? Is it located anywhere inside of an XML file someplace besides the database? If so, then there are other issues for me that I will have to dig depper into.

        Thanks for the confirmation.

        Best regards,
        Jason

________________________________

        From: Jose García [mailto:josegar74@anonymised.com]
        Sent: Wed 2009-07-29 16:33
        To: karibu
        Cc: geonetwork-users@lists.sourceforge.net
        Subject: Re: [GeoNetwork-users] customise template and regions list

        Hi Karibu

        The ddf files are loaded in the GeoNetwork database using GAST.

        The problem is that loading these files with GAST will delete your actual
        Geonetwork data and replace it with the content of default datafiles
        (geonetwork\gast\setup\db\*.ddf), so if you have metadata or customizations
        (custom users, groups, ...) in GeoNetwork this method is not right for you.

        In this case te best solution is that you connect to the GeoNetwork database
        with some SQL client and add the custom data to the Regions and RegionsDes
        tables.

        Regards,
        Jose

        ----- Original Message -----
        From: "karibu" <kat_lore@anonymised.com>
        To: <geonetwork-users@lists.sourceforge.net>
        Sent: Wednesday, July 29, 2009 3:49 PM
        Subject: Re: [GeoNetwork-users] customise template and regions list

        >
        > Hi,
        > I customised the Regions.ddf and RegionsDes.ddf, but when I open
        > Geonetwork
        > the places list is still the same. Do I have to change any other file?
        > Thanks for your help.
        >
        >
        >
        >
        >
        >
        >
        >
        >
        >
        >
        > --
        > View this message in context:
        > http://n2.nabble.com/customise-template-and-regions-list-tp3343295p3349823.html
        > Sent from the GeoNetwork users mailing list archive at Nabble.com.
        >
        > ------------------------------------------------------------------------------
        > Let Crystal Reports handle the reporting - Free Crystal Reports 2008
        > 30-Day
        > trial. Simplify your report design, integration and deployment - and focus
        > on
        > what you do best, core application coding. Discover what's new with
        > Crystal Reports now. http://p.sf.net/sfu/bobj-july
        > _______________________________________________
        > GeoNetwork-users mailing list
        > GeoNetwork-users@lists.sourceforge.net
        > https://lists.sourceforge.net/lists/listinfo/geonetwork-users
        > GeoNetwork OpenSource is maintained at
        > http://sourceforge.net/projects/geonetwork
        >

        ------------------------------------------------------------------------------
        Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
        trial. Simplify your report design, integration and deployment - and focus on
        what you do best, core application coding. Discover what's new with
        Crystal Reports now. http://p.sf.net/sfu/bobj-july
        _______________________________________________
        GeoNetwork-users mailing list
        GeoNetwork-users@lists.sourceforge.net
        https://lists.sourceforge.net/lists/listinfo/geonetwork-users
        GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

TimoB · January 3, 2011, 2:53pm

Hi list !
This post is very useful to get started with changes in the regions list.
I would like some advice to customize this list in a different way.
Most of the data in our catalog regards a specific region of France, with
subregions. Most of the regions in the original lists are at the country
level or even bigger regions, whereas our regions would be smaller.
Would anyone have advice to give about how to make the list show these
specific regions first, at the top of the list, disregarding the
alphabetical order ?
It would be something like:

- Any -
- User defined -
France
Rhone-Alpes
Isère
Drôme
Vercors
---
Afghanistan
Africa
Albania

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/customise-template-and-regions-list-tp3343295p5880863.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

TimoB · January 3, 2011, 2:55pm

Hi list !
This post is very useful to get started with changes in the regions list.
I would like some advice to customize this list in a different way.
Most of the data in our catalog regards a specific region of France, with
subregions. Most of the regions in the original lists are at the country
level or even bigger regions, whereas our regions would be smaller.
Would anyone have advice to give about how to make the list show these
specific regions first, at the top of the list, disregarding the
alphabetical order ?
It would be something like:

- Any -
- User defined -
France
Rhone-Alpes
Isère
Drôme
Vercors
---
Afghanistan
Africa
Albania

Best regards,
Tim

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/customise-template-and-regions-list-tp3343295p5880869.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.