Vidal Graupera's Profile

Great topic.

One problem I've had with importing CSV files from real users is often they aren't always valid, i.e., they include extended characters, are encoded weirdly, or are otherwise malformed leading to many parsing errors. Finally if they include headers at all they do not match that names of the attributes in the Rails model.

The users who send me files like these are also the least technical so hardest for them to clean up themselves or understand why files are invalid.

Would like to see more about error handling, or know what people do with these real world messy files. Thanks.