(Version 2 of everything) I was trying to move data from an older Ansi
database (used with Delphi) to a newer Unicode (gonna be used with .Net), so
I thought I'd play around with the store. I created a store and exported a
three-field table to a CSV to that store. The third field in each record is
all NULL.

So the CSV ends up looking like this:

"EDU-153-01-2008SU","0214301",
"ISC-132-01-2008SU","0263088",
"RED-090-01-2008SU","0216198",
"SOC-213-01-2008SU","0470641",
"BUS-110-W1-2008SU","0213251",

However, trying to import into EDBManager (Unicode), after creating a store
pointing to the same directory, keeps giving me an error: "The import file
is truncated or incomplete."

The fields in both tables match up in terms of type and length.

Just trying to export the 2 fields with data and import the same gives an
error as well.

Is there something I'm missing here?

Alan,

<< However, trying to import into EDBManager (Unicode), after creating a
store pointing to the same directory, keeps giving me an error: "The import
file is truncated or incomplete." >>

The Unicode versions generate Unicode csv files, and the ANSI versions
generate ANSI csv files, and one cannot import the other type, and
vice-versa.  I need to add an option at some point that allows you to
specify the character set used for the import and export, but for now you'll
have to use something like NotePad to do the conversion.   One thing to
watch out for, however, is NotePad may add a small BO (Byte Order Mark)
header that needs to be stripped out of the csv file before trying to import
it into the Unicode version of EDB:

http://msdn.microsoft.com/en-us/library/ms776429(VS.85).aspx

--
Tim Young
Elevate Software
www.elevatesoft.com

What would be the easiest way, then, if you were switching from ANSI to
Unicode to get the data from former to the latter...I've had no luck with
anything I've tried.

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:15C1BD71-5193-4FBB-913A-36BC4DAFC2F0@news.elevatesoft.com...
> Alan,
>
> << However, trying to import into EDBManager (Unicode), after creating a
> store pointing to the same directory, keeps giving me an error: "The
> import file is truncated or incomplete." >>
>

Ignore...Notepad seems to have worked fine.

"Alan Questell" <alanq@pinehurst.net> wrote in message
news:5F75BDD8-EA5C-4F82-8AC5-F215E77CEBB9@news.elevatesoft.com...
> What would be the easiest way, then, if you were switching from ANSI to
> Unicode to get the data from former to the latter...I've had no luck with
> anything I've tried.
>

Alan


Congratulations - you must be the first person apart from Tim to play with stores.

Roy Lambert

Roy,

<< Congratulations - you must be the first person apart from Tim to play
with stores. >>

You should check them out, they're pretty cool.  I'll have the replication
technical article up on the web site today (finally), and it uses stores
like crazy.  In fact, it uses 17 of them (!!!) for the article.

--
Tim Young
Elevate Software
www.elevatesoft.com

Yes, it is cool...even for something as simple as exporting data from
tables, because A) you don't have to remember where you put your stuff
and B) You can have another EDBManager session store simply point to that
same location and have access to everything.


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:CE8475D0-6136-4AA6-A5A9-A5E81609E9B0@news.elevatesoft.com...
> Roy,
>
> << Congratulations - you must be the first person apart from Tim to play
> with stores. >>
>
> You should check them out, they're pretty cool.  I'll have the replication
> technical article up on the web site today (finally), and it uses stores
> like crazy.  In fact, it uses 17 of them (!!!) for the article.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Alan,

<< Yes, it is cool...even for something as simple as exporting data from
tables, because A) you don't have to remember where you put your stuff
and B) You can have another EDBManager session store simply point to that
same location and have access to everything. >>

And no more need for FTP if you have a remote ElevateDB Server set up on the
Internet.

--
Tim Young
Elevate Software
www.elevatesoft.com