[Imported] Nouvel utilisateur CS

[sbeadle]

>>Message imported from previous forum - Category:ClearSCADA Software<<
User: ape, originally posted: 2019-03-01 10:28:10 Id:374
Hello everyone I have recently been a new user of clearscada software that I particularly like, and I support demos for existing clients and I need specific features such as mapping with real value display , also the use of table via dream report.
I would also like to know if it is possible in a simple way to import variables en masse?
I do not speak very well but then forgive my mistakes in advance thank you very much and congratulations for this forum mutual aid

[sbeadle · Accepted solution]

>>Responses imported from previous forum

Reply From User: sbeadle, posted: 2019-03-01 13:56:25
Hi, you're welcome!

Bulk configuration/import - see "Spreadsheet-based Configuration Import Tool" at http://resourcecenter.controlmicrosystems.com/pages/viewpage.action?pageId=40535951

Mapping - read the release notes for ClearSCADA 2017 at: https://schneider-electric.box.com/shared/static/bct2w7pxt6koqfl0tcoxp0fzwzgn55j3.pdf

Best regards.

Reply From User: ape, posted: 2019-03-01 14:21:50
Thank you for this informations.
For cartographie, i can't to display a real value in tooltip? it's possible?
have you ever used dream report for CS 2017R3?

Reply From User: sbeadle, posted: 2019-03-01 14:57:34
Yes, you can use the SQL in the User Query to display values (in colours) in the tooltips. The 2017 version release notes describe how.
Dream Reports can access the ClearSCADA historian - details are in their documentation.

Reply From User: ape, posted: 2019-03-02 06:35:19
Do you know why this query doesn 't work? i would like display synthes of active alarme count/acquit alarm count/alarm clean count on one display on tooltip

SELECT FULLNAME, FULLNAME || '
Alarmes : ' || AlarmSetCount(Value)
as "TOOLTIP", GISLOCATION-LATITUDE, GISLOCATION-LONGITUDE,CASE WHEN AlarmSetCount 0 THEN 255 WHEN AlarmAcceptedCount 0 THEN 255
WHEN AlarmClearedCount 0 THEN 150*256 ELSE 0 END AS"Foreground", Background,CASE WHEN AlarmSetCount 0 THEN 1 ELSE 0
END AS "Blink",AlarmSetCount, AlarmAcceptedCount, AlarmClearedCount
FROM CGROUP
WHERE
FULLNAME LIKE '%EU%' AND GISLOCATIONSOURCE = 1
ORDER BY AlarmSetCount, AlarmAcceptedCount, AlarmClearedCount

Reply From User: BevanWeiss, posted: 2019-03-03 21:30:37
What is AlarmSetCount(Value) supposed to be?
Do you instead just mean AlarmSetCount? (i.e. the property on the CGroup object type)

You should include the error message in these situations. In fact, I suspect that the error message would have told you exactly what the problem was.

Reply From User: ape, posted: 2019-03-04 05:44:28
indeed, the error message informs me that the request can not concatenate values of type string or integer. I have the following query on which I can not insert numerical values

SELECT FULLNAME, FULLNAME || '
Active:' || 'Acquitted:' || 'Disappeared:' as "TOOLTIP",
GISLOCATION- LATITUDE, GISLOCATION- LONGITUDE, WHEN CASE AlarmSetCount 0 THEN 255 WHEN AlarmAcceptedCount 0 THEN 255
WHEN AlarmClearedCount 0 THEN 150 * 256 ELSE 0 END AS "Foreground", Background, CASE WHEN AlarmSetCount 0 THEN 1 ELSE 0
END AS "Blink", AlarmSetCount, AlarmAcceptedCount, AlarmClearedCount
FROM CGROUP
WHERE
FULLNAME LIKE '% EU%' AND GISLOCATIONSOURCE = 1
ORDER BY AlarmSetCount, AlarmAcceptedCount, AlarmClearedCount

Reply From User: sbeadle, posted: 2019-03-04 08:50:26
look at FORMATVALUE in the SQL help

Reply From User: ape, posted: 2019-03-04 09:20:16
Thank you very much it's ok !!!!

Reply From User: ape, posted: 2019-03-04 09:28:14
But i dont't understand this example query in the note.
i would like display on map synthese "Niveaux" of a group "EP" with 2 sites but it doesn't work. i dont find my error...

