Importing more data


Permalink 02:40:52 pm, by Greg, 54 words, 92 views   English (CA)
Categories: Tasks; Mins. worked: 0

Importing more data

Importing the CGWP records that have matching CVWM rows produces about 10,600 results.
Of those, 173 seem to be duplicates.
We need someone to go through them and weed out dupes.
This is the sql to get those records:

select * from transfer ou
where (select count(*) from transfer inr
where inr.cwgc_id = ou.cwgc_id) > 1


No Pingbacks for this post yet...


Development blog for next version of the Canadian Great War Project. The production site is at, and the development site is at (access controlled)

Some sections of the development site are not explicitly linked via menus. See the post titled "CGWP development URLs" for details.


XML Feeds