changed the collectedfrom as the id of the datasource for the funder. Added the insertion of the datasources in the database
changed the collectedfrom to the one of the datasource of the funder instead of openaire (to have the collectedfrom as the id of the openaire datasource made the projects to be associated to openaire)
Procedure for #6000
#5976: remove from beta the funders already in production
Instructions to address the path of multiple funding paths: see also #5695
#5695 : addressing the cleanup of projects with multiple funding paths
exclude projects from BETA funders in the view used by the IIS in production
Missing ';' to properly end statements
fixed table name
SQL commands to copy projects from beta to prod
No UNKNOWN funding streams for FP7
#5603: Yugoslavian orgs
Fixing countries for organizations coming from NSF annd not only
Query to patch the missing countries for funders.
#4962: patching db for summary and funded amount
added summary, totalcost and fundedamount to the projects_mv materialized view
#4967: change for datasources
removed optional2 and optional2 from project_details table
#4689: changed type for missionstatementurl on dsm_datasources
reintegrated branch solr75 -r53774:HEAD
updated to new tables of dsm
using dsm_identities in materialised projects view
updated materialised view update script. Adjusted db mgration procedure.
SQL INSERTs to add the unidentified project for MIUR, as suggested in #3683#note-19
Updated instructions to migrate to incremental transformation
Added provenanceactionclass for wt unidentified project
take lastupdate in consideration for orgs and projects
using dsm_datasources in sql expressions
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.
distinct fundingpaths in projects_mv
xqueries to turn all aggregation workflow with incremental transformation
using dsm_datasources instead of datasources table, fixed datasource data migration rules for languages and od_contenttypes
utility file we can use to disable/enable the table triggers to speedup manual operations
assume the view orgs is already there
depending on released parent
merged branch dsm into trunk
new patch db file for manually added hostedby entries
added contact details to the projects_mv materialised view
fixed param names
Updated migration sql statements
updated views definitions
updated DSM migration instructions
integrated (hopefully) all required changes from dnet40
early version
codebase used to migrate to java8 the production system