Exporting podcasts from WordPress

This is a tutorial for exporting podcast MP3s and their metadata from a WordPress site that's using the Blubrry PowerPress podcasting plugin and importing them into the Internet Archive as separate items. The instructions assume a macOS environment, but any OS with a text editor, spreadsheet program, and command line will work.
 * 1) Install the WP All Export plugin in the WordPress site.
 * 2) On that plugin's "New Export" page, create a custom export of all posts, including these fields: ID, Slug, Title, Content, Author Username, Date, Permalink, enclosure, Tags
 * 3) Open the resulting CSV file. Each cell in the "enclosure" column consists of four lines. The first line in each is the URL to an MP3. Collect those URLs into a separate text file (one URL per line) named wp-podcast-download-urls.txt in a directory named wp-podcast.
 * 4) To download all the MP3s, open Terminal, navigate to the wp-podcast directory, and execute wget -i wp-podcast-download-urls.txt --no-check-certificate
 * 5) If you have album art for the podcast, save it to the wp-podcast directory as a JPEG named cover.jpg
 * 6) Open the CSV file in a spreadsheet editor (Excel, Numbers, Google Sheets).
 * 7) * Rename the "Slug", "enclosure", "Author Username", "Tags", and "Permalink" column headers to "identifier", "file", "creator", "subject", and "source", respectively.
 * 8) * Change the cell formatting in the "Date" column to use YYYY-MM-DD format. (You may need to change the cell type from "Date" to "Text"; otherwise, the spreadsheet may display one value but be storing another.)
 * 9) * Run a search-replace on the "subject" column to change the pipes to semicolons.
 * 10) * The fourth line of each cell in the "enclosure" column contains the episode length, which can be moved to a separate "runtime" column.
 * 11) * Remove everything else from each "enclosure" cell except the MP3 filename.
 * 12) * Create a column named "mediatype" and fill it with the value "audio".
 * 13) * Copy the "descriptions" into a text editor (such as BBEdit) to add paragraph tags and remove carriage returns and CSS tags. Note that the Internet Archive's command line importer will not preserve hyperlinks in this column.
 * 14) * Copy the "creator" column and name it "taper".
 * 15) * For each podcast episode, create another row that has the same identifier, cover.jpg in the "file" column, and all other columns blank.
 * 16) Export the Excel file to a CSV named wp-podcast-upload.csv in the wp-podcast directory. (Here is a sample CSV generated using the above workflow.)
 * 17) Use a text editor to change the CSV file's encoding from "Unicode (UTF-8, with BOM)" to "Unicode (UTF-8)" and to eliminate high-ASCII characters ("Zap Gremlins" in BBEdit).
 * 18) If you haven't already, install the Internet Archive command line tool for bulk uploading.
 * 19) Again in the Terminal, and still in the wp-podcast directory, run this command: time ia upload -S wp-podcast-upload.csv 2>&1 | tee wp-podcast-upload.log
 * 20) If you uploaded more than fifty related podcast episodes, then they qualify for a collection. Copy the "identifier" column out of wp-podcast-upload.csv and paste it into an email to collections-service@archive.org with this other information:
 * 21) * The email address(es) of the account(s) that uploaded the content
 * 22) * A list of the item links or a search query which will identify them
 * 23) * The name of the collection.
 * 24) * A brief description (to be used on your collection page) of your organization and/or the material housed in the collection.
 * 25) * A suggested identifier (the tail of the URL for the collection page) for the collection page (please use meaningful words and it should be 5-80 characters preferably lowercase and/or numbers only. no special characters or spaces)
 * 26) * At least one Subject Tag that describes the collection. Please separate multiple tags with semicolon.
 * 27) * (optional) The logo you would like to display on the collection page. Best if it is at least 500p x 500p or, at least 500px wide or high.
 * 28) * The archive.org account email address(es) that you would like to have administrative privileges for this collection (these addresses will be able to upload directly to the collection as well as edit information about the collection).