INSERT INTO datasources (_dnet_resource_identifier_, id, officialname, englishname, websiteurl, logourl, contactemail, latitude, longitude, timezone, namespaceprefix, collectedfrom, datasourceclass)
VALUES ('openaire____::ands', 'openaire____::ands', 'Australian National Data Service (ANDS) - Grants Registry',
                              'Australian National Data Service (ANDS) - Grants Registry', 'http://www.ands.org.au/index.html',
                              'http://www.ands.org.au/assets/images/ands-full-b.png', 'contact@ands.org.au', -34.2333, 140.5667, 10.50, 'ands________',
        'infrastruct_::openaire', 'entityregistry');
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass)
VALUES ('api_________::ands::0', 'api_________::ands::0', 'filesystem', 'openaire____::ands', 'entityregistry', 'native');
INSERT INTO apicollections (param, original, api) VALUES ('baseUrl', 'file:///var/lib/dnet/ands', 'api_________::ands::0');
INSERT INTO apicollections (param, original, api) VALUES ('extensions', 'xml', 'api_________::ands::0');
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '/project/id', 'api_________::ands::0', FALSE);

INSERT INTO datasources (_dnet_resource_identifier_, id, officialname, englishname, websiteurl, logourl, contactemail, latitude, longitude, timezone, namespaceprefix, collectedfrom, datasourceclass)
VALUES ('openaire____::arc', 'openaire____::arc', 'Australian Research Council (ARC) - Grants Registry', 'Australian Research Council (ARC) - Grants Registry',
                             'http://www.arc.gov.au/', 'http://www.arc.gov.au/images/screen_logo.gif', 'info@arc.gov.au', -33.9, 151.1833, 11.0, 'arc_________',
        'infrastruct_::openaire', 'entityregistry');
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass)
VALUES ('api_________::arc::0', 'api_________::arc::0', 'filesystem', 'openaire____::arc', 'entityregistry', 'native');
INSERT INTO apicollections (param, original, api) VALUES ('baseUrl', 'file:///var/lib/dnet/arc', 'api_________::arc::0');
INSERT INTO apicollections (param, original, api) VALUES ('extensions', 'xml', 'api_________::arc::0');
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '/project/id', 'api_________::arc::0', FALSE);

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

insert into dsm_organizations(id, legalname, legalshortname, country, dateofcollection, _dnet_resource_identifier_, lastupdate, trust) VALUES ('arc_________::ARC', 'Australian Research Council (ARC)', 'ARC', 'AU',  '2018-06-08', 'arc_________::ARC', '2020-07-18', 0.9);