New in the Community? Get started here

Schneider Electric Exchange Community

Discuss and solve problems in energy management and automation. Join conversations and share insights on products and solutions. Co-innovate and collaborate with a global network of peers.

Register Now
Geo SCADA Expert Forum
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Lt. Commander

[import] Nouvel utilisateur CS

>>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


Reply 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 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 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 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 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 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 User: sbeadle, posted: 2019-03-04 08:50:26
look at FORMATVALUE in the SQL help


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


Reply 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 User: sbeadle, posted: 2019-03-04 09:30:19
I think formatting messed that post up. Try the code format.


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


Reply 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 User: ape, posted: 2019-03-04 09:32:15
view code lower......


Reply 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 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 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 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 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 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 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 User: sbeadle, posted: 2019-03-06 13:13:52
p is a table alias: https://www.sqlteaching.com/#!table_alias