Issue 69097 - .cvs import
Summary: .cvs import
Status: CLOSED DUPLICATE of issue 20804
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.3
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2006-08-30 13:40 UTC by gregorystec
Modified: 2006-09-07 13:04 UTC (History)
2 users (show)

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

Attachments
.cvs import missconvertion (80 bytes, text/csv)
2006-08-30 13:44 UTC, gregorystec 		no flags Details
The biger .cva file with many misstakes in import (column "Tenroh Bderrs","9*","9#","1^" ) (29.78 KB, text/csv)
2006-08-31 14:02 UTC, gregorystec 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description gregorystec 2006-08-30 13:40:56 UTC 
In the case of import .cvs file, to the imported Fields are automatically
assigned data type (number, percent, text...). This assignment is made arbitrary
and for some set of data/fields faulty (is made bad data type assignment). I
suggest to add to the import dialog page option (check box) for example "Raw
import" to prevent any arbitrary data type assignment except your choice from
drop down list, default is 'text'. The individual assignment for columns could
be do in the 'Finds' preview. In the 'Fields' preview area of import dialog
form, the data are displayed properly.
In the assigned example file the  field "Pikal-ID" is interpreted as 'Date' type
incorrectly. The "Pikal-ID" is not date, is string.
Comment 1 gregorystec 2006-08-30 13:44:18 UTC 
Created attachment 38850 [details]
.cvs import missconvertion
Comment 2 Regina Henschel 2006-08-30 14:37:09 UTC 
In the import dialog you can choose the format. Click onto the column header in
the preview and then choose the format from the drop-down list "column type".

I do not understand the problem.
Comment 3 gregorystec 2006-08-31 14:02:35 UTC 
Created attachment 38875 [details]
The biger .cva file with many misstakes in import (column "Tenroh Bderrs","9*","9#","1^" )
Comment 4 Regina Henschel 2006-08-31 16:21:35 UTC 
It works for me. Make sure, that you choose the right type for the column in the
import dialog. If your local do not use a dot as decimal delimiter and the datas
have a dot, you must choose US-English for decimal numbers. Also make sure, you
choose the right order of year, month and day for date, according to your datas.
Comment 5 frank 2006-09-07 13:04:33 UTC 
double to Issue 20804

*** This issue has been marked as a duplicate of 20804 ***
Comment 6 frank 2006-09-07 13:04:59 UTC 
closed double