Export a CSV of Environment Categories since October

[brandonhundt]

Indra Request:

• Stories in the environment category between 10/1/2023 and today
• would also need to pull the headlines/bylines (teasers if possible)

I'm thinking of using that export tool we paid for to do the GP dump. I don't think its activated. I'll try this on local dev first.

[brandonhundt]

I think this is best to run in local dev so we don't strain the live DB. For the record:

1. Download the latest DB

2. Enable All Export - Pro Plugin

3. Go to All Export in the bottom of the sidebar and create a New Export

4. Choose Posts from the Dropdown

5. Add Filtering Options (Category + Date)

6. Click on Customize File

7. Add in the columns for the spreadsheet (I removed the Content, and added the date, permalink, and teaser)

8. Click Continue

9. Depending on the size of the Export you might want to shrink the batch size.

10. Save and run export, and download the file

11. After the file downloads, I imported the data into a Google Sheet and did a find and replace on the URL.