Auto-refresh php based dashboard

system · January 27, 2009, 2:33pm

There are some arbitrary limitations in terms of what you can do with
MES.

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mjhoney71
Sent: Tuesday, January 27, 2009 2:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: auto-refresh php based dashboard

The baq is marked as shared but the user running the dashboard is not
the same user that created the baq. We don't get the mentioned error
unless we try using the dashboard in MES. Could there be some type
of limitation with MES on the tables that can be queried?

Marc

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Brian W. Spolarich "
<bspolarich@...> wrote:

>
> Are you logged in using the same account? Is the BAQ that the
> dashboard is using marked as Shared?
>
>
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced

Photonix /

> Picometrix
>
> bspolarich@... ~ 734-864-5618 ~
> www.advancedphotonix.com
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf

> Of mjhoney71
> Sent: Tuesday, January 27, 2009 1:06 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: auto-refresh php based dashboard
>
>
>
> Thank you very much, this approach worked very well. I have another
> issue I was wondering if you could help me with. When I try to use
> this dashboard in the Vantage MES I get an error "Invalid query:
> where (Company='Argo-MI' and ()) and (IsShared = yes or
> DCDUserID='timeclock') and (Approved=yes)". What might be causing
> this problem? I don't get this error when using the dashboard in a
> full Vantage client.
>
> Thanks,
>
> Marc
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

<mailto:vantage%40yahoogroups.com> ,

> "Brian W. Spolarich "
> <bspolarich@> wrote:
> >
> > Yes. The trick is that you need to have the dashboard tab get
> its URL
> > from a BAQ. Here's how I did it.
> >
> >
> >
> > 1. Write a BAQ that returns a single calculated field whose
> value
> > is the URL you want to use. I just pick the Company table for my
> base
> > table, even though I don't select any fields from it. The Progress
> > syntax for a string is to enclose it in double quotes. E.g.
> > http://intranet.mycompany.com/foo.aspx.
> >
> > 2. Add that query to your dashboard. Publish the URL field
> from
> > the query.
> >
> > 3. Add a URL view to your dashboard. Subscribe the URL view
> to
> > use the query's published field.
> >
> > 4. Now it will auto-populate as you expect. You can drag the
> > Dashboard Grid View to the bottom to minimize you since you won't
> care
> > to show it on this tab but I would get runtime errors if I

deleted

> it.
> >
> >
> >
> > That's it. Kind of a kluge but probably explainable given the
> > Dashboard program's event model.
> >
> >
> >
> > --
> >
> > Brian W. Spolarich ~ Manager, Information Services ~ Advanced
> Photonix /
> > Picometrix
> >
> > bspolarich@ ~ 734-864-5618 ~
> > www.advancedphotonix.com
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

<mailto:vantage%40yahoogroups.com>

> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

<mailto:vantage%
40yahoogroups.com> ] On

> Behalf
> > Of mjhoney71
> > Sent: Monday, January 26, 2009 3:45 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

<mailto:vantage%40yahoogroups.com>

> > Subject: [Vantage] auto-refresh php based dashboard
> >
> >
> >
> > I have a php script that I call via a url in a dashboard to show
> > employees how many hours they have clocked for the week. When I

run

> > the dashboard from inside a Vantage client it just brings up a
> blank
> > page with a mini IE toolbar. I have to click the home icon on the
> > toolbar to get the data to populate. Is there a way to call this
> url
> > so it will auto-update?
> >
> > TIA,
> >
> > Marc
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · January 26, 2009, 3:45pm

I have a php script that I call via a url in a dashboard to show
employees how many hours they have clocked for the week. When I run
the dashboard from inside a Vantage client it just brings up a blank
page with a mini IE toolbar. I have to click the home icon on the
toolbar to get the data to populate. Is there a way to call this url
so it will auto-update?

TIA,

Marc

system · January 26, 2009, 3:59pm

Yes. The trick is that you need to have the dashboard tab get its URL
from a BAQ. Here's how I did it.

1. Write a BAQ that returns a single calculated field whose value
is the URL you want to use. I just pick the Company table for my base
table, even though I don't select any fields from it. The Progress
syntax for a string is to enclose it in double quotes. E.g.
http://intranet.mycompany.com/foo.aspx.

