Newly Updated Bible Project TBP videos

[thsneha]

• Hindi
• Telugu
• Bengali
• Gujarathi
• Tamil
• Malayalam
• Punjabi
• Marathi
• Kannada
• English

[Leni-Easo]

Updated bible_videos.csv PR Link

[svishnu06]

Updated 9 Hindi TBP videos PR link

[RevantCI]

• Create CSV
• send PR to Github
• upload to staging
• QA
• upload to production

[RevantCI]

Connect with Anu and see the script they have
If not possible make own script in python using Youtube APIs
https://developers.google.com/youtube/v3/docs/playlists/list

[svishnu06]

updated languages - Hind,Telugu,Bengali,Gujarathi,Tamil,Malayalam,Punjabi,Marathi,Kannada,English
PR link

missing/private urls in hindi language :

isa https://youtu.be/1F70gW0UUtE
isa https://youtu.be/XXx87dQivsY
hos https://youtu.be/ybKH-s_GRX0
amo https://youtu.be/WFV1KMyemWY
oba https://youtu.be/YmWJLmoypms
jon https://youtu.be/x-myCc60SRY
hab https://youtu.be/IXtUWh4d10k
zep https://youtu.be/o_vtrslM9Io
hag https://youtu.be/vJussU1PCh0
zec https://youtu.be/_05pJdSEqn4
mal https://youtu.be/6FDCwg3HIEs
job https://youtu.be/ecdCbo6S3-0
sng https://youtu.be/FwCk5RmVHk8
rut https://youtu.be/GZDRIwVrIoI
lam https://youtu.be/tKZmpYmaO0I
ecc https://youtu.be/GOh1w4ayH_M
ezr https://youtu.be/IyZJxxI0fDM
est https://youtu.be/YA_LJ6-a_uk
dan https://youtu.be/_fX9hq1oepc
2ch https://youtu.be/8NwPV5dVEv8
mic https://youtu.be/xTeYNmC6Y_8

[svishnu06]

Created an Excel file showing the availability of TBP videos for each language TBP Videos 2024

• create script (2 hrs)
• create csv/excel file (2 hrs)
  TBP Videos 2024
• Add Luke-Acts Gospel Series (4 hrs)
• add Nepali and Urdu video to the list(2 hrs)
• Create CSV(1 hr)
• send PR to Github(30min)
• upload to staging(2 hrs)
• QA
• upload to production

[svishnu06]

hindi new videos added - sng,mal and nam changed to mic.
pr updated - PR LINK , updated the changes in TBP Videos 2024

[RevantCI]

Staging date inserted adding notes of deletion and insertion below

1. 83 mal deleted
   query: delete from bible_videos where language_id in (select language_id from languages where language_code = 'mal') and theme not like '%Gospel%' and theme not like '%Testament%';

2. 73 eng delete
   delete from bible_videos where language_id in (select language_id from languages where language_code = 'eng') and theme like '%Testament%';

3. 73 hin deleted
   delete from bible_videos where language_id in (select language_id from languages where language_code = 'hin') and theme like '%नियम%';

4. 73 tel deleted
   delete from bible_videos where language_id in (select language_id from languages where language_code = 'tel') and theme= 'లేఖనాలు చదవండి';

5. 274 ben deleted
   delete from bible_videos where language_id in (select language_id from languages where language_code = 'ben');
   reinserted 200 FCBH videos again

6. 35 guj deleted
   delete from bible_videos where language_id in (select language_id from languages where language_code = 'guj') and theme like '%વિહંગાવલોકન:%';

7. 72 tam deleted
   delete from bible_videos where language_id in (select language_id from languages where language_code = 'tam') and theme like '%ஏற்பாடு%';

8. 32 pan deleted
   delete from bible_videos where language_id in (select language_id from languages where language_code = 'pan') and theme like '%ਸੰਖੇਪ ਜਾਣਕਾਰੀ%';

9. 19 mar deleted
   delete from bible_videos where language_id in (select language_id from languages where language_code = 'mar') and theme like '%विहंगावलोकन:%';

10. 47 kan deleted
    delete from bible_videos where language_id in (select language_id from languages where language_code = 'kan') and theme like '%ಸಾರಾಂಶ:%';

13:50:18.848 INFO ### ADD OPERATION ###
13:50:18.848 INFO Type: video
13:50:19.061 INFO Videos added for eng:{"Duplicate urls skipped":[],"message":" Videos added: 73","success":true}
13:50:19.139 INFO Videos added for hin:{"Duplicate urls skipped":[],"message":" Videos added: 54","success":true}
13:50:19.174 INFO Videos added for ben:{"Duplicate urls skipped":[],"message":" Videos added: 73","success":true}
13:50:19.198 INFO Videos added for mar:{"Duplicate urls skipped":[],"message":" Videos added: 73","success":true}
13:50:19.218 INFO Videos added for guj:{"Duplicate urls skipped":[],"message":" Videos added: 73","success":true}
13:50:19.219 INFO Videos added for mal:{"Duplicate urls skipped":[],"message":" Videos added: 73","success":true}
13:50:19.261 INFO Videos added for tel:{"Duplicate urls skipped":[],"message":" Videos added: 73","success":true}
13:50:19.264 INFO Videos added for pan:{"Duplicate urls skipped":[],"message":" Videos added: 73","success":true}
13:50:19.306 INFO Videos added for tam:{"Duplicate urls skipped":[],"message":" Videos added: 73","success":true}
13:50:19.314 INFO Videos added for kan:{"Duplicate urls skipped":[],"message":" Videos added: 73","success":true}

13:55:50.429 INFO ### ADD OPERATION ###
13:55:50.429 INFO Type: video
13:55:50.645 INFO Videos added for ben:{"Duplicate urls skipped":[],"message":" Videos added: 200","success":true}

[VineethaVi]

Test Result

1. 1,2,3 John Epistles video is showing with the Gospel of John's video. 1,2,3 John epistles not displaying TBP videos of these books. This is happening in all languages.

[Screen Recording](John 1 - Eng-ESV - Vachan Online (3).webm)

2. In TBP videos of Hindi language, the video of the book Malachi is playing for the book Psalms instead of the Psalms video.
3. For Proverbs, the video of Psalms is showing for the Proverbs video.

[Screen Rcording](अय्यूब 1 - Hin-IRV - Vachan Online.webm)

4. Video title for the book Haggai in Kannada language is showing in other language.

Screenshot

5. The book James's video is not accessible in Marathi. Breaking occurs after choosing a chapter.

Testing Environment : staging - https://www.dev.vachanonline.com/

Moving this issue to In progress

[svishnu06]

new changes in bible_video.csv

1. modified 2ki to '1ki,2ki' for every language.
2. added '1jn,2jn,3jn entries for all languages. this will fix issue number 1 mentioned above by QA.
3. modified 2ch to '1ch,2ch' for every language.
4. modified ezr to ,"ezr, neh" for every language.

[svishnu06]

Test Result

1. 1,2,3 John Epistles video is showing with the Gospel of John's video. 1,2,3 John epistles not displaying TBP videos of these books. This is happening in all languages.

[Screen Recording](John 1 - Eng-ESV - Vachan Online (3).webm)

2. In TBP videos of Hindi language, the video of the book Malachi is playing for the book Psalms instead of the Psalms video. 3. For Proverbs, the video of Psalms is showing for the Proverbs video.

[Screen Rcording](अय्यूब 1 - Hin-IRV - Vachan Online.webm)

4. Video title for the book Haggai in Kannada language is showing in other language.

Screenshot

5. The book James's video is not accessible in Marathi. Breaking occurs after choosing a chapter.

Testing Environment : staging - https://www.dev.vachanonline.com/

Moving this issue to In progress

issue no. 1 ,2 and 3 has been resolved.
issue no 4 - Haggai in Kannada language video thumbnail looks different but this video originally uploaded from content creators. no further check needed.
issue no 5 - this issue not related to the recent TBP video updates .IRV Marathi James 1 parsing issue causes UI to crash, created a separate issue .issue link

updated bible_videos.csv PR

[svishnu06]

newly added videos.

1. Nepali and Urdu videos.
2. Luke-Acts Gospel Series for all languages.

[RevantCI]

10:00:05.448 INFO Videos added for urd:{"Duplicate urls skipped":[],"message":" Videos added: 53","success":true}
10:00:05.613 INFO Videos added for nep:{"Duplicate urls skipped":["https://youtu.be/Pak4OSQUCCU","https://youtu.be/73KurzKX1T0","https://youtu.be/UkMtzg9aYhU","https://youtu.be/dBSV2XjFS7k","https://youtu.be/SS0mqpFnIAk","https://youtu.be/0EFi2dmt9Tk","https://youtu.be/9xga2UXHwdk","https://youtu.be/sdh-hj3lxDc","https://youtu.be/Nx2wJZsBqQg","https://youtu.be/jzA2Ero3P7s","https://youtu.be/NfnwOGjBaf0","https://youtu.be/P9K8i4YRx2A"],"message":" Videos added: 69","success":true}