Project

General

Profile

1
INSERT INTO datasources (_dnet_resource_identifier_, id, officialname, englishname, websiteurl, logourl, contactemail, latitude, longitude, timezone, namespaceprefix, collectedfrom, datasourceclass)
2
VALUES ('openaire____::erc', 'openaire____::erc', 'European Research Council (ERC)', 'European Research Council (ERC)', 'http://erc.europa.eu',
3
                             'http://erc.europa.eu/sites/default/files/content/LOGO-ERC.jpg', 'Alexis-Michel.MUGABUSHAKA@ec.europa.eu', 50.85, 4.35, 1,
4
                             'erc_________', 'infrastruct_::openaire', 'pubsrepository::unknown');
5
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass)
6
VALUES ('api_________::erc::0', 'api_________::erc::0', 'file', 'openaire____::erc', 'pubsrepository::unknown', 'openaire3.0');
7
INSERT INTO apicollections (param, original, api) VALUES ('baseUrl', 'file:///var/lib/dnet/erc/PUB_REPORTED.xml', 'api_________::erc::0');
8
INSERT INTO apicollections (param, original, api) VALUES ('splitOnElement', 'RECORD', 'api_________::erc::0');
9
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '//PUB_ID', 'api_________::erc::0', FALSE);
10

    
11
UPDATE apicollections
12
SET _dnet_resource_identifier_ = api || '@@' || param;
(11-11/13)