Apache OpenOffice (AOO) Bugzilla – Issue 97416
Additional options for csv import
Last modified: 2017-05-20 10:20:31 UTC
Let's add a new option to import quoted fields as text for CSV import. This is often requested by users. The current ascii import filter doesn't make any distinction between quoted and unquoted fields, in terms of data types. Some users wish to always import quoted fields as text. This blog entry of mine http://kohei.us/2008/12/18/its-text-when-its-quoted-stupid/ might shed more light on this.
Created attachment 58929 [details] patch for sc
Created attachment 58930 [details] patch for officecfg
These are the patches that implement this enhancement. Note that these patches also implement the feature done by muthusuba as described in Issue 3687 since it depends on that feature.
One nitpick: as seen in the screenshot http://kohei.us/wp-content/uploads/2008/12/ascii-import-quoted-field-as-text-dialog.png of your blog, the "Quoted field as text" check box IMHO should not be grouped under Separators (as shouldn't be "Text delimiter"). I suggest to move both to an own group. Doesn't apply the "quoted is text" to fixed width as well? Cc'ing 'fl' of UX for input, if necessary.
I'd like to also add an option to select language (locale), and an option to enable/disable automatic number recognition, similar to what I did for the html import. See Issue 102141 or my blog entry http://kohei.us/2009/05/21/html-import-option/ for the html options. That would solve the issue discussed in Issue 87999 as well as other similar csv import issues wrt incorrect date recognition.
.
not sure if I can make it, but let's target this for 3.2.
I meant 3.2! Geez. I need to get my hands checked out.
Spec is now available here: http://wiki.services.openoffice.org/wiki/Calc/Features/Numbers_import_for_plain_text_files The development is on-going in koheicsvimport cws.
fixed in koheicsvimport cws.
re-assign to oc for qa.
adjusting target according to cws target
Please see Issue 85946. I think this is a more general approach.
verified in internal build cws_koheicsvimport
The new dialog uses a complete new set of help IDs, thus breaking the context sensitive help completely. Please make sure to conserve the help ids next time. @OC: Please add help functionality to your test plans.