Provide a sample .csv file
hatseflats - September 23, 2005 - 10:41
| Project: | User Import |
| Version: | HEAD |
| Component: | Documentation |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Description
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 :-)
#1
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.
#2
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.
#3
Sample CSV file now included.
#4