[WordPress] 外掛分享: Aeropage Sync for Airtable

前言介紹

  • 這款 WordPress 外掛「Aeropage Sync for Airtable」是 2022-11-08 上架。
  • 目前有 70 個安裝啟用數。
  • 上一次更新是 2025-04-25,距離現在已有 9 天。
  • 外掛最低要求 WordPress 6.0.2 以上版本才可以安裝。
  • 外掛要求網站主機運作至少需要 PHP 版本 7.0.0 以上。
  • 有 2 人給過評分。
  • 還沒有人在論壇上發問,可能目前使用數不多,還沒有什麼大問題。

外掛協作開發者

aeropage |

外掛標籤

cpt | divi | sync | Airtable | custom post type |

內容簡介

A powerful, easy-to-use combination of tools that allows you to automate (or manually create) WordPress posts with customized metadata. Create WordPress posts directly from your Airtable data.

To get started, install the Aeropage Sync for Airtable WordPress plugin, available in the WordPress directory by searching for "Aeropage." This plugin has two parts: it pulls your Airtable data into WordPress and connects with Airtable's API tools, found here.

Once the Aeropage Sync for Airtable plugin is installed, open it from the sidebar and select "Add a Post." This will bring up a form where you can enter information for your new post. The Title of your custom post type should match the name of the table you're importing data from in Airtable, while the Dynamic URL can be either "SEO" friendly or use the unique ID of each record to manage potential duplicate names.

You'll also need an API Token to complete the form. The Auto Sync feature, which checks for changes every 10 minutes and automatically imports them into WordPress, can be toggled on or off. When you submit the form, a custom post type will be created and a new post added for every record in your connected Airtable.

To create an API Connector & Token, click "new" and create your project. Copy and paste the URL to the Airtable data you want to connect; for more details on this step, click on the instructions button. You can then create dynamic values for your posts by customizing Post Data & Fields (Metadata), including a custom Post Title, automatically downloaded Post Image, and short Post Excerpt. By default, every field in your Airtable record will be created as post metadata; toggle off any fields you want to exclude.

Use Attachment Proxy to replace temporary links in your attachment fields with permanent URLs. After making changes, you will need to refresh the data to see the result. Preview your posts to confirm Post Title, Image, and Excerpt are correct before synchronizing with WordPress.

Once your data is set up in Aeropage, open the settings and click the "token" field to copy it. Then go back to the "create post" page in the WordPress plugin and paste your token into the API Token field. Auto Sync can be toggled on or off depending on your preference.

原文外掛簡介

Security Notice
In our latest release (version 3.3.0), we addressed security vulnerabilities reported by Cheng Liu. We strongly recommend updating to the latest version to protect your site.

A powerful, easy to use combination of tools that allow you to automatically (or manually) generate WordPress posts with custom metadata.
Create WordPress posts from your Airtable data.

Install the WordPress Plugin
The WordPress Connector has two parts, a WordPress plugin that pulls your Airtable data into wordpress, and an API tool to connect with airtable here.
To connect to wordpress, use the Aeropage Sync for Airtable plugin. You can find it in the WordPress directory by searching for “Aeropage“.

Add a Custom Post Type
Once the plugin is installed, just open it from the sidebar and “Add Post”.

After clicking “Add a Post” you will be shown a form.

Title
The title of the custom post type will usually be the same name as the table you”re importing data from in Airtable.
Dynamic URL
The dynamic url can be “SEO” friendly by using the name eg “shure-headphones” or it can be easier to manage potential duplicate names by using the unique id of each record.
API Token
Continue to the next steps to create a token to use with the api connector.
Auto Sync
A cron job that is executed in an hourly interval which is based on WordPress Cron implementation. WordPress Cron is WordPress’s task scheduler that runs on site visits to handle tasks like publishing posts and checking for updates.
WordPress Cron, and to an extent auto sync, relies on site traffic, so on low-traffic sites, tasks may not run on time.
If you have an access to the hosting server settings, you can update it like so:
Disable WordPress Cron in wp-config.php:
define('DISABLE_WP_CRON', true);

Set up a server cron job to run wp_cron.php every hour:
*/5 * * * * curl http://example.com/wp-cron.php?doing_wp_cron

