WordPress - 从*.csv文件导入电子邮件订阅

Question

我们如何从CSV文件中将Jetpack subscriptions的电子邮件地址导入WP？

Answer 1

在这里找到了答案，并从这里加入了另一个答案：

Jetpack subscriptions不托管在您的站点上，而是托管在WordPress.com服务器上。因此，您无法直接添加到数据库中。

但是，如果您查看 Jetpack 插件代码，它会概述用于与WordPress.com交互和添加订阅者的XML-RPC调用。所以你可以建立自己的进口商...

<?php
//1. the "file_name_here.csv" should get changed to your need
//2. the script just needs to get placed on site like "example.com/subscribe.php"
//3. just execute it in the browser using your link
require_once($_SERVER['DOCUMENT_ROOT'].'/wp-load.php');
$row = 1;
if (($handle = fopen("file_name_here.csv", "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$num = count($data);
echo "<p> $num fields in line $row: <br /></p>n";
$row++;
for ($c=0; $c < $num; $c++) {
$email = $data[$c];
echo $email . "<br />n";
Jetpack_Subscriptions::subscribe( $email );
}
}
fclose($handle);
}