Page 1 of 5 12345 LastLast
Results 1 to 10 of 44

Thread: Request CROWD SOURCING Help : Update 2200 odd CWGC Records from existing Forum Posts

  1. #1
    Join Date
    Jan 2008
    Location
    Delaware, USA
    Posts
    1,492
    Thanks
    754
    Thanked 205 Times in 144 Posts

    Default Request CROWD SOURCING Help : Update 2200 odd CWGC Records from existing Forum Posts



    Data Updates to be made in the link below:


    Google Sheet Link : https://docs.google.com/spreadsheets...it?usp=sharing

    -----------------------------------------
    All, As we are reaching the milestone of less than 3000 records remaining, I am taking this opportunity to ask for help from forum members for a crowd sourcing effort.


    In the early days of the CWGC database, I had only updated forum posts links and did not have the ability to populate the cause of 'death' for many of the records. Thus a record will show up as :

    http://www.rafcommands.com/database/...php?qnum=27546


    Warrant Officer Class II John LOVE (211782) of the South African Air Force

    Circumstances of Death:
    Forum Post
    i.e there is no text under "Circumstances of Death" only a link to the forum post. I want to update the text from the forum there..

    All the records that are like the above are now in this google sheet.

    https://docs.google.com/spreadsheets...it?usp=sharing

    There are 2250 such records that are like that. I am asking for help from forum members to read the forum post and copy the text to a 'detail' field

    So anyone who wants to chip in with effort, please use the sheet above. Click on the link in Column J - it will tkae you to the forum post and highlight the surname. Copy the text back to the spreadsheet in Column K. Re-write as needed.

    I will run some SQLs based on the sheet to populate the details back into the DB.

    Thanks for helping here!
    Last edited by Jagan; 29th September 2022 at 15:21.

  2. The Following 3 Users Say Thank You to Jagan For This Useful Post:

    Jim C (12th October 2022),jonheyworth (30th September 2022),paulmcmillan (29th September 2022)

  3. #2
    Join Date
    Jan 2008
    Location
    Delaware, USA
    Posts
    1,492
    Thanks
    754
    Thanked 205 Times in 144 Posts

    Default Re: Request CROWD SOURCING Help : Update 2200 odd CWGC Records from existing Forum Po

    Can all our forum members commit to picking up one or two records per day each to update in this sheet? if a 100 members do it for a month sporadically, we will be done with this ask!

  4. #3
    Join Date
    Nov 2007
    Posts
    6,881
    Thanks
    350
    Thanked 415 Times in 375 Posts

    Default Re: Request CROWD SOURCING Help : Update 2200 odd CWGC Records from existing Forum Po

    can you give me edit access please ?

    I can't commit 2 a day - but I will commit to doing some a week
    Last edited by paulmcmillan; 29th September 2022 at 15:34.

  5. The Following 3 Users Say Thank You to paulmcmillan For This Useful Post:

    Jagan (29th September 2022),jonheyworth (30th September 2022),Luc Vervoort (29th September 2022)

  6. #4
    Join Date
    Jan 2008
    Location
    Delaware, USA
    Posts
    1,492
    Thanks
    754
    Thanked 205 Times in 144 Posts

    Default Re: Request CROWD SOURCING Help : Update 2200 odd CWGC Records from existing Forum Po

    Quote Originally Posted by paulmcmillan View Post
    can you give me edit access please ?
    DUH!!.My bad. I just made it editable..

    only the last column is editable - the update can be made in tehre

  7. #5
    Join Date
    Nov 2020
    Location
    Lincoln, England
    Posts
    671
    Thanks
    14
    Thanked 247 Times in 227 Posts

    Default Re: Request CROWD SOURCING Help : Update 2200 odd CWGC Records from existing Forum Po

    I will do some for you Jagan.

  8. The Following 2 Users Say Thank You to Andy Marden For This Useful Post:

    Jagan (29th September 2022),jonheyworth (30th September 2022)

  9. #6
    Join Date
    Nov 2007
    Location
    Prague, Czech Republic
    Posts
    4,407
    Thanks
    68
    Thanked 88 Times in 87 Posts

    Default Re: Request CROWD SOURCING Help : Update 2200 odd CWGC Records from existing Forum Po

    Jagan I have made few at the beginning of 1941 and I hope I have got the right understanding how to make it.
    As I have found some additional info missing in the DB (locked columns) please:

    JOHN ANTHONY ARCHIBALD QUINLAN - add service number R/68547

    LIONEL HENRY PHILLIPS - add unit 15 O.T.U.

    SAUL EDWARD LYONS - add unit No. 6 Balloon Centre, RAF Wythall

    STANISLAW BYLCZYNSKI - add service number P-0189

    TIA

    Pavel

    P.S. I will do more time to time.
    Czechoslovak Airmen in the RAF 1940-1945
    http://cz-raf.webnode.cz

  10. The Following User Says Thank You to CZ_RAF For This Useful Post:

    jonheyworth (30th September 2022)

  11. #7
    Join Date
    Nov 2007
    Posts
    6,881
    Thanks
    350
    Thanked 415 Times in 375 Posts

    Default Re: Request CROWD SOURCING Help : Update 2200 odd CWGC Records from existing Forum Po

    1939 complete!

  12. The Following 2 Users Say Thank You to paulmcmillan For This Useful Post:

    CZ_RAF (30th September 2022),jonheyworth (30th September 2022)

  13. #8
    Join Date
    Jan 2011
    Posts
    7,197
    Thanks
    271
    Thanked 404 Times in 369 Posts

    Default Re: Request CROWD SOURCING Help : Update 2200 odd CWGC Records from existing Forum Po

    Jagan, it's a brilliant idea . All I'd ask extra , is there any way to start to differentiate partially accounted entries ?

    I can't really do any of these myself at the moment though sorry, as I don't think I'd currently have time with trying to get through the remaining unaccounted

  14. The Following User Says Thank You to jonheyworth For This Useful Post:

    Jagan (30th September 2022)

  15. #9
    Join Date
    Nov 2020
    Location
    Lincoln, England
    Posts
    671
    Thanks
    14
    Thanked 247 Times in 227 Posts

    Default Re: Request CROWD SOURCING Help : Update 2200 odd CWGC Records from existing Forum Po

    I've made a (small) start on 1942.

  16. #10
    Join Date
    Nov 2007
    Location
    Prague, Czech Republic
    Posts
    4,407
    Thanks
    68
    Thanked 88 Times in 87 Posts

    Default Re: Request CROWD SOURCING Help : Update 2200 odd CWGC Records from existing Forum Po

    Few more for 1941 added.

    Pavel
    Czechoslovak Airmen in the RAF 1940-1945
    http://cz-raf.webnode.cz

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •