Canned Vantage Reports to Excel

Yahoo Archive
1
Excel can read the xml data file with ease (formatting once the data is pulled in can be a challenge though!).

The difference is that excel can't initiate generation of the xml file. Crystal already has the built in integration hooks to trigger the initial required Vantage data export to xml.

We just got service connect - so I'm hoping the BAQ export process BO methods are exposed and we find they can be called from within excel via a vbScript.

Rob

--- On Fri, 12/19/08, Paul Pachniak <paul.pachniak@...> wrote:
From: Paul Pachniak <paul.pachniak@...>
Subject: [Vantage] Canned Vantage Reports to Excel
To: vantage@yahoogroups.com
Date: Friday, December 19, 2008, 12:22 PM













We are on Vantage 8.03.0405A, is there a way to take a canned vantage

report (like Engineering/ Reports/BOM Listing) directly to excel like you

can with Crystal reports?



Paul E. Pachniak



Accounting Manager



Ace Precision Machining Corporation



W146 N5714 Enterprise Avenue



Menomonee Falls, WI 53051



Phone: Ext. 1114



Fax:



Email: paul.pachniak@ aceprecision. com

<mailto:paul.pachniak@ aceprecision. com>



WWW: http://www.acepreci sion.com <http://www.acepreci sion.com>



NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL INFORMATION OF ACE PRECISION MACHINING CORP. If you are an unintended recipient, immediately (1) delete all copies of this message and any attachments, and (2) contact the sender. If you are an intended recipient, you are prohibited from deleting or obstructing this or any other Ace Precision Machining Corp. proprietary or confidentiality designation that appears on this message or any attachments. All recipients are prohibited from reproducing, publishing or disclosing the contents of this message and any attachments to others, unless you first request and receive written permission from Ace Precision Machining Corp.



[Non-text portions of this message have been removed]
2
We are on Vantage 8.03.0405A, is there a way to take a canned vantage
report (like Engineering/Reports/BOM Listing) directly to excel like you
can with Crystal reports?



Paul E. Pachniak

Accounting Manager

Ace Precision Machining Corporation

W146 N5714 Enterprise Avenue

Menomonee Falls, WI 53051

Phone: 262-252-4003 Ext. 1114

Fax: 262-252-4974

Email: paul.pachniak@...
<mailto:paul.pachniak@...>

WWW: http://www.aceprecision.com <http://www.aceprecision.com>





NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL INFORMATION OF ACE PRECISION MACHINING CORP. If you are an unintended recipient, immediately (1) delete all copies of this message and any attachments, and (2) contact the sender. If you are an intended recipient, you are prohibited from deleting or obstructing this or any other Ace Precision Machining Corp. proprietary or confidentiality designation that appears on this message or any attachments. All recipients are prohibited from reproducing, publishing or disclosing the contents of this message and any attachments to others, unless you first request and receive written permission from Ace Precision Machining Corp.

[Non-text portions of this message have been removed]
3
> We are on Vantage 8.03.0405A, is there a way to take a canned vantage
> report (like Engineering/Reports/BOM Listing) directly to excel like you
> can with Crystal reports?

Since the Progress reports end up as text files in your MfgSysdata or
EpicorData folder, you can use a tool like Monarch:

http://www.datawatch.com/_products/monarch_overview.php

or other such tool.

BTW, BOMListing and BOMSummarized are now Crystal reports in Epicor 9.

Mark W.

P.S. I hope you and your family has a great holiday!
4
Just yesterday, I found a way that works. There is a 'Method Tracker'
that does not seem to be in the menu system but is accessible from
Part Tracker Revision tab. Select Part # you want, go to REVISIONS
tab, place cursor in REV field, RIGHT click and select METHOD TRACKER.
Select MATERIALS or OPERATIONS tab. This will bring up a grid of data.
You can use mouse to SELECT, COPY then PASTE into Excel worksheet. You
then will need to adjust column widths to see data.

I am on Version 8.03.406A

Bob

--- In vantage@yahoogroups.com, "Paul Pachniak" <paul.pachniak@...> wrote:
>
>
> We are on Vantage 8.03.0405A, is there a way to take a canned vantage
> report (like Engineering/Reports/BOM Listing) directly to excel like you
> can with Crystal reports?
>
>
>
> Paul E. Pachniak
>
> Accounting Manager
>
> Ace Precision Machining Corporation
>
> W146 N5714 Enterprise Avenue
>
> Menomonee Falls, WI 53051
>
> Phone: 262-252-4003 Ext. 1114
>
> Fax: 262-252-4974
>
> Email: paul.pachniak@...
> <mailto:paul.pachniak@...>
>
> WWW: http://www.aceprecision.com <http://www.aceprecision.com>
>
>
>
>
>
> NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL
INFORMATION OF ACE PRECISION MACHINING CORP. If you are an unintended
recipient, immediately (1) delete all copies of this message and any
attachments, and (2) contact the sender. If you are an intended
recipient, you are prohibited from deleting or obstructing this or any
other Ace Precision Machining Corp. proprietary or confidentiality
designation that appears on this message or any attachments. All
recipients are prohibited from reproducing, publishing or disclosing
the contents of this message and any attachments to others, unless you
first request and receive written permission from Ace Precision
Machining Corp.
>
> [Non-text portions of this message have been removed]
>