Import board game data into Craft CMS

Alex Aguilar, Partner, Software Engineer Alex Aguilar Craft CMS

In the previous lesson, we created the Board Games section. Now we’ll import our favorite board games into Craft CMS using the Feed Me plugin. We’ll use the Craft Plugin Store, configure Feed Me, import our game data & customize the admin listings screen.

Install Feed Me plugin #

We’ll install the Feed Me plugin via the Craft Plugin Store.

  1. Click on Plugin Store.

  2. In the Search plugins box type in “Feed”.

  3. Click on Feed Me.

  4. Click the Install button.

  5. After a bit of processing time, you’ll see Feed Me in left sidebar.

Board Game CSV #

I have a Notion spreadsheet with board game data that I’ve exported to a CSV.

Create Board Game feed to import CSV #

  1. Click on Feed Me.
  2. Click the New feed button.
  3. Fill out the Name field with “Favorite Board Games”.
  4. In Feed URL enter: https://cdn.eaglepeakweb.com/img/projects/blog/favorite-board-games.csv
  5. In Feed Type select CSV.
  6. For Element Type select Entry.
  7. In Section, select Board Games.
  8. In Entry Type, select Board Games.
  9. For Import Strategy, leave Create new elements checked.
  10. The default values for remaining fields (Passkey and Backup) are fine. Click Save & Continue.
  11. The default values for Primary Element and Pagination URL are fine. Click Save & Continue.

Mapping the Entry fields #

Now we’ll map the CSV columns to Craft entry fields.

  1. Map Title to <Name>.
  2. Leave the remaining fields as Don’t Import.

Mapping the Content fields #

Next we’ll map the CSV columns to Craft content fields.

  1. Map Board Game Image to <Photo>. Check [✓] Create asset from URL.
  2. Map Board Game Category to <Category>.
  3. Map Difficulty to <Difficulty>.
  4. Map Minimum number of players to <Min. Players>.
  5. Map Maximum number of players to <Max Players>.
  6. Map Best number of players to <Best Players>.
  7. Map Minimum Duration to <Min. Duration>.
  8. Map Maximum Duration to <Max Duration>.
  9. Map Play Online to <Play Online>.
  10. Leave the Title as the unique identifier. Click Save & Continue.
  11. You’ll see a message that the import has been queued up.
  12. Click on View feeds.

Run feed to import board games #

Moment of truth. Time to run the feed and import the board game data.

  1. Click the Run feed button.
  2. You’ll see notification that feed is running.
  3. Once the import has finished. Click on Entries.
  4. Success! 🎉 Our board games have imported correctly.

Customize Board Games admin listings #

We’ll finish this lesson by adjusting the columns on the board games index. I’d like to see the board game image & remove Expiry Date.

  1. Click on the gear icon ⚙️.
  2. Uncheck the Expiry Date.
  3. Check Board Game Image and drag it up.
  4. Click Save.

Hide Image Labels #

I don’t like the redundant titles after the images. So I’ll hide them.

  1. Go to Settings.
  2. Click on Fields.
  3. Click on Board Game Image.
  4. Scroll down to Preview Mode and change it to Show thumbnails only.
  5. Click Save.

If you return to the Board Games entries screen it’ll now look like this:

In the next lesson, we’ll install & configure Tailwind CSS to display board game cards on the front-end.

✨ This series is in development. Sign up or follow me @AlexAguilar18 to learn when new lessons are released.

Alex Aguilar, Partner, Software Engineer

Alex Aguilar

Partner, Software Engineer