D-Net

INSERT INTO datasources (_dnet_resource_identifier_, id, officialname, englishname, websiteurl, logourl, contactemail, latitude, longitude, timezone, namespaceprefix, collectedfrom, datasourceclass) VALUES ('openaire____::erc', 'openaire____::erc', 'European Research Council (ERC)', 'European Research Council (ERC)', 'http://erc.europa.eu', 'http://erc.europa.eu/sites/default/files/content/LOGO-ERC.jpg', 'Alexis-Michel.MUGABUSHAKA@ec.europa.eu', 50.85, 4.35, 1, 'erc_________', 'infrastruct_::openaire', 'pubsrepository::unknown');

INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass) VALUES ('api_________::erc::0', 'api_________::erc::0', 'file', 'openaire____::erc', 'pubsrepository::unknown', 'openaire3.0');

INSERT INTO apicollections (param, original, api) VALUES ('baseUrl', 'file:///var/lib/dnet/erc/PUB_REPORTED.xml', 'api_________::erc::0');

INSERT INTO apicollections (param, original, api) VALUES ('splitOnElement', 'RECORD', 'api_________::erc::0');

INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '//PUB_ID', 'api_________::erc::0', false);

UPDATE apicollections SET _dnet_resource_identifier_ = api||'@@'||param;