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

[cfgwizard@xxxxxxx]

Hello Dan,
The add-in capability you mention is part of the Client Access product. It may 
be dependent on the install process for both Excel and client access. If Excel 
exists on the PC when a full install of Client Access takes place, the download 
add in will be updated automatically. If Excel is installed after a full Client 
Access install, then your add-in process is required. If you select a custom 
install of Client Access, you may exclude the cwbtfxla add-in.
 
Regards
Larry Costain
 
-----Original Message-----
From: Dan Sweeney <dsweeney@xxxxxxxxxxxxxxxx>
To: 'SSA's BPCS ERP System' <bpcs-l@xxxxxxxxxxxx>
Sent: Sun, 20 Mar 2005 20:44:15 -0500
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: cfgwizard@xxxxxxx