D-Net

-- European Commission FP7

-- FCT

-- copy the good ones from the other db

\copy  (select * from project_fundingpath where project like 'fct\_\_\_\_\_\_\_\_\_%') TO '/tmp/fct_project_fundingpath-prod.sql' CSV;

-- do the following on the bad ones

delete from project_fundingpath where project like 'fct\_\_\_\_\_\_\_\_\_%';

CREATE TEMP TABLE fct (

_dnet_resource_identifier_ VARCHAR(2048),

funding varchar(255),

project varchar(255),

startdate date,

enddate date,

semanticclass varchar(255),

semanticscheme varchar(255),

optional1 varchar(255),

optional2 varchar(255)

);

 \copy fct from '/tmp/fct_project_fundingpath-prod.sql' CSV;

 INSERT INTO project_fundingpath select * from fct;

 -- fct is a temp table and will be dropped when you log out

-- SFI

delete from project_fundingpath where funding = 'sfi_________::SFI::SFI US Ireland R&D Partnership - Planning Grant';

delete from project_fundingpath where funding ='sfi_________::SFI::SFI Stokes Professorship & Lectureship Programme';

delete from project_fundingpath where funding ='sfi_________::SFI::SFI US Ireland R&D Partnership';

delete from project_fundingpath where funding = 'sfi_________::SFI::China / Ireland Science & Technology Collaboration Research Fund�';

delete from fundingpaths  where id = 'sfi_________::SFI::China / Ireland Science & Technology Collaboration Research Fund�';

delete from fundingpaths  where id ='sfi_________::SFI::SFI US Ireland R&D Partnership';

delete from fundingpaths  where id = 'sfi_________::SFI::SFI Stokes Professorship & Lectureship Programme';

delete from fundingpaths  where id = 'sfi_________::SFI::SFI US Ireland R&D Partnership - Planning Grant';

select count(distinct project) from project_fundingpath where project like 'sfi%';

select count(distinct id) from projects where id like 'sfi%';