-
QSX Integration. Starting data.
Hi Guys!
Someone finished the integration of the QSX processor?
Explain how you got the initial device data. Integrator Type: Username / Password.
Thanks
-
Hello! You can find further integration details in Settings > Configure Integration in the Designer software.
-
Post Thanks / Like - 0 Thanks, 1 Likes, 0 Dislikes
-
HI! CSV file suits me.
Who is interested, what do you find in the CVS file:
- Device name,Model,href,Component,Component href,Component Name
- Zone Name,href
- HVAC Zone Name,href
- Area Name,href
- Shade Group Name,href
- Area Scene Name,href
Thanks Jonathan, it's not an obvious place for starting data for me)
-
The following key points should be taken into consideration while designing a database or data manipulation:
a. Appropriate Data Type to improve the query performance and lead enrichment
b. Avoid nchar and nvarchar because both take double memory
c. Avoid NULL in the fixed-length field
d. Avoid * in SELECT statement
e. Use always the command EXISTS
f. Avoid Clause
g. Create Clustered and Non-Clustered Indexes
h. Avoid Cursors
i. Use Table variable