BAQ and ASP pages

Yahoo Archive
1
Aaron

I would be very interested in some guidelines for getting this working

Thanks
Gary Parfrey
Operations Manager
Steatite Limited
TEL: 0044 (0)1527 406880
FAX: 0044 (0)1527 406899
www.steatite.com

garyp@...

-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: 05 August 2004 16:57
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ and ASP pages


Just thought I would let the group know I managed to use the xsl
translation file to get totals (and a few other functions) to show in
the ASP pages generated by BAQ.
If anyone is interested in details, let me know.
Aaron Hoyt
Hittite Microwave


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129fgvvjr/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1091807831/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=214672412>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
Is anyone else out there using the Business Activity Query to Generate
XML files and ASP pages to access them?
I have been trying to get this functionality to work as a side project
for the last few days. I can get the XML to generate (in fact the new
process server for automatically generating the XML files is slick).
The ASP file seems to have some rather large faults though. With a
little self taught ASP programming I have managed to get the ASP to
display and sort the data as it should. My major problem is that it
does not filter the data. Is it just me, or are there others having
this problem?
I appreciate any response related to this.
Thank you all,


Aaron Hoyt

Hittite Microwave Corporation




[Non-text portions of this message have been removed]
3
Is anyone else out there using the Business Activity Query to Generate
XML files and ASP pages to access them?
I have been trying to get this functionality to work as a side project
for the last few days. I can get the XML to generate (in fact the new
process server for automatically generating the XML files is slick).
The ASP file seems to have some rather large faults though. With a
little self taught ASP programming I have managed to get the ASP to
display and sort the data as it should. My major problem is that it
does not filter the data. Is it just me, or are there others having
this problem?
I appreciate any response related to this.
Thank you all,


Aaron Hoyt

Hittite Microwave Corporation




[Non-text portions of this message have been removed]
4
With some help from a list member off line, I was able to learn some
vital keys that makes this work.
1. Find the two files filterdata.xsl and exports.css in the Vantage
directory (mine were in the UD folder)
2. Copy them to the web where your ASP pages reside.
3. If you use formulas to generate numbers inside a BAQ, you will need
to edit the (filename).xsl file to use a ###,###....format instead of
the x(30) format (notepad works great for this).
Other than that, this is very useful.
I am finding you can generate basic reports that everyone can use to
slice the data the way they want with filters and sorting. If you have
office XP or above, you can rightclick on the grid that is generated in
Explorer and export it to excel, filtered and sorted. If you are
dealing with static data (last years shipments for example), you can run
the query once and then users can slice and dice as they like. If the
data is dynamic, you can turn on the BAQ Process server and have this
refresh the queries at preset intervals.
And the top three reasons I like this:
3. Users don't have to know Report Builder to filter and sort.
2. No Vantage license is used to look at the data (not even ODBC).
1. It's Vantage 8 (Sonoma code name is being dropped) compatible.
So, for anyone that was stressing out about the death of Report Builder,
I highly encourage you to check out the Business Activity Query in
Vantage 6.1.

Aaron Hoyt
Hittite Microwave


-----Original Message-----
From: Aaron Hoyt
Sent: Thursday, May 20, 2004 10:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ and ASP pages


Is anyone else out there using the Business Activity Query to Generate
XML files and ASP pages to access them?
I have been trying to get this functionality to work as a side project
for the last few days. I can get the XML to generate (in fact the new
process server for automatically generating the XML files is slick).
The ASP file seems to have some rather large faults though. With a
little self taught ASP programming I have managed to get the ASP to
display and sort the data as it should. My major problem is that it
does not filter the data. Is it just me, or are there others having
this problem?
I appreciate any response related to this.
Thank you all,


Aaron Hoyt

Hittite Microwave Corporation




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=1298mthfs/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1085148940/A=2128215/R=0/SIG=10se96mf6/*http://
companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=447076079>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



********************************************************************************************************************

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC network and is subject to archival and review
by someone other than the recipient.

********************************************************************************************************************





[Non-text portions of this message have been removed]
5
I'm new to BAQ and programming. I have developed some BAQ's to list
table contents with some filtering, sorting, and minor formula's.
However, what complexity of formulas are available using BAQ? Two
needs that I have are for a Query listing previous weeks sales totals
and previous weeks # of sales order lines. Where do I declare
variables for totals columns?
Secondly, what is the ASP page and would you use it for?
Thanks for any help.
John
--- In vantage@yahoogroups.com, "Aaron Hoyt" <hoyt@h...> wrote:
> With some help from a list member off line, I was able to learn some
> vital keys that makes this work.
> 1. Find the two files filterdata.xsl and exports.css in the Vantage
> directory (mine were in the UD folder)
> 2. Copy them to the web where your ASP pages reside.
> 3. If you use formulas to generate numbers inside a BAQ, you will
need
> to edit the (filename).xsl file to use a ###,###....format instead
of
> the x(30) format (notepad works great for this).
> Other than that, this is very useful.
> I am finding you can generate basic reports that everyone can use to
> slice the data the way they want with filters and sorting. If you
have
> office XP or above, you can rightclick on the grid that is
generated in
> Explorer and export it to excel, filtered and sorted. If you are
> dealing with static data (last years shipments for example), you
can run
> the query once and then users can slice and dice as they like. If
the
> data is dynamic, you can turn on the BAQ Process server and have
this
> refresh the queries at preset intervals.
> And the top three reasons I like this:
> 3. Users don't have to know Report Builder to filter and sort.
> 2. No Vantage license is used to look at the data (not even ODBC).
> 1. It's Vantage 8 (Sonoma code name is being dropped) compatible.
> So, for anyone that was stressing out about the death of Report
Builder,
> I highly encourage you to check out the Business Activity Query in
> Vantage 6.1.
>
> Aaron Hoyt
> Hittite Microwave
>
>
> -----Original Message-----
> From: Aaron Hoyt
> Sent: Thursday, May 20, 2004 10:13 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAQ and ASP pages
>
>
> Is anyone else out there using the Business Activity Query to
Generate
> XML files and ASP pages to access them?
> I have been trying to get this functionality to work as a side
project
> for the last few days. I can get the XML to generate (in fact the
new
> process server for automatically generating the XML files is slick).
> The ASP file seems to have some rather large faults though. With a
> little self taught ASP programming I have managed to get the ASP to
> display and sort the data as it should. My major problem is that it
> does not filter the data. Is it just me, or are there others having
> this problem?
> I appreciate any response related to this.
> Thank you all,
>
>
> Aaron Hoyt
>
> Hittite Microwave Corporation
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/SIG=1298mthfs/M=295196.4901138.6071305.3001176/D=
gr
>
oups/S=1705007183:HM/EXP=1085148940/A=2128215/R=0/SIG=10se96mf6/*http:
//
> companion.yahoo.com> click here
>
> <http://us.adserver.yahoo.com/l?
M=295196.4901138.6071305.3001176/D=group
> s/S=:HM/A=2128215/rand=447076079>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
**********************************************************************
**********************************************
>
> This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual
> or entity to which they are addressed. If you have received this e-
mail in error please notify the system manager.
>
> This e-mail message has been swept for the presence of computer
viruses.
>
> WARNING: All e-mail sent to this address will be received by the
HMC network and is subject to archival and review
> by someone other than the recipient.
>
>
**********************************************************************
**********************************************
>
>
>
>
>
> [Non-text portions of this message have been removed]
6
Aaron,

I know epicor is working on improving the BAQ features to aid in replacing
report builder type stuff. But I'm concerted about doing more than just
sorting data.

The features of Report Builder are below which BAQ can't do:

prepass sorting of calculated fields like percentages for exception reports
alias table joins
totals on columns
Subtotals
just adding in a calculated field as a new column
running cums
reading the previous() field data
summary reports not displaying record data
conditional printing of band lines
Linking and displaying employee photo's on a report
Calculating Dates used in other calculated fields for sales reports showing
columns last month, two month ago, etc...


I'm not trying to be all negative here: I would like to move as much as
possible into BAQ so users can eventually in Vantage 8, right click and move
to a Tracker or even edit data. How nice would that be to tell someone it's
the same as the report builder report you ran giving you your exception list
to work on but now we are paperless because you can just right click on the
entry and lookup or edit information.

On the other hand:
It will be hard for the end user to swallow if I have to say here use BAQ,
pull it into Excel and work the data yourself.

Patrick Winter


-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, May 27, 2004 6:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ and ASP pages

With some help from a list member off line, I was able to learn some vital
keys that makes this work.
1. Find the two files filterdata.xsl and exports.css in the Vantage
directory (mine were in the UD folder) 2. Copy them to the web where your
ASP pages reside.
3. If you use formulas to generate numbers inside a BAQ, you will need to
edit the (filename).xsl file to use a ###,###....format instead of the x(30)
format (notepad works great for this).
Other than that, this is very useful.
I am finding you can generate basic reports that everyone can use to slice
the data the way they want with filters and sorting. If you have office XP
or above, you can rightclick on the grid that is generated in Explorer and
export it to excel, filtered and sorted. If you are dealing with static
data (last years shipments for example), you can run the query once and then
users can slice and dice as they like. If the data is dynamic, you can turn
on the BAQ Process server and have this refresh the queries at preset
intervals.
And the top three reasons I like this:
3. Users don't have to know Report Builder to filter and sort.
2. No Vantage license is used to look at the data (not even ODBC).
1. It's Vantage 8 (Sonoma code name is being dropped) compatible.
So, for anyone that was stressing out about the death of Report Builder, I
highly encourage you to check out the Business Activity Query in Vantage
6.1.

Aaron Hoyt
Hittite Microwave


-----Original Message-----
From: Aaron Hoyt
Sent: Thursday, May 20, 2004 10:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ and ASP pages


Is anyone else out there using the Business Activity Query to Generate
XML files and ASP pages to access them?
I have been trying to get this functionality to work as a side project
for the last few days. I can get the XML to generate (in fact the new
process server for automatically generating the XML files is slick).
The ASP file seems to have some rather large faults though. With a
little self taught ASP programming I have managed to get the ASP to
display and sort the data as it should. My major problem is that it
does not filter the data. Is it just me, or are there others having
this problem?
I appreciate any response related to this.
Thank you all,


Aaron Hoyt

Hittite Microwave Corporation




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=1298mthfs/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1085148940/A=2128215/R=0/SIG=10se96mf6/*http://
companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=447076079>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



****************************************************************************
****************************************

This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC network
and is subject to archival and review
by someone other than the recipient.

****************************************************************************
****************************************





[Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
7
John,
I would be suspicious of joins or filtering if I got duplicate records.
I actually have a BAQ that exports the backlog. Here we have a backlog
of > 900 orders with a total of in excess of 1700 lines (We generally
ship around 100 orders per day). This being said, my BAQ showing this
information contains exactly the same information as my Crystal Report
and Report builder showing the same.
If you would like to copy and paste the Query out of BAQ and send it to
me offline, I would be happy to take a look at it for you.
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: johndeligdisch [mailto:johndeligdisch@...]
Sent: Monday, May 31, 2004 3:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ and ASP pages


Aaron,
I read a couple of the BAQ postings about replacing some report
builder reports with BAQ's. I made a simple one using
OrderHead.OrderNum, OrderDtl.OrderLine, OrderDtl.PartNum,
OrderDtl.SellQty, and OrderDtl.UnitPrice. I ran the query and had
many lines (up to 40+ lines) for each order number since we add
releases and changed release quantities over time. This file ended up
being over 3500 lines when exported to Excel. I then made a Crystal
report of the same information and had only 600 lines (I did not
select "Hide Duplicates"). Using BAQ, how do I hide duplicate fields
or display only the last entry in the database?
Thanks again for your help.
John Deligdisch
Axiomatic Technologies Corp.
--- In vantage@yahoogroups.com, "Aaron Hoyt" <hoyt@h...> wrote:
> John,
> You still can't total in BAQ.
> That being said. In 6.1 in the menu that you select Run, there is a
> Generate ASP choice. You have to export the initial query to XML
(can
> be set to do so automatically using a process server) and you will
have
> to do this to an IIS web (XP has one built in that can just be
> installed). The ASP file is a web page interface that lets you
easily
> sort, filter and display the data in the xml export. If you have
office
> 2002 or above, right clicking on the grid in the ASP lets you
export it
> to excel filtered and sorted.
> Some of the uses that I am using are:
> Displaying on a web page the active labor transactions. This gives
> production a up to the minute, who is on what machine doing what on
what
> job.
> I have exported all shipment lines with SO pricing to yearly XML
files
> with a web page for each year. Sales is using this and excel to
find
> best customers, best selling products and who buys specific parts.
> I also have a BAQ to export current Backlog so our Sales Admins can
> review their open orders and keep track of anything overdue,
allowing
> them to be proactive in dealing with unhappy customers.
> Just some thoughts.
> Aaron Hoyt
> Hittite Microwave
>
> -----Original Message-----
> From: johndeligdisch [mailto:johndeligdisch@y...]
> Sent: Thursday, May 27, 2004 8:34 AM
> To: vantage@yahoogroups.com
> Subject: [SPAM] - [Vantage] Re: BAQ and ASP pages - Email found in
> subject
>
>
> I'm new to BAQ and programming. I have developed some BAQ's to
list
> table contents with some filtering, sorting, and minor formula's.
> However, what complexity of formulas are available using BAQ? Two
> needs that I have are for a Query listing previous weeks sales
totals
> and previous weeks # of sales order lines. Where do I declare
> variables for totals columns?
> Secondly, what is the ASP page and would you use it for?
> Thanks for any help.
> John
> --- In vantage@yahoogroups.com, "Aaron Hoyt" <hoyt@h...> wrote:
> > With some help from a list member off line, I was able to learn
some
> > vital keys that makes this work.
> > 1. Find the two files filterdata.xsl and exports.css in the
Vantage
> > directory (mine were in the UD folder)
> > 2. Copy them to the web where your ASP pages reside.
> > 3. If you use formulas to generate numbers inside a BAQ, you
will
> need
> > to edit the (filename).xsl file to use a ###,###....format
instead
> of
> > the x(30) format (notepad works great for this).
> > Other than that, this is very useful.
> > I am finding you can generate basic reports that everyone can use
to
> > slice the data the way they want with filters and sorting. If
you
> have
> > office XP or above, you can rightclick on the grid that is
> generated in
> > Explorer and export it to excel, filtered and sorted. If you are
> > dealing with static data (last years shipments for example), you
> can run
> > the query once and then users can slice and dice as they like.
If
> the
> > data is dynamic, you can turn on the BAQ Process server and have
> this
> > refresh the queries at preset intervals.
> > And the top three reasons I like this:
> > 3. Users don't have to know Report Builder to filter and sort.
> > 2. No Vantage license is used to look at the data (not even
ODBC).
> > 1. It's Vantage 8 (Sonoma code name is being dropped) compatible.
> > So, for anyone that was stressing out about the death of Report
> Builder,
> > I highly encourage you to check out the Business Activity Query in
> > Vantage 6.1.
> >
> > Aaron Hoyt
> > Hittite Microwave
> >
> >
> > -----Original Message-----
> > From: Aaron Hoyt
> > Sent: Thursday, May 20, 2004 10:13 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] BAQ and ASP pages
> >
> >
> > Is anyone else out there using the Business Activity Query to
> Generate
> > XML files and ASP pages to access them?
> > I have been trying to get this functionality to work as a side
> project
> > for the last few days. I can get the XML to generate (in fact
the
> new
> > process server for automatically generating the XML files is
slick).
> > The ASP file seems to have some rather large faults though. With
a
> > little self taught ASP programming I have managed to get the ASP
to
> > display and sort the data as it should. My major problem is that
it
> > does not filter the data. Is it just me, or are there others
having
> > this problem?
> > I appreciate any response related to this.
> > Thank you all,
> >
> >
> > Aaron Hoyt
> >
> > Hittite Microwave Corporation
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> > have already linked your email address to a yahoo id to enable
> access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/links
> >
> >
> >
> > Yahoo! Groups Sponsor
> >
> > ADVERTISEMENT
> >
> >
>
<http://rd.yahoo.com/SIG=1298mthfs/M=295196.4901138.6071305.3001176/D=
> gr
> >
>
oups/S=1705007183:HM/EXP=1085148940/A=2128215/R=0/SIG=10se96mf6/*http:
> //
> > companion.yahoo.com> click here
> >
> > <http://us.adserver.yahoo.com/l?
> M=295196.4901138.6071305.3001176/D=group
> > s/S=:HM/A=2128215/rand=447076079>
> >
> >
> > _____
> >
> > Yahoo! Groups Links
> >
> >
> > * To visit your group on the web, go to:
> > http://groups.yahoo.com/group/vantage/
> >
> >
> > * To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@yahoogroups.com
> > <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
> >
> >
> > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > Service <http://docs.yahoo.com/info/terms/> .
> >
> >
> >
> >
>
**********************************************************************
> **********************************************
> >
> > This e-mail and any files transmitted with it are confidential
and
> intended solely for the use of the individual
> > or entity to which they are addressed. If you have received this
e-
> mail in error please notify the system manager.
> >
> > This e-mail message has been swept for the presence of computer
> viruses.
> >
> > WARNING: All e-mail sent to this address will be received by the
> HMC network and is subject to archival and review
> > by someone other than the recipient.
> >
> >
>
**********************************************************************
> **********************************************
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/SIG=1298e9qt9/M=295196.4901138.6071305.3001176/D=
gr
>
oups/S=1705007183:HM/EXP=1085747626/A=2128215/R=0/SIG=10se96mf6/*http:
//
> companion.yahoo.com> click here
>
> <http://us.adserver.yahoo.com/l?
M=295196.4901138.6071305.3001176/D=group
> s/S=:HM/A=2128215/rand=340695659>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
**********************************************************************
**********************************************
>
> This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual
> or entity to which they are addressed. If you have received this e-
mail in error please notify the system manager.
>
> This e-mail message has been swept for the presence of computer
viruses.
>
> WARNING: All e-mail sent to this address will be received by the
HMC network and is subject to archival and review
> by someone other than the recipient.
>
>
**********************************************************************
**********************************************
>
>
>
>
>
> [Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=129lnfjqp/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1086118589/A=2128215/R=0/SIG=10se96mf6/*http://
companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=236020643>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



********************************************************************************************************************

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC network and is subject to archival and review
by someone other than the recipient.

********************************************************************************************************************





[Non-text portions of this message have been removed]
8
Jerry,
With further testing, you are apparently right.
Thank you for the heads up.
Aaron

-----Original Message-----
From: Jerry Boyle [mailto:jboyle@...]
Sent: Friday, May 28, 2004 9:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: BAQ and ASP pages


Aaron, thanks to your comment about using BAQ to publish a web page with
current labor transactions, I set one up yesterday with this same data
and
my plant floor people love it. They have been unhappy since the loss of
the
"who was clocked in screen" on the old data collection screen. Now they
not
only see who is currently clocked in but what job/asm/op they are
working
on. I do have a question about the process server. You said that it
processes all BAQs with an output file name specified in the query. Is
it
just the ones with xml specified as the output format? I have many
existing
queries with ASCII or Dbase as the format and it is not processing them,
only the new one I set up yesterday.
Thanks again for your input, I was actually popular yesterday for a
short
time.

Jerry Boyle, Controller
Sipco Molding Technologies
Meadville, PA. 16335
p 814.724.2243 x53
f 814.724.2244
Vantage 6.10.506

-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Friday, May 28, 2004 5:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: BAQ and ASP pages
John,
Let me caution you about a couple things.
For static data...export as XML, but do not save the path in the "Output
file name" of the query. If you choose to use the process server it
will
process any BAQ with a location in that field. Also set up a delay in
the
process server for the BAQ if you plan to use it. I run my process
server
from the server, allowing the server to use it's awesome power to run
the
queries, but it does put a draw on the server, so be careful how many
and
how complex the Queries are you plan to run automatically (by entering a
path in the "Output file name" field in the query). Also, remember if
you
run the process server from the server, the path you choose will be used
on
the server, so if you pick c:\...
that is where it will be on the server (I use UNC for mine).
The last thing. The ASP pages that Vantage generates can be processed
by an
IIS server, so you might want to set up a virtual directory on your
Intranet
(assuming you have one) for the ASP, XML and such to be exported to.
Ok, so one more thing. Test, test and retest. You may want to export
the
XML files to a local directory on the server running the process server
and
then schedule a simple copy command to copy them over to another
location
every so often. Again, something I learned was if the XML is in use as
the
query runs, the process server stops and you have to reset it (kind of a
pain).
Feel free to contact me if you need additional assistance.
Good luck,
Aaron Hoyt
Hittite Microwave



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=129nko0v5/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1085838177/A=2128215/R=0/SIG=10se96mf6/*http://
companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=162069282>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



********************************************************************************************************************

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC network and is subject to archival and review
by someone other than the recipient.

********************************************************************************************************************





[Non-text portions of this message have been removed]
9
Just thought I would let the group know I managed to use the xsl
translation file to get totals (and a few other functions) to show in
the ASP pages generated by BAQ.
If anyone is interested in details, let me know.
Aaron Hoyt
Hittite Microwave


[Non-text portions of this message have been removed]