IoT & Connectivity

Dear community,   I would like to use aggregation on string values, comparable to other languages, e. g. SQL. Easy example of an Infotable:   myKey stringValue 1 "mx" 2 "my" 2 "mz"   Any chance I can use the Aggregate function (or anything else) to get   myKey stringValue 1 "mx" 2 "my"   with "my" as the first or minimum value?   Thank you Benny

Hello all,    I am aware on how to configure SSL/HTTPS with a self-signed certificate for TWX. However, I don't find any relevant information on how to configure SSL/HTTPS with a CA certificate.    Are there any steps available that I am missing?    Thanks!

Background: I have a few assets defined and some connected tags via KepServer. These tags have good quality and I can see their values updating in the Composer. I'll also note I have the status's of these assets configured, and I can watch the status change according to their definitions (I have seen the status change from Running to Unplanned Downtime correctly). The properties corresponding to the KepServer tags in the Asset_ Things are flagged as Logged (the ones of type Integer and Boolean anyways). Our ThingWorx version is 8.4.3.   The Problem: The asset performance is not being updated. The availability remains stuck at 0% and the status chart shows Not Configured 100% of the time: I get this error in the Mashup:  ERROR - universalServiceTrigger, exception: triggerName: "UI_timelinechart-10_render", _evt: {"EventHandlerArea":"UI","EventHandlerId":"timelinechart-10","EventHandlerService":"render","EventTriggerArea":"Data","EventTriggerEvent":"ServiceInvokeCompleted","Ev

I am using TWX 8.5, I need to change fonts for few of the labels in my mashup.    I tried using custom css  .label {   font-family:"Segoe UI" !important ; } like this, but code is not working previously I used this method in 8.4 It worked fine, I don't know why I am not able to change Segoe or Roboto fonts.

Hello,   In the following video we can see a new UI for what seems Thingworx Manufacturing Apps. https://iot.gallery.video/detail/videos/thingworx-for-manufacturing/video/6227441370001/factory-insight-as-a-service-:-asset-monitoring-and-utilization?autoStart=true Is this UI available for Manufactuing Apps? How can we get it?   Thanks

Can we display XML of type XSL in thingworx mashup ? I have kept the XML file in Thingworx File repository but I am not able to load XML. getting below error when trying to use the LoadXML method in a service. Wrapped by: com.thingworx.dsl.exceptions.DSLRequestProcessingException: Execution error in service script [getXml] :: Content is not allowed in prolog. at com.thingworx.dsl.engine.DSLProcessor.executeService(DSLProcessor.java:328) Any suggestions ? Please find attached XML for your reference.

Hi , I am exporting the infotable data in CSV but before exporting i am trying to remove couple of fields and specific row but the below code not working as expected. can someone help to get this?       Thanks

Hello,   We are using the Manufacturing apps 9.1 with a MS Sql server. Since the manufacturing apps are receiving and logging a lot of data it will probably be necessary at a certain point of time to archive some of the data in order to keep the system performant. Is there any guidance about this? Which table have to be considered? kpielementvalue, kpivalue, value_stream?

Hi,    We have an instance of thingworx 9.0 with postgres as its persistence provider on windows 2019 server in the cloud. I am trying to import manufacturing app. There are 3 parts to the bundle dependencies, extension and upgrade utils. I am successfully able to import dependencies and upgrade utils extension files, however when i try to import the extension I get the below error  sco-AlertMonitor-customization-9.0.0-01-extension:9.0.0 sco-AlertMonitor-customization-9.0.0-01-extension is licensed but cannot find feature in license_capability_response.bin file A quick not my instance isn't licensed yet, but I will license it in coming 2-3 days. Can you please let me know what needs to be done to proceed.   Kind Regards SO

I am  using Breadcrumbs widget in a responsive layout, In runtime, if I use 2 links the last link in the breadcrumbs not shown fully. If use more than 2 or 3 links it showing correctly. find the image for reference. Please any one give a solution ASAP.   Thanks.

  I am having multiple catagories with different data for each data i want to show multiple colors in one bar. Can someone help me out. Is there any extension available? Please find attached screenshot

Hello,   1. I have one question about line chart. I have used get property values for data stream, when i use query property history the red triangle is shown in line chart.   2. I vant to have countinous data stream on display in line chart but instead the xaxis is moving around, what can i do?

When I tried to set String property values with Chinese letters by using C SDK, I could see only broken characters in Thingworx. The cause of the problem is simple and it's encoding. In order to solve this problem, you need to convert encoding to UTF-8 in your C code. I used 'libiconv' library to do it. This guide is for Win32 version. If you want to make a library for other platforms such as Linux, you can create or get a library for your own by googling.How to Get the Source Code of libiconvAt the moment, the most recent version of libiconv is 1.15. You can download the source code of libiconv from here.How to BuildI used MS Visual Studio 2012, but the explanation can be applied to the earlier versions of MS Visual Studio and express editions.Step 1. Download the most recent version of libiconv and unzip the file.Step 2. Make a new Win32 Project.Let's say "libiconv" as the project name. Check to create directory for solution.Choose DLL as the application type and check Empty Project

can I connect postgresql as a external db connection to Thingworx 90 days trial version?

Team,   I have a customer that we will have a small application with 100 assets, 3 properties each and they will be logging time series data into Postgres at every 5 seconds,   We plan to use PostGres for time series historization but we have the following questions: Is there any performance testings for persisting timeseries into PostGres vs SQL Server vs InfluxDB? What is the performance tests PTC has done for PostGres? What are the best practices limits we can consider for historizing time series data into PostGres and what aspects/limitations we should analyze to move to other historization solutions?   TKs, Chris

'Alert delivery' option is not enabled in Asset advisor. Do I need to import anything like mail extension? I am using PTC cloud 30 days trial Asset advisor..      

Hello everybody,   i combined several widgets to one gadget which i am using within a mashup. When using mashups there is a plus sign in the upper left corner which indicates to create a dashboard. I want to remove it/ making it unvisible. I did that once before but cannot remember how i did it. The property within the gadget are the same for the gadget where it is working and the gadget where it is not. In the image below you can hopefully see what i mean.

Hello everyone,   i am trying to write a custom service "Calculate_all" see second image, which calculates the mean maximum and min and in future other different statistical values. As input my service expects a datetime and a string (property name for the QueryNumberPropertyHistory service inside my service). As an output it gives an infotable with the 3 values. The service is a service of a thing which has sensor data as properties.   When i try to give a value widget a data source i can link one of the outputs of my service for one sensor (given through the property name which is defined in the data properties section or by a readable lable widget) to the data of the value widget. But after that if i want to give data to another value widget from my service but from different sensor (property name input changes) i have to add my service again to the data area in the mashup builder (see picture 3) because thingworx says that my service already has a binding to his input par

Hi , I wanted to have column in Datatable as primary key which will  increment by 1 automatically whenever add the row. how to make it auto increment.   Thanks

What is the data shape for the selected Items and for standard widgets like this that accept infotables where is the best place to find documentation on what data shapes to use with them when generating data?

Hi,   The structure of my custom widget is shown below, Now a widget referencing a third-party widget is possible, but if I need to develop 10 widgets, I need to put 10 of the same third-party JS, so the size will become larger and may affect performance.   if it is possible to put only one third-party JS in the widget package, and the other widgets can refer to the JS?     Thank you! Chason

Hi ,   I'm unable to send SMS using twilio extension, getting java socket exception. The same extension is working in another server which has similar configuration. Both servers running on SSL. Do I have to change any specific configuration?   please find the error attached.       Thanks, Janakiraman P

Hello.   I am using Thingworx 9.1 version with Postgre SQL.  GetText function is not working. Got error as "Invalid Content Type: application/json". The same code it was worked with Thingworx 8.5.1 version.   var propertiesAttr = Resources["ContentLoaderFunctions"].GetText(params);   Could you please suggest?   Thank you in Advance.   Regards, Latha

Hi , How to give column header separator line as in below image.     Thanks 

Hi Team,   Suppose I have an existing network and want to add the new root node at the top of existing root node.   How to achieve this scenario.   Please advise.