2. Add that query to your dashboard. Publish the URL field from
the query.

3. Add a URL view to your dashboard. Subscribe the URL view to
use the query's published field.

4. Now it will auto-populate as you expect. You can drag the
Dashboard Grid View to the bottom to minimize you since you won't care
to show it on this tab but I would get runtime errors if I deleted it.

That's it. Kind of a kluge but probably explainable given the
Dashboard program's event model.

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mjhoney71
Sent: Monday, January 26, 2009 3:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] auto-refresh php based dashboard

I have a php script that I call via a url in a dashboard to show
employees how many hours they have clocked for the week. When I run
the dashboard from inside a Vantage client it just brings up a blank
page with a mini IE toolbar. I have to click the home icon on the
toolbar to get the data to populate. Is there a way to call this url
so it will auto-update?

TIA,

Marc

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

system · January 27, 2009, 1:06pm

Thank you very much, this approach worked very well. I have another
issue I was wondering if you could help me with. When I try to use
this dashboard in the Vantage MES I get an error "Invalid query:
where (Company='Argo-MI' and ()) and (IsShared = yes or
DCDUserID='timeclock') and (Approved=yes)". What might be causing
this problem? I don't get this error when using the dashboard in a
full Vantage client.

Thanks,

Marc

--- In vantage@yahoogroups.com, "Brian W. Spolarich "
<bspolarich@...> wrote:

>
> Yes. The trick is that you need to have the dashboard tab get

its URL

> from a BAQ. Here's how I did it.
>
>
>
> 1. Write a BAQ that returns a single calculated field whose

value

> is the URL you want to use. I just pick the Company table for my

base

> table, even though I don't select any fields from it. The Progress
> syntax for a string is to enclose it in double quotes. E.g.
> http://intranet.mycompany.com/foo.aspx.
>
> 2. Add that query to your dashboard. Publish the URL field

from

> the query.
>
> 3. Add a URL view to your dashboard. Subscribe the URL view

to

> use the query's published field.
>
> 4. Now it will auto-populate as you expect. You can drag the
> Dashboard Grid View to the bottom to minimize you since you won't

care

> to show it on this tab but I would get runtime errors if I deleted

it.

>
>
>
> That's it. Kind of a kluge but probably explainable given the
> Dashboard program's event model.
>
>
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced

Photonix /

> Picometrix
>
> bspolarich@... ~ 734-864-5618 ~
> www.advancedphotonix.com
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf

> Of mjhoney71
> Sent: Monday, January 26, 2009 3:45 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] auto-refresh php based dashboard
>
>
>
> I have a php script that I call via a url in a dashboard to show
> employees how many hours they have clocked for the week. When I run
> the dashboard from inside a Vantage client it just brings up a

blank

> page with a mini IE toolbar. I have to click the home icon on the
> toolbar to get the data to populate. Is there a way to call this

url

> so it will auto-update?
>
> TIA,
>
> Marc
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 27, 2009, 2:08pm

Are you logged in using the same account? Is the BAQ that the
dashboard is using marked as Shared?

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mjhoney71
Sent: Tuesday, January 27, 2009 1:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: auto-refresh php based dashboard

Thank you very much, this approach worked very well. I have another
issue I was wondering if you could help me with. When I try to use
this dashboard in the Vantage MES I get an error "Invalid query:
where (Company='Argo-MI' and ()) and (IsShared = yes or
DCDUserID='timeclock') and (Approved=yes)". What might be causing
this problem? I don't get this error when using the dashboard in a
full Vantage client.

Thanks,

Marc

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Brian W. Spolarich "
<bspolarich@...> wrote:

>
> Yes. The trick is that you need to have the dashboard tab get

its URL

> from a BAQ. Here's how I did it.
>
>
>
> 1. Write a BAQ that returns a single calculated field whose

value

> is the URL you want to use. I just pick the Company table for my

base

> table, even though I don't select any fields from it. The Progress
> syntax for a string is to enclose it in double quotes. E.g.
> http://intranet.mycompany.com/foo.aspx.
>
> 2. Add that query to your dashboard. Publish the URL field

