Tag Archives: CSV

Drupal 7 – Export data using Views data export module with Drush command

Yesterday we talked about exporting data using the Views data export module.
Drupal 7 – Export view data CSV, XML, XLS by Views data export module

The module also provides a Drush command such that you can run the export command in the server which is convenient for backend integration.

The following command is stated in the project page.

  • drush views-data-export [view-name] [display-id] [output-file]

Continue reading Drupal 7 – Export data using Views data export module with Drush command

Drupal 7 – Export view data CSV, XML, XLS by Views data export module

In Drupal 7, we can easily create export Views data by the Views data export module. Say, we want to export all current nodes with title and post date.

1. Download and install the module.
Continue reading Drupal 7 – Export view data CSV, XML, XLS by Views data export module

Garbled characters when opening CSV in Microsoft Excel

Quite often i will use Microsoft Excel to edit CSV file. But sometimes you may find garbled characters in the opened file and it is caused by the file encoding.

For example, Excel could not view UTF-8 file. So if you got a CSV encoded in UTF-8, you need to convert it to ANSI encoded. This could be done by opening the CSV file in Notepad and then save it as new file in ANSI encoding. Continue reading Garbled characters when opening CSV in Microsoft Excel