IoT & Connectivity

How to modify the existing thingworx Extension and build in JAVA      

Consider I have a series of json data as follows, [{"f":"450.0","a":"746.0"},{"f":"453.0","a":"1119.0"},{"f":"456.0","a":"746.0"}]with f denoting frequency and a represents acceleration.  How to plot a graph for acceleration in x axis and frequency in y axis ? How to write a service for the same ? 

Hello, I have a use case where I want to use the auto complete widget.However when implemented, it seems to not work correctly, or at least not all the time. The following is a search I've made setting the "MinimumLength" property to 1:As you can see, I get some values. But as soon as I add one more character, I get no results: This doesn't always happen as you can see here: So it doesn't seem to be because of the amount of text. If anyone has had similar experiences and have found a fix for it, or that could confirm that this is some issue with the widget, that'd be great. This way I can continue on with my work. Thanks,Jens 

Hello Team,Here i want to know from all knowledgeable members of community, Is Kepware can return 0/False if it is unable to write value on PLC Tag. I am writing some integer value on my PLC Tag using Kepware but sometime it happens, there in no connectivity or Network issue so how I would be able to know, if kepware has written a vale on perticular Tag. RegardsPankaj     

Hi,When trying to format a date into MM-DD, I get the error "Invalid format: "2023-03-07 15:09:57" is too short". What am I doing wrong in my code bellow?let datetime = parseDate(r.eventDesc1, "yyyy-MM-dd HH:mm:ss.SSS");let formattedDate = dateFormat(r.eventDesc1);r.eventDesc1 = formattedDate;    

How to read  the specific excel file which is placed in Sytemrepository using java thingworx extension? Please help me over here. 

Sorry if this is not the right place to ask, but I didn't find any related communities. I am using KepServerEx to monitor some PLC tags. I have defined some alarm tags in Area1 for testing. when I tried to access these tags in some clients like OpcExpert or UaExpert, I can find the Area1 folder but there is no tags inside. These clients have successfully read other tags. In OpcExpert I even can't find the server itself in the alarm tab. The AE connection to the server is enabled and I am not using anonymous logins.    

Hi,I am working on a bar chart and I want the data to display differently than it is shown now. I can find the format property for the yAxis, but nothing for the xAxis, where do I modify how that data is shopwn? You can see a sample of the current chart in the picture attached. For example we only want a portion of the date to show. Kind RegardsOskar Berntorp   

Below line of  code has been written in thingworx java extension in eclipseInputStream in=TestThingShape.class.getResourceAsStream("test.xlsx");   Where does the file test.xlsx is present in Thingworx server? Please help me over here. 

