A lot of data in CSV files I've imported before contain commas and quotes. It's always a pain to have to search and replace these with escape characters to create a valid CSV file, and often it just refuses to work properly for unknown reasons. In phpMyAdmin you can import from Excel, Open Doc format, CSV, etc, directly into a MySQL table.

It would be great if User Import did the same, or at least allowed import from a MySQL table, the way the Migrate (version 1) module does.

Comments

gisle’s picture

Issue summary: View changes
Status: Active » Closed (won't fix)

Import from MySQL table or Open Doc format is beyond the scope of this module.

You can import SQL using other tools including drush, and for other formats, consider Feeds.