Posts

Issue with comma delimiter while exporting data to CSV file with taxonomy csv module

Issue :- After exporting the data using taxonomy  csv module in Drupal, it separates the "description" into different cells treating the comma in the "description" field as the delimiter. Solution: - Add htmlspecialchars() in the file taxonomy_csv/export/taxonomy_csv.export.inc in the function taxonomy_csv_term_export(). Replace the line $result['line'][] = _taxonomy_csv_escape_line_break($item['value']); with $result['line'][] = htmlspecialchars(_taxonomy_csv_escape_line_break($item['value']));

How to overcome the longer time taking for export of data?

We have a site running in Drupal. We have tried to export taxonomy terms. On the remote server (from PROD), it took 5 minutes to export 9700 terms . As it is quite long, we have setup the site on local box and tried running the export script. And now, it took less than a minute to export the taxonomy terms.