![[community profile]](https://www.dreamwidth.org/img/silk/identity/community.png){kind=small}
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
kitsuneheartI have made...the perfect spreadsheet for me. One that automatically generates the HTML for my AO3 posts. And maybe you all are already doing it, but I just figured it out for myself! Look here for the spreadsheet copy that doesn't give away my ITPE secrets.
So, as I'm recording more podfics of late, handling all the metadata and posting has gotten...onerous. I keep a spreadsheet of relevant metadata and a fill-in-the-blank HTML file, but it still involved going back and forth between two windows, and took a long time. In addition, I recently changed from DropBox Pro to Google One storage; I had enough space to continue storing podfics on DropBox, but I wanted to have download links for both available, in case one shuts down in the future.
I didn't like the idea of going through each of my podfics (about 70, at the moment, but once ITPE is released...) and doing the copy-paste on each attribute AGAIN. And possibly even more in the future, if things break. There had to be a way to do things smarter, faster, easier.
Enter...a lot of trial-and-error on how many quotation marks I need. A LOT. I took my fill-in-the-blank file, turned un-coded line breaks into ACTUAL HTML line breaks, and replaced the "blanks" with the actual metadata cells. Fiddled...fiddled...and...voila.
It's beautiful. And look, not only the main HTML, but I'm so lazy I made it auto-generate my title, as well! AND! I also made a second sheet, which generates the text for my YouTube posts (I'm posting there, as well, trying to seduce podfic YouTubers onto AO3).
With the auto-generated HTML, I went through and updated the HTML for ALL my podfics in about 15 minutes! Over 70 fics, 15 minutes! :D
I'm just...I'm gonna save SO MUCH TIME with this thing!
So, as I'm recording more podfics of late, handling all the metadata and posting has gotten...onerous. I keep a spreadsheet of relevant metadata and a fill-in-the-blank HTML file, but it still involved going back and forth between two windows, and took a long time. In addition, I recently changed from DropBox Pro to Google One storage; I had enough space to continue storing podfics on DropBox, but I wanted to have download links for both available, in case one shuts down in the future.
I didn't like the idea of going through each of my podfics (about 70, at the moment, but once ITPE is released...) and doing the copy-paste on each attribute AGAIN. And possibly even more in the future, if things break. There had to be a way to do things smarter, faster, easier.
Enter...a lot of trial-and-error on how many quotation marks I need. A LOT. I took my fill-in-the-blank file, turned un-coded line breaks into ACTUAL HTML line breaks, and replaced the "blanks" with the actual metadata cells. Fiddled...fiddled...and...voila.
It's beautiful. And look, not only the main HTML, but I'm so lazy I made it auto-generate my title, as well! AND! I also made a second sheet, which generates the text for my YouTube posts (I'm posting there, as well, trying to seduce podfic YouTubers onto AO3).
With the auto-generated HTML, I went through and updated the HTML for ALL my podfics in about 15 minutes! Over 70 fics, 15 minutes! :D
I'm just...I'm gonna save SO MUCH TIME with this thing!