from

> the query.
>
> 3. Add a URL view to your dashboard. Subscribe the URL view

to

> use the query's published field.
>
> 4. Now it will auto-populate as you expect. You can drag the
> Dashboard Grid View to the bottom to minimize you since you won't

care

> to show it on this tab but I would get runtime errors if I deleted

it.

>
>
>
> That's it. Kind of a kluge but probably explainable given the
> Dashboard program's event model.
>
>
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced

Photonix /

> Picometrix
>
> bspolarich@... ~ 734-864-5618 ~
> www.advancedphotonix.com
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf

> Of mjhoney71
> Sent: Monday, January 26, 2009 3:45 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] auto-refresh php based dashboard
>
>
>
> I have a php script that I call via a url in a dashboard to show
> employees how many hours they have clocked for the week. When I run
> the dashboard from inside a Vantage client it just brings up a

blank

> page with a mini IE toolbar. I have to click the home icon on the
> toolbar to get the data to populate. Is there a way to call this

url

> so it will auto-update?
>
> TIA,
>
> Marc
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · January 27, 2009, 2:27pm

The baq is marked as shared but the user running the dashboard is not
the same user that created the baq. We don't get the mentioned error
unless we try using the dashboard in MES. Could there be some type
of limitation with MES on the tables that can be queried?

Marc

--- In vantage@yahoogroups.com, "Brian W. Spolarich "
<bspolarich@...> wrote:

>
> Are you logged in using the same account? Is the BAQ that the
> dashboard is using marked as Shared?
>
>
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced

Photonix /

> Picometrix
>
> bspolarich@... ~ 734-864-5618 ~
> www.advancedphotonix.com
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf

> Of mjhoney71
> Sent: Tuesday, January 27, 2009 1:06 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: auto-refresh php based dashboard
>
>
>
> Thank you very much, this approach worked very well. I have another
> issue I was wondering if you could help me with. When I try to use
> this dashboard in the Vantage MES I get an error "Invalid query:
> where (Company='Argo-MI' and ()) and (IsShared = yes or
> DCDUserID='timeclock') and (Approved=yes)". What might be causing
> this problem? I don't get this error when using the dashboard in a
> full Vantage client.
>
> Thanks,
>
> Marc
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Brian W. Spolarich "
> <bspolarich@> wrote:
> >
> > Yes. The trick is that you need to have the dashboard tab get
> its URL
> > from a BAQ. Here's how I did it.
> >
> >
> >
> > 1. Write a BAQ that returns a single calculated field whose
> value
> > is the URL you want to use. I just pick the Company table for my
> base
> > table, even though I don't select any fields from it. The Progress
> > syntax for a string is to enclose it in double quotes. E.g.
> > http://intranet.mycompany.com/foo.aspx.
> >
> > 2. Add that query to your dashboard. Publish the URL field
> from
> > the query.
> >
> > 3. Add a URL view to your dashboard. Subscribe the URL view
> to
> > use the query's published field.
> >
> > 4. Now it will auto-populate as you expect. You can drag the
> > Dashboard Grid View to the bottom to minimize you since you won't
> care
> > to show it on this tab but I would get runtime errors if I

deleted

> it.
> >
> >
> >
> > That's it. Kind of a kluge but probably explainable given the
> > Dashboard program's event model.
> >
> >
> >
> > --
> >
> > Brian W. Spolarich ~ Manager, Information Services ~ Advanced
> Photonix /
> > Picometrix
> >
> > bspolarich@ ~ 734-864-5618 ~
> > www.advancedphotonix.com
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%

40yahoogroups.com> ] On

> Behalf
> > Of mjhoney71
> > Sent: Monday, January 26, 2009 3:45 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] auto-refresh php based dashboard
> >
> >
> >
> > I have a php script that I call via a url in a dashboard to show
> > employees how many hours they have clocked for the week. When I

run

> > the dashboard from inside a Vantage client it just brings up a
> blank
> > page with a mini IE toolbar. I have to click the home icon on the
> > toolbar to get the data to populate. Is there a way to call this
> url
> > so it will auto-update?
> >
> > TIA,
> >
> > Marc
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>