Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
beta_projects_drop.sql 1.21 KB 59460 over 1 year Alessia Bardi #5976: remove from beta the funders already in ...
fix_org_ids.sql 2.22 KB 59676 about 1 year Alessia Bardi Procedure for #6000
increase_size_re3data_fields.sql 474 Bytes 56553 over 2 years Alessia Bardi #4689: changed type for missionstatementurl on ...
incrementalTransformation_migration.xqueries 2.06 KB 52390 over 3 years Alessia Bardi Updated instructions to migrate to incremental ...
materialised_views.sql 9.13 KB 59018 over 1 year Alessia Bardi exclude projects from BETA funders in the view ...
migrate-projects.sql 4.15 KB 59015 over 1 year Alessia Bardi Missing ';' to properly end statements
migrate_dsm.sql 8.26 KB 53133 over 3 years Claudio Atzori updated materialised view update script. Adjust...
patch-constraints.sql 2.93 KB 48139 over 4 years Alessia Bardi integrated (hopefully) all required changes fro...
patch-fct.sql 2.43 KB 48139 over 4 years Alessia Bardi integrated (hopefully) all required changes fro...
patch-fundingpaths.sql 3.77 KB 59186 over 1 year Alessia Bardi Instructions to address the path of multiple fu...
patch-identities.sql 5.1 KB 48139 over 4 years Alessia Bardi integrated (hopefully) all required changes fro...
patch-jsonextrainfo.sql 66 Bytes 48139 over 4 years Alessia Bardi integrated (hopefully) all required changes fro...
patch-pics.sql 600 Bytes 61029 8 months Alessia Bardi Do not prepend PIC to the PIC number, as reques...
patch-projects-summary-amount.sql 411 Bytes 57652 about 2 years Alessia Bardi #4962: patching db for summary and funded amount
patch-unidentifiedProjects.sql 647 Bytes 60978 9 months Miriam Baglioni changed the collectedfrom to the one of the dat...
patch.sql 19.6 KB 55762 over 2 years Claudio Atzori reintegrated branch solr75 -r53774:HEAD
patch_arc_and_ands.sql 2.72 KB 59186 over 1 year Alessia Bardi Instructions to address the path of multiple fu...
patch_canadian_funder.sql 3.01 KB 60979 9 months Miriam Baglioni changed the collectedfrom as the id of the data...
patch_countries_yugoslavia.sql 1.47 KB 58842 over 1 year Alessia Bardi #5603: Yugoslavian orgs
patch_dsTypes.sql 1.25 KB 55762 over 2 years Claudio Atzori reintegrated branch solr75 -r53774:HEAD
patch_erc_pubsrepository.sql 1.27 KB 48139 over 4 years Alessia Bardi integrated (hopefully) all required changes fro...
patch_funder_countries.sql 103 Bytes 57678 about 2 years Alessia Bardi Query to patch the missing countries for funders.
patch_h2020.sql 3.16 KB 48139 over 4 years Alessia Bardi integrated (hopefully) all required changes fro...
patch_hostedbymap.sql 140 Bytes 49745 about 4 years Alessia Bardi new patch db file for manually added hostedby e...
patch_org_countries.sql 1.04 KB 57810 about 2 years Alessia Bardi Fixing countries for organizations coming from ...
patch_pangaea_doaj.sql 6.92 KB 50489 almost 4 years Michele Artini merged branch dsm into trunk
triggers.sql 1.02 KB 53725 about 3 years Alessia Bardi updated to new tables of dsm

Latest revisions

# Date Author Comment
61029 20/05/2021 12:24 Alessia Bardi

Do not prepend PIC to the PIC number, as requested by the EC DG staff member

60979 07/05/2021 14:52 Miriam Baglioni

changed the collectedfrom as the id of the datasource for the funder. Added the insertion of the datasources in the database

60978 07/05/2021 14:51 Miriam Baglioni

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)

59676 23/10/2020 17:44 Alessia Bardi

Procedure for #6000

59460 23/09/2020 18:03 Alessia Bardi

#5976: remove from beta the funders already in production

59186 29/07/2020 11:52 Alessia Bardi

Instructions to address the path of multiple funding paths: see also #5695

59020 29/06/2020 18:07 Alessia Bardi

#5695 : addressing the cleanup of projects with multiple funding paths

59018 29/06/2020 17:52 Alessia Bardi

exclude projects from BETA funders in the view used by the IIS in production

59015 29/06/2020 16:55 Alessia Bardi

Missing ';' to properly end statements

59013 29/06/2020 16:37 Alessia Bardi

fixed table name

View revisions

Also available in: Atom