Data Conversion
Terry Curran
terrycurran@onetel.net.uk
Tue, 1 Apr 2003 12:41:19 +0100
This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C2F84B.FF4BF980
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
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.
------=_NextPart_000_0000_01C2F84B.FF4BF980
Content-Type: text/x-vcard;
name="Terence Phillip Curran (terry.curran@towermarsh.co.uk).vcf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="Terence Phillip Curran (terry.curran@towermarsh.co.uk).vcf"
BEGIN:VCARD
VERSION:2.1
N:Curran;Terence;Phillip
FN:Terence Phillip Curran (terry.curran@towermarsh.co.uk)
ORG:TowerMarsh Ltd
TITLE:Managing Director
TEL;WORK;VOICE:+44 (2392) 503893
TEL;HOME;VOICE:+44 (2392) 503893
TEL;CELL;VOICE:+44 (7720) 562048
ADR;WORK:;;130 Parham Road;Gosport;Hants;PO12 4UE;United Kingdom
LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:130 Parham Road=3D0D=3D0AGosport, =
Hants PO12 4UE=3D0D=3D0AUnited Kingdom
URL;WORK:http://www.towermarsh.co.uk
EMAIL;PREF;INTERNET:terry.curran@towermarsh.co.uk
REV:20030301T095201Z
END:VCARD
------=_NextPart_000_0000_01C2F84B.FF4BF980--