search

ddavisqa / google-refine

Automatically exported from code.google.com/p/google-refine
0 stars 0 forks source link

Auto-conversion on import trashes Hex values #308

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. have a data source that contains a column of Hex values
2. Import

What is the expected output? 
I expect the data to arrive intact. "0033" and "9e42" should arrive exactly as 
represented

What do you see instead?
Strings that do not contain a text character are being converted to numbers. 
Strings that contain an "e" and numerals are treated as if they were numbers 
expressed with scientific notation. Strings that contain numerals only have 
leading zeroes removed.

What version of Google Refine are you using?
Version 2.0 [r1836]

What operating system and browser are you using?
Mac OS X 10.6.6 Safari Version 5.0.3 (6533.19.4)

Is this problem specific to the type of browser you're using or it happens
in all the browsers you tried?
This problem occurs in Safari and Firefox

Please provide any additional information below.
MS Excel and Apple Numbers also do this. It is extremely annoying.

Original issue reported on code.google.com by malc...@notyourhomework.net on 15 Jan 2011 at 3:28

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
Discovered "auto-detect value types" check box is selected by default. When 
importing without that option selected the data is imported without conversion.

Original comment by malc...@notyourhomework.net on 15 Jan 2011 at 11:20

GoogleCodeExporter commented 9 years ago 
I think we should consider changing the default to unchecked.  It's both slow 
and often produces undesirable results.  Anything that can be done at import 
time can be done later (when it's more easily reversible too).

Original comment by tfmorris on 15 Jan 2011 at 4:15

GoogleCodeExporter commented 9 years ago 
tfmorris: hopefully the new importer UI will also help here, as you can toggle 
options and preview their effects right away.

Original comment by dfhu...@gmail.com on 15 Jan 2011 at 4:40

GoogleCodeExporter commented 9 years ago 
Importing from an XML source, with auto-convert turned off, changes the data as 
if auto-convert was turned on.

Original comment by malc...@notyourhomework.net on 17 Jan 2011 at 5:21

GoogleCodeExporter commented 9 years ago 
Can you attach an example file that demonstrates the problem of XML files not 
getting imported correctly when auto-detect types is turned off?

Original comment by tfmorris on 14 Jun 2011 at 7:38

GoogleCodeExporter commented 9 years ago

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

GoogleCodeExporter commented 9 years ago

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

GoogleCodeExporter commented 9 years ago

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