IoT & Connectivity

Hi,I have two date values in String format like "2024-07-25 19:41:27.0000000 +00:00"I want to calculate the time difference in between so I want to change them to date format. so used the code below but it gives me the invalid format error. Parsing neglects the year: let StartDate = "2024-07-25 19:41:27.0000000 +00:00"let sdf = "yyyyMMddHHmmsszzz";result = parseDate(StartDate,sdf); Invalid format: "2024-07-25 19:41:27.0000000 +00:00" is malformed at "-07-25 19:41:27.0000000 +00:00" I even tried the slice the string, but I got the same error: let StartDate = "2024-07-25 19:41:27.0000000 +00:00"let ShortStartDate = StartDate.slice(0,19)let sdf = "yyyyMMddHHmmsszzz";result = parseDate(ShortStartDate,sdf); Invalid format: "2024-07-25 19:41:27" is malformed at "-07-25 19:41:27"

Hi, I have a service output of base type infotable. The datashape attached only has 1 column called timestamp. I add all my other columns dynamically in my service. In the result, the timestamp column appears last. Instead I want this column to be the first in the grid. How do I force this column to appear first? Many Thanks.

Hello All, I am working on DPM and have uploaded the default excel file which we get from github name is DPM sample 1.2.14. In Performance Anaysis page >> waterfall model >> timeloss trend i not loading PFA 

We are fetching almost 2k-3k rows data from datatable to populate in grid. It takes around 1 minute to populate data in tree grid. We also using data filter to filter data from datatable, it takes another 1 minute to filter data from datatable and to populate in grid. How to reduce the time when multiple users fetching data at same time in production environment.

Hi all, I have a case where I want to query a lot of different property histories, do some calculations from the history, and create a report from it. For my specific case, it simplifies the process of creating a clean report if I just loop through the list of properties and query each one individually (typically like 30 or less properties total so nothing crazy). I am curious about whether doing this and calling several queries will cause any performance issues or database access problems. I tried doing it all in one query, but it is much simpler to get the data specific to each property and then perform my calculations in individual queries. The speed of my service is fine, so really just wondering if there are possible issues I haven't considered with this approach or if this is okay practice. Thanks!

Hi all,My mashup is completed and working, that is until I tried adding a new function.Currently I have a service that provide data to the bar chart and have my seriesclicked and selecteddata binded to another barchart which works, it takes in the x and dataField of the first barchart. The problem occurs when I try reading the x and dataField of the chart in the same service that provide the data to the chart.Now my Mashup have loading error only on the chart, and only when I try to read the x or dataField of the input infotable. Any advice is greatly appreciated!

Hi Community,   I'm trying to run integration runtime with logback.xml. When I run below command in CMD     java -DconfigFile="integrationRuntime-settings.json" -Dlogs.includedLogback="logback.xml" -jar .\integration-runtime-8.0.14-b100.jar     Throws an error   logback.xml file content   <?xml version="1.0"?> <included> <property name="logs.dir" value="C:\\ThingworxStorage\\IRlogs" /> <property name="logs.uniqueId" value="${processId}" /> <property name="logs.maxFileSize" value="1MB" /> <property name="logs.maxIndex" value="5" /> <logger name="com.twx.integration" level="DEBUG" /> <logger name="org.apache.camel" level="DEBUG" /> <logger name="org.apache.http" level="DEBUG" /> </included>     Also, I'm looking for a way to set IR log level to DEBUG mode   Could anyone please help me on this    /VR

Our Research & Innovation team at PTC is conducting a study on productivity and quality analysis using insights from work instruction execution in the manufacturing industry. We have a new solution design to help our customers optimize their work instructions and are seeking experienced professionals like you for a 30-minute interview to provide feedback on our new solution design. We're looking for production supervisors, continuous improvement team members, or manufacturing engineers experienced with work instructions or operations optimization. Your insights will help us refine our design to better meet industry needs. If interested, click the link below to provide your contact information and availability: >> Click here to register << Feel free to share this invitation with colleagues who may be interested. We appreciate your contribution to our research and look forward to hearing from you! Best regards,Tadeusz WitczakResearch & Innovat

