New to Powerhouse
Jonathan Bickel
jonbickel@sbcglobal.net
Thu Jun 2 22:30:18 CDT 2005
--0-1400090903-1117747818=:1911
Content-Type: text/plain; charset=us-ascii
Guy,
Excellent point. I was thinking primarily of the export side of the equation. The update back from raw text to the C-ISAM data could be done through QTP a/o batch Quick (I've seen it done), but that would entail a more thorough understanding of PH to set up, and there are many potential data integrity issues. If there's a meaningful degree of update back from the EDI process, and the primary manipulation location is the PC, then I'd side with your suggestion of finding a means of pushing updates from the PC (and, subsequently, pulling by the same methodology). Thanks for the catch.
jb
Guy Werry <guy.werry@hbms.ca> wrote:
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.
--0-1400090903-1117747818=:1911
Content-Type: text/html; charset=us-ascii
<DIV>Guy,</DIV>
<DIV> </DIV>
<DIV>Excellent point. I was thinking primarily of the export side of the equation. The update back from raw text to the C-ISAM data could be done through QTP a/o batch Quick (I've seen it done), but that would entail a more thorough understanding of PH to set up, and there are many potential data integrity issues. If there's a meaningful degree of update back from the EDI process, and the primary manipulation location is the PC, then I'd side with your suggestion of finding a means of pushing updates from the PC (and, subsequently, pulling by the same methodology). Thanks for the catch.</DIV>
<DIV> </DIV>
<DIV>jb<BR></DIV>
<DIV><BR><B><I>Guy Werry <guy.werry@hbms.ca></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR>
<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></BLOCKQUOTE>
--0-1400090903-1117747818=:1911--
More information about the powerh-l
mailing list