[SERVER-3180] CSV/TSV import split data on line breaker Created: 02/Jun/11  Updated: 29/Aug/11  Resolved: 22/Jun/11

Status: Closed
Project: Core Server
Component/s: Tools
Affects Version/s: 1.8.0
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Charles Ke Qiao Assignee: Mathias Stearn
Resolution: Duplicate Votes: 0
Labels: corrupt, csv, import, return, tsv
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

window xp


Issue Links:
Duplicate
duplicates SERVER-1097 mongoimport / export should adhere to... Closed
Operating System: Windows
Participants:

 Description   

when import data that contains long descritpion text, mongo import tool snap a single CSV cell and treat it as multiple line

Sample Data

TITLE , DESCRIPTION
title 1 , " this is sample description, line break start here
description continue on new line
end of description here. "

Excel will disaply above csv file correctly, however, because description contains line break, mongodb import tool will treat it as 3 csv records instead of a single cell.

I think this is a bug and hope the fix can go into the latest release.

Please also advise if here is any work around to allow successfully import the csv content and stop the record being truncated by line breaker.

Regards,
Charles


Generated at Thu Feb 08 03:02:18 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.