Re: [foxboro] Decimals in AIM*Historian - ODBC returned data. Automatic Excel reports

There is a Foxboro product that allows you to configure and schedule =
Excel
reports with GUIs. It can extract data from Legacy or AIM* historian.

Its name is "Information Suite Report Package" and its PSS can be found =
here
:
=20
http://www.foxboro.com/iaseries/pss/pss/start.asp?xml=3Dpss.xml&xsl=3Din=
fo.xsl



-----Original Message-----
From: Control y Automatizacion (Rodolfo Piedra)
[mailto:rpiedra@xxxxxxxxxxx]
Sent: Monday, February 24, 2003 8:07 PM
To: Omori, Suzi
Cc: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] Decimals in AIM*Historian - ODBC returned data.
Automatic Excel reports



Thanks, you right.

Now we are facing the problem with automatic reports. We configured an
excel-ODBC reports which now works perfectly in interactive mode.

We added an Auto_Open macro, it saves the report (just data, no =
functions)
and quits automatically. If we manually run this sheet, it performs as
expected but when we schedule it using NT=B4s "task scheduler" the ODBC
function calls "SQL.Request" returns no data.

Any idea will be appreciated.

Thanks in advance,

Rodolfo Piedra



----- Original Message -----
From: "Omori, Suzi" <SOmori@xxxxxxxxxxx>
To: "'Control y Automatizacion (Rodolfo Piedra) '" =
<rpiedra@xxxxxxxxxxx>
Sent: Saturday, February 22, 2003 1:20 AM
Subject: RE: [foxboro] Decimals in AIM*Historian - ODBC returned data


> Take a look at your Windows Regional Settings:
> Keep in mind that in USA they use (.) as decimal notation....
>
> Regards,
> Suzi
>
>
> -----Original Message-----
> From: Control y Automatizacion (Rodolfo Piedra)
> To: foxboro@xxxxxxxxxxxxx
> Sent: 20/Feb/2003 7:57 PM
> Subject: [foxboro] Decimals in AIM*Historian - ODBC returned data
>
> We implemented a data report using following ODBC call in excel, but
> returned data has no decimal.
>
> =
=3DSQL.REQUEST("DSN=3DAIM_Historian;AP=3DS00001;DB=3DReduction";;4;"SELE=
CT
> '"&B$7&"' FROM '"&B$1&"'  WHERE (Source=3D'"&B$6&"' and Time BETWEEN =
{ts
> '"&$C$3&"'} And {ts '"&$C$4&"'})";TRUE)
>
> Any idea  how to get the data with, at least, one decimal.
>
> Thanks in advance,
>
> Rodolfo Piedra
> Control y Automatizacion SA
> PO Box 1612-7050
> Costa Rica
> Celular +506   834-1921
> Ph: +506  256-9901
> Fax: +506 223-3539  /  257-5392
> rpiedra@xxxxxxxxxxx
>
>
>
>
> =
_______________________________________________________________________
> This mailing list is neither sponsored nor endorsed by Invensys =
Process
> Systems (formerly The Foxboro Company). Use the info you obtain here =
at
> your own risks. Read =
http://www.thecassandraproject.org/disclaimer.html
>
> foxboro mailing list:             =
http://www.freelists.org/list/foxboro
> to subscribe:         =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Djoin
> to unsubscribe:      =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Dleave
>
>

=20
=20
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
=20
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Djoin
to unsubscribe:      =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Dleave
=20
 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: