RE: [BPCS-L] Tips / *OUTFILE & XL

[Paul.Bogle@xxxxxxxxxx]

The only problem with introducing users to the CA download function is 
that the more gifted users can find that they now have the ability to 
create 'query type' download definitions. We had one user create a monster 
download, by injudicious linking of files, which brought the AS400 to its 
knees.

In an attempt to restrict this possibility we encourage the use of a 
multi-step process. 

1       IT create the a query to output a file in the normal way and place 
this query on a menu for users to use. (sometimes with an opportunity for 
the user to revise selection criteria)
2       Create an Excel template to accept the downloaded data. BPCS file 
names are replaced with something meaningful.
3       Create a CA download file to retrieve the data file and place it 
in the template.

 It does involve more work for IT staff up front, but means we can sleep 
at night. 

Excel pivot tables can be extremely useful in turning the data into 
information.

Paul Bogle 
Business Systems Manager
+44 7979 745404



"Dan Sweeney" <dsweeney@xxxxxxxxxxxxxxxx> 
Sent by: bpcs-l-bounces+paul.bogle=colaik.com@xxxxxxxxxxxx
21/03/2005 01:44
Please respond to
"SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>


To
"'SSA's BPCS ERP System'" <bpcs-l@xxxxxxxxxxxx>
cc

Subject
RE: [BPCS-L] Tips / *OUTFILE & XL






I have some simple instructions on how to download an outfile from the
AS/400 to Excel utilizing query.

EXCEL Add-in

1. Start Excel

2. Click Tools | Add-Ins

3. Click Browse 

4. Now you want to browse to C:\Program Files\IBM\Client Access\Shared

5. Double Click the cwbtfxla file

6. Click OK to close the Add-Ins Dialog box

Now you should have a new tool bar for data transfer.  Also you can
Click Data | Transfer Data from AS400.


-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf
Of Jan Simons
Sent: Sunday, March 20, 2005 4:08 PM
To: 'SSA's BPCS ERP System'
Subject: RE: [BPCS-L] Tips / *OUTFILE & XL

A very easy solution for getting 400 data to Excel is found
on http://www.symtrax.com/en/products/starquery/default.asp Here you
find the story on Starquery.
This is a beautiful tool to get live data into excel.



-----Original Message-----
From: bpcs-l-bounces+beldencdt=tiscali.nl@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+beldencdt=tiscali.nl@xxxxxxxxxxxx] On Behalf Of
Al Mac
Sent: Saturday, March 19, 2005 8:20 PM
To: BPCS_L discussion
Subject: [BPCS-L] Tips / *OUTFILE & XL


This post is not a question, more like an offer that info is available.

Our Local Evansville AS/400 User Group just had a meeting in which we 
exchanged tips and techniques.  I talked about how I use *OUTFILE to
manage 
BPCS resources and other 400 objects, such as when someone wants to know
if 
we have a report to do "X" it is real helpful that I have a directory of

our queries etc. sorted by "X".

This kind of how-to info may also be of interest to this group.
    * There is the issue of BPCS work areas named after work stations we

not have any more, and also Device Management ... this is a fast way of 
finding if someone has configured a work station that is illegal for
BPCS 
operations.
    * *OUTFILE directory of BPCS files to tell us when we need to reorg 
them, and which may need resizing due to inappropriate sizes.
    * We have thousands of query/400 and hundreds of add on RPG reports
... 
*OUTFILE directory sorted by their description so we can look up when
there 
is a new interest ... do we already have a solution.
    * Security Management and BPCS inter-relationship navigation without

the risks of XRF
    * Backup recovery aid
    * There's probably other applications for *OUTFILE that I not
stumbled 
over yet.

Another speaker to the group talked about stuff you could do with 400
data 
to Microsoft Excel.  Well we have been sending BPCS reports to Excel but

not to the degree this guy said was doable, so I am now on a hunt for
links 
with step by step how to get from 400 to EXCEL and how to code MACROS in

EXCEL so that when someone opens an EXCEL linked to the 400 they get the

latest BPCS story.

-
Al Macintyre  http://www.ryze.com/go/Al9Mac
Find BPCS Documentation Suppliers 
http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html
-- 
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: beldencdt@xxxxxxxxxx


-- 
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: dsweeney@xxxxxxxxxxxxxxxx

-- 
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: paul.bogle@xxxxxxxxxx



The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential, proprietary, and/or privileged 
material. Any review, retransmission, dissemination or other use of, or taking 
of any action in reliance upon this information by persons or entities other 
than the intended recipient is prohibited. If you received this in error, 
please contact the sender and delete the material.