csv2sql

Categories

Component ID

2409555

Component name

csv2sql

Component type

module

Maintenance status

Development status

Component security advisory coverage

covered

Downloads

33333

Component created

Component changed

Component body

Development is done on GitHub

Convert CSV to SQL and create a table in your Drupal installation

CSV are a great way to give a client to enter their data that will be migrated to the site. However, for the migration itself, SQL would be quicker.

Convert a single file.

Execute the command: drush csv2sql /PATH/TO/file.csv

Scan a directory.

You have the option to scan a whole directory instead of giving an exact path to a csv file. Execute the command: drush csv2sql /PATH/TO/directory/

Will create a _raw_file table in the Drupal installation which drush is running under.

More details can be found here.