Tfe

Blog/jokoak_euskaraz/csv2ToJson.php

<?php

if(count($argv)<2 || !file_exists($argv[1]))
{
    die($argv[0]." : Missing filename.csv filename.json argument.\n");
}


$newCsv=[];
$trads=[];
if (($handle = fopen($argv[1], "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

        $json_file = $data[0];
        $loc = $data[1];
        $es = $data[2];
        $eus = $data[3];
        $json = json_decode(file_get_contents($json_file),true);
        print "READ $json_file / $loc\n";

        if(empty($eus)) { print "Skippe $json_file / $loc\n"; continue; }

        if($loc=="m_hLocalization")
        {
            foreach($json["m_hTitleLocalization"]["Array"] as &$loc_data)
            {
                if($loc_data["m_nLanguage"]==3)
                {
                    $loc_data["m_sText"]=$eus;
                }
            }
            //file_put_contents($json_file, json_encode($json, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES));
            file_put_contents($json_file, json_encode($json, JSON_PRETTY_PRINT  ));
        }
        if(preg_match("/^(\d+)\/m_hLocalization/", $loc, $regs))
        {
            print "TEST ".$regs[1]."\n";
            foreach($json["content"]["Array"][$regs[1]]["m_hLocalization"]["Array"] as &$loc_data)
            {
                if($loc_data["m_nLanguage"]==3)
                {
                    print $loc_data["m_sText"] ." = $eus\n";
                    $loc_data["m_sText"]=$eus;
                    //exit;
                }
            }
            file_put_contents($json_file, json_encode($json, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES));
        }
    }
    fclose($handle);
}