Fixed problem – Add variable delimiter for export to csv file – to import excel
-
Hi guys!
Following a problem with a complex data import, I made a change to the export-csv.php file to add the possibility to customize the delimiter in the csv file output. I think it can be useful to many!open the file “export-csv.php” located in the “\inc” folder of the plugin and change the array2csv function as follows
public function array2csv(array &$array, $df){ $delimiter = '|'; if (count($array) == 0) { return null; } $array_keys = array_keys($array); $heading = array(); $unwanted = array('cfdb7_', 'your-'); foreach ( $array_keys as $aKeys ) { $tmp = str_replace( $unwanted, '', $aKeys ); $heading[] = ucfirst( $tmp ); } fputcsv( $df, $heading, $delimiter); foreach ( $array['form_id'] as $line => $form_id ) { $line_values = array(); foreach($array_keys as $array_key ) { $val = isset( $array[ $array_key ][ $line ] ) ? $array[ $array_key ][ $line ] : ''; $line_values[ $array_key ] = $val; } fputcsv($df, $line_values, $delimiter); } }
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘Fixed problem – Add variable delimiter for export to csv file – to import excel’ is closed to new replies.