Importing more data

27/09/16

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

Pingbacks:

No Pingbacks for this post yet...

CGWP

Development blog for next version of the Canadian Great War Project. The production site is at https://cgwp.uvic.ca/, and the development site is at https://cgwpdev.uvic.ca/ (access controlled)

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

Reports

XML Feeds