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

Robert Castelo - September 23, 2005 - 13:16

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

hatseflats - September 23, 2005 - 13:33

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.

AttachmentSize
test.csv71 bytes

#3

Robert Castelo - November 27, 2005 - 15:00
Status:active» fixed

Sample CSV file now included.

#4

Robert Castelo - November 28, 2005 - 02:39
Status:fixed» closed
 
 

Drupal is a registered trademark of Dries Buytaert.