Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: from Unix to Windows



Permlink Replies: 2 - Last Post: Apr 13, 2015 12:46 PM Last Post By: Pierre Demers
Pierre Demers

Posts: 11
Registered: 7/30/01
from Unix to Windows
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 13, 2015 6:38 AM
Hello,

I may be asked to import in our database a customers'list (maybe 6000
custromers) that is now on a Unix system. I don't know the system,
don't know the database and never worked in Unix.

Is printing the list, scanning it and converting it to xlsx is a
plausible avenue (and the easiest, never done that) or it would be
easier to find about the files to be imported, and use a kind of
database manager (if the file is not password protected) and start with
that.

Thanks for any advices.

Pierre
Peter Below

Posts: 1,227
Registered: 12/16/99
Re: from Unix to Windows
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 13, 2015 10:37 AM   in response to: Pierre Demers in response to: Pierre Demers
Pierre Demers wrote:

Hello,

I may be asked to import in our database a customers'list (maybe 6000
custromers) that is now on a Unix system. I don't know the system,
don't know the database and never worked in Unix.

Is printing the list, scanning it and converting it to xlsx is a
plausible avenue (and the easiest, never done that) or it would be
easier to find about the files to be imported, and use a kind of
database manager (if the file is not password protected) and start
with that.

If the source is a database then you need a database client program of
some kind to even print the list. If you have that there is a very good
chance that the client will also support some kind of export to file.
Somebody will need to have access to this Unix machine, just ask him to
get you the data in standard CSV or plain text format. You can then
load this file into a Delphi TStringlist (that can handle Unix-style
linebreaks just file) and parse the lines as need to insert it into
your database.

You have a compiler, don't be afraid to use it <g>.


--
Peter Below (TeamB)

Pierre Demers

Posts: 11
Registered: 7/30/01
Re: from Unix to Windows
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 13, 2015 12:46 PM   in response to: Peter Below in response to: Peter Below
Peter Below wrote:

Pierre Demers wrote:

Hello,

I may be asked to import in our database a customers'list (maybe
6000 custromers) that is now on a Unix system. I don't know the
system, don't know the database and never worked in Unix.

Is printing the list, scanning it and converting it to xlsx is a
plausible avenue (and the easiest, never done that) or it would be
easier to find about the files to be imported, and use a kind of
database manager (if the file is not password protected) and start
with that.

If the source is a database then you need a database client program of
some kind to even print the list. If you have that there is a very
good chance that the client will also support some kind of export to
file. Somebody will need to have access to this Unix machine, just
ask him to get you the data in standard CSV or plain text format. You
can then load this file into a Delphi TStringlist (that can handle
Unix-style linebreaks just file) and parse the lines as need to
insert it into your database.

You have a compiler, don't be afraid to use it <g>.

Good advices. If I could get my hands on a CSV file, the rest would be
a piece of cake. We'll see.

Thanks a lot.

Pierre
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02