All importers should support option to import without changing data

[GoogleCodeExporter]

It should be possible for users to turn off all unnecessary transformations of 
input data.  Many times these are irreversible, so the time to deal with them 
is at initial import.

One example is the XML importer has no way to turn off string->number 
conversion.  Other converters such strip leading and trailing double quotes 
that they find.

Original issue reported on code.google.com by tfmorris on 5 Nov 2011 at 4:27

• Blocked on: Auto-conversion on import trashes Hex values #308, Refine messes up quotations marks on import and export. #402, Line based importer needs to keep Quotation Marks with separators #420, #578, #596

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Issue 511 has been merged into this issue.

Original comment by tfmorris on 20 Dec 2011 at 3:44

[GoogleCodeExporter]

Original comment by tfmorris on 7 Sep 2012 at 9:15

• Changed state: Started

[GoogleCodeExporter]

In r2451 TabularImportingParserBase now defaults guessCellValueTypes to False 
so that importers which don't specify it don't get it turned on automatically.  
This was adversely affecting Excel, Open Office Calc, and Google Spreadsheets 
because they had no control to turn off the default since they have data types 
built in.

Original comment by tfmorris on 7 Sep 2012 at 9:24

[GoogleCodeExporter]

Original comment by tfmorris on 7 Sep 2012 at 9:35

• Now blocked on: #578, #596, Auto-conversion on import trashes Hex values #308, Line based importer needs to keep Quotation Marks with separators #420

[GoogleCodeExporter]

Original comment by tfmorris on 7 Sep 2012 at 9:35

• Now blocked on: Refine messes up quotations marks on import and export. #402

[GoogleCodeExporter]

I think most of the work is done for this and I'd like to clean up any loose 
ends and get it included in Refine 2.6.

Original comment by tfmorris on 18 Sep 2012 at 5:52

• Added labels: Milestone-2.6
• Now blocked on: Auto-conversion on import trashes Hex values #308, Refine messes up quotations marks on import and export. #402, Line based importer needs to keep Quotation Marks with separators #420, #578, #596