IoT & Connectivity

What's needed on the Advanced Grid is someone at PTC to RECODE the "RESET" attribute.  I expect RESET to "reset" the grid back to its original DEFAULT state.  That is, after all, what the word RESET means!   [RESET(Verb) - To set back to the initial state.]   If it had no rows selected when you first arrived at the grid, then triggering the RESET feature "SHOULD" return it to the initial state.  If one or more rows are selected by default, then the grid should return to THAT state instead.  It makes absolutely NO sense whatsoever that you don't have this feature built into the grid in the first place!   AND...that feature should be very intuitive to find and use. You have it on other widgets...why not the grid? The only way to clear a selected row is to refresh the browser.  And that is unsatisfactory.  Forcing someone to set up and/or use a filter service just so they can clear a selected row is also just plain silly, especially w

Hello, My company need a partner for consultant about KEPServerEX.If you can, pls give your information. I will contact to you. Thanks   

The UserManagementSubsystem has Session Management Settings where we can set the "Idle Session Timeout (min)". My use case requires redirecting the user to the login mashup screen when the idle session timeout expires. As far as I can tell, I don't see the redirect URL to configure the same in ThingWorx. Could you please share the code snippet for this scenario?In ThingWorx, even though the mashups are active, the session expires when the session timeout is reached. Does ThingWorx behave this way by default? I want to implement the timeout in such a way that only the session expires if the system is idle for the set period of time.Thanks  

Data, Properties, Explore, Widget, Layout Panel is not visible in Thingworx. Can anyone please help me out here. I already tried restarting the tomcat.Thingworx version is :  9.3  

Hi! I'm trying to get all the entries from one Stream Thing and transfer them to another. My code looks like this:  new_entries = Things["TemporalStream"].GetStreamEntriesWithData(); var params = { values:new_entries }; Things["MainStream"].AddStreamEntries(params);  I'm getting the error message :: Wrapped java.lang.NullPointerException - See Script Error Log for more details.Could someone please tell me what I'm doing wrong?   

For the american eastern time zone, the UTC Offset is -5:00 during standard time and is -4:00 during daylight saving time.  For this year, Daylight Saving time started at 2:00am on 3/12/2023 and ends at 2:00am on 11/5/2023.  So, I expect that this service should return -4:00 for this time period and -5:00 for all times before and after those dates. However it actually returns -4:00 between 3/11/23 9:00pm and  11/4/23 9:59pm. So, it's like the service thinks that DST starts at 2am UTC, instead of local time.  So, to figure the offset it converts the given time to UTC and if it is between 3/12 2am UTC and 11/5 2am UTC it returns -4:00. Here's a screen shot of the service:Am I correct in thinking the service doesn't work properly? Thanks,Steve 

Good day Community, I have an Info table that stores the sales of fruit a day. See (MyTable.png)<MyTable> I want to add the number of fruits I sold each day then reorganize my table to that the day that has the highest sales can appear at the top of my list, and the day I on which I had the least sales should appear at the bottom of the info table. See the image below:  I've written up a piece of code, however I have hit a wall because the sum of the sales per day is not correct. How can I fix this:let Total_Sales_Per_Day = 0;for(let c=0; c<Fruit_Names.length; c++){//the column names from the inputFruit_Input = Fruit_Names[c].Fruit_Names;Value = MyTable[Fruit_Input];Value = parseFloat(Value);let Total_Sales_Per_Day = Total_Sales_Per_Day + Value;}let result = Total_Sales_Per_Day Regards,   

I’m using the Demo version of KEPServerEX 6.14 and I would like to import a CSV into the datalogger using the API.I followed the instructions in this github https://github.com/PTCInc/Kepware-Example-Scripts/tree/master/Datalogger/CSV%20to%20DataLogger%20API but I got a HTTP 401 error: Settings: Any ideas?Thanks

I'm currently using the following lines to create an infotable from json:     var json = { rows: jsonData.run_history, //an array of objects dataShape: DataShapes["SomeDataShape"].GetDataShapeMetadataAsJSON() }; /////////////////// //Loads json data to an infotable var data = Resources["InfoTableFunctions"].FromJSON({ json: json });     I'd like to add more data from jsons to the infotable, but the FromJSON service replaces the previous data.  Is there a service that adds JSON data to the infotable?  Kind of like .AddRow?  I'd like to avoid using a for loop to add each row one-by-one as there are many rows.  Also, is there a limit to the size (MBs) of the infotable?

Is it possible to connect ThingWorx with PLC without using kepware? If yes, what is the best way to do this?   Translated by the Community Moderation using Google Translate     É possivel conectar o ThingWorx com o PLC sem usar o kepware ? Se sim Qual a melhor forma de fazer isso ?  

We have established a connection with opcua via Kepserver and we created a industrial thing and from that we created a remote thing. After creating remote thing if we press refresh the data use to be updated.I connected the thing to Label widget in vuforia studio there also the real time data was available.   But after doing all this if I click the save button of remote thing once more it will stop the data pushing into studio and also data refreshing. I got the error in kepserver as shown in image. (error pushing property updates to thing). even i tried by writing services still the thing is not refreshing. If we create new remote thing it will work fine until I press a save button on second time. Is there any solution to overcome this problem. Help will be appreciated.

Is it possible to programmatically create a Scheduler in thingworx 8.5.3?  I saw the following article, but I don't see this template in 8.5.3. https://www.ptc.com/en/support/article/cs382629 I'd like to create a mashup where users can schedule email reminders for preventive maintenance.  The emails will be sent out to the users on the scheduled date/time.  In order to implement this, I think I need to be able to create a scheduler programmatically, where the subscription on the scheduler would be created automatically as well.

Hello everybody. We have a server with KepServerEX  (6.12.361.0) and Ignition (7.9.21)  installed as client of Kepware. In the OPC UA Configuration, the server endpoint is setted as default : opc.tcp://127.0.0.1:49320.Everything was working fine until last week. but now Ignition is in error becuase can not connect to the OPC server (kepware) . I noticed that even if the KepServerEx service is running, I can not see the port 49320 in Listening state ( I used the command C:\ ....\netstat -aon). I installed a Kepware on my laptop and when the service is running I can find this row (with the same command ...\netstat -aon):TCP      127.0.0.1:49320       0.0.0.0:0      LISTENING       15340 I tried to change the port number in the server but nothing changes.Other informations:The device connected to Kepware (channels) communicate perfectly.The server is not connected t

Hello everybody. As I posted in another thread, I have a problem with OPC UA Server endpoint. Port 49320. Until now I did not removed completely Kepware but only made Repair and Maintenance. If I remove KepserverEX and then, after a reboot, I  reinstall KepServerEX on the same machine, are the licenses still working? Which is the right way to do this operation. Is there an article about it?Thank you for your help.Guido De Biase 

I followed the instructions in the link below to add pagination to grid advanced.  It works. https://www.ptc.com/en/support/article/CS311123   I typically add the following code to add query to grid advanced.     if (query) { result = Resources["InfoTableFunctions"].Query({ t: result /* INFOTABLE */ , query: query /* QUERY */ }); }       For the paginated grid advanced, I tried the code below to match the output infotable, but it's not working.  Is there a way to add query to a paginated grid advanced?     if (query) { result = Resources["InfoTableFunctions"].Query({ t: result.Data /* INFOTABLE */ , query: query /* QUERY */ }); }        

Hello,  I'm using kepware datalogger. I have set it up to log to an existing table called "Interval". It has been working fine for a while. I stopped the data logger and added a few more tags to log. When I restarted the logger I get this error: Unable to query recordset on Log Group 'Test_IntervalReading'. Reason: Cannot find object ID 2063930610 in database ID 33.  This has happened once before, and by dropping and recreating the table it goes away. Obviously I cannot do that in future once I go live with my application. Does anyone have any idea what this error means and how to resolve it ? It seems to indicate to me that kepware cannot see the database or table ( I assume that's what those IDs refer to). However I can confirm that user has the right access to those tables. Not only has it been working already, but I've double checked by logging in as that user directly to the db etc.   

I was trying to create a Gauge in the mashup for which I cannot bind the input values, No error is showing in the log! Can anyone help me on this! 

Dear community,another very basic question from me;if I want to "execute" a tag which basically just sends a hard coded string to an device; how do I do that from the client perspective?I have configured an tag in UCON which sends a string. Furthermore I do not want to periodically send the string; only when the client application wants it.I know I could get data from the client for this tag (for example a '01' ASCII string)  and could use IF-branching in UCON to execute the transmit command if the tag contains the data '01'. But I think I have overlooked something; I feel like there should be a "right"/"easier" way to do that from the client application. I have looked into the documentation but haven't found an satisfying answer yet; please help me.Kind regards   

Hello, I am currently using KepwareEx in conjunction with the DataLogger plugin for recording data from PLCs and CheckWeighers. The process works seamlessly when I log the data to dbo.FrequentReading. However, I'm experiencing issues when trying to log data to Kepware.FrequentReading (Kepware schema instead of dbo schema). Despite setting the default database and schema to Kepware for the user connection, the problem persists. Interestingly, Kepware does recognize the table and allows me to select it, but fails when attempting to write to it. Furthermore, when I try to set the table definition to Kepware.FrequentReading, I receive an error message stating that the table doesn't exist. We make heavy use of schemas within our databases, so it would suck to have to use dbo for the datalogger tables.  I'd appreciate any advice or solutions to this problem.  

How to make mashup data update in ThingWorx with no external equipment just the platform?   Translated by the Community Moderation using Google Translate ----------------------------------------------------------------------------------------------- Como fazer os dados de mashup se atualizarem no ThingWorx sem equipamento externo somente a plataforma   

Hi,I'm very new to RTPPM installing & configuring the Core Setup. Im trying to install RTPPM in my development server for exploration. I have successfully installed the RTPPM with guidelines available in manufacturing apps site but in Core Configuration Im facing issue while executing the SQL query. Kindly find the attached image. Also I'm not sure about the demo data which i have prepared in excel sheet. Do we have any detailed steps available for the core setup preparation/ any demo data filled sheets for refernces based on the tabs? Using,TWX Version : 9.3.7-b1432RTPPM Version: 2.0.2 Thanks & Regards,Arun C

Hello, I am working on an IoT program that needs Water level sensors, which are supported by or compatible with KepServer. Are there any Water level sensors that have been tested with KepServer? If yes, can I know the names of those Water level sensors? Thanks in advance 

I would like to understand limitation about Local Account on Thingworx Application 9.3.2*Thingworx SCO Enterprise Package License , How about user account per license?- Admin Limited??- User Limited?- User Group Limited?        

Hi,   How to add UserSessionShapes in User Management Subsystem programmatically.   I'm using the below code to update it  // table: INFOTABLE dataShape: "" let data = Subsystems["UserManagementSubsystem"].GetConfigurationTable({ tableName: "UserSessionShapes" /* STRING */ }); // Provide your filter using the format as described in the help topic "Query Parameter for Query Services" let query = { "filters": { "type": "And", "filters": [{ "fieldName": "name", "type": "EQ", "value": "MYSHAPE" }] } }; let params = { t: data /* INFOTABLE */ , query: query /* QUERY */ }; // result: INFOTABLE let sessionData = Resources["InfoTableFunctions"].Query(params); if (sessionData.length === 0) { data.AddRow({ "name": "MYSHAPE" }); Subsystems["UserManagementSubsystem"].SetConfigurationTableRows({ values: data /* INFOTABLE */, persistent: true /* BOOLEAN {"defaultValue":true} */, tableName: "UserSessionShapes" /* STRING */ }); } var result = data;   When I e

To make a simple IoT we need 3 things1 Device- Which we will be connecting with the cloud.2 Gateway- To provide a safe path to transfer data and services to cloud using protocols.3 Cloud-These will be used to store data and display it using a dashboard. I want to know whether these sequences are correct or notDevice = PLCsGateway = KEPServerEXCloud = ThingWorx