Issue 97416

Summary: Additional options for csv import
Product: Calc Reporter: kyoshida
Component: open-importAssignee: oc
Status: CLOSED FIXED QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: frank.loehmann, issues, jbf.faure, ooo, uwefis
Version: DEV300m37   
Target Milestone: ---   
Hardware: All   
OS: All   
URL: http://wiki.services.openoffice.org/wiki/Calc/Features/Numbers_import_for_plain_text_files
Issue Type: PATCH Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on: 3687, 102141    
Issue Blocks:    
Attachments:
Description Flags
patch for sc
none
patch for officecfg none

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.