Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Error when importing from textfile in EDBManager
Wed, Oct 10 2007 7:43 AMPermanent Link

Mats Berggren
Can anyone help me with the following problem?

I use ElevateDB Manager (Unicode) version 1.05

In the ElevateDB Manager I create the following simple table:
CREATE TABLE "Test1" (
"ID" INTEGER NOT NULL ,
"FRNR" INTEGER NOT NULL ,
"ABNR" INTEGER ,
"ARKBILD" VARCHAR(50) COLLATE "SVE_CI"
)

Then I insert one row and export the table to a textfile with the following command:
EXPORT TABLE "Test1"
TO 'D:\Delad\NappData\Test1.csv'
DELIMITER CHAR #9
QUOTE CHAR '"'
DATE FORMAT 'yyyy-mm-dd'
TIME FORMAT 'hh:mm:ss n' AM LITERAL 'AM' PM LITERAL 'PM'
DECIMAL CHAR '.'
BOOLEAN TRUE LITERAL 'True' FALSE LITERAL 'False'
INCLUDE HEADERS
MAX ROWS -1

The resulting file looks like this:
"ID"   "FRNR"   "ABNR"   "ARKBILD"
1   1   1   "Hello"

Then I delete the existing row in the table Test1 and try to import from file with the command:
IMPORT TABLE "Test1"
FROM 'D:\Delad\NappData\Test1.csv'
DELIMITER CHAR #9
QUOTE CHAR '"'
DATE FORMAT 'yyyy-mm-dd'
TIME FORMAT 'hh:mm:ss n' AM LITERAL 'AM' PM LITERAL 'PM'
DECIMAL CHAR '.'
BOOLEAN TRUE LITERAL 'True' FALSE LITERAL 'False'
USE HEADERS
MAX ROWS -1

When I execute the import I get an error message:
================================================================================
SQL Error (ElevateDB 1.05 Build 1)
================================================================================

ElevateDB Error #904 Error importing the file D:\Delad\NappData\Test1.csv into
the table Test1 (The import file is truncated or incomplete)

What is the problem here? The ElevateDB Manager can't import a file it has exported. It doesn't seem right.

I am very grateful for any solution to this problem.

Mats Berggren
Wed, Oct 10 2007 10:05 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mats,

<< Can anyone help me with the following problem? >>

I'm looking into this and will let you know by this afternoon what I find.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Oct 18 2007 4:08 AMPermanent Link

Mats Berggren
Tim,

Have you had time to look into this problem yet?

Mats Berggren
Thu, Oct 18 2007 2:24 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mats,

<< Have you had time to look into this problem yet? >>

Not yet, but I will do so shortly and let you know.  No matter what, it will
be fixed/addressed for the 1.06 release.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Nov 1 2007 6:26 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mats,

<< Have you had time to look into this problem yet? >>

It is indeed a bug in the Unicode importing, and will be fixed in 1.06.   If
you need the source code fix, just let me know and I will detail it for you.
It is a very minor fix.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image