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 :-)
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | test.csv | 71 bytes | hatseflats |
Comments
Comment #1
robert castelo commentedThis 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.
Comment #2
hatseflats commentedThe 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.
Comment #3
robert castelo commentedSample CSV file now included.
Comment #4
robert castelo commentedComment #5
wwwoliondorcom commentedHello,
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.