Viewing BOM's Blank Title 71921

Yahoo Archive
1
Vic,
Can you use a Vantage BO's and Adapters within ASP code?

Grzegorz Szczepański

Dnia Sat, 8 Aug 2009 14:53:56 -0400
"Vic Drecchio" <vic.drecchio@...> napisał(a):

> Karen,
>
>
> This is the best $399 I've ever spent
>
> http://www.xlinesoft.com/asprunnerpro/
>
>
> I create a SQL View containing the data I want to display.
>
> Then I use ASP Runner Pro and toss together a complete web interface
> for it in a matter of minutes using the SQL view's data (versus
> hitting the Vantage tables directly which I try to avoid).
>
> You can have a basic display or get more advanced with security,
> logins, etc.
>
> Put the ASP in your IIS folder (C:\inetpub\...) on your server (mine
> happens to be on my Vantage server).
>
> Download a free trial from them. Their Support is great and they
> provide prompt email replies.
>
> I don't use the Vantage dashboard feature at all and I've save
> $$$$$$$$ buy allowing certain users and execs to gain access to
> Vantage data (and even update data) without having to buy user seats
> and install the Vantage client on their PC.
>
> For example our HAZMAT dept needed to update and maintain 8 UD fields
> on the Part table for their HAZMAT data. Instead of buying and
> installing the Vantage client on their PCs for such a limited need I
> wrote an ASP interface to hit the Vantage Part master table and
> update the UD fields required.
>
> For our Sales force I've written some slick dashboards in ASP with
> conditional formatting for quote and sales pipelines.
>
> Let me know if you have any other questions. It's a real slick
> product and very intuitive.
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email:Â Â vic.drecchio@...
> Mobile:Â 704.530.3092
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of karenalexander78 Sent: Saturday, August 08, 2009 2:28 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Viewing BOM's
>
> I have some similar reports/dashboards to build but the vantage qery
> tool will not handle it - can you tell me how you built your ASP? I
> am ok with the sql view bit.
>
> Thanks
>
>
> --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
> wrote:
> >
> > If you are a SQL customer, do what I do all the time: Create a SQL
> > View, use ASP to hit it and display it in Internet Explorer.
> >
> > I have buttons all over my UI that open Internet Explorer and a URL
> > on my "Vantage Intranet".
> >
> > That's about your only option as a Dashboard won't do what you need.
> > Perhaps an Executive Dashboard, but I haven't fooled with them.
> >
> >
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Dave Eaton
> > Sent: Thursday, December 11, 2008 1:36 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Viewing BOM's
> >
> > I need to give users the ability to view a bill of materials and
> > all sub-bill/parts beneath it but I don't want these users to have
> > access to the engineering workbench. The BOM listing report is
> > useless as it does not give all information. In addition they
> > should be able to look up a part directly from the bill. Does
> > anyone know the best way to accomplish this?
> >
> >
> > ------------------------------------
> >
> > 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/linksYahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> 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/linksYahoo! Groups Links
>
>
>
2
I need to give users the ability to view a bill of materials and all
sub-bill/parts beneath it but I don't want these users to have access
to the engineering workbench. The BOM listing report is useless as it
does not give all information. In addition they should be able to look
up a part directly from the bill. Does anyone know the best way to
accomplish this?
3
If you are a SQL customer, do what I do all the time: Create a SQL
View, use ASP to hit it and display it in Internet Explorer.

I have buttons all over my UI that open Internet Explorer and a URL on
my "Vantage Intranet".

That's about your only option as a Dashboard won't do what you need.
Perhaps an Executive Dashboard, but I haven't fooled with them.




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dave Eaton
Sent: Thursday, December 11, 2008 1:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Viewing BOM's

I need to give users the ability to view a bill of materials and all
sub-bill/parts beneath it but I don't want these users to have access
to the engineering workbench. The BOM listing report is useless as it
does not give all information. In addition they should be able to look
up a part directly from the bill. Does anyone know the best way to
accomplish this?


------------------------------------

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/linksYahoo! Groups Links
4
Part Tracker will give you all of this.

Find the top-level assembly you¹re interested in in Part Tracker. Right
click on the revision in the Revision tab list view, and Open With -> Method
Tracker. You can see the entire bill under materials, and can look at the
component parts, or right-click on the Part from the Part Detail sheet and
open that Part with Part Tracker or Part Display.

-bws

On 12/11/08 10:35 AM, "Dave Eaton" <deaton@...> wrote:
>
> I need to give users the ability to view a bill of materials and all
> sub-bill/parts beneath it but I don't want these users to have access
> to the engineering workbench. The BOM listing report is useless as it
> does not give all information. In addition they should be able to look
> up a part directly from the bill. Does anyone know the best way to
> accomplish this?



[Non-text portions of this message have been removed]
5
> I need to give users the ability to view a bill of materials and all
> sub-bill/parts beneath it but I don't want these users to have access
> to the engineering workbench. The BOM listing report is useless as it
> does not give all information. In addition they should be able to look
> up a part directly from the bill. Does anyone know the best way to
> accomplish this?

Sounds like Method Tracker, which is available on Part Tracker | Revisions:
right mouse click on the revision letter and choose Open With... | Method
Tracker.

