Data Conversion
Viet Nguyen
VNguyen@wsboces.org
Tue, 1 Apr 2003 08:54:04 -0500
Thank you all for the suggestions on the data conversion. I think I am
going to port the files to the portable subfiles and go from there.
Viet.
-----Original Message-----
From: Terry Curran [mailto:terrycurran@onetel.net.uk]
Sent: Tuesday, April 01, 2003 6:41 AM
To: Viet Nguyen; powerh-l@cube.swau.edu
Subject: RE: Data Conversion
I don't think this is a practical solution.
This would only work properly if the data in the files was 'Text', i.e.
all fields were CHARACTER, or ZONE UNSIGNED numeric. Any numeric fields
will have binary data in them which would not translate correctly when
transferred to Windows!!
That's why you should use portable subfiles as the portable subfiles
convert numeric values to characters. Anyway its very simple to create
Portsbale subfiles in QUIZ, just
Access <filename>
Report all
Set subfile name <subfilename> portable keep
Set report nolimit
Go
Then just transfer the .psd, and the .pd fdiles, and they can be read
directly by quiz
------------------------------------------------------------------------
----------------
This email is brought to you courtesy of 1 & 1, for more details please
visit the
link below
http://oneandone.co.uk/xml/init?k_id=5753616
------------------------------------------------------------------------
----------------
-----Original Message-----
From: powerh-l-admin@cube.swau.edu [mailto:powerh-l-admin@cube.swau.edu]
On Behalf Of Viet Nguyen
Sent: Monday, March 31, 2003 2:53 PM
To: Greig Morrison; powerh-l@cube.swau.edu
Subject: RE:Data Conversion
Hi Mike & Greig,
Thank you for the suggestions. I have a question: Can I not
just move the raw data files and the dictionary from Unix and recompile
in Windows then read the files directly with PowerHouse and output them
into MS Sql tables? Thanks in advance. Viet.
-----Original Message-----
From: Greig Morrison [mailto:greig.morrison@sympatico.ca]
Sent: Sunday, March 30, 2003 1:03 PM
To: powerh-l@cube.swau.edu
Subject: Re: powerh-l digest, Vol 1 #597 - 1 msg
A possible solution if you have PowerHouse on NT available.
One of the issues you probably have is that the MS SQL database will
have "_" underscore in table and item names where "-" dashes may exists
in the C-ISAM dictionary definitions, assuming that your new MS SQL
database uses most of the same names. Using PowerHouse to do the data
conversion, you can create a new dictionary from the existing dictionary
for your C-ISAM files changing all the "-" dashes to "_" underscores.
Compile this new dictionary on the Unix box, unload all the files to
Portable subfiles with QUIZ or QTP. Download the subfiles via FTP using
binary for the data component (.ps) and ASCII for the dictionary
component (.psd) to a PC. You could use PowerHouse on NT or Axiant to
read the subfiles directly, to load the MS SQL database, these products
will read the subfile dictionary and use automatic initialization to
load like named items from the subfiles to the corresponding MS SQL
tables. Note: you need to manipulate any dates with "0" (zeroes) to
convert them to Nulls etc.
Greig
powerh-l-request@cube.swau.edu wrote:
> Send powerh-l mailing list submissions to
> powerh-l@lists.swau.edu
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.swau.edu/mailman/listinfo/powerh-l
> or, via email, send a message with subject or body 'help' to
> powerh-l-request@lists.swau.edu
>
> You can reach the person managing the list at
> powerh-l-admin@lists.swau.edu
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of powerh-l digest..."
>
> Today's Topics:
>
> 1. RE:moving c-isam files to MS SQL (Viet Nguyen)
>
> --__--__--
>
> Message: 1
> Subject: RE: moving c-isam files to MS SQL
> Date: Fri, 28 Mar 2003 14:53:20 -0500
> From: "Viet Nguyen" <VNguyen@wsboces.org>
> To: <powerh-l@lists.swau.edu>
>
> Hi all, can someone show me how to move c-isam files to Microsoft SQL?
> We have c-isam on IBM AIX (Unix).
>
> --__--__--
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
> powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a
subscriber.
>
> End of powerh-l Digest
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.