The data I'm importing has lots of "s as well as newlines, so it would be cool to be able to specify an arbitrary delimiter and enclosure for CSV files.

Comments

robert castelo’s picture

Would be good yes.

In the long run it would be better to hand the whole task of data input to a dedicated module like this one:

http://drupal.org/node/67043

That way other Drupal modules can use the data input functions, and then just concentrating on processing the data.

ontwerpwerk’s picture

Because http://drupal.org/project/profile_csv uses doubleqoute enclosures and semicolon delimiters and this module is the logical complement it would make much sense to at least support that format

webchick’s picture

Title: specify CVS delimeters » specify CSV delimeters

Fixing the title... must've been tired. :)

robert castelo’s picture

I would really like a API module that just handles CSV import.

emdalton’s picture

Version: master » 5.x-1.3

I need this -- I'm trying to rebuild my drupal system to avoid some data corruption that may have occurred. My user data has to include commas, as it includes LDAP information. Am I going to have to import directly to MySQL?

gcassie’s picture

I've had to import fields with commas as well. I switched to a tab-delimited file and modified the module slightly. There are two calls to the function fgetcsv in user_import.module; if you make the third argument in each "\t", the module will break the file up by tabs instead of commas.

I've imported ~30,000 user records this way with no problems.

SebCorbin’s picture

Version: 5.x-1.3 » master

Replacing to head as it could a significant feature... and subscribing

mokko’s picture

Is there a better way of doing this (exporting and importing users) by now? I am looking at http://drupal.org/project/importexportapi but it doesnt mention users and seems not to be quite ready. Haven't tried though, so method described in this issue still seems to be a good idea?

robert castelo’s picture

Status: Active » Fixed

User Import 6.x-3.0-beta1 has support for custom delimiters.

Not sure if it covers all the requirements of this issue, if it doesn't please re-open it and give more detail.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.