IoT & Connectivity

Hello,   I am using Thingworx 8.4 with Postgres database, Analytics extension and Kepserverex. Thingworx and Kepserverex servers are configured to Timezone CET. In the following examples the current time is ~1210(German Standard CET):   (1) I execute the queryPropertyHistory service with a Thing receiving data(current) from Kepserver, with the following results:     The time is exactly 3h off.   (2) Now I execute the following code as a service of the same thing: var dateValue = new Date();var formattedDate = dateFormat(dateValue,'yyyy-MM-dd hh:mm zzz');var result = formattedDate; //resulttype string   Result: The Time is UTC so 1h off.   (3) Now I execute this code as service: result = new Date(); //result datatype: DATETIME   The time is 2h off.     When I try to display the data in a Time Series chart in a mashup using QueryPropertyHistory, the time is 1h off. The first (1) example changes the difference of time sometimes. Also: I

Hello, Till now I've seen that the services and properties have been defined in Rasperry Pi and then bounded to the remote thing in thingworx. My question is that is the opposite is possible i.e to call the service of Thingworx Remote Thing in Raspberry Pi? For example- Firstly Thingworx: MyThing with remoteThing is having a service AddSignal Secondly RPi: How can I call that already exist service (AddSignal) in RPi using LUA script.   Thank You!   Best Regards, Naeem

Hi, hoping someone can help with with an issue I'm struggling with? I'm tying to create a dynamic monthly sales table. something like the one shown below.   Product Feb  March April May June July AX 500 100 80 120 80 100 50 PQ 500 50 60 65 65 80 80 AX250 100 87 60 70 60 75   I am using a dynamic infotable as I allow the user to select the number of months they wish to display, so there could be 1 month or 20 months. I am able to dynamically create the infotable to return from my service by creating an empty infotable and then adding the required fields (months) using the code shown below: var params = { infoTableName: "tmpTable" /* STRING */};var myTable = Resources["InfoTableFunctions"].CreateInfoTable(params); // myTable: INFOTABLE var newField = new Object();newField.name = "Product"newField.baseType = 'STRING';myTable.AddField(newField);   newField.name = "Feb"newField.baseType = 'INTEGER"myTable.AddField(newField);   newField.name = "March"newF

Hi,   We have installed Thingworx 8.5 with Flow ( ThingWorxFoundationFlowPostgres-8.5.0-x64 ), since it is having some bug internally, we are unable to write any workflow service inside the composer. So we are planning to uninstall it, but we are unable to find any uninstaller for it.   Should I remove one by one like erlang,RabbitMQ..etc., Or do we have any common uninstaller to do it?   Regards, Janakiraman P

Hi guys,   I'm facing trouble using Value Stream in association with Thing. Following the guide https://developer.thingworx.com/en/resources/guides/data-storage-methods/dsm-value-streams I'm only able to feed the Value Stream by updating the property through the Composer. Instead, trying to update the same property with a PUT (as described in API reference) I get a 200 OK HTTP response (infactThing's property is correctly updated) however its corresponding Value Stream's property is not logged. Please, is there someone who can explain me why?   Thank in advance for any suggestion Alvaro

Hi,   I have created the MENU which has 5 mashups in it.  In this one of the mashup is like HTML form as shown in snapshot below.     On the press of "Next" button , it should load the "Review Details" mashup as below. I am not able to load another mashup on "Next" button clicked event. Please let me know if anyone know how to load mashup on button clicked event. Also how to get the data entered in the Form.

Hello,Q1.According to previous guides I have downloaded Metadata.xml file from ptc marketplace and after importing in thingworx platform it has created a mashup with the name jdbccreater to upload the file and it is not accepting any kind of file. (Didn't modify metà.XML file).Q2. I have created a thing testDatabase with base template as Database. After writing in configurations and saving it, only the lasconnected property has been modified, while isConnected is false.I am using postgresql which is also my persistence provider and SqlServer 2014. But having the same results isConnected:falseThank you!Naeem

where can i use that code? how can I use that code? please provide a detailed info or any webpages that I can visit to know about that?

Hi, We have installed Thingworx 8.5 with Tomcat 8.5. It was working properly. But, after sometime it is showing "This is a proxy server. Does not respond to non-proxy requests." message while trying to open tomcat. What will be the issue? How to resolve?   Thanks & Regards, Sathishkumar C.

Hello everyone,   I am developing a native-react app that should open some Mashups in a Webview. Since Webviews in such frameworks do not allow Popups (for the login necessary), I am looking for a way to open the Mashup in the Webview with Authorization.    The login Credentials are requested from the user beforehand. I already tried to simply open the link of the mashup in the webview and pass the credentials "userid" and "password" in the http header, but I still get the error "401 - not authorized".   Has anyone made experiences with opening mashups in webviews and a working authorization process?   Any hints would be appreciated very much!   Best Regards, Dominik

Hi, As part of the development we are creating some entities on thingworx platform and releasing them to the internal test team.  As the development is in progress and we continuously modify and add new entities we would like to maintain entity versions for each release on the thingworx platfrom. So the question is how to band entities to a specific version? How to define versions on thingworx entities so that we can differentiate them based on release?

Hi ,   I have a data table with the data shape below,  just found a very strange behavior, for the service:  -------------------------------------------------------------- var values = me.CreateValuesWithData({values: { WorkOrderId: "NA", DeviceId: "OP10-OvenREHM00001" } /* JSON */}); result = me.FindDataTableEntries({values: values /* INFOTABLE */}); ------------------------------------------------------- The result always return empty as long as the field Estimated is true , otherwise it work well.   Is it a known issue ?    Thingworx version: 8.4.4 Database: Posgresql 10.x   -----------Table Structure-----------------   Seq INTEGER KEY     DeviceId STRING KEY     DataProducedTime DATETIME KEY     WorkOrderId STRING KEY     StartTime DATETIME       Estimated BOOLEAN  

Newb and first time poster.   I am creating a service that calls a stored procedure in SQL Server*. It uses the JDBC connector. The results I see when testing the service don't match what is returned when executed on the SQL Server. Some numbers are completely missing, presumably because of their format? If I change the query to return random integers in the Eff column, then I can get results back. It doesn't seem to matter if I bind my output to a data shape or just to text.   Thanks in advance for any tips.   * it doesn't matter if I am calling a stored proc or running the code in the service. Same result.  

 Image Source: https://www.thefire.org/resources/spotlight/     Designed a super cool mashup? Have an innovative IoT app? Are you really proud of how you solved an IoT challenge? Are you using ThingWorx for a unique use case?   If so, we want to hear from you! I’m looking for a few ThingWorx developers that are interested in sharing their work to be showcased on the Ask Kaya blog! (Don’t worry—we can hide your confidential info and only share what you allow us to.) We’d love to highlight what our developers are doing with ThingWorx out in the real world. If you’re interested, comment below or message me directly!   As always, stay connected.  

Hello everyone!   We are creating a system based on the MQTT protocol, which will be our main source of incoming data. We are planning to connect various systems and devices through it and use it in independent projects on multiple environments. (i.e. DEV/QA/PROD).   The question is if we should stay with MQTT Extension. It looks like it has no user context at all, which is forcing us to use System user everywhere, where Entities are subscribed to changing data from MQTT. It is quite painful and I see quite a lot of room for security leaks.   After some research we found PAT with already implemented MQTT channel.   Questions from my side: 1. Is MQTT channel ready for production use? 2. Is sample MQTT codec sufficient and supported? 3. What is an effort to switch from Extension to codec beside new software mantainance? 4. How it is working comparing to the Extension in terms of a lot of topics (lets say tousands)? 5. Which one is better for the real production use? &

Hi, In pie chart, I am binding single data source. Is it possible to traverse to different mashups based on selected segment of pie chart?   Thanks, Shalini V.

In the Advanced Grid or Grid configuration, you can specify the number format as "0.00". This results in 3.1415 being displayed as "3.14", but also 11 as "11.00", and 12.3 as "12.30" Is there a possible format string to remove unnecessary zero's, so 3.1415 is displayed as "3.14", but 11 is displayed as "11" and 12.3 is displayed as "12.3"?  

Developing Great IoT Solutions Brought to you once again by your EDC team, find attached here a brand-new, comprehensive overview of ThingWorx best practices! This guide was crafted by combining all available feedback, from support cases to PTC Community threads, and tapping all internal resources. Let this guide serve to bridge the knowledge gaps ThingWorx developers most commonly see.    The Developing Great IoT Solutions (DGIS) Guide is a great way to inform both business and technically minded folks about the capabilities of the ThingWorx Platform. Learn how to design good solutions from a high-level, an overview designed specifically with the business audience in mind. Or, learn how to implement good IoT designs through a series of technical examples. Start from very little knowledge of the Platform and end up understanding data structures and aggregation, how to use the collection widget, and how to build a fully functional rules engine for sending and acknowledging al

I'm having this bug in TW 8.5.0 where the reworked widgets are not always showing up. When I press 'view mashup' 10 times, I'd see the new widgets 1 time. I have set up 3 environments with TW 8.5.0, and I have had this with 2 out of 3 environments: - One in the cloud (don't know what database) - One with PostgreSQL - One with MSSQL (with no issues)    Will this issue be resolved in 8.5.1? And when will 8.5.1 be released?    Jasper

Hello Friends,   I have install ThingworxH2trial 8.4 version . I have made mashup that is taking realtime value in gauge widget  and I have used things ,MQTT extension,subscription and changevalue event . Values are stored in valuestream successfully    But suddenly,When we open thngworx ,Following error is apeared. After that when we make again new things Base thing template is listed empty though MQTT extension is listed in extensions list.   Application log [message: Entity Not Found : [Teksun_mqttThing]]   Error in writing to Data Table for Feature : twx_composer, Product: TWX_PLATFORM Error : Unable to store license usage data in data table due to error:null

I have mashups that use the advance grid extension in 8.4. I just upgrade to 8.5 and the message to replace the legacy widgets, which will soon be deprecated. How does the advance grid will be affected?   

Hi All, I am new to PTC ThingWorx and started to  learn each components. Now I want to configure Operator Advisor with Windchill MPMLink. I don't how to achieve this. Please help me.   Do I need ThingWorx platform/Composer to  configure Operator Advisor? if yes, then please share the ThingWorx platform/Composer  installation steps.   Thanks Saravanan

hi,  I have a problem and search for a solution, I created an organization and  put a user into, I need when I log in with this user, the page showed a mashup, I configured and give permission to the user from the mashup page,  my problem, when I log in using this user, the mashup shown as a white page, and it isn't shown anything,  what the problem??  

Hi, We wanted to send a text from a textbox to a service on text change event. We are providing a data input to the text box and when that data is changed in database it will change in textbox, at that time it should trigger a service. We are connecting the text changed event for this. But, the text changed event is working only if it is edited manually. We do not want to manually edit it as we are going to hide the text box.   Thanks, Shalini V.

Hi guys,   I am working with Manufacturing apps in Thingworx 8.5.  I have created a new availability KPI that I want to display on the Production KPI mashup.   I have done the following: - On all my templated I have overridden the KPInames service to include the new KPI - I updated the GetEquipmentNetworkForKPIs service with the underlying PopulateProductionKPIsTreeGrid service to include the KPI in the InfoArray on the PTC.Factory.PlantStatusUtils thing. - I also updated the PTC.Factory.PlantStatusTreeDataShape and PTC.Factory.EquipmentStatusTreeDataShape to include the new KPI.   On the advanced tree grid widget in the mashup I can see the new KPI but when I select it to include it in the grid columns it is not shown when the mashup is loaded.   Any advice on why this is happening and how to allow me to do this?