BAQ and ASP pages

Yahoo Archive
1
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
2
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

-----Original Message-----
From: johndeligdisch [mailto:johndeligdisch@...]
Sent: Friday, May 28, 2004 6:34 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - [Vantage] Re: BAQ and ASP pages - Email found in
subject - Email found in subject


Aaron,
Thanks for the reply. I am researching ASP.NET to see what it is
about and how I can deploy it. I need to give people access to
information through a browser and this looks as if it might be
possible now.
Thanks again,
John Deligdisch
--- 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=129ja1icp/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1085827061/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=464192921>


_____

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]