Run TechTV public collection migration

[pdpinch]

This issue is just for the task of running the migration.

[mbertrand]

@emmello can you double-check that these are the right TTV collection id's for:

Region-blocking collection ids 575, 587, 1081, 1214, 2191, 2884, 2885, 2886, 2887, 2888, 2890, 2891, 2894, 2956, 3152, 3251, 3254, 3255, 3256, 3257, 3326, 3384, 3385, 3401 (most of these are children of 587 (OCW) in the database; 575 already completed; 3384 not restored).

Not on Youtube 2228, 3672

Assuming these are correct, the command to run is:

DROPBOX_TOKEN=<value>;DROPBOX_FOLDER=/Captions;MYSQL_PASSWORD=<value>

python manage.py techtvimport --user <mysql_user> --db <mysql_db> --host <mysql_host> --protected 0 --aws --cloudfront 575 587 1081 1214 2191 2884 2885 2886 2887 2888 2890 2891 2894 2956 3152 3251 3254 3255 3256 3257 3326 3385 3401 --noyoutube 2228 3672

[shaidar]

@mbertrand Is this safe to run now on prod or we still waiting on anything?

[mbertrand]

@shaidar I think we're waiting for collection pagination, otherwise the home page and side bar will both list 3000+ collections.

[pdpinch]

This is blocked by #521 and shouldn't be run until that is released to production.

[emmello]

@pdpinch Checking Quickbase, I also see collection 3385 (only partially restored for course 18.S096). Also 3348 was not restored back to TechTV.

[pdpinch]

Sorry, I don't understand @emmello -- is that for @mbertrand ?

[emmello]

Oops, yes confirming OCW collections.

[mbertrand]

Thanks @emmello, I updated the command, added 3385 and removed 3384.

[shaidar]

Ran video migrations on production.

[pdpinch]

@shaidar @mbertrand I'm closing this one.