Project

General

Profile

Statistics
| Revision:

# Date Author Comment
59013 29/06/2020 04:37 PM Alessia Bardi

fixed table name

59012 29/06/2020 04:29 PM Alessia Bardi

SQL commands to copy projects from beta to prod

59000 26/06/2020 03:00 PM Alessia Bardi

No UNKNOWN funding streams for FP7

58842 04/06/2020 05:03 PM Alessia Bardi

#5603: Yugoslavian orgs

57810 04/12/2019 03:24 PM Alessia Bardi

Fixing countries for organizations coming from NSF annd not only

57678 25/11/2019 05:25 PM Alessia Bardi

Query to patch the missing countries for funders.

57652 20/11/2019 05:10 PM Alessia Bardi

#4962: patching db for summary and funded amount

57353 11/10/2019 05:38 PM Claudio Atzori

added summary, totalcost and fundedamount to the projects_mv materialized view

57300 08/10/2019 10:21 AM Alessia Bardi

#4967: change for datasources

57268 04/10/2019 02:32 PM Claudio Atzori

removed optional2 and optional2 from project_details table

56553 15/07/2019 04:14 PM Alessia Bardi

#4689: changed type for missionstatementurl on dsm_datasources

55762 28/05/2019 11:26 AM Claudio Atzori

reintegrated branch solr75 -r53774:HEAD

53725 12/11/2018 06:05 PM Alessia Bardi

updated to new tables of dsm

53708 09/11/2018 07:01 PM Claudio Atzori

using dsm_identities in materialised projects view

53133 14/09/2018 05:53 PM Claudio Atzori

updated materialised view update script. Adjusted db mgration procedure.

52973 22/08/2018 12:24 PM Alessia Bardi

SQL INSERTs to add the unidentified project for MIUR, as suggested in #3683#note-19

52390 07/06/2018 06:30 PM Alessia Bardi

Updated instructions to migrate to incremental transformation

52367 05/06/2018 05:03 PM Alessia Bardi

Added provenanceactionclass for wt unidentified project

52338 04/06/2018 04:20 PM Alessia Bardi

take lastupdate in consideration for orgs and projects

52325 04/06/2018 02:47 PM Claudio Atzori

using dsm_datasources in sql expressions

52294 31/05/2018 11:22 AM Alessia Bardi

To support incremental update of projects in the database, useful functionality of IncrementalTransformationJobNode has been extracted to a superclass. Wf template for entity registries has been updated accordingly. Wf templates for other types of ds that were already in incremental mode have been updated for the new param name inherited from the superclass.

52191 24/05/2018 11:02 AM Claudio Atzori

distinct fundingpaths in projects_mv

52120 22/05/2018 10:09 AM Alessia Bardi

xqueries to turn all aggregation workflow with incremental transformation

51516 26/03/2018 06:19 PM Claudio Atzori

using dsm_datasources instead of datasources table, fixed datasource data migration rules for languages and od_contenttypes

51176 13/03/2018 12:07 PM Claudio Atzori

utility file we can use to disable/enable the table triggers to speedup manual operations

51175 13/03/2018 12:07 PM Claudio Atzori

assume the view orgs is already there

50724 13/02/2018 03:33 PM Claudio Atzori

depending on released parent

50489 30/01/2018 11:27 AM Michele Artini

merged branch dsm into trunk

49745 30/10/2017 03:13 PM Alessia Bardi

new patch db file for manually added hostedby entries

48962 13/09/2017 06:09 PM Claudio Atzori

added contact details to the projects_mv materialised view

48651 20/07/2017 05:06 PM Claudio Atzori

fixed param names

48518 10/07/2017 08:13 PM Alessia Bardi

Updated migration sql statements

48460 07/07/2017 06:30 PM Claudio Atzori

updated views definitions

48165 29/06/2017 04:29 PM Claudio Atzori

updated DSM migration instructions

48139 28/06/2017 06:40 PM Alessia Bardi

integrated (hopefully) all required changes from dnet40

47021 28/04/2017 06:21 PM Claudio Atzori

early version

45281 10/01/2017 06:36 PM Claudio Atzori

codebase used to migrate to java8 the production system