Excel file (.csv) to WP post Plugin

excel2post.php

<?php
add_action('admin_menu', 'excel2post_plugin_setup_menu');

function excel2post_plugin_setup_menu(){

	add_menu_page('Shoppers Mag CSV Import Page', 'Shoppers Mag CSV Import', 'manage_options', 'csv-import', 'e2p', "dashicons-image-rotate-right", 2);
}

function e2p(){

	e2p_handle_post();
?>
  <h1>CSV Import</h1>
  <h2>Upload a File</h2>
  <!-- Form to handle the upload - The enctype value here is very important -->
  <form  method="post" enctype="multipart/form-data">
    <input type='file' id='test_upload_pdf' name='test_upload_pdf'></input>
    <?php
	submit_button('Upload') ?>
  </form>


  <?php
?>
  <?php
}

function e2p_handle_post(){

	// First check if the file appears on the _FILES array

	if (isset($_FILES['test_upload_pdf'])) {
		$pdf = $_FILES['test_upload_pdf'];

		// Use the wordpress function to upload
		// test_upload_pdf corresponds to the position in the $_FILES array
		// 0 means the content is not associated with any other posts

		$uploaded = media_handle_upload('test_upload_pdf', 0);

		// Error checking using WP functions

		if (is_wp_error($uploaded)) {
			echo "Error uploading file: " . $uploaded->get_error_message();
		}
		else {
			echo "<h3 style='color:green;'>File upload successful!</h3>";
			$dir = wp_upload_dir();
			global $csv_url;
			$csv_url = $dir["path"] . "/" . $pdf["name"];
			$csv_http_url = $dir["url"] . "/" . $pdf["name"];
			print_r($csv_url);
			echo "<p>";
			echo "To insert the posts into the database, click the button to the right.";
			echo '<form action="' . get_site_url() . '/wp-admin/admin-post.php" method="post">';
			echo '<input type="hidden" name="action" value="create_post">';
			echo '<input type="submit" value="Submit" class="button button-primary">';
			echo '</form>';
			echo "</p>";
			$_SESSION["csv_url"] = $csv_url;
			$_SESSION["csv_http_url"] = $csv_http_url;
		}
	}
}

add_action('admin_post_create_post', 'create_post_from_csv');

function pn_get_attachment_id_from_url($attachment_url = ''){

	global $wpdb;
	$attachment_id = false;

	// If there is no url, return.

	if ('' == $attachment_url) return;

	// Get the upload directory paths

	$upload_dir_paths = wp_upload_dir();

	// Make sure the upload path base directory exists in the attachment URL, to verify that we're working with a media library image

	if (false !== strpos($attachment_url, $upload_dir_paths['baseurl'])) {

		// If this is the URL of an auto-generated thumbnail, get the URL of the original image

		$attachment_url = preg_replace('/-\d+x\d+(?=\.(jpg|jpeg|png|gif)$)/i', '', $attachment_url);

		// Remove the upload path base directory from the attachment URL

		$attachment_url = str_replace($upload_dir_paths['baseurl'] . '/', '', $attachment_url);

		// Finally, run a custom database query to get the attachment ID from the modified attachment URL

		$attachment_id = $wpdb->get_var($wpdb->prepare("SELECT wposts.ID FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta WHERE wposts.ID = wpostmeta.post_id AND wpostmeta.meta_key = '_wp_attached_file' AND wpostmeta.meta_value = '%s' AND wposts.post_type = 'attachment'", $attachment_url));
	}

	return $attachment_id;
}

function create_post_from_csv(){
	
	global $wpdb;
	$post_data = array(
		'post_type' => 'post'
	);
	$file = $_SESSION["csv_url"];
	$data = array();
	$errors = array();
	if (!is_readable($file)) {
		chmod($file, 0744);
	}

	if (is_readable($file) && $_file = fopen($file, "r")) {
		$post = array();
		$header = fgetcsv($_file);
		while ($row = fgetcsv($_file)) {
			foreach($header as $i => $key) {
				$post[$key] = $row[$i];
			}

			$data[] = $post;
		}

		fclose($_file);
	}
	else {
		$errors[] = "File '$file' could not be opened. Check the file's permissions to make sure it's readable by your server.";
	}

	if (!empty($errors)) {
		print_r($errors);
	}

	// echo "<pre>";
	// print_r($data);
	// echo "</pre>";
	// ===================================

	$offers = $wpdb->get_col("SELECT post_title FROM {$wpdb->posts} WHERE post_type = 'offer'");
	$businesses = $wpdb->get_col("SELECT post_title FROM {$wpdb->posts} WHERE post_type = 'business' AND post_status = 'publish'");
	foreach($data as $value) {
		if (in_array($value['Business Name'], $businesses)) {
			$offer_title = mysql_real_escape_string($value['Offer Title']);
			$offer_description = mysql_real_escape_string($value['Offer Description']);
			$offer_legal = mysql_real_escape_string($value['Legal Terms']);
			$offer_start = mysql_real_escape_string($value['Start Date']);
			$offer_end = mysql_real_escape_string($value['End Date']);
			$offer_small_sub = $offer_legal . "<br />Fecha de inicio - " . $offer_start . "<br />Fecha final - " . $offer_end;
			/*==========================Now create offer here======================*/
			$new_offers = array(
				'post_title' => $offer_title,
				'post_content' => $offer_description,
				'post_type' => 'offer',
				'post_status' => 'publish',
			);
			$cat = $value['category'];
			$offer_post_id = wp_insert_post($new_offers, true); // created offer
			echo "<p style='color:green;'>" . $offer_title . " - Offer Imported</p>";
			wp_set_object_terms($offer_post_id, $cat, 'offer_category');
			$thumb_id = pn_get_attachment_id_from_url(trim($value['Offer Feature Image Link']));
			set_post_thumbnail($offer_post_id, $thumb_id);
			$offer_metas = array(
				"bus_name" => $value["Business Name"],
				"business_name" => $value["Business Name"],
				"offer_location" => $value["Business Location"],
				"offer_sub_description" => $offer_small_sub,
			);
			update_post_meta($offer_post_id, 'SkilledTheme_Themag_SKL_offer_meta', $offer_metas);

			// offer ends

			continue;
		}

		$new_business = array(
			'post_title' => $value['Business Name'],
			'post_content' => $value['Business Description'],
			'post_type' => 'business',
			'post_status' => 'publish',
		);
		$cat = $value['category'];

		// $c_id = get_cat_ID($cat);

		$the_post_id = wp_insert_post($new_business);
		wp_set_object_terms($the_post_id, $cat, 'business_category');
		$thumb_id = pn_get_attachment_id_from_url(trim($value['Logo Link']));
		set_post_thumbnail($the_post_id, $thumb_id);
		$metas = array(
			"business_location" => $value["Business Location"],
			"latitude" => $value["Latitude"],
			"longitude" => $value["Longitude"],
			"business_contact" => $value["Telephone"],
		);
		update_post_meta($the_post_id, 'SkilledTheme_Themag_SKL_business_meta', $metas);
		/*==========================Now create offer here======================*/
		$offer_title = mysql_real_escape_string($value['Offer Title']);
		$offer_description = mysql_real_escape_string($value['Offer Description']);
		$offer_legal = mysql_real_escape_string($value['Legal Terms']);
		$offer_start = mysql_real_escape_string($value['Start Date']);
		$offer_end = mysql_real_escape_string($value['End Date']);
		$offer_small_sub = $offer_legal . "<br />Fecha de inicio - " . $offer_start . "<br />Fecha final - " . $offer_end;
		/*==========================Now create offer here======================*/
		$new_offers = array(
			'post_title' => $offer_title,
			'post_content' => $offer_description,
			'post_type' => 'offer',
			'post_status' => 'publish',
		);
		$offer_post_id = wp_insert_post($new_offers, true); // created offer
		echo "<p style='color:green;'>" . $offer_title . " - Offer Imported</p>";
		wp_set_object_terms($offer_post_id, $cat, 'offer_category');
		$thumb_id = pn_get_attachment_id_from_url(trim($value['Offer Feature Image Link']));
		set_post_thumbnail($offer_post_id, $thumb_id);
		$offer_metas = array(
			"bus_name" => $value["Business Name"],
			"business_name" => $value["Business Name"],
			"offer_location" => $value["Business Location"],
			"offer_sub_description" => $offer_small_sub,
		);
		update_post_meta($offer_post_id, 'SkilledTheme_Themag_SKL_offer_meta', $offer_metas);

		// offer ends

	}

	echo '<a href="' . get_site_url() . '/wp-admin/edit.php?post_type=business" target="_blank">Check Business Entry</a><br />';
	echo '<a href="' . get_site_url() . '/wp-admin/edit.php?post_type=offer" target="_blank">Check Offer Entry</a>';
	$file_id = pn_get_attachment_id_from_url($_SESSION["csv_http_url"]);
	wp_delete_attachment($file_id, true); //to delete uploaded csv file from the media library
}

?>