I am wondering how to scan a QR/Barcode in a ThingWorx Mashup. This question was answered here (https://community.ptc.com/t5/ThingWorx-Developers/Integrating-barcode-scanning-functionality-in-mashup/td-p/574883) but that extension is no longer available.  

Hi, I have successfully installed Thingworx AMU Application in my local system for exploration. After installing AMU, I'm trying to do the thingworx app core configuration by the given link Core Functions - Process the JSON File.  In this process, I have filled all required sheets & mandatory columns in the spreadsheet with the demo values as per the instructions. After that successfully generated the JSON file with the help of the README file. But when executing that SQL query in database of thingworxapps with generated JSON string, I'm getting some error message - Error, Parent Equipment Type Hierarchy is not respected.  Can anyone please help me to out for continuing further exploration.  FYR, I'm here sharing the below documents,Demo value filled Spreadsheet.XSLXGenerted JSON Source FileThanks in advance.  

Hello,I am using Media Queries on a Mashup, but when Media Queries are applied, the tooltips/Hover are not showing up on the Runtime, Mainly for Line Chart.Thingworx Version: 9.3.0 Thanks,

I am setting up an Atlas Copco MTF6000 controller using the KEPServerEX Torque Tool Ethernet driver. I am expericing an issue seeing Variable data in the OPC Quick Client. Some addresses, such as COMM_CONTROL_SER_NUM display data and display 'Good' quality. However, another tag with an address of format 1202.30237 does not display data in the OPC Quick Client and shows 'Bad' Quality.  The Torque Tool Ethernet Driver help page uses 1202.30237 as an example of Variable Data addressing, but I am unable to determine why this does not display data. In fact, I have this issue for all MID.PID address formats. Does anyone have any ideas? Am I addessing the tags correctly? 

GUIDE CONCEPTStep 1: DescriptionStep 2: Install EMS Remotely administer Windows Edge IoT Devices without coding. GUIDE CONCEPT Learn how to download, install, and configure the Edge Microserver (EMS) to create an AlwaysOn (TM) connection between Edge IoT Devices and ThingWorx Foundation.   YOU'LL LEARN HOW TO Install the Edge MicroServer (EMS)Configure the EMSConnect the EMS to ThingWorx Foundation NOTE: The estimated time to complete all parts of this guide is 30 minutes.  Step 1: Description The Web Socket Edge MicroServer (WSEMS... or just EMS for short) is a pre-compiled application based on the C SDK.  Typically, the EMS is used on devices "smart" enough to have their own operating system, such as a Raspberry Pi or personal computer. Rather than editing code and compiling into a custom binary (as with the SDKs), the EMS allows you to simply edit some configuration files to point the Edge

Hello everyone, I'm trying to connect TWX to SAP and have been able to correctly validate the connection. What I'm having issue with is accessing the metadata.The address that I got from the customer is correct, I can directly access it through chrome or edge.But when I try to run the GetEndpointList, it returns me the following error: 2023-03-03 11:12:47.497 [ClientProcessor-4] ERROR c.t.i.r.o.MetadataTransformer - Failure processing metadata for root /sap/opu/odata/sap/API_BILL_OF_MATERIAL_SRV/ and serviceRelativePath with exception: Internal error accessing metadata references2023-03-03 11:12:47.498 [ClientProcessor-4] ERROR c.t.i.r.IntegrationEngine - Exchange process failed with exception thrown : Your route exchange has failed. Resource Error [Internal error accessing metadata references]java.lang.RuntimeException: Your route exchange has failed. Resource Error [Internal error accessing metadata references] The address the customer gave is: https://xxxxxxxxxxx

Hello, I am trying to build image of thingworx 9.1 on docker.this is the tuto i am folowing:https://support.ptc.com/help/thingworx/platform/r9/en/index.html?_gl=1*76uyjh*_ga*MTQyMTY0MzUwOS4xNjczMjU5Mjcz*_ga_1QBT6P6HR1*MTY3Nzg2NDM4My40OC4xLjE2Nzc4NjQ0NzEuMC4wLjA.#page/ThingWorx/Help/Installation/ThingWorxDockerGuide/thingworx_docker_getting_started.html# failed to compute cache key: "/staging/Thingworx-Platform-Postgres-9-1-14.zip" not found: not foundBuild Postgres DB: Failed. More detail on attached file. Any idea to resolve this is welcome. Thank you      

Hello, I am trying to find a way to change what is shown in the "Page Mashup" container in the master mashup similar to how you can using the contained mashup widget.Is this possible?  My situation is that from the master mashup, I want to search for a thing, and by doing so, I should change the mashup to where I can find that thing. Any pointers would be highly appreciated! Thanks,Jens

Hi everyone I had a service that dynamically created alerts on a template level. This template has one connected thing.I deleted some of the unwanted alerts on the template level and also on the thing level. However these alerts keep reappearing on the connected thing and they are causing errors in the script log. How can I permanently delete these alerts on the connected thing?I already removed the code that dynamically created these alerts. Best Regards,  

Hi all,I am making a GET API call from a ThingWorx service. I want to parse the JSON data from the API call and search through it for certain values, which will then be pushed into an array. It seems to me that standard JavaScript methods like .filter() and .find() don't work in ThingWorx.Can this be done in the same service or will I need multiple?Any help would be appreciated. 

Hi everyone,   I'm not using kepware. Someone already use my credit for pay this software. I already sent email to online.sales@kepware.com and orders@kepware.com. But no replies.    Anyone can help?  

Hi, I'm using Thingworx MSSQL  9.3.7 in my local system. In that I'm trying to install the Thingworx AMU Application - V2.0.2  for my project exploration purpose. Also following the steps which are provided in the Installation support AMU Installation Link. But when I'm executing the installer with the respective values I'm getting some error message ofInstall Missing Dependencies - Error Code: 25003Failed to import PTC.Base.zipCaused by:Extension PTC.Base failed to installPlease find the attached image for reference. Note : Extension Import Policies are also updated in the Platform-Settings-JSON file.Kindly help me to fix this.  Thanks in Advance.

Is it possible to change the VTQ config and add a new field definition there, for example: for a certain property I want to ingest Value, Timestamp, Quality, and Unit (of measure)?For example we are currently setting only the Lat, Long, Altitude and date time, and I want to add 2 new field to store GPS accuracy and GSM strength in the same value stream.Is it doable? Any lead is greatly appreciated.      

There is a MSSQL database Thing. I would like to add a new property to this thing as "TempValue" and  then map a sql query to this property. How can this be done ? 

Hello, We have always created SQL logins for our users to be able to connect to external databases from our  Thingworx platforms.But it was recently brought up that for some external databases we have, it is more common to use AD as a way to give access  when accessing it through SSMS. So I was wondering if there was any documentation or experience in the community on how we could use AD to connect to these external databases. Any pointers would be very appreciated. Thanks,Jens  

HI Developers, I had to merge two infotables and export them into excel. Code is working fine to merge them and export but it is merging alternate rows of both table.OEEIssueDelayDescPercentageWasteDegreeSample1Sample28.1Issue9.1Heating 1289testtestingHere we have 2 infotables. one has OEE, Delay, Percentage, Degree. Sample1 and Sample2.. Second has Issue, Desc and WasteRequirement is to merge it likeIssueDescWasteOEEDelayPercentageDegreeSample1Sample2IssueHeating128.19.10.1289testtesting Can we order infotables as per our requirement? Please suggest