Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84649members
353989posts

[Imported] Nouvel utilisateur CS

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

Solved
sbeadle
Janeway Janeway
Janeway
0 Likes
1
490

[Imported] 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


Accepted Solutions
sbeadle
Janeway Janeway
Janeway
0 Likes
0
489

Re: [Imported] Nouvel utilisateur CS

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

 

See Answer In Context

1 Reply 1
sbeadle
Janeway Janeway
Janeway
0 Likes
0
490

Re: [Imported] Nouvel utilisateur CS

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