Can you please provide a sample .csv file or list the syntax in README.TXT. A comma separated cvs created in excel show all columns as one and when i manually edit the file to use , instead of ; i still get zero imports.

Otherwise great module, really usefull :-)

CommentFileSizeAuthor
#2 test.csv71 byteshatseflats

Comments

robert castelo’s picture

robert castelo commented

This is the main thing I need to work my way through now - csv file formats.

The module uses fgetcsv() to get each line of the csv file as an array of columns. Unfortunately this doesn't work with all line endings. It works with Excel csv file saved as 'Windows', which I guess is the most common - I'll add that info to the README.txt.

I'm working on some clean up functions that automatically convert between different line endings.

Hopefully we will end up with a list of working formats.

hatseflats’s picture

hatseflats commented
StatusFileSize
new test.csv71 bytes

The attached file is a file i created in excel and saved as .csv (MS-DOS). When i upload i get the right columns but when i test zero rows are imported.

robert castelo’s picture

robert castelo commented
Status: Active » Fixed

Sample CSV file now included.

robert castelo’s picture

robert castelo commented
Status: Fixed » Closed (fixed)
wwwoliondorcom’s picture

wwwoliondorcom commented

Hello,

I can't find how to make a Csv file.

I have a list of email addresses separated by coma.

Is it possible to create a user with each of these emails automatically?
If email address is JOSHUAK@GMAIL.COM create the user JOSHUAK with password JOSHUAK

Can you show me how should look the CSV file to import ?

Thanks a lot.