1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
<?PHP
if ($argc == 2)
{
$lines = file($argv[1]);
$c_lines = count($lines);
$array01 = explode(",", $lines[0]);
$array01 = array_map('trim', $array01 );
// chech if this is a multi value csv
$arr1 = explode(",", $lines[1]);
$arr2 = explode(",", $lines[2]);
$multivalue = false;
if ($arr1[0] == $arr2[0]) {$multivalue = true;}
if (!$multivalue)
{
for($i=1;$i<$c_lines;$i++) {
$arrayd = explode(",", $lines[$i]);
$c_arrayd = count($arrayd);
$data.="[".$arrayd[0]."]\n";
for ($x=1;$x<$c_arrayd;$x++) {
$field = $arrayd[$x];
if (strpos( $field, ' '))
{ $field = "\"".$field."\""; }
$data.=$array01[$x]." = ".$field."\n";
}
}
} else {
$lastsection = "";
// $section[] = "";
$fpas = true;
$x=0;
for($i=1;$i<$c_lines;$i++) {
$arrayd = explode(",", $lines[$i]);
$c_arrayd = count($arrayd);
if ( $lastsection != $arrayd[0] ) {
if ($section) {
foreach ($section as $iniline)
$data .= $iniline."\"\n";
$data .= "\n";
}
$data.="[".$arrayd[0]."]\n";
$lastsection = $arrayd[0];
unset($section);
$fpas = true;
}
for ($x=1;$x<$c_arrayd;$x++) {
$field = $arrayd[$x];
if (strpos( $field, ' '))
{ $field = "\"".$field."\""; }
$field = trim($field, "\n");
if ($fpas)
$section[$x] = $array01[$x]." = \"".$field;
else
$section[$x] .= ",".$field;
}
$fpas = false;
}
foreach ($section as $iniline) $data .= $iniline."\"\n";
}
echo "$data\n";
}
else
{
echo "\n";
echo "Usage: php csv2ini.php file.csv > file.ini\n";
echo "\n";
echo "Notes: before converting you have to create and/or adjust all the first descriptive row\n";
echo "Spaces are not allowed !\n";
echo "probably you need to do something like: php csv2ini.php file.csv | grep -v \"nused\" > file.ini\n";
echo "\n";
}
?>
|
