FJ Software

Code: Alles auswählen

<?php
// CSV to XML converter for MyPhoneExplorer
// Public domain: use, reuse, peruse and abuse :)

// file uploaded
if (count($_FILES)) {

	// open uploaded file for reading
	$f = fopen($_FILES['csvfile']['tmp_name'], 'r');
	
	// iterator
	$i = 0;
	
	// init output var
	$xmlout = array();
		
	// call type (Storage)	
	$CallTypes = array('DC', 'RC', 'MC');
	
	// loop through CSV data
	while ($csvline = fgetcsv($f, 1024, ',', '"')) {
		
		// first line, get headings
		if ($i == 0) {
			$headings = $csvline;
			$i++;
			continue;
		}
		
		// populate data from headings
		foreach ($headings AS $j => $heading)
			${$heading} = $csvline[$j];
		
		// generate UNIX timestamp from standard timestamp
		list($stampdate, $stamptime) = explode(' ', $Time);
		list($yr,$mo,$da) = explode('-', $stampdate);
		list($hr,$mn,$sc) = explode(':', $stamptime);
		
		// OUTPUT
		$xmlout[] = "  <call number=\"$Number\" duration=\"$Duration\" date=\"" . mktime($hr,$mn,$sc,$mo,$da,$yr) . "000\" type=\"" . (array_search($Storage, $CallTypes)+1) . "\" />";
		
		$i++;
	}
	
	// file population of data
	$xml_start = '<' . "?xml version='1.0' encoding='UTF-8' standalone='yes' ?" . ">\r\n<calls count=\"" . count($xmlout) . "\">\r\n";
	$xml_end   = "\r\n</calls>";
	
	// output as XML file to save
	header('Content-Type: text/xml');
	header('Content-Disposition: attachment; Filename="calls-restored.xml"');
	echo $xml_start . implode("\r\n", $xmlout) . $xml_end;
	exit;
}

// Output upload form...
?>

<div align="center" style="margin-top: 25px">
	<div style="font-size: 20px">CSV to XML converter for MyPhoneExplorer / Android Call Log</div>
	<div style="padding: 25px; text-align: center; width: 600px; border: 1px dotted #000000; margin-top: 5px">
	<form name="csv2xml" method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>" style="margin: 0px" enctype="multipart/form-data">
	CSV file from MyPhoneExplorer: <input type="file" name="csvfile">
	<input type="submit" value="convert" style="font-weight: bold">
	</form>
	</div>
</div>

Code: Alles auswählen

<?php 
// CSV to XML converter for MyPhoneExplorer 
// Public domain: use, reuse, peruse and abuse :) 
date_default_timezone_set('America/Chicago');
$file = "export.csv";

   // open uploaded file for reading 
   $f = fopen($file, 'r'); 
    
   // iterator 
   $i = 0; 
    
   // init output var 
   $xmlout = array(); 
       
   // call type (Storage)    
   $CallTypes = array('DC', 'RC', 'MC'); 
    
   // loop through CSV data 
   while ($csvline = fgetcsv($f, 1024, ',', '"')) { 
       
      // first line, get headings 
      if ($i == 0) { 
         $headings = $csvline; 
         $i++; 
         continue; 
      } 
       
      // populate data from headings 
      foreach ($headings AS $j => $heading) 
         ${$heading} = $csvline[$j]; 
       
      // generate UNIX timestamp from standard timestamp 
      list($stampdate, $stamptime, $am) = explode(' ', $Time);
	  $stamptime = $stamptime . " " . $am;
	  //echo "\n" . $stamptime . " - ";
	  $stamptime = date("H:i", strtotime($stamptime));  
	  //echo $stamptime . "\n";	  
      list($mo,$da,$yr) = explode('/', $stampdate); 
	  //echo $mo . "-" . $da . "-" . $yr . "\n";
      list($hr,$mn,$sc) = explode(':',  $stamptime); 
	  //echo $hr . "-" . $mn . "-" . $sc. "\n";
      $sc = "00"; 
      // OUTPUT 
      $xmlout[] = "  <call number=\"$Number\" duration=\"$Duration\" date=\"" . mktime($hr,$mn,$sc,$mo,$da,$yr) . "000\" type=\"" . (array_search($Storage, $CallTypes)+1) . "\" />"; 
       
      $i++; 
   } 
    
   // file population of data 
   $xml_start = '<' . "?xml version='1.0' encoding='UTF-8' standalone='yes' ?" . ">\r\n<calls count=\"" . count($xmlout) . "\">\r\n"; 
   $xml_end   = "\r\n</calls>"; 
    
   // output as XML file to save 
   header('Content-Type: text/xml'); 
   header('Content-Disposition: attachment; Filename="calls-restored.xml"'); 
   echo $xml_start . implode("\r\n", $xmlout) . $xml_end; 
   exit; 
 

// Output upload form... 
?>