New to Powerhouse
Guy Werry
guy.werry@hbms.ca
Thu, 2 Jun 2005 15:21:36 -0500
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C567B0.ACFEC550
Content-Type: text/plain;
charset="iso-8859-1"
Matt,
This is a pretty good suggestion, at least for taking data FROM the C-ISAM
to the PC application. One thing that we have done a fair bit of is to add
a comma between each field on a report (set up a variable that's equal to a
comma and then just use it between each field in your REPORT statement) and
rename the output file so that it ends in '.csv'. This way, Excel can open
and format it very cleanly.
In terms of loading back UP to the C-ISAM, that's something we haven't done,
mostly as a data integrity issue. However, I've done enough programming
with PH to state that I'd want to use ODBC and push from the PC that way.
Unfortunately, I've never gotten that far and so can't recommend any
particular driver. You do want to be VERY careful about data integrity,
though. I've seen some real horror stories with people who have downloaded
data, manipulated it and then come back saying that the report from the main
computer is wrong. EVERY TIME it has been a goof in the spreadsheet!
Hope that helps direction-wise.
Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited.
-----Original Message-----
From: Jonathan Bickel [mailto:jonbickel@sbcglobal.net]
Sent: Thursday, June 02, 2005 3:02 PM
To: Matthew Cox; powerh-l@lists.sowder.com
Subject: Re: New to Powerhouse
Matt,
Not being familiar with the overall architecture of your situation, or your
familiarity with various platforms, I would take a semi-wild guess and...
Suggest that you look through the introductory docs/tutorials sufficiently
to use quiz to dump the data which you require from the C-ISAM files in a
raw text format (delimited or fixed width), ftp the file over to a windows
area, and then use your VB expertise to handle whatever further formatting
is necessary.
That's not to say that PowerHouse is not sufficient to handle the whole
process as well or better than VB (it is). That's just a suggestion for
getting the best return on your time invesment.
jb
Matthew Cox <mcox@fstusa.com> wrote:
Hello All,
I'm new to Powerhouse and this list. We are running Powerhouse 8.13 on an
SCO Unix box with C-ISAM files for the data. I have a project I've been
asked to complete and I'm trying to decide on the best way to proceed. I'm
hoping that you Powerhouse experts can help with some suggestions. I need to
import data into and export data out of the C-ISAM files to be shared with
another application running on a Windows Server. (Anyone familiar with
E.D.I.?) I consider myself to be a very good VB programmer but a complete
novice with Powerhouse. My question is what do you consider to be the best
way to accomplish this task? My experience leads me to consider a VB
application running on the Windows server using an ODBC connection to push
and pull the data I need.
Has anyone else tried this and if so what ODBC driver did you use?
! What kind of import/export options do I have in Powerhouse?
Thanks
Matt Cox
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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.
------_=_NextPart_001_01C567B0.ACFEC550
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=078331420-02062005>Matt,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=078331420-02062005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=078331420-02062005>This
is a pretty good suggestion, at least for taking data FROM the C-ISAM to the PC
application. One thing that we have done a fair bit of is to add a comma
between each field on a report (set up a variable that's equal to a comma and
then just use it between each field in your REPORT statement) and rename the
output file so that it ends in '.csv'. This way, Excel can open and format
it very cleanly.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=078331420-02062005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=078331420-02062005>In
terms of loading back UP to the C-ISAM, that's something we haven't done, mostly
as a data integrity issue. However, I've done enough programming with PH
to state that I'd want to use ODBC and push from the PC that way.
Unfortunately, I've never gotten that far and so can't recommend any particular
driver. You do want to be VERY careful about data integrity, though.
I've seen some real horror stories with people who have downloaded data,
manipulated it and then come back saying that the report from the main computer
is wrong. EVERY TIME it has been a goof in the spreadsheet!
</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=078331420-02062005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=078331420-02062005>Hope
that helps direction-wise.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=078331420-02062005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=078331420-02062005>
<P><FONT size=2>Guy L. Werry<BR>Senior Systems Analyst<BR>Hudson Bay Mining
& Smelting Co., Limited. </FONT></P></SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Jonathan Bickel
[mailto:jonbickel@sbcglobal.net]<BR><B>Sent:</B> Thursday, June 02, 2005 3:02
PM<BR><B>To:</B> Matthew Cox; powerh-l@lists.sowder.com<BR><B>Subject:</B> Re:
New to Powerhouse<BR><BR></FONT></DIV>
<DIV>
<DIV>Matt,</DIV>
<DIV> </DIV>
<DIV>Not being familiar with the overall architecture of your situation, or
your familiarity with various platforms, I would take a semi-wild guess
and...</DIV>
<DIV>Suggest that you look through the introductory docs/tutorials
sufficiently to use quiz to dump the data which you require from the
C-ISAM files in a raw text format (delimited or fixed width), ftp the file
over to a windows area, and then use your VB expertise to handle whatever
further formatting is necessary.</DIV>
<DIV> </DIV>
<DIV>That's not to say that PowerHouse is not sufficient to handle the
whole process as well or better than VB (it is). That's just a
suggestion for getting the best return on your time invesment.</DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV>jb</DIV>
<DIV> </DIV>
<DIV><BR><BR><B><I>Matthew Cox <mcox@fstusa.com></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Hello
All,<BR>I'm new to Powerhouse and this list. We are running Powerhouse 8.13
on an<BR>SCO Unix box with C-ISAM files for the data. I have a project I've
been<BR>asked to complete and I'm trying to decide on the best way to
proceed. I'm<BR>hoping that you Powerhouse experts can help with some
suggestions. I need to<BR>import data into and export data out of the C-ISAM
files to be shared with<BR>another application running on a Windows Server.
(Anyone familiar with<BR>E.D.I.?) I consider myself to be a very good VB
programmer but a complete<BR>novice with Powerhouse. My question is what do
you consider to be the best<BR>way to accomplish this task? My experience
leads me to consider a VB<BR>application running on the Windows server using
an ODBC connection to push<BR>and pull the data I need.<BR><BR>Has anyone
else tried this and if so what ODBC driver did you use?<BR><BR>! What kind
of import/export options do I have in Powerhouse?<BR><BR><BR>Thanks<BR>Matt
Cox<BR><BR><BR><BR>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = =
= = =<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe: "subscribe"
in message body to powerh-l-request@lists.sowder.com<BR>Unsubscribe:
"unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This
list is closed, thus to post to the list you must be a
subscriber.<BR></BLOCKQUOTE></DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C567B0.ACFEC550--