Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread import from other DB
Sat, Jan 2 2010 2:15 AMPermanent Link

"Fabio Codebue @ GestionaleOpen"
the only way to import from other DB, without writing lots of code is
using store and import table?

I tried with unicode DB... but they always answer: Error the import
file is truncated or incompleted...

I try to put csv file in ANSI mode, UTF-8 standard, UTF-8 without
BOM...


nothing to do....
Fabio Codebue
Gestionale Open srl
Sat, Jan 2 2010 2:16 AMPermanent Link

"Fabio Codebue @ GestionaleOpen"
naturallly all works if I use ANSI database...

I forget to explain that I'm using Win7 x64bit enviroment, naturally
with 32bit version of Lazarus 0.9.29/fpc 2.3.1
Fabio Codebue
Gestionale Open srl
Sat, Jan 2 2010 12:33 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Fabio,

<< the only way to import from other DB, without writing lots of code is
using store and import table? >>

No, the easiest way is to use a migrator:

http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=0&topic=14

Just copy the desired migrator .DLL into your configuration file path,
making sure to select the proper type of migrator (ANSI or Unicode).

You don't need to create the migrator using CREATE MIGRATOR if you are using
the ElevateDB Manager to do the migration - the ElevateDB Manager
automatically looks for these DLLs and sets them up as migrators if they are
found in the configuration file path.

Which type of database are you trying to import from ?

<< I tried with unicode DB... but they always answer: Error the import file
is truncated or incompleted... >>

This usually means that you're trying to import a Unicode .csv into an ANSI
version of ElevateDB, or vice-versa.  You need to make sure that the .csv is
in Unicode format for (no BOM) for the Unicode version of ElevateDB, which
is what you should be using for Windows CE/Lazarus.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image