Hello, I am using ThingWorx 9.3.9.I was wondering if there was a method to get data from a infotable, and separate each of the columns in an property. In my case, I have three columns, id, temperature, and force, and I want to separate these into three different properties in a Thing. I have written a service in a Thing that has 4 properties, 3 of which are numbers and the last one being an infotable. This is my service code that I tried to use to pull one row of information from the infotable:   let infoTable = me.MyCSVProperty; let searchCriteria = { "id" : 2 }; let foundRow = infoTable.Find(searchCriteria); if (foundRow!== null) { let id = foundRow.getValue(0); if (id!== null && id!== undefined) { me.id = id; } else { me.id = -1; // Set to -1 to indicate an error } } else { me.id = 4; }   and when i run this program i get an error: Any help would be greatly appreciated!Additionally, I am new to coding and thingworx so detailed explanation

Network adapter is not shown. So getting BAD in client file.    Following action also done but still not showing it. Start the server_config.exe as Administrator Go to KEPServerEX 6\server_config.exe > right click Properties > Compatibility > Change Settings for all users > Run this program as administrator > Enable.     Please suggest what to do for Quality as good in client file 

Has anyone tried connecting to the A/B Powermonitor 5000?  The Rockwell manual says we can configure RSLinx as a SLC5/03 as it supports PCCC addressing.  I tried SLC5/05 in KepwareEX and this didn't work.  Neither did the PLC-5 family,  Thanks        

Hi,Does KEPServerEX support integrity with any hardware security module? 

Hey Community, here i want data from three different datatables and i want to have all the entries in one infotable. How can i achieve it? i think i need to have here infotable and collect all the data there... let data; linesArray.forEach(line => { logger.info("QControl."+line.lineName+"-"+line.lineLocation+".DT"); let thingName = "QControl."+line.lineName+"-"+line.lineLocation+".DT"; let maxItems = Things[thingName].GetDataTableEntryCount(); data = Things[thingName].GetDataTableEntries({ maxItems: maxItems /* NUMBER */ }); });  

For one of the customers, we are working on application development where Snowflake DB data (Power bi View tables) need to be inserted in postgres through ThingWorx schedular but while doing so ThingWorx Apache Tomcat went down.  We are handling here around 22 lac rows to insert it in database. While doing so we are experiencing this. Please help us to improve this. Is there other way to insert this many rows from snowflake DB to postgres without affecting ThingWorx performance?

Hello,  I am reading Channel.Device.System*_Error tag via OPC DA Client of the SCADA. I am able to read tags of the device but can't read the _Error tag and quality is bad, whenever I restart the kepserver computer.After started the quick client I can see the tag quality is good.Why this is happen? Thank you in advance.

How to start userextension properties in alphabetical order

So I'm tasked with resurrecting neglected OPC connections and I'm encountering a situation where i have to use a custom interface design XML file with KepServerEX 5.12.140.0 to specify tags from Sartorius AMBR systems. I'm also encountering an issue where the OPC UA Configuration Manager that came with KepServerEX 5.12.140.0 seems to be creating a bad URI that can't be parsed by newer software because it puts whitespace in the URI string?'C:\Program Files (x86)\Kepware\KEPServerEX 5\plugins\connection_sharing.dll'. Reason: 'Connection sharing plug-in failed to load due to lack of driver support.'am also encountering the following error "Unable to load plug-in DLL  Wondering if an upgrade to 6.5 will solve my problems or if i need a more expansive license key or if i should be looking at Kepware Server instead: if there's a driver OOB for KepServerEX if i just get a different license type that will allow me to use drivers and not just a CID XML file. Or if I upgrade

Good day, everyone I am trying to print my webpage/mashup, (an image just for now).Following this article guide: https://www.ptc.com/en/support/article/CS319138I wrote the below in a service and I invoke this service on a button click with the hopes of getting the print page to open up (Like how it would when you press Ctrl+P).This isn't working. Is there something I am missing? The code: let table = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "dataShape_DS"});let html = "window.open('http://xx.xx.co/:port/Thingworx/MediaEntities/Icon'); html.print()";table.AddRow({htmlColumn:html});result = table.htmlColumn;

I have configured DPM equipment. using  https://www.ptc.com/en/support/article/CS371476   this linkBut I cannot select the WorkCentre showing some error. Kindly check attached  image.I have also checked https://support.ptc.com/help/digital_performance_management/r9.5/en/index.html#page/dpm/digital_performance_management/production_dashboard/production_blocks.html# Please guide

Hello,   What is the difference between thingworx and thingworx naviagte. I am working on thingworx but thingworxnavigate is also a platform or how does it works. Would anyone clear my confusion please

In thingworx navigate UI, how to upload the files directly from windchill rather than uploading from local drive.

Why the Display Name stated in State definition file is not shown accordingly for value with boolean base type? please refer the screen shotversion: ThingWorx 9.3.7-b1432  

Hi Community,   We have trying to enable SSO on Thingworx using ADFS as IDP. We followed steps suggested in this link - Configuring Authentication with AD FS (ptc.com)   When we enable SSO on Thingworx, we are getting below error      2024-06-29 04:54:29.694+0000 [L: INFO] [O: o.s.s.s.l.SAMLDefaultLogger] [I: ] [U: ???] [S: ] [P: ] [T: https-openssl-nio-443-exec-8] AuthNResponse;FAILURE;<<IP>>;<<RELYING_PARTY>>;https://<<ADFS HOST >>/adfs/services/trust;;;org.opensaml.common.SAMLException: Response has invalid status code urn:oasis:names:tc:SAML:2.0:status:Responder, status message is null__ at org.springframework.security.saml.websso.WebSSOProfileConsumerImpl.processAuthenticationResponse     Could someone help me to solve this issue   /VR

When creating a button with only an icon/ image displayed on it I find that the icon can only be enlarged to so far before it exceeds some allowable area.With a blank label the icon, sized here to 100x100 pixels, becomes cropped. With a label the icon is properly sized.Is there a way to get image only buttons to have their icons properly sized without this cropping?

var data = me.Data; //InfoTable var result;result = "<!DOCTYPE html><html><head></head><body>" +"<table style='width: 100%; border-collapse: collapse;'>" +"<thead>" +"<tr>" +"<th style='border: 1px solid black; color: white; padding: 8px; text-align: center; background-color: #005495;'>Column 1</th>" +"<th style='border: 1px solid black; color: white; padding: 8px; text-align: center; background-color: #005495;'>Column 2</th>" +"<th style='border: 1px solid black; color: white; padding: 8px; text-align: center; background-color: #005495;'>Column 3</th>" +"</tr>" +"</thead>" +"<tbody>";// Iterate over the rows of the InfoTablefor (var i = 0; i < data.rows.length; i++) {var row = data.rows[i];result += "<tr>";// Iterate over each column in the rowfor (var key in row) {var value = row[key];result += "<td style='border: 1px solid black; padding: 8px; text-align: center;'&g