Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
Error when importing from textfile in EDBManager |
Wed, Oct 10 2007 7:43 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent Link |
Mats Berggren | Tim,
Have you had time to look into this problem yet? Mats Berggren |
Thu, Oct 18 2007 2:24 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Friday, April 26, 2024 at 06:09 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |