IoT & Connectivity

Does anyone know if there is a way to export the asset inventory from Kepserver?  Looking specifically for a list of the devices at a site with their name, IP and/or MAC address, and anything else we can get.  Would be interested in the API call as well if there is one.

Hello, I am trying to check the network connection with another server from thingworx , but when i try to run the telnet from command prompt it gives me following error. 'telnet' is not recognized as an internal or external command, operable program or batch file Thanks

When communicating with Mitsubishi PLC via Mitsubishi Ethernet from kepServer, I wonder if it is difficult to link if they are on different networks.I have already confirmed that linking is possible on the same network.----------------------------------------------------------Translated the topic from Korean to English using google translate.Body - kepServer에서 Mitsubishi Ethernet을 통해 Mitsubishi PLC와 통신할 때 다른 네트워크에 있으면 연동이 어려운지 궁금합니다.같은 네트워크에서 연동이 가능하다는 것은 이미 확인했습니다.-By Community Moderation Team.----------------------------------------------------------

In TWX 9.6 , While trying to pass value from collection to cell mashup using MashupGlobalPropertyBinding , observed in cell mashup i am not getting the value , What should I try ?

Hello Community,     I  have datatable with usercredentials stored in it and one of the field is of password type which i do hash also before saving it. Now the issue is when i import this datatable from thingworx 9.1 to 9.3 and in my code below:= i am unable to get the value from datatable it just does not appear EntryExists.row[0].loginPassword is undefined even though on old thingworx version everything is working fine.   let EntryExists = Things[userDataTable].GetDataTableEntryByKey({ key: hashedLoginName }); if(EntryExists && EntryExists.rows[0].hashedLoginName == hashedLoginName && EntryExists.rows[0].loginPassword == hashedLoginPassword){  I have changed nothing but still it just does not work because its not getting it from datatable but on other hand all the fields are showing values. Why its like that    My assumption: I think its not possible to import the userpassword which are hashed into another

I am looking for guidance on managing code for custom Thingworx mashups. Is it possible to manage these in code versioning tools such as Github?What are some guidelines on managing changes to configuration of thingworx environments?

Hello community, We're experiencing issue where errors attached bellow pops up and it seems like this problem causing outages in our MES visualization system. Any ideas what can cause this error message or how to deal with it? Thanks in advance for suggestions. JT  

Error:  Unable to process purgeBetweenNow Request for Test_CM_ValueStream : Another request for this thing is active

Hi! i have read alot of documentation but cant find how to do this in TW9.5 i get succes on everything but it just adds empty lines in my infotable. i have added the json and service below{"station":"station_3","Artikelnr":2053,"antal":46,"vo":767,"Embalage":"Packaging_3","operator":"Operator_4","Antalskort":3} var dataTableName = "Proddata"; var dataShapeName = ".datashape.lucas"; var result = "Success"; try { var dataToAdd = dataToAdd; var jsonData = JSON.parse(dataToAdd); logger.debug("Incoming JSON data: " + jsonData); // Directly access the InfoTable property on the Thing var infoTable = me[dataTableName]; // Directly create a ValueCollection from the JSON data var rowValues = new Object(); rowValues.station = jsonData.station; rowValues.Artikelnr = jsonData.Artikelnr; rowValues.antal = jsonData.antal; rowValues.vo = jsonData.vo; rowValues.Embalage = jsonData.Embalage; rowValues.operator = jsonData.operator; rowValues.Antalskort = jsonData.Antalskort;

I have a problem about I changed the location of KEPSeverEX from PC-A to PC-B I transfer the licence and save lic file and active with new PC -B but I can't connect to my PLC and  it still show time limit  ( I can monitor some data )  how to solve this problem please suggest. Thank you in advance.

Hello Team, I would like to read the value from configuration API service, How can read the Value?   

Has anyone tried to migrate ThingWorx from Microsoft SQL server to PostGreSQL. Currently we are using ThingWorx 9.4.2 version.

Hi Everyone,I have grid widget which data is populated through a SQL service, and I want to export that data which is in the grid into an excel file , can I do that if so then please share the solution.   Thanks and Regards, Lavkush

Dear Community,    So below in attachment is my datashape of my datatable and currently i am getting all the entries in one of my service. Is there anyway that with infotable capabilities i can get entries which are created in the last 30 days. As you can see i have one of the parameter qualityCheckTimestamp which records the datetime for the entry. Now i would like to use pre existing function of infotable to get the entries created in last 30 days and if its not possible then i would have to iterate through all the entries to get the desired entries which would might be slow process. so anyone have a clue about it? Thank you 🙂   

Hi all, I have a dropdown on my Mashup that gets display data from one of my properties which have an infotable as output and Datashape of GenericStringList. It used to work fine but one day it just stops working and I can't figure out why after troubleshooting for half a day. Any help will be greatly appreciated.Below is the settings for my dropdown widget:Cheers,Deon

I'm not even exactly sure how to ask this question so if I seem ignorant that's only because I am. I assume that I'm having an issue understanding a fundamental concept of interacting with an OPC UA server.  I'm attempting to create an OPC UA client in Python to ultimately read values that originated from Modbus PLC registers. The targeted PLC is successfully connected to KepServerEX6 and values from registers are being pulled into KepServerEX Project>Channel>Device>Tags perfectly. The data (values from PLC registers) is being and has been successfully used from this KepServer by another application for several years so KepServer and connections to multiple PLCs (multiple brands) is working just fine. Python code completely aside, in a 3rd party OPC UA client application (UaExpert), I can connect to the OPC UA server, I can see a lot of things about the server/KepWare, (Root/Objects/Server, ServerCapabilities, ServerDiagnostics, etc) but the Objec

I am using KepServerEx (version 6.16) OPC DA client to access ABB MicroSCADA OPC server data.I am able to access OPC tags using the connection parameters. But when trying to read data using the OPC channel, i am getting the BAD vartype errorPictures (1-5) If I directly add OPC server to OPC client, and import tags to it from the same server, i am able to read all the values.Pictures (6-7) 

Hello ! Background :My application has several mashups that are loaded onto computer screens to display information. These computers start up automatically at the beginning of the day, then a script loads a mashup link. The link contains an Appkey, linked to a virtual user with rights to view the mashup. So these screens have no real user in front of them, they're just there to give information to people looking at the screen.Note that I have several different screens in different locations. Each screen works like this, using the same Appkey, linked to the same virtual user.   Problem:After a while (more than an hour), a login pop-up appears at the top of the mashup (see screenshot). The application continues to run in the background, but the pop-up is still there. I don't understand why the mashup requires a login, when it's still working and has an Appkey.   Solutions tried :I've tried changing the mashup session ID at regular intervals (every 5 minutes). I thought that if

Hi! I'm trying to post to thingworx.  Is it posible without creating the thing via post?   Is there an easier way to send JSONdata from a node.js application to ThingWorx?   Thanks for the help 🙂

This post will show you an example on how to use the DBConnection Building Block on a TWX 9.3.4+ instance.Sometimes you need to store data in ThingWorx, but none of the existing capabilities (Thing properties, Streams, ValueStreams or DataTables) really fit your use case and your best option is to directly use SQL. Previously, you had to do this manually, but now you can use the DB Connection Building Block which is part of the Common Building Blocks and is freely available. This way, you can also leverage the Building Block (BB) concept, the go-to architecture pattern to create reusable, shareable software components in Thingworx. While there is comprehensive documentation available around BBs, it is quite technical, and the idea of this article is to give a jumpstart with an easy and simple example. (Please note that when you are on ThingWorx 9.3.7 or newer, this process becomes drastically simpler, so if you're here just for the quickest results, you might want to check my foll

Hello All,      I have a datagrid widget in which i am showing some entries as you can see in the picture below i can choose which parameter to show and which do not. when i select the parameters and save changes then it appears and shows me but then when i open the mashup next day again then its again gone and do not show me the parameters which i have selected to display on the mashup in datagrid. I want the parameters which i selected to show me always there until i do changes. anyone has an idea about it?    

Good day all, I have a table that contains a timestamp field.I want to replace the values in this field with a specific dataDifference calculation that I make. The two dates that I use to find the difference are inputs.I have written the code below. It seems like the issue occurs when I assign the new timestamp value to the table.  if (testMode) {    // Get data directly from the property for testing purposes    searchTable = Things["ThingName"].ChartData[0].Data;} else {    searchTable = data;}  let params = {t1: searchTable /* INFOTABLE */};let clonedTable = Resources["InfoTableFunctions"].Clone(params);  // Find the row in searchTable with the matching timestamplet searchForTimestampRow = clonedTable.Find({timestamp: currentTimestamp});if (searchForTimestampRow) {    // Calculate duration    let duration = dateDifference(currentTimestamp, otherTime);     // Update the duration fi

Hi Everyone,I have a requirement in which I ahve data like this  Now i want to sort data Based on Approved state , Sports Category Mainly Approved State and then want to show the data on line or bar chartso Basically requirement is in the drop down all the approved state will be there and when I select one of the approved state the data will populate in the Bar/ Line chartso how can I implement this pls share your solution  ThanksLav

Needed to copy some properties from one Thing to other. To avoid manual work, created Service with AddPropertyDefinition (later wanted to add service to copy values). It creates no error when running first time, but properties are not generated. So, started script - and it answer "Property [name] already exists".Manual refreshing of Thing in web service does not help. Restart Thing by code also makes no difference. Here is sample code: myList = me.GetPropertyDefinitions({category: "MyCategory" /* STRING */,type: undefined /* BASETYPENAME */,dataShape: undefined /* DATASHAPENAME */}); for each (var x in myList.rows) {Things["MyThing"].AddPropertyDefinition({indexed: undefined /* BOOLEAN {"defaultValue":false} */,defaultValue: undefined /* STRING */,remoteBindingAspects: undefined /* JSON */,description: "my desc"/* STRING {"defaultValue":""} */,readOnly: undefined /* BOOLEAN {"defaultValue":false} */,type: 'INFOTABLE' /* BASETYPENAME */,remote: undefined /* BOOLEAN {"defa

Hello community,Is there a way to check what the real error is in KEPServerEX for SQL diagnostics? This doesn't help at all:Date Time Level Source Event12/08/2024 16:39:18 Error Data Logger Plug-in Unknown error while executing query in table 'mytable' for log group 'datalog-azure'. I am guessing it's something about security/privileges since I am trying to log data in an Azure database.I am able to see tables, columns when I am mapping the data but unable to write values to table.Using app version 6.16 (V6.16.203.0)  Any help is appreciated. Cheers,