Getting existing posts ready for import & import

[MirandaEcho]

No description provided.

[benlk]

From Thomas Wilburn, when I asked in News Nerdery about scraping the HTML:

It depends on whether you're actually going to do this repeatedly, but if it's a one-time thing, I'll often do this from the browser console. You can use the copy() function in the console to toss something onto the clipboard, so if you can map your list into a comma-separated form, you can then paste into Excel or Sheets.

We can write a chunk of JS, save that here, and paste it into browser to capture the most-recent version of the page.

[benlk]

Note: Preferable to import from the spreadsheet, not by scraping the page.

[benlk]

[benlk]

Interim Conclusions

With:

• a CSV where:
  • each piece of metadata about a post is in a separate column
  • the first row is the column headers
• the WP All Import Pro plugin (which is installed on prod)

We can:

• use a GUI to map CSV entries to post meta fields that we define
• tell the plugin to download images

Questions/tasks for further exploration:

• The docs show ways to set taxonomy terms, but because work in Creation of custom post type #119 doesn't yet have custom taxonomies registered for the projects post type, we can't test imports.
  • create a taxonomy or three
  • Can terms for that taxonomy be provided in a CSV, and if so, in what format?
• Make a sample CSV for Current

[benlk]

Can terms for that taxonomy be provided in a CSV, and if so, in what format?

Terms can be provided in a list inside a CSV cell, separated by a separator of our choosing.

Here's a import template designed to be used with "2019 LTW submissions _MF_JD.xlsx" converted to a .csv:
templates_5ec313cf24b50.txt

Import this template at Dashboard > All Import > Settings.