Mark W.
6
--- In vantage@yahoogroups.com, "Brian W, Spolarich" <bspolarich@...>
wrote:
>
>
> Part Tracker will give you all of this.
>
> Find the top-level assembly you¹re interested in in Part
Tracker. Right
> click on the revision in the Revision tab list view, and Open With -
> Method
> Tracker. You can see the entire bill under materials, and can look
at the
> component parts, or right-click on the Part from the Part Detail
sheet and
> open that Part with Part Tracker or Part Display.
>
> -bws
>
> On 12/11/08 10:35 AM, "Dave Eaton" <deaton@...> wrote:
> >
> > I need to give users the ability to view a bill of materials and
all
> > sub-bill/parts beneath it but I don't want these users to have
access
> > to the engineering workbench. The BOM listing report is useless
as it
> > does not give all information. In addition they should be able to
look
> > up a part directly from the bill. Does anyone know the best way
to
> > accomplish this?
>
>
>
> [Non-text portions of this message have been removed]
>

Perfect!! Exactly what I was looking for...just too new to know
where to look. Thanks all.
7
Are you saying that you don't want users to be able to view the
workbench at all? If not then they should be able to s get to the method
tracker which is just the Engineering Workbench in read only format.

Kersten MacLennan
IT/ERP Analyst
Semrock
A Unit of IDEX Corporation
3625 Buffalo Road, Suite 6
Rochester, New York 14624

585-594-7009
585-594-7095 fax

kmaclennan@...

The Standard in Optical Filters for Biotech & Analytical Instrumentation

Hundreds of Thousands of Ion Beam Sputtered filters delivered -
extensive inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dave Eaton
Sent: Thursday, December 11, 2008 1:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Viewing BOM's



I need to give users the ability to view a bill of materials and all
sub-bill/parts beneath it but I don't want these users to have access
to the engineering workbench. The BOM listing report is useless as it
does not give all information. In addition they should be able to look
up a part directly from the bill. Does anyone know the best way to
accomplish this?






[Non-text portions of this message have been removed]
8
Is there any way to personalize/customize Tree Options for Method
Tracker? It'd be great if we could turn on descriptions and qties etc
in the left hand tree pane, as we do for Job Tracker, Quote Tracker,
Engineering Workbench etc. We've been told by our consultants (Cogita)
that it is not possible, but we've done a few things that were
called "impossible", so haven't given up hope yet... What makes Method
Tracker so different from other trackers?
9
I have some similar reports/dashboards to build but the vantage qery tool will not handle it - can you tell me how you built your ASP? I am ok with the sql view bit.

Thanks


--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> If you are a SQL customer, do what I do all the time: Create a SQL
> View, use ASP to hit it and display it in Internet Explorer.
>
> I have buttons all over my UI that open Internet Explorer and a URL on
> my "Vantage Intranet".
>
> That's about your only option as a Dashboard won't do what you need.
> Perhaps an Executive Dashboard, but I haven't fooled with them.
>
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Dave Eaton
> Sent: Thursday, December 11, 2008 1:36 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Viewing BOM's
>
> I need to give users the ability to view a bill of materials and all
> sub-bill/parts beneath it but I don't want these users to have access
> to the engineering workbench. The BOM listing report is useless as it
> does not give all information. In addition they should be able to look
> up a part directly from the bill. Does anyone know the best way to
> accomplish this?
>
>
> ------------------------------------
>
> 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/linksYahoo! Groups Links
>
10
Karen,


This is the best $399 I've ever spent

http://www.xlinesoft.com/asprunnerpro/


I create a SQL View containing the data I want to display.

Then I use ASP Runner Pro and toss together a complete web interface for it in a matter of minutes using the SQL view's data (versus hitting the Vantage tables directly which I try to avoid).

You can have a basic display or get more advanced with security, logins, etc.

Put the ASP in your IIS folder (C:\inetpub\...) on your server (mine happens to be on my Vantage server).

Download a free trial from them. Their Support is great and they provide prompt email replies.

I don't use the Vantage dashboard feature at all and I've save $$$$$$$$ buy allowing certain users and execs to gain access to Vantage data (and even update data) without having to buy user seats and install the Vantage client on their PC.

For example our HAZMAT dept needed to update and maintain 8 UD fields on the Part table for their HAZMAT data. Instead of buying and installing the Vantage client on their PCs for such a limited need I wrote an ASP interface to hit the Vantage Part master table and update the UD fields required.

For our Sales force I've written some slick dashboards in ASP with conditional formatting for quote and sales pipelines.

Let me know if you have any other questions. It's a real slick product and very intuitive.


Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@...
Mobile:Â 704.530.3092

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of karenalexander78
Sent: Saturday, August 08, 2009 2:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Viewing BOM's

I have some similar reports/dashboards to build but the vantage qery tool will not handle it - can you tell me how you built your ASP? I am ok with the sql view bit.

Thanks


--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> If you are a SQL customer, do what I do all the time: Create a SQL
> View, use ASP to hit it and display it in Internet Explorer.
>
> I have buttons all over my UI that open Internet Explorer and a URL on
> my "Vantage Intranet".
>
> That's about your only option as a Dashboard won't do what you need.
> Perhaps an Executive Dashboard, but I haven't fooled with them.
>
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Dave Eaton
> Sent: Thursday, December 11, 2008 1:36 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Viewing BOM's
>
> I need to give users the ability to view a bill of materials and all
> sub-bill/parts beneath it but I don't want these users to have access
> to the engineering workbench. The BOM listing report is useless as it
> does not give all information. In addition they should be able to look
> up a part directly from the bill. Does anyone know the best way to
> accomplish this?
>
>
> ------------------------------------
>
> 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/linksYahoo! Groups Links
>




------------------------------------

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/linksYahoo! Groups Links