4 ms·
> You can probably also change the automatic type coercion Maybe for manual entry, but not when importing a foreign format like one if the many CSV variants th
by dspillett 6y ago
> You can probably also change the automatic type coercion
Maybe for manual entry, but not when importing a foreign format like one if the many CSV variants that we run into.
> buried somewhere in the settings
This is a huge problem, as where such settings exist they are by their very nature user-local. Back to our old frenemy CSV for one (sadly not hypothetical) example: too many times our clients shuffle data (exported from various places) around in text format and someone along the chain has the wrong locale set so when ISO8601 dates get silently converted it is to a format the next users version isn't expecting but silently assumes is correct because by some "miracle" the ambiguous day/month number combination is "valid" both ways around. The result is then imported into our system which is blamed for its answer not making sense...
- phonon 6y ago> Maybe for manual entry, but not when importing a foreign format like one if the many CSV variants that we run into. Use Get and Transform Data -> CSV You can control the typing per column when you import, split columns, etc.
- dspillett 6y agoUnfortunately, people working for our clients are not trained to do this. Or are but take the quicker option and hope that it works.