IoT & Connectivity

Hi Developers,I'm trying to create the following functions.1. save image file to SQL as binary data.2. pull binary data from SQL.3. create Image contents from the binary data to display on mashup. I'm struggling to create codes for part 3.Could anyone help me for the part3?    

Hello, i'am trying to add the value of a property to the Value column of a infotable located in the same thing as the properties i want to use. I have the name of every property in string format and since there are around 200 of them i wanted to use this to add them. example: myArr = [{Name: 'Tag1', Message: 'Hello', Type: 'BOOLEAN'}, {Name: 'Tag2', Message: 'Sweet', Type: 'BOOLEAN'}]   me.myInfo.AddRow(       {        Name: myArr[0].Name        Message: myArr[0].Message        Status: me.myArr[0].Name //This part dont work. I Have a property with that exact name and i want the status for that property      }   how can i reffrence the tag with the string i have? Or another smarter way to refrence it? In my program im planning to use a for loop to go over every tag one at the time.      

Shall we add subcolumns for each field definition in infotable

{"data": [{"usageId": "50030540014333322800000050","assetFound": true,"compartments": {"rows": [{"compartmentId": "50030540014333322800000052","observableProperties": {"gatewayLocationDescription": "Ireland","temperature": 6,"timestamp": 1612393200000},"compartmentUsage": {"compartmentState": "Inuse","minTemperatureThreshold": 2.2}},{"compartmentId": "50030540014333322800000051","observableProperties": {"gatewayLocationDescription": "Belgium","temperature": 2,"timestamp": 1612220400000},"compartmentUsage": {"compartmentState": "Idle"}}],"dataShape": {"fieldDefinitions": {"compartmentId": {"name": "compartmentId","aspects": {"isPrimaryKey": false},"description": "","baseType": "STRING","ordinal": 1},"observableProperties": {"name": "observableProperties","aspects": {"isPrimaryKey": false},"description": "","baseType": "JSON","ordinal": 3},"compartmentUsage": {"name": "compartmentUsage","aspects": {"isPrimaryKey": false},"description": "","baseType": "JSON","ordinal": 2}}}}}],"message":

I'm having problems troubleshooting an SLC5/05 tag syntax.  I am using Open Addressing and both of my OPC UA utilities required imported tags.  Any tools or utilities I can use? 

We are having a following services to get/search/query the data table data. Which service is more efficient? GetDataTableEntriesSearchDataTableEntriesQueryDataTableEntries 

hi, allNow I'm working with Thingworx 9.2.0.I create ex1Thig and add ex1Infotable property defined by ex1Datashpe includes LOCATION base type field to show the location on the Google Map Widget as below.The location field is available at the setting default value in INFOTABLE.But the location field in not available in edit value in INFOTABLE because the location column is missing, Why?Thanks. 1 ex1Datashape 2 ex1Thing 3 ex1Infotable -> default value -> all columns are available. 4 ex1InfoTable -> value setting --> no location field!          

I'm trying to push an empty child infotable to a field (of basetype : infotable) in parent infotable var InvalidAssets = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "ChildInfotable.DS"});var output = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "ParentInfotable.DS"});var message = "Please enter name";output.AddRow({"InvalidAssets" : InvalidAssets, //infotable"StatusMessage" : message //string});var result = output; attached is the output I'm seeing... but I would like to have empty infotable in the "InvalidAssets" feild as I'm trying to bind the child infotable from the output of the service to a grid in mashup.     

Hi What does it mean SelectedRows in the output of a service ?  Thank you    

Caution: Multiple licenses of the same product cannot be activated on one machine. Attempting to do so will result in the loss of the license. kepware como resolver? oque fazer quando aparece esta mensagem no kepware? 

Now i try to make dashboard for showing data from MSSQL to Kepware in ODBC Client (as picture 1) and input to ThingWorx for showing as dashboard. But i cannot show all data that save to MSSQL can show only 1 row (as Picture 2) and can use Move function only (as Picture 3) but cannot next at mashup and search by date and time. How can i show all data and sorting by date and time? Thank you.  

Dear Sir,                I want to Copy a column in excel sheet with 1000 cell value to Siemens S7 1500(Excel =>  Kepserver Ex(DDE) => Siemens PLC ).the only way up till now for me i write 1000 tags 3 time manually one time to define Siemens PLC tags ,second time in DDE, third time define in advanced tags . so there's any way to assign 1000 tags for example as array or any way?. Best Regards, Ahmed Helmy        

How to activate Thingworx license?   Translated by the Community Moderation using Google Translate ----------------------------------------------------------------------------------------------- Como ativar a licença do Thingworx??      

Please import the attached extension to min(9.2.1) Thingworx version.Upon clicking Take snapshot button it is capturing image perfectly but the base64 string needs to be passed to image_base64 property which is not happening and getting type error.Not sure why it is happeneing. Please check and let me know why it is faling. Thanks in advance

Currently we have KepserverEx V5.21.236 with a 2017 licence on our server. Which version am I eligible for free?Because the screenshot says V6.3. Thank you! 

Hi  As i previously posted a query that, i have created customize login page on thingworx by using the jsp file.I have created users on thingworx side which are present on database side and also on thingworx side.I am creating user which have fields like "Name", "Contact no", "Email Address", "Username". And i am registering the Username as Email Address like "ABCD@gmail.com". when i am trying to login on thingworx login page it is login with the username "ABCD@gmail.com" which is correct. But now i want to login with name like, if i will enter the name "ABCD" then it should login. is it possible to do on Customize login page on JSP file?Please let me know the solution on this ASAP.  

Hello, Is there any possibility to connect a Fanuc Robot to a Kepware Server by an ethernet connection?  

I want to save the data I bound to the grid while some (not all)  rows users can edit.I need to save both edited and unedited rows. currently, I'm getting only those rows that are edited. I need all the grid data. My Thingworx version is 9.3.3-b20.if anyone know how to achieve it please help.   

Hi,   Is there a possibility to get a user last logged in time?   Thanks,  

Hi  I want to connect the control logic 5500 into kepware using routing path. the first plc connected to the network same as the server and the second plc is connected locally to the first plc. can someone give me the device ID? see the attached screenshot      

In a data analysis project, you are tasked with exploring an SQL database to gather insights about a company's sales data. The database contains two tables: orders and customers. The orders table includes columns like order_id, customer_id, order_date, and order_amount. The customer's table includes columns like customer_id, customer_name, and country. My goal is to write SQL queries to answer the following questions:Total Revenue: Calculate the total revenue generated from all orders.Top Customers: Identify the top 5 customers who have made the most orders, along with the total number of orders they placed.Country Analysis: Find the top 3 countries with the highest total revenue from orders.Monthly Sales Trends: Generate a report showing the total revenue for each month, ordered chronologically.Please give me some places where I may discover the answers to these queries or small samples of SQL code. Assuming the appropriate tables are present, you may provide SQL queries to get t

Hello, I am using a collection widget to display items in an info table and a chart. However, it only displays the rows and I am unable to display or put on any column headings. To clarify, I am using a collection widget and not a grid widget since I wanted to add shapes in the table, where the color changes based on a column's value. This is what the parent mashup looks like:The workaround that I did was that I added a container above the collection widget which has the column names that I want. However, that didn't work well since the column headings do not align with the columns in the container widget, as seen in the image below (mashup on runtime): I have tried just resizing the containers but it still did not work well and it does not seem like a good idea since it will just be based on my screen size.Could someone please tell me how can I solve this? Thank you in advance. 

so the Whats new page of 9.4.0 states this: Platform There is a known issue with API SetGlobalSessionInfoTableValue, where the infotable value is not stored correctly. This API will be deprecated and removed in a future release; issue will not be fixed. Update your applications appropriately.   Can i get some more clarification about this: "This API will be deprecated and removed in a future release"?   Will only function SetGlobalSessionInfoTableValue be removed or will there be more changes to the sessions?   side note: The javadoc doesn't show it as deprecated.

Hi All,I'm facing an issue with KEPSERVER EX and MODBUS TCP/IP.I have one Channel for MODBUS communication and in it 8 devices (each has 16 tags). Each of it commucating with same IP but with different ID to read data from different channels.When I have only 5 devices, all works fine. When I add more, I'm not able to read devices from ID5 to 8 (warning - device is not responding), but the first 4 still works fine.I've tried to separate devices to other channel, tried to raise the Scan rate to 20 seconds for each tag. but nothing helped.I've tried to read the IDs from vendors app, which is communication also over modbus and it works fine for all devices in same time. do you have any suggestions/ideas what to do?Many thanks  

We recently update Kepware version but start some error with a driver of control logix 5500 the plc is some old and have the firmware version 20.0, and some times lose connection and try to generate the tags but fail until we start the create tags of the driver some know why happen this or some advise