Issue 97416 - Additional options for csv import
Summary: Additional options for csv import
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: DEV300m37
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL: http://wiki.services.openoffice.org/w...
Keywords:
Depends on: 3687 102141
Blocks:
  Show dependency tree
 
Reported: 2008-12-19 04:09 UTC by kyoshida
Modified: 2017-05-20 10:20 UTC (History)
5 users (show)

See Also:
Issue Type: PATCH
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
patch for sc (24.06 KB, patch)
2008-12-19 04:10 UTC, kyoshida
no flags Details | Diff
patch for officecfg (3.62 KB, patch)
2008-12-19 04:11 UTC, kyoshida
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description kyoshida 2008-12-19 04:09:32 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.
Comment 1 kyoshida 2008-12-19 04:10:50 UTC
Created attachment 58929 [details]
patch for sc
Comment 2 kyoshida 2008-12-19 04:11:12 UTC
Created attachment 58930 [details]
patch for officecfg
Comment 3 kyoshida 2008-12-19 04:16:22 UTC
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.
Comment 4 ooo 2009-01-28 11:41:13 UTC
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.
Comment 5 kyoshida 2009-06-05 21:09:14 UTC
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.
Comment 6 kyoshida 2009-06-10 20:33:13 UTC
.
Comment 7 kyoshida 2009-07-27 16:29:04 UTC
not sure if I can make it, but let's target this for 3.2.
Comment 8 kyoshida 2009-07-27 16:35:28 UTC
I meant 3.2!  Geez.  I need to get my hands checked out.
Comment 9 kyoshida 2009-08-07 03:31:17 UTC
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.
Comment 10 kyoshida 2009-08-07 03:53:24 UTC
fixed in koheicsvimport cws.
Comment 11 kyoshida 2009-08-07 04:00:14 UTC
re-assign to oc for qa.
Comment 12 oc 2009-11-05 12:55:08 UTC
adjusting target according to cws target
Comment 13 ali_b 2009-12-11 11:27:22 UTC
Please see Issue 85946.
I think this is a more general approach.
Comment 14 oc 2010-03-09 13:35:47 UTC
verified in internal build cws_koheicsvimport
Comment 15 frank.thomas.peters 2010-08-11 17:30:17 UTC
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.