google-code-export / sqlite-manager

Automatically exported from code.google.com/p/sqlite-manager
1 stars 0 forks source link

CSV Import #456

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Import wizard
2. select attached file (csv file, ISO-8859-1, pipe as delimiter, first row 
doesn't contains field 
names)
3. press Ok

What is the actual output?
Error importing data: seems like it doesn't accept two consecutive delimiter 
(null values) 

What is the expected output?
It should import a 6 columns table

What version of the product are you using? On what target Application (e.g.
Firefox 3.5.1, etc.)? On what operating system?
Extension Version = 0.5.14 (previous release were ok)
Application = Firefox 3.6.3
OS = both windows Xp and MacOs (Snow Leopard)

Please provide any additional information below. In some cases
errors/warnings may be logged in the Error Console (in Firefox) which is
available under the Tools menu or using Ctrl+Shift+J. If you find any
related to this extension, please report that too.

Errore: SQLiteManager: Likely SQL syntax error: INSERT INTO 
"main"."voci_albero" VALUES 
('4976236','4976235','1','COSTITUZIONE ITALIANA','0') [ table main.voci_albero 
has 6 columns but 
5 values were supplied ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 
(NS_ERROR_FAILURE) 
[mozIStorageConnection.createStatement]
File sorgente: 
file:///Users/ruggero/Library/Application%20Support/Firefox/Profiles/0xdc0uz8.de
fault/extensi
ons/SQLiteManager@mrinalkant.blogspot.com/chrome/resource/sqlite.js
Riga: 907

Original issue reported on code.google.com by ruggerom...@gmail.com on 30 Apr 2010 at 10:43

Attachments:

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
solved in 0.5.15, isn't it?

Original comment by ruggerom...@gmail.com on 30 Apr 2010 at 11:02