1
|
INSERT INTO dsm_organizations (id, legalshortname,legalname)
|
2
|
VALUES
|
3
|
('nserc_______::NSERC','NSERC','Natural Sciences and Engineering Research Council of Canada'),
|
4
|
('sshrc_______::SSHRC','SSHRC','Social Sciences and Humanities Research Council'),
|
5
|
('cihr________::CIHR','CIHR','Canadian Institutes of Health Research');
|
6
|
|
7
|
INSERT INTO fundingpaths (id,path,funder,jurisdiction)
|
8
|
VALUES
|
9
|
('nserc_______::NSERC','<fundingtree>
|
10
|
<funder>
|
11
|
<id>nserc_______::NSERC</id>
|
12
|
<shortname>NSERC</shortname>
|
13
|
<name>Natural Sciences and Engineering Research Council of Canada</name>
|
14
|
<originalname>Natural Sciences and Engineering Research Council of Canada</originalname>
|
15
|
<jurisdiction>CA</jurisdiction>
|
16
|
</funder>
|
17
|
</fundingtree>', 'nserc_______::NSERC','CA'),
|
18
|
('sshrc_______::SSHRC','<fundingtree>
|
19
|
<funder>
|
20
|
<id>sshrc_______::SSHRC</id>
|
21
|
<shortname>SSHRC</shortname>
|
22
|
<name>Social Sciences and Humanities Research Council</name>
|
23
|
<originalname>Social Sciences and Humanities Research Council</originalname>
|
24
|
<jurisdiction>CA</jurisdiction>
|
25
|
</funder>
|
26
|
</fundingtree>', 'sshrc_______::SSHRC','CA'),
|
27
|
('cihr________::CIHR','<fundingtree>
|
28
|
<funder>
|
29
|
<id>cihr________::CIHR</id>
|
30
|
<shortname>CIHR</shortname>
|
31
|
<name>Canadian Institutes of Health Research</name>
|
32
|
<originalname>Canadian Institutes of Health Research</originalname>
|
33
|
<jurisdiction>CA</jurisdiction>
|
34
|
</funder>
|
35
|
</fundingtree>', 'cihr________::CIHR','CA');
|
36
|
|
37
|
INSERT INTO projects (id, code, title, collectedfrom, provenanceactionclass)
|
38
|
VALUES
|
39
|
('nserc_______::unidentified', 'unidentified', 'unidentified', 'infrastruct_::openaire', 'sysimport:crosswalk:entityregistry'),
|
40
|
('sshrc_______::unidentified', 'unidentified', 'unidentified', 'infrastruct_::openaire', 'sysimport:crosswalk:entityregistry'),
|
41
|
('cihr________::unidentified', 'unidentified', 'unidentified', 'infrastruct_::openaire', 'sysimport:crosswalk:entityregistry');
|
42
|
|
43
|
INSERT INTO project_fundingpath (funding, project)
|
44
|
VALUES
|
45
|
('nserc_______::NSERC', 'nserc_______::unidentified'),
|
46
|
('sshrc_______::SSHRC', 'sshrc_______::unidentified'),
|
47
|
('cihr________::CIHR', 'cihr________::unidentified');
|
48
|
|
49
|
|