ThingWorx

Hello,          I want to apply state formatting' before (15 min ) program starting it will show in yellow background  and if program is start then I want to show status is "ON" in green background and if the program is finish it will show program status is "OFF" in red background please suggest how do I used state formatting for value display with these use cases and refer below attachment  Thanks in advance

I am trying to connect to a database but it's not working. I downloaded the mysql connector (sqljdbc42.jar) and I put it in the tomcat/lib folder. The configuration is like this:   com.mysql.jdbc.Driver jdbc:mysql:/ip:3306/thingworx?user=x&password=x   Do you know how to fix this? Thankyou!

We are trying to call a service on the Thingworx platform, not directly, but via the EMS channel.  Our assumption is that once our EMS communication channel has been established, we can make REST calls to the EMS and our REST call will travel to the Thingworx platform to where the execution of the service will take place.  We are making this REST call on the same PC as our EMS is running but are running into "401 Authentication Required" errors.  In our config.json, we have ssl and certificates enabled.   Using Postman, we POST: https://localhost:9000/Thingworx/Things/<Thing name>/Services/WhatsMyName  (note the use of https)   In our header we pass the appKey = <app key>, Content-Type = application/json, Accept = application/json, x-csrd-token and x-thingworx-session = false.   No matter what we seem to try, we just get the "401 Authentication Required" error.  We assume this error is on the EMS side and not the Thingworx p

The trial version installation fails and does not even keep the logs. I copied the log file just before it failed and it does not show any issues. attached the file. I,m using AWS EC2 with the right configuration and windows 2016 server version. Can someone help.

Hi team,   I just started using Thinkworx and I am trying to get all the tags from Kepware Server to a Thingworx Foundation. But Kepware tag value is not updated in Thingworx Foundation. When I refresh "Industrial Thing" in Thingworx, the value is not updated. Kepware Server version: 6.9 Thingworx Foundation Version: 9     I was referred to the following guidelines.   https://developer.thingworx.com/en/resources/learning-paths/connect-and-monitor-plant-equipment/connect-kepware-server-thingworx-guide/bind-industrial-tag   https://community.ptc.com/t5/ThingWorx-Developers/How-do-I-simulate-random-tag-values-against-a-device-in-kepware/td-p/545582   In OPC Quick Client, Tag values are updated.   And one more thing. When I startup the Kepware server, it shows one info as "The specified account does not exist". I have attached the log details image file.    

