Tfe

Blog/jokoak_euskaraz/shadow_tactics/csv_to_json_general.php

<?php

$file_csv = "loca_general_Spanish-resources.assets-322.csv";
$file_json = "jsons/loca_general_Spanish-resources.assets-322.json";
$new_file_json = "eus/loca_general_Basque-resources.assets-322.json";

$decoded = json_decode(file_get_contents($file_json),true);
$data = file_get_contents($file_json);

$strings= [];
if (($handle = fopen($file_csv, "r")) !== FALSE){
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $id = $data[2];
        $strings[$id]  = $data[5];
    }
}

$lines_m_script = preg_split("/[\r\n]+/", $decoded["m_Script"]);
$new_lines = "";

foreach($lines_m_script as $line)
{
    $data = preg_split("/\t/", $line);
    $id = $data[0];
    if(isset($strings[$id]) && !empty($data[2]))
    {
        $data[2] = $strings[$id];
    }
    $new_lines .= join("\t", $data)."\r\n";
}
$decoded["m_Script"] = $new_lines;

file_put_contents($new_file_json, json_encode($decoded, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES));