Sitemap

Amicuk Programming Answers

Excel import problems (collected)

2015-10-11   Views:0

Advertisement

There are a few problems with Excel Import. Some have been reported elsewhere. Test Data Table Definition.   CREATE TABLE "JIM"."EXCEL_IMPORT"    (     "COLUMN1" VARCHAR2(100 BYTE),      "COLUMN2" VARCHAR2(100 BYTE)

There are a few problems with Excel Import. Some have been reported elsewhere.
Test Data
Table Definition.
  CREATE TABLE "JIM"."EXCEL_IMPORT"
   (     "COLUMN1" VARCHAR2(100 BYTE),
     "COLUMN2" VARCHAR2(100 BYTE),
     "COLUMN3" VARCHAR2(100 BYTE),
     "COLUMN4" NUMBER(10,2),
     "COLUMN5" NUMBER(10,0)
  TABLESPACE "USERS" ;
Spreadsheet contents
Label1,Name 1,Desc 1,2.95,2.45
Label2,Name 2,Desc 2,1,1.23456
1 The file chooser doesn't remember the last directory used, but defaults to the sqldeveloper install directory.
2 Numbers in the preview are truncated/rounded.
2.95->3
2.45->2.4
1->1
1.23456->1.2
3 If you make a mistake in assigning table columns to spreadsheet columns, you can't undo it because the columns already used are removed from the list of available columns. This needs an 'De-assign' option
4 When you assign columns, number columns don't get their precision or scale picked up.
This shouldn't matter because the DML is simple doing insert...values(1.2), but the end result is wrong (see 5).
The DML looks OK (relative to the already rounded numbers, not to the original spreadsheet.
insert into EXCEL_IMPORT (COLUMN1,COLUMN2,COLUMN3,COLUMN4,COLUMN5) VALUES('Label1','Name 1','Desc 1',3,2.4);
insert into EXCEL_IMPORT (COLUMN1,COLUMN2,COLUMN3,COLUMN4,COLUMN5) VALUES('Label2','Name 2','Desc 2',1,1.2);
5 A problem with assigning colums if you switch off header row after assigning columns. There are a number of slightly different problems.
a. Select your table and select all the columns in the 'Columns' tab
b. Assign table columns to your spreadsheet columns in the 'Data Types' tab
c Go back to the columns tab
d Uncheck 'Header Row?' - the columns are all deselected
e Reselect all columns
Any of several things may happen now
e.1 In the Data types tab, columns may be missing
e.2 Column assignments may be wrong
e.3 There are no table columns in the drop down when trying to assign columns
It looks as if the handling of the list of table columns is not right.
6 The 'Choose data type' prompt is misleading. It should be 'Choose Table Column'
7 The help is very sparse, especially on the datatypes tab.
I've also posted a couple of enhancement suggestions in the exchange
- an option to save the DML
- an option to save the metadata for a given import so that the next import to the same table is just a matter of select file and go.

The replay answer
Advertisement
Are there any solutions to the data truncation/rounding problem?
I am trying to import Excel data into tables through SQL Developer and notice that the preview screen displays truncated/rounded numbers even after I have deliberately formatted the data in Excel as numbers in 3.2 format. Is there a workaround?
Thanks for any advice you can give.
Frank Eichel
Forest Inventory Analyst
Natural Resources Canada
Victoria, Canada

Go to See the other 5 answers

Excel import problems (collected)

Category:DefaultRelease time:2015-10-11Views:130

There are a few problems with Excel Import. Some have been reported elsewhere. Test Data Table Definition.   CREATE TABLE "JIM"."EXCEL_IMPORT"    (     "COLUMN1" VARCHAR2(100 BYTE),      "COLUMN2" VARCHAR2(100 BYTE)[More]

Excel Import problem

Category:DefaultRelease time:2015-10-11Views:130

I'm having trouble with importing data from excel. I'm using HiQ version 4.5 and during import spurious data seems to appear after import. doesn't inspire confidence in software qualityWhen the Excel Import dialog is invoked, you need to give the inf[More]

Excel import problems

Category:DefaultRelease time:2015-10-11Views:130

Hi - i recently imported information of a football team from excel into indesign and the birth date information magically all changed by 4 years and 1 day. Not very helpful! The Excel application is Microsoft 2008 and Indesign is CS3. Has anyone else[More]

1.5.1: Excel import - Problem with NULL values in date fileds

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'm trying to import Excel Data via CSV with the import into table feature of SQLDeveloper. Everything works fine, but if I select some of my date colums I get an error telling me that I have null or invalid values in a date column: Verifying if[More]

Probleme bei Excel-Import mit SBO 2007

Category:DefaultRelease time:-0001-11-30Views:130

Hallo zusammen! Wir haben bei einem gewöhnlichen Stammdatenimport zu den Geschäftspartnern mit Excel folgendes Problem: die Fehlermeldung lautet: interner Fehler --> Zahlwege für Zahlungsassistenten (OPYM) (-2007) aufgetreten. Wenn wir die Zahlwege f[More]

Excel import: importing too many rows

Category:DefaultRelease time:2015-10-11Views:130

I am working with SQL Developer 1.2.0 Build MAIN-29.98 and have a problem with Excel import: I would like to import some data from an XLS file. I click on Actions -> Import Data -> Excel, complete the dialog and check the DML: there are 3 insert int[More]

Excel-Import with SBO 2007

Category:DefaultRelease time:2015-10-11Views:130

Hello to all! I have problems concerning the Excel-Import-function within SAP 2007. I want to import some business partners (what should not be such a huge problem), but an internal error occures which states: "internal error: Payment Methods for Pay[More]

CS5 Windows import problems (ppj, avi)

Category:DefaultRelease time:-0001-11-30Views:130

I have the CS5 Master Collection installed on a Windows 7 Ultimate 64-bit laptop. I have some old Premiere 6.5 projects that I wanted to open/import. When I first tried this, I could open the ppj files and make prproj files from them, either by doubl[More]

HD Import Problems

Category:DefaultRelease time:-0001-11-30Views:130

I recently purchased a Canon HV 20 HD Camcorder. Picture quality and playback from the camera is excellent. However I have had a few problems following import of HD footage to my computer with IMovie 06 HD. Most of the footage is fine, however a few[More]

Excel Importer for Visual Studio LightSwitch 2013

Category:DefaultRelease time:2015-10-11Views:130

Has anyone managed to get the 'Excel Importer for Visual Studio LightSwitch' extension working with Visual Studio 2013?Hi Kevin, I assume you mean this extension here - http://code.msdn.microsoft.com/silverlight/Excel-Importer-for-Visual-61dd4a90 Fro[More]

LR3.2 import problem on computer with Windows OS

Category:DefaultRelease time:2015-10-11Views:130

LR3.2 import problem on Windows OS This is a continuation of a question that I posed on August 22, 2010 in the discussion string "Cannot import CR2".  I have not been able to resolve the issue of importing an image into an existing folder locati[More]

Hot
I am having trouble getting the Business Catalyst panel in Dreamweaver CS6 to work. The panel works just fine on another computer using Dreamweaver CS 5.5, but I cannot get CS6 to show any of the standard BC panel elements. I've tried the few solutio [More]
When I am speaking on my Curve it will start to Buzz in the back ground and then shortly it will completely shutdown and then it goes thru a reboot. Does anyone have any ideas? Solved! Go to Solution.Hi and welcome to the forums! I would check two th [More]
Hi, I am working in Quality Management for Material procurement quality check according to vendor, The Quality Inspection parameter same material procure deferent vendors have different parameter. Please help me for SAP configuration for above scenar [More]
I have a site which is set up in 2 main sections. I have a custom error page working for one half of the site but need to specify a different error page for the other half of the site. For example, any errors which occur while on pages in the /html f [More]
I have a user table that contains active and disabled users(tblUsers), I also have a transaction table(tblTransactions) with rows of records and an empty UserId colunm. I want to select from UserId of active users from tblUsers and distribute those I [More]
HOW DO YOU CHANGE THE NUMBER OF EMAILS THAT ARE KEPT ON YOUR PHONE BEFORE YOU DELETE THEM?Your carrier sets this by time, not the number of "rings" since different ring tones take different times/ring.  The typical setting is 30 seconds, sometim [More]
Hi, One of our systems SP is upgraded 62 for Basis and ABAP and 28 for APPL. After which it is giving a syntax error in the program /PBS/SAPMF05L.  Any help on how to rectify this SAP program quickly? thank you, NagaHi Naga, i'm not sure but it seems [More]
Mobileme subscription has expired.  Unable to access IDisk.  How do I update to ICloud.Update to 10.7.2 and then cheak out System preferences you'll get iCloud configartion.Read other 2 answers [More]
Hi friends Can you guys show me some links to some great motion 5 transtions.Hi Luxorox Thanks for the tips. I have always try to reverse engineer motion template to see what is under the skin. But sometimes it is quite tedious to do so, especially w [More]
The line of above choices is mostly unreadable. Only a small portion of the top of the choices are able to be read for selection.A possible cause is that you have increased the minimum font size. If you have increased the minimum font size then try t [More]