I I have followed the below steps.... Downloded the ngdbc.jar file. create a extension with this file.(https://www.youtube.com/watch?v=ZlxFok1Y_HU) Import that extension in Thingworx. After importing that extension a Thingtemplate will be created in the thingworx. Put all the details like username password,Connection Url and driver name. create a service for fetching the data.                      but i am getting  Invalid host, missing port number  error in the logs. Thanks in Advance Arnab      

Hi Team,   Please let me know the different types of methods of sending data to ThingWorx and also let me know the case in which we have to use all those methods?   Thanks in advance.

Hi , I am looking to access csv file from SystemRepository , i have stored the file in SystemRepository of Cloud Instance of TWX..when i use getFileListing() it asks parameters like below but not getting how to set path of repo and namemask..also check repo snap.. Thanks,  

Please share the snippet or logic, if any provided by PTC.   Also let me know how to use that snippet with any example.   The thingworx version is 8.3.   Thanks in advance,

In one of the mashups in my company's Thingworx application, we show a percentage as the pie slice's value: The users would like to see '58.8%' for the value, but my team is struggling to find a way to append that. The ValueFormat property appears to only control the numeric formatting. We haven't been able to find the HTML that appears for it so that we might try some Custom CSS magic.   Can this be done with the widget?

I'm still trying to get the DropDown widget to work properly. This time the problem is that the usernames are not being displayed in the menu of the widget. I think I've got the needed connections in place, I may be missing one, though. I'm not sure. If I use the "View Mashup" button, I get an error like this:   Failed to load resource: the server responded with a status of 500 ()   that points to the GetUsersofAdmin service. As I'm  sure you are aware this usually points to a missing permission somewhere, but I can't find it. I've double checked all of the needed permissions that I can think of. The weird thing is that if I use a private window to log into the correct FormLogin to check the errors that come up when I log in with a specific user, I don't get any errors. It seems to be working properly, but the DropDown menu doesn't show any data. I've attached a picture of the connections. Thanks in advance.

Hi,   I have a question, what's the real advantages of ThingWorx Flow comparing to JavaScript Service ?   Here are some of the possible advantages and the corresponding objections :  "Flow provides lots of OOTB connector".  --- But if the implementation of connectors are exposed as services in Resources things,  JavaScript service can also call it without using Flow "Flow allows user to map and route between services without coding".  ---  But it's not big deal to implement mapping and route in JavaScript service,  Thing model design and the logic of data transformation are the main work in a project . "Flow ensure the calling sequence of each node,  while JavaScript cannot .  "  ---  This is what I heard , but I don't believe it .   I have written tens of thousands of lines of JavaScript service code and never see any disorder problem between JavaScript service.  And if this point is true , JavaScript ser

Hi , I am looking for File reading from Grid . i have table like below , when i click on "View" the File should open from File Repository which is on Remote server.    1. how to store file path from repository in Infotable/datatable. 2.How can i do it in Grid Advanced? If you would give the steps to achieve it ..would be better   Thanks

Unable to bind mashup parameters of navigation function. The bindings getting automatically removed after clicking on Done button of navigation function.   It is showing obsolete bindings were removed.   Thanks in advance.

Hi all. I have created MSSQL stored procedure and could successfully call it from ODBC driver with parameters. How can I do the same with Oracle function or procedure?   Thanks.

HI, In Thingworx is there a way by which I can execute a service, through passing the name of the service as parameter from another service? To be more clear, consider the following snippet --   I have two services in a thing 'Thing_Example' as 'srvA' and 'srvB' Defination of 'srvA' -- Inputs: serviceName; Type: String; Value: 'srvB' Service body -- var result = Things["Thing_Example"][serviceName]; //At this point I am expecting that 'srvB' should be executed   Thanks and Regards Aditya Mittal

Hello,          I want to compare database data and mashup data ,for this please suggest How do I write  JavaScript service with case sensitive ?? Thanks in advance

Hi Team,   Have implemented one functionality in which I upload image via File Upload widget in repository and then display it immediately over image widget by creating media entity dynamically via service after clicking "Upload" button of file upload widget.   What actually happens it displays image correctly when I upload first time. It properly creates new media entity and displays over image widget immediately. But when I updates the image at the same time then it updates the image only at the media entity level but not refreshes on mashup.   Can somebody help me on this.   I am using code:-   var params = {name: mediaEntityName /* STRING */,content: imageContent /* IMAGE */}; // no returnResources["EntityServices"].UpdateMediaEntity(params);   My thingworx is 8.3.   Thanks in advance.  

Hello,   I am facing a problem with almost all the transformed properties of my system.  My environment is: - Virtual Machine 1      - THW Platform: 8.5.2      - SSL:443      - Autogenerated certificate - Virtual Machine 2      - Analytics Server: 8.5.2           - Connected to the platform and working     - Platform-Analytics: 8.5.1           - RabbitMQ and Apache Flink from the installer           - Erlang 21.0           - The installation summary said that everything went OK and Things were created   All my transformed properties are configured to make the calculation every 6 hours taken 12 hour of data. However, when I search for the logged data I can see that there are calculated values that are not inside the configured 6 hours period. In the attached image there are two results that don't belong t

Hi, We can link Service successful function to any other service but How to link the service Failure function to another service? Please support ASAP.

Hi, If I create Custom widget Extension in Thingworx version 8.5.2 and later in future if i want to use this extension in 8.5.4 or Thingworx 9.0  then Is it Easy to Migrate such elements?   Note- Custom extension is about Grid Customization ..that is 1)add , delete , Edit save the rows in Grid 2)Sequencing rows by dragging and dropping the row(Exchange the rows) 3)adding Button as Cell value in Grid etc.   Thanks

Hi,   I'm installing ThingWorx Flow on ThingWorx foundation 9.1.0, both of them are to be installed in the same machine.  According to the installation guide: https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Integration_Orchestration/InstallingTwxFlowPostgreSQL.html I should run the following commands firstly in a machine which has internet access, let's call it machineB:  ◦ yum install 'nginx' ◦ yum install 'rh-nodejs8' ◦ yum install 'rabbitmq' ◦ yum install 'openssl' ◦ yum install 'policycoreutils-python'   However,  yum install 'rh-nodejs8' and ◦ yum install 'policycoreutils-python' get failed (the other  3  packages are installed):  yum install 'rh-nodejs8' Updating Subscription Management repositories. Extra Packages for Enterprise Linux Modular 8 - 142 kB/s | 528 kB 00:03 Extra Packages for Enterprise Linux 8 - x86_64 684 kB/s | 8.7 MB 00:12 PostgreSQL c

Hi,   Can anyone help me to write Message Box in Thingworx 9.0? When I press button one message box should open with Yes and No option with it.When user press any one button, I want to take feedback of his input in thingworx 9.0 to use further.   Please provide me java code for above requirement ASAP. Note: I am using Thingworx 9.0 so provide a solution related to this version..

Hi, I have used Data export widget to export Grid data in Excel/CSV file in Tabular Form. but its exporting in Comma separated ...i binds export button to property of type infotable. using ThingWorx 8.5.10-b597 Note- I had used Data export earlier in TWX 8.5.2 and there it was able to see tabular data in CSV.     Thanks

Hi , I have a Grid Advance in Mashup , running on Thingworx 8.5.2 , i had to add Hyperlink as Column Value. and i added it using Column Base Type as 'Hyperlink' but at runtime in grid its not Clickable. please see below screen..   Thanks