User talk:1033Forest
Jump to navigation
Jump to search
Hi
[edit]Could you teach me how you use OpenRefine to create episodes of TV shows Trade (talk) 20:33, 26 March 2024 (UTC)
- I load my data from an Excel sheet listing the title, description, follows, followed by, season, no. in season, no. overall, publication date, and production code if that's available (made in Google Sheets). Reconcile every column to create a new item for each cell except the season column which you reconcile as natural number then change each match to "X show, season 1", "X show, season 2", etc.
- After reconciling each column, a schema is built and I match the reconciled columns to each value then upload the edits. I do the follows/followed by by copying the reconciliation data after the items areemad
- This is the best explanation I can come up with, there's also tutorials on YouTube on how to use this software. 1033Forest (talk) 00:45, 27 March 2024 (UTC)
- Could you upload one of your Excel sheet listings to Mediafire so i can check it out? Or just whatever file upload site of your choice Trade (talk) 22:12, 27 March 2024 (UTC)
- I can try and share one of them since they are on Google Sheets. 1033Forest (talk) 01:33, 28 March 2024 (UTC)
- How long would you estimate it takes to make a spreadsheet for a standard TV show season (24 ep)? Trade (talk) 02:32, 28 March 2024 (UTC)
- I import the table, copy the table to another sheet then remove the rows. Takes about a few minutes or so I think 1033Forest (talk) 02:36, 28 March 2024 (UTC)
- Any update? Trade (talk) 16:15, 18 April 2024 (UTC)
- Sorry, I've been too busy with adding a bunch of other TV show episodes. But I can show you one of the sheets I've made for a TV episode listing:
- https://docs.google.com/spreadsheets/d/1G1DVk98gGpjkGDRmXA1I4pBTr5XswOjpgn2tw6ZF29k/edit?usp=sharing
- This is the one I made for Odd Squad earlier that I uploaded to OpenRefine to make the edits for. I had to copy and paste each one separately and it took a while because the items are for both segments. 1033Forest (talk) 16:27, 18 April 2024 (UTC)
- Any programs you can recommend for making the sheets? Not in the mood of dealing with Google Accounts Trade (talk) 16:38, 27 April 2024 (UTC)
- Use Microsoft Excel, I think that's what Google Sheets is based off. 1033Forest (talk) 18:10, 27 April 2024 (UTC)
- Any programs you can recommend for making the sheets? Not in the mood of dealing with Google Accounts Trade (talk) 16:38, 27 April 2024 (UTC)
- How long would you estimate it takes to make a spreadsheet for a standard TV show season (24 ep)? Trade (talk) 02:32, 28 March 2024 (UTC)
- I can try and share one of them since they are on Google Sheets. 1033Forest (talk) 01:33, 28 March 2024 (UTC)
- Could you upload one of your Excel sheet listings to Mediafire so i can check it out? Or just whatever file upload site of your choice Trade (talk) 22:12, 27 March 2024 (UTC)
fictional geographic location (Q116780221)
[edit]Please don't use this on items. It's way too broad and unspecific Trade (talk) 21:23, 25 April 2024 (UTC)
- Thanks, I understand now for when I create future fiction items. 1033Forest (talk) 21:24, 25 April 2024 (UTC)
Regarding Artificial Intelligence Bomb (Q125636848) keep in mind that audio track (Q7302866) is strictly for non-music tracks. --Trade (talk) 02:55, 28 April 2024 (UTC)
- Got it now, thanks for fixing. I didn't know what to use at the time because I saw that when I set it to instance of "song" (Q7366) it gave an error when I provided a Spotify ID. Now I know what to use for instances of music without lyrics. 1033Forest (talk) 03:00, 28 April 2024 (UTC)
- Take a look at the tracklist here. That should explain how music works on this site. If someone for example were to make a cover or remix of Ayla & Falafel then both of the tracks should have an recording or performance of value of Ayla & Falafel. You can apply the same logic to every other music releases
- I used MultiTracker to easily create the tracklist. Feel free to try it out when you got time. I set the value to Sandbox#4 so you can experiement Trade (talk) 03:47, 28 April 2024 (UTC)
- If you want to create something like the first track here you only need to write "Ayla & Falafel|1:15" into the Tracklist field and so on and so on--Trade (talk) 03:49, 28 April 2024 (UTC)
Please don't use video game franchises as values for present in work (P1441). List the individual games instead--Trade (talk) 03:17, 29 April 2024 (UTC)
- Thanks, fixed that just now. 1033Forest (talk) 03:36, 29 April 2024 (UTC)
SpongeBob
[edit]Hi could you add this statement when making items about SpongeBob? Trade (talk) 22:38, 17 July 2024 (UTC)
- Yes, added it to the other items I made just now, thank you. 1033Forest (talk) 22:41, 17 July 2024 (UTC)
- Could you try and remember to use the property last appearance (P12878) when making SpongeBob items? See Mrs. Wormsley (Q127547859) for example--Trade (talk) 03:01, 23 July 2024 (UTC)
- Got that, I'll do that for the next SpongeBob items I make. I see that it's a newly added property, I thought before it was added that it wouldn't be needed as SpongeBob is a long-running series, and the item could possibly appear in a future episode or piece of SpongeBob media later on. If the item only had one appearance I just put the appearance under the qualifier "statement is subject of" for "present in work". 1033Forest (talk) 03:45, 23 July 2024 (UTC)
- Could you try and remember to use the property last appearance (P12878) when making SpongeBob items? See Mrs. Wormsley (Q127547859) for example--Trade (talk) 03:01, 23 July 2024 (UTC)