powerh-l Digest, Vol 29, Issue 15 - Portable subfiles -
Deskin, Bob
Bob.Deskin at Cognos.COM
Thu Oct 25 15:30:56 CDT 2007
I gather that you're on MPE/iX. Record separators are different on all
platforms. In other words, when you send a file from MPE to a PC, it may
not look like a PC file normally does.
What I did was to create a portable subfile on MPE. I FTPed it to my PC
using ASCII. When I ran psf2csv I got some strange messages as follows:
*W* Data file: not an even number of records, attempting conversion.
*E* Psf2Csv, Bad number in data: Record 4 (x).
And no csv.
So I got into QUIZ on my PC and read the subfile and created a new one.
Now psf2csv worked like a charm.
Since I don't expect that everyone has PowerHouse for Windows (although
they should :-) ) to do this conversion, maybe Vaughn can look at the
different separators and see what can be done.
I also ran a test on UNIX, copying a UNIX portable subfile to my PC, and
that worked fine.
Bob
-----Original Message-----
From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com] On
Behalf Of Lowe, Chuck J
Sent: October 25, 2007 3:48 pm
To: Johnson, Tracy; powerh-l at lists.sowder.com
Subject: RE: powerh-l Digest, Vol 29, Issue 15 - Portable subfiles -
Thanks. I got the portable subfiles. But the utility does not work.
I created a Portable subfile as follows.
SET LOC FIL UPD
ACC DISTRO-LIST
SUB DISTRO PORTABLE INC &
LIST-NAME, &
E-MAIL-01, E-MAIL-02,E-MAIL-03,E-MAIL-04,E-MAIL-05
go
Then copied DISTRO to ./DISTRO.psd and DISTROQ to ./DISTRO.ps and
brought them to the PC (Minisoft file transfer) and ran the utility on
it. The .csv is out of whack (shifted) and I only have text fields in
it. The Suprtool version creates the .CSV with no problem. I guess you
get what you pay for.
-----Original Message-----
From: Johnson, Tracy [mailto:Tracy.Johnson at meas-spec.com]
Sent: Thursday, October 25, 2007 3:12 PM
To: Lowe, Chuck J; powerh-l at lists.sowder.com
Subject: RE: powerh-l Digest, Vol 29, Issue 15 - Portable subfiles -
Just add the word PORTABLE to your subfile statement.
Yes, it is that simple.
(May be mutually exclusive of other subfile statements, you won't be
able to use the word INDEXED for example.)
Tracy Johnson
Measurement Specialties, Inc.
BT
NNNN
> -----Original Message-----
> From:
> powerh-l-bounces+tracy.johnson=meas-spec.com at lists.sowder.com
> [mailto:powerh-l-bounces+tracy.johnson=meas-spec.com at lists.sow
> der.com] On Behalf Of Lowe, Chuck J
> Sent: Thursday, October 25, 2007 2:58 PM
> To: powerh-l at lists.sowder.com
> Subject: FW: powerh-l Digest, Vol 29, Issue 15 - Portable subfiles -
>
>
> This is great. Now does anyone have an example of how to create a
> portable subfile? I don't mean what the manual says. I mean a REAL
> WORLD Example. Thee manual, at least the one I have, is very vague on
> the subject.
>
> -----Original Message-----
> From:
> powerh-l-bounces+chuck.j.lowe=questdiagnostics.com at lists.sowder.com
> [mailto:powerh-l-bounces+chuck.j.lowe=questdiagnostics.com at lis
> ts.sowder..
> com] On Behalf Of powerh-l-request at lists.sowder.com
> Sent: Thursday, October 25, 2007 1:02 PM
> To: powerh-l at lists.sowder.com
> Subject: powerh-l Digest, Vol 29, Issue 15
>
> Send powerh-l mailing list submissions to
> powerh-l at lists.sowder.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.sowder.com/mailman/listinfo/powerh-l
> or, via email, send a message with subject or body 'help' to
> powerh-l-request at lists.sowder.com
>
> You can reach the person managing the list at
> powerh-l-owner at lists.sowder.com
>
> When replying, please edit your Subject line so it is more specific
> than
> "Re: Contents of powerh-l digest..."
>
>
> Today's Topics:
>
> 1. Portable Subfile to CSV conversion Utility, now available
> (Beta) (Vaughn (Home))
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 24 Oct 2007 21:36:50 -0600
> From: "Vaughn (Home)" <vaughn at sewardconsulting.com>
> Subject: Portable Subfile to CSV conversion Utility, now available
> (Beta)
> To: powerh-l at lists.sowder.com
> Message-ID: <47200F52.4020803 at sewardconsulting.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> I am pleased to announce we have just released for beta-testing an
> open-source portable subfile to CSV conversion Utility. The program,
> called Psf2Csv, will convert a portable subfile into a comma-,
> semicomma-, or tab-delimited file. You can download a Windows zip file
> from here (scroll to the bottom of the page):
>
> http://sewardconsulting.com/product
>
> The zip file contains a Windows executable as well as the Python
> source, the open source license agreement, a readme file, and an
> example. To get started with Psf2Csv, unzip the download file into its
> own directory and refer to the readme for details on how to use it.
>
> Please send any feedback to us via our contact page:
>
> www.sewardconsulting.com/contact
>
> P.S. We plan to release an HP/9000 Unix version in the near future. We
> are also currently in the process of developing a utility, to be
> called Csv2psf, for doing the reverse (i.e.
> converting a CSV file into a portable subfile).
>
> Thanks,
> ------------------------------
> Vaughn Seward, B.Sc., I.S.P.
> Seward Consulting Ltd.
> (780) 702-5117
>
>
> ------------------------------
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
> powerh-l at lists.sowder.com
> Subscribe: "subscribe" in message body to
> powerh-l-request at lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body
> to powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a
> subscriber. Add 'site:lists.sowder.com powerh-l' to your search terms
> to search the list archive at Google.
>
> End of powerh-l Digest, Vol 29, Issue 15
> ****************************************
> ------------------------------------------
> The contents of this message, together with any attachments, are
> intended only for the use of the person(s) to which they are addressed
> and may contain confidential and/or privileged information. Further,
> any medical information herein is confidential and protected by law.
> It is unlawful for unauthorized persons to use, review, copy,
> disclose, or disseminate confidential medical information. If you are
> not the intended recipient, immediately advise the sender and delete
> this message and any attachments. Any distribution, or copying of this
> message, or any attachment, is prohibited.
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
> powerh-l at lists.sowder.com
> Subscribe: "subscribe" in message body to
> powerh-l-request at lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body
> to powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a
> subscriber. Add 'site:lists.sowder.com powerh-l' to your search terms
> to search the list archive at Google.
>
------------------------------------------
The contents of this message, together with any attachments, are
intended only for the use of the person(s) to which they are
addressed and may contain confidential and/or privileged
information. Further, any medical information herein is
confidential and protected by law. It is unlawful for unauthorized
persons to use, review, copy, disclose, or disseminate confidential
medical information. If you are not the intended recipient,
immediately advise the sender and delete this message and any
attachments. Any distribution, or copying of this message, or any
attachment, is prohibited.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
More information about the powerh-l
mailing list