INSERT INTO dsm_datasources (id, officialname, namespaceprefix, typology)
VALUES
('openaire____::nserc', 'Natural Sciences and Engineering Research Council of Canada', 'nserc_______', 'entityregistry::projects'),
('openaire____::sshrc', 'Social Sciences and Humanities Research Council', 'sshrc_______', 'entityregistry::projects'),
('openaire____::cihr', 'Canadian Institutes of Health Research', 'cihr________','entityregistry::projects');
INSERT INTO dsm_organizations (id, legalshortname,legalname)
VALUES
('nserc_______::NSERC','NSERC','Natural Sciences and Engineering Research Council of Canada'),
('sshrc_______::SSHRC','SSHRC','Social Sciences and Humanities Research Council'),
('cihr________::CIHR','CIHR','Canadian Institutes of Health Research');
INSERT INTO fundingpaths (id,path,funder,jurisdiction)
VALUES
('nserc_______::NSERC','
nserc_______::NSERC
NSERC
Natural Sciences and Engineering Research Council of Canada
Natural Sciences and Engineering Research Council of Canada
CA
', 'nserc_______::NSERC','CA'),
('sshrc_______::SSHRC','
sshrc_______::SSHRC
SSHRC
Social Sciences and Humanities Research Council
Social Sciences and Humanities Research Council
CA
', 'sshrc_______::SSHRC','CA'),
('cihr________::CIHR','
cihr________::CIHR
CIHR
Canadian Institutes of Health Research
Canadian Institutes of Health Research
CA
', 'cihr________::CIHR','CA');
INSERT INTO projects (id, code, title, collectedfrom, provenanceactionclass)
VALUES
('nserc_______::unidentified', 'unidentified', 'unidentified', 'openaire__::nserc', 'sysimport:crosswalk:entityregistry'),
('sshrc_______::unidentified', 'unidentified', 'unidentified', 'openaire__::sshrc', 'sysimport:crosswalk:entityregistry'),
('cihr________::unidentified', 'unidentified', 'unidentified', 'openaire__::cihr', 'sysimport:crosswalk:entityregistry');
INSERT INTO project_fundingpath (funding, project)
VALUES
('nserc_______::NSERC', 'nserc_______::unidentified'),
('sshrc_______::SSHRC', 'sshrc_______::unidentified'),
('cihr________::CIHR', 'cihr________::unidentified');