SELECT g.Id as "Id", g.FullName as "FullName",g.FullName || '
|| FormatValue (r.Niveaux '0.00') as"Tooltip",
g.GISLOCATION-LATITUDE as "GISLOCATION-LATITUDE", g.GISLOCATION-
LONGITUDE as "GISLOCATION-LONGITUDE",
case
when Niveaux 50 then (255 + cast( (100-Niveaux)/100*2*255 as INT)*256)
end as "Foreground",255+256*255+256*256*255 as "Background", 0 as "Blink"
FROM CGROUP AS g left join CRandom as r on r.ParentGroupId = g.Id
WHERE g.FULLNAME LIKE 'EP.%'

Reply From User: sbeadle, posted: 2019-03-04 09:30:19
I think formatting messed that post up. Try the code format.

Reply From User: ape, posted: 2019-03-04 09:31:35
voir le code plus bas ......

Reply From User: ape, posted: 2019-03-04 11:04:01
i try to simplify the query but display doesn't work (identifier unknow).
This group for measure is local/EP/Site/variables/mesures/niveau

SELECT FULLNAME, FULLNAME ||'
' || FormatValue (Niveau.Currentvalue using '0.00') as "TOOLTIP",
GISLOCATION-LATITUDE, GISLOCATION-LONGITUDE,
FROM CGROUP
WHERE
FULLNAME LIKE '%EU%' AND GISLOCATIONSOURCE = 1

Reply From User: ape, posted: 2019-03-04 09:32:15
view code lower......

Reply From User: sbeadle, posted: 2019-03-04 10:17:16

Try testing your query in querypad (search in the help).
'
' || FormatValue (r.Niveau USING '0.00')
Quotes around

Add USING
What is r.Niveau - no field with this name exists
The JOIN links a point within the group

Reply From User: ape, posted: 2019-03-04 09:41:42
Sorry, i don't have seen that we can get a preview for the message..

Reply From User: ape, posted: 2019-03-04 10:03:50
SELECT g.Id as "Id", g.FullName as "FullName",g.FullName ||
|| FormatValue (r.Niveau '0.00') as"Tooltip",
g.GISLOCATION-LATITUDE as "GISLOCATION-LATITUDE", g.GISLOCATION-
LONGITUDE as "GISLOCATION-LONGITUDE",case
when r.Niveau 50 then (255 + cast( (100-r.Niveau)/100*2*255 as INT)*256)
end as "Foreground",255+256*255+256*256*255 as "Background", 0 as "Blink"
FROM CGROUP AS g left join CRandom as r on r.ParentGroupId = g.Id
WHERE g.FULLNAME LIKE 'EU.%'

Reply From User: sbeadle, posted: 2019-03-04 13:52:31
Your query is from the table CGroup (an object folder), but you are selecting a field (currentvalue) valid only on points, and with a table alias (Niveau) which does not exist. Is your point called Niveau and the top level group is EU?
Maybe try
`SELECT FULLNAME, FULLNAME ||'
' || FormatValue (p.Currentvalue using '0.00') as "TOOLTIP",
GISLOCATION-LATITUDE, GISLOCATION-LONGITUDE,
FROM CDBPoint p
WHERE
FULLNAME LIKE 'EU.%.Niveau' AND GISLOCATIONSOURCE = 1`

Reply From User: ape, posted: 2019-03-04 14:06:19
Ok i understand a little more...
What is "p." front of field currentvalue?
What is " p after CDBPoint?
I try this query but she doesn't work (unexpected identifier)

thank you for your patience ; i'm beginner and great opportunity comes with this software

Reply From User: ape, posted: 2019-03-05 16:02:19
It's OK!!!! so i can't to display 2 values on one tootlip..it's possible for

Reply From User: ape, posted: 2019-03-05 16:07:03
`SELECT FULLNAME, FULLNAME||'
' || Formatvalue (CurrentValueFormatted using '0.00') AS "TOOLTIP",
GISLOCATION-LATITUDE, GISLOCATION-LONGITUDE
FROM CDBPoint
Where fullname LIKE '%.Niveau%'`

Reply From User: sbeadle, posted: 2019-03-06 13:13:52
p is a table alias: https://www.sqlteaching.com/#!table_alias