OpenRefine Error Message: One or more rows contain no data for column platform.host.name

Full text of error

platform.host.name One or more rows contain no data for column platform.host.name

Description

Platform.host.name is a required data element in GOKb, so you will receive this error message if any of the cells are left blank. If the appropriate platform doesn't exist in GOKb, please consult the editor to find out if it should be added.

Solutions

Update platform names with the Reconcile function

From the Platform column's dropdown menu, select Reconcile
Select Start Reconciling
Click GOKb
Choose the radio button next to Platform
Click Start Reconciling
You should see the Platform column populate with names and checkboxes. Click the double checks to add the name of the platform to all matching rows.

If all the titles in your project have the same provider:

In the first cell of your platform.host.name column, click "Edit."
In the edit dialogue that appears, right click in the white area.
The GOKb lookup menu will appear. Choose "Platform." The Lookup Platform dialogue will appear.
Type in the first few letters of the platform you are looking for.
Choose the correct platform from the results list and click OK.
You will see the name of the platform, along with a GOKb identifier, in the edit dialogue. (Ex. Cambridge University Press::{Platform:67251})
Click "Apply."
The platform name will now be in the first cell in your column.
Click the small triangle menu at the top of your column.
Choose "Edit cells>Fill down." The platform name and identifier will be filled down through all the remaining blank cells in your column.

If the titles in your project have different providers:

Use OpenRefine to facet your project to show only those titles that are on the same platform.
Perform steps 1-10 as described above.
Re-facet your project to show the next group of titles with the same platform.
Repeat steps 1-10 above.
Repeat this process as necessary for each group of titles with the same platform.