Pirate's Booty Status Showing
closed
Amrayu78
There's still some Dramas/Specials that have the Pirate's booty link on the main page and these should be moved to the Episodes tab.
We've slowly been migrating these.
I recently migrated this one over to episodes: https://drama-otaku.com/drama/neko-kare-shounen-wo-kau/
But the Status on the main overview page still remains.
Maybe add some logic like this: If Pirate's Booty link is deleted, then do not show Status at all.
Separate from this, is it possible if you can help migrate the old data over to the new data schema?
Old data:
- Pirate's Booty link is on the main overview page for Dramas and Specials (for Movies this is okay, it has no Episodes tab, so leave this alone)
- Move these links over to Episodes tab (you can put it for the first episode, and we can populate the rest, or if you can populate the total episodes, that would help us a great deal)
- After data is migrated over, delete the pirate's booty link from the main overview page.
- Once fully migrated, we can remove the entire Pirate's Booty widget from Dramas and SPs. For Movies this should still be there.
- For Movies, we can update the header for the widget: Pirate's Booty moved to Episodes tab --> to "Pirate's Booty (anchor icon)" Make it black text instead of red.
Amrayu78
closed
Amrayu78
Max Romanchenko: Bug and enhancement when you get the chance.
Max Romanchenko
Amrayu78 I've completed this part so far:
"Maybe add some logic like this: If Pirate's Booty link is deleted, then do not show Status at all."
Please check it.
Regarding migration, I need to clarify some details with you.
Let's take this drama (as an example)
It does not have any related episodes and has one PB link. What should I do?
Should I create 10 related episodes (as specified in this drama) and add a PB link to the first episode, correct?
Also, many dramas contain dead PB links on wetransfer.com, for example:
What should I do in such cases?
Amrayu78
Max Romanchenko:
This is fixed, thanks: "Maybe add some logic like this: If Pirate's Booty link is deleted, then do not show Status at all."
Migration:
Case 1: Yes, so it has one PB link, then you'll have to create 10 related episodes and link to that same PB link. Initially I wanted to use different links per episode, but that is too tedious for me. So linking to the same PB link is fine.
Case 2 (wetransfer links): Can you send me an updated .csv of the dramas, movies, and SPs that have wetransfer link? After you export those out, you can just delete the PB links from those Dramas, Movies, SPs and I will rehost those and fix them when I get the chance.
Max Romanchenko
Amrayu78
Here is a link to the xls file with wetransfer links:
Please check it out.
Case 1. Got it. I create related episodes and create the same pb link for each episode created.
Case 2. So I can delete these links from the database and not create episodes for these dramas, right?
Max Romanchenko
I don't quite understand this task:
“For Movies, we can update the header for the widget: Pirate's Booty moved to Episodes tab --> to ‘Pirate's Booty (anchor icon)’ Make it black text instead of red.”
I don't see that text. I think we already made those changes?
This is what the widget looks like on the movie page
Max Romanchenko
I would also like to add two additional cases and discuss them with you.
- Some titles have a huge number of episodes. Should I process them and create them all? (see screenshot).
- I am sending you 22 specific titles. These are special cases, they already have episodes created, as well as pb links. I think the team needs to double-check these cases manually, so I will remove them from the migration process because it is impossible to process these cases automatically.
Here is the file:
Amrayu78
Max Romanchenko movies is good to go then. I wasn’t sure if you were reusing that widget for movies as well. Thanks!
Amrayu78
Max Romanchenko yes process the titles with a lot of episodes. Right now I manually add these everyday if they air.
Case 2: I’ll review these, thanks
Max Romanchenko
Amrayu78 I implemented a custom migration script. Here are the results:
- 5,395 new episodes were created for 568 dramas and specials.
- The pb link was added to all created episodes.
Please check it. Once you have checked it, I will be able to delete the widget and old pb link fields (which are not in the episodes).
Amrayu78
Max Romanchenko thanks max! I will check a sampling of these.
Amrayu78
Max Romanchenko: Do you have the links of the ones you've migrated? I'll check those first.
Max Romanchenko
Amrayu78
Max Romanchenko: You can delete wetransfer links from the titles that only have a wetransfer link to avoid confusion.
Max Romanchenko
Amrayu78 Done. I deleted it. 173 titles were affected.
Amrayu78
Max Romanchenko: Mare and I checked the 568 dramas and specials and made some fixes. Everything is good to go.
You can delete the widget and old pb link fields (that's not in episodes), this includes the old pb status field connected to that widget.
Amrayu78
Max Romanchenko: I've manually checked and fixed these 22 specific titles (that had content already), so the PB widget is ready to get removed from SPs and Drama titles that's part of this migration.
Max Romanchenko
Amrayu78 Thank you, I've set myself the task. I'll let you know when it's ready.
Max Romanchenko
Amrayu78 All done:
- The widget has been removed from Dramas and Specials.
- Old fields have been deleted from admin, forms and database (except for Movies and People).
Please check.
Amrayu78
Max Romanchenko Checked a few and it looks good. Thank you for helping with this.