When submitted this will create a custom post type and automatically add a new post for every record in your connected Airtable
To complete the form you will need an API token (below)…
Create API Connector & Token
The api connector stores your connection info and prepares the data in the response to be used in WordPress.
Connect to Airtable
After clicking new and creating your project, copy and paste the url to the airtable data you want to connect. To find out more details on this step, click on the instructions button.

Post Data & Fields (MetaData)
you can create dynamic values for your posts when they appear in “loops” on your WordPress archive pages, query and loop templates
Post Title
If you want to make a custom title, instead of using the default name of the records.
Post Image
The image will be automatically downloaded to your wordpress media library.
Post Excerpt
A short description of the post content.
Fields (Metadata)
By default, every field in your airtable record will be created as post metadata. If you want to prevent some data from being synced, click the field settings and toggle off the ones you want to exclude.
Attachment Proxy
Replaces temporary links in your attachment fields with permanent urls.
💡 After making changes, you need to refresh the data to see the result.

Posts Preview
You can see a preview of how your posts would look in a WordPress loop by click on the “posts” view. This can be used to confirm the Post Title, Image and Excerpt are correct before you syncronize with WordPress.

Syncronizing with Airtable
Once your data is setup in Aeropage…

Open the settings.
Click on the “token” field to copy it.
Go back to Wordrpress plugin, “create post” page.
Paste your token into the API Token field.

💡 Auto sync can be toggled on to check for new and changed data.

After a few seconds, you should see your data appear in the right – and a Success message.
You are now ready to save the post, which will syncronize you posts for the first time. After syncronizing your custom post will appear in the WordPress menu, and a post will have been added for each record in your Airtable data.
💡 The first time you sync it can take longer as it”s downloading your featured images.
You should also see the featured images for each post in your media library.

Finished
You can now use your custom post to make queries and templates → also use custom post meta data, for any of the fields in your Airtable data when making Single Post templates. The custom posts and metadata should work with all your favorite builders.

Gutenberg

Create loops using the “Query Loop” Block
Make templates for your single posts.

Elementor

Create loops using the “Loop Template” widget.
Make templates for your single posts.

Divi

Refer to documentation for how to make loops with custom posts and metadata.

Update your Data
To manually resync your data, make changes or delete – just click the icons below.

Make changes to the configuration

Resyncronize your data manually.
If you have auto sync toggled on, your posts will be updated automatically after running the cron job.

各版本下載點

  • 方法一:點下方版本號的連結下載 ZIP 檔案後,登入網站後台左側選單「外掛」的「安裝外掛」,然後選擇上方的「上傳外掛」,把下載回去的 ZIP 外掛打包檔案上傳上去安裝與啟用。
  • 方法二:透過「安裝外掛」的畫面右方搜尋功能,搜尋外掛名稱「Aeropage Sync for Airtable」來進行安裝。

(建議使用方法二,確保安裝的版本符合當前運作的 WordPress 環境。


1.0.1 | 1.0.2 | 1.0.3 | 1.0.4 | 1.1.0 | 1.2.0 | 1.2.1 | 1.2.2 | 1.2.3 | 1.3.0 | 1.3.1 | 2.0.0 | 2.0.1 | 2.0.2 | 2.0.3 | 3.0.0 | 3.1.0 | 3.1.1 | 3.1.3 | 3.1.4 | 3.2.0 | 3.3.0 | trunk |

延伸相關外掛(你可能也想知道)

  • Air WP Sync – Airtable to WordPress 》通過將你的 Airtable 資料庫平台連接到 WordPress 網站,這個外掛程式協助你更好地管理內容。識別你想連結到 WordPress 的 Airtable 欄位並選擇匯入內容的格...。
  • CF7 to Airtable 》使用 WordPress 外掛 Contact Form 7 連接 Airtable,將您的表單實時同步到 Airtable 中。此可靠的附加功能可讓您集成 Contact Form 7 表單,使用戶提交表單...。
  • miniExtensions Gallery for Airtable 》, 這個外掛可以把 Airtable 的記錄顯示到你的網站上,並呈現為與網站相同的樣式。你可以生成一個相容於你網站的記錄圖庫,它可以根據內容自動調整其高度。, ...。
  • EmbedTables – Embed Google Sheets on website 》EmbedTables 讓您可以快速地美觀地嵌入 Google Sheets 或 Airtable 中的數據,不再需要讓使用者跳轉到試算表頁面。, 關於, 這個外掛讓您可以輕鬆地在 WordPre...。

文章
Filter
Apply Filters
Mastodon