FAO Home

AgriOcean Installation files

Hi guys, i need make two consults  First, is possible to install trough binaries files. If is this possible, how to download the files.

I need your help in this topic.

Vote

1 Mar 2012
Luis Rojas

Installation

Thanks all for your support.

Now I was trying to install AgriOcean in windows server 2000 r2, but when the installation is about to end,  is generated an error and the application don't have a connection with the data base and the posgresql manager not is possible to start.  

I need your help, please

If possible througth of skype or messenger...Thanks
10 Feb 2012
Denys Slipetskyy

migration from old DSpace version

As Marc said before, the main problem is database update/migration.

What have we done at IBSS (we also migrated from OceanDocs/DSpace 1.4 to AgriOcean/Dspace 1.7.2):

  1. BACKUP everything .... golden rule :) 

  2. created new virtual server in parallel to production one;

  3. installed AgriOcean;

  4. replace new created empty database with our production one;

  5. apply update sql scripts from DSpace installation to current database (there are scripts for DB schema update in [dspace]/etc/postgres directory);

  6. added tables for authority control (issn, agrovoc & asfa keywords);

  7. update design and visual styles (logo, color ... )

After that we had working system, except that some old Dublin Core fields must be updated. It was done directly in database (using pgAdmin tool and SQL queries). Marc and I can provide that scripts we used + you will need to do some fields update, depending on your situation.

Summary: it is really possible to upgrade from DSpace 1.4 to AgriOcean DSpace. It will require some SQL work to update DB schema  (but in our case it was even less work than I expected before ...).

 

10 Feb 2012
Marc Goovaerts

There is one major problem

There is one major problem that Denys overlooked because he already started from richer metadata (where the citation of journal or proceedings is already split up to its atomic value): How to create these granular metadata values (e.g. journal title, volume, issue, starting page, etc. out of identifier.citation). I remember that one of our students created in the past an application to do that, but still manual control was necessary.

Marc

10 Feb 2012
Denys Slipetskyy

Yes, correct. We started

Yes, correct.

We started from OceanDocs 1.4, not pure DSpace.
mmm .... actually if you figure out how to split original fields in more granular one, you can write small java task - walk through all items in cycle and refine it's metadata.


Migration...

Hello, we have the same problem with our repository http://www2.cita-aragon.es/citarea/but we have  another version 1.5.2. It could be perfect if we could create a working group to help us in this process because our IT staff are not specialized in Dspace software.

Andrés Yubero Cortés

******************************************************
Centro de Investigación y Tecnología
Agroalimentaria de Aragón (CITA)

Avda. Montañana 930 - 50059 Zaragoza
Telf. +34 976713219 / Email: ayubero@aragon.es
******************************************************
9 Feb 2012
Marc Goovaerts

It is possible, but it is not

It is possible, but it is not a straight process.

Originally OceanDocs started as a standard Dspace 1.3 and it was gradually upgraded to the actual AgriOcean Dspace standard. The metadata of the old records will not be as refined as the standards used in AgriOcean Dspace and will give conflicts in the OAI export for Agris AP and MODS.

Updating means essentially working on the postgresql database:
- using the update sql commands of Dspace from 1.4.2 to 1.7
- change the type element to the terms used by AgriOcean Dspace
- translate identifier.citation to specific refined elements
- add Agrovoc terms (with term code as authority ID)


Marc Goovaerts