Convert a CSV file with two columns, where column A is the source URL and column B is the destination

convert_csv_to_json.php

<?php
/**
 * Settings your variables
 * $csv_file handles the name of your CSV file.
 * $csv_separator is the symbol used to sepparate the columns in the CSV file.
 * $sc_redirect_file is the final file you will need to import in Smartcrawl Pro -> Tools -> URL Redirection
 */
$csv_file = "redirect_list.csv";
$csv_separator = ";";
$sc_redirect_file = "sc_redirect.json";

$row_formatter_data = array(
        "title"=> "",
        "source"=> "\/kamloops?utm_camp=gmb",
        "path"=> "",
        "destination"=> "\/",
        "type"=> 301,
        "options"=> [],
        "rules"=> []

);

$redirect_list = array();

if (($handle = fopen($csv_file , "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, $csv_separator)) !== FALSE) {
        $row_formatter_data["source"]= $data[0];
        
        if (str_contains($row_formatter_data["source"], '.*') || str_contains($row_formatter_data["source"], '(') || str_contains($row_formatter_data["source"], '[')) {
            $row_formatter_data["path"] = "regex";
            $row_formatter_data["options"] = ["regex"];
        }
        else {
            $path = explode("?", $row_formatter_data["source"]);
            $row_formatter_data["path"] = $path[0];
            $row_formatter_data["options"] = [];
        }

        
        $row_formatter_data["destination"]= $data[1];

        $redirect_list[] = $row_formatter_data;

    }
    fclose($handle);
}

$sc_json = json_encode($redirect_list);
$fp = fopen($sc_redirect_file, 'w');
if(fwrite($fp, $sc_json)){
    echo "Done";
}
fclose($fp);

?>