A tool to convert AJ-Fork (Cutenews) data into a well-formated CSV for import into WordPress or other.

ajfork2csv.php

<?php
/*
2017-09-10
A tool to convert AJ-Fork (Cutenews) data into a well-formated CSV for import into WordPress or other.
*/

$input = file('data.txt');
$output = fopen('data.csv','w+');
$entries = 0;

function aj_prepareTitle($title) {	
	$title = strtolower($title);
	$title = str_replace("å", "aa", $title);
	$title = str_replace("ø", "o", $title);
	$title = str_replace("æ", "ae", $title);    
	$title = preg_replace('/&.+?;/', '', $title); // kill entities
	$title = preg_replace('/[^a-z0-9 _-]/', '', $title);
	$title = preg_replace('/\s+/', ' ', $title);
	$title = str_replace(' ', '-', $title);
	$title = preg_replace('|-+|', '-', $title);
	$title = trim($title, '-');

	return $title;
}

foreach ($input as $null => $line) {
	@list($date, $user, $title,$short,$unused1,$unknown1, $cat, $unknown3) = explode('|',trim($line));
	$news = array(
		"id" => $date,			
		"date" => date("Y-m-d\TH:i:s",$date),
		"author" => $user,
		"title" => str_replace ('"', '“', $title);
		"slug" => aj_prepareTitle($title),
		"short" =>  str_replace('{nl}',"\n",$short),
		"category" => $cat,
	);

	fputcsv($output, $news);
	$entries++;
}

echo 'entries parsed: ' . $entries;
?>