ThingWorx

Hello Experts,             Application Requirement : To fetch excel or CSV file in thingworx as template, Update cells or rows in file and save with new name ( so that my template will be there for every next operation)  Current Status:  I want to only update excel/CSV file but i am unable to find any solution for same,  I have tried CSV Parser function in thingworx to Read and write file but during write operation it completely overwrites previous data. Please suggest solution for same. I am using Thingworx 9.3.2 

Hi,How can a Z-Index be used in a Responsive Mashup?, Z-Index is commonly used in spacing a widget on top of another widget; how can this be achieved in a Responsive Mashup?Thanks,

Hello,Whe  I started working with ThingWorx Analytics, I learnt a lot from a serie of videos located on Developer portal:https://developer.thingworx.com/resources/guides/analytics-training-videosI cannot find this resource material on ptc community. Did I search in a bad way? How can I find it in ptc community?Thanks in advance 

A previous installation of ThingWorx Foundation for MSSQL has been found. Uninstall the existing installation and then reinstall ThingWorx Foundation for MSSQL. If you are upgrading ThingWorx Foundation, you must first ensure that all prerequisites are met. Do you want to review the prerequisites in the help center now ?

We have installed thingworx 9.1 with postgreSQL using installer. Create more than 50+ entities and done a kind of an PoC. How to cleanup everything and make just like fresh installation instance without uninstallation?

Started developing extension to get image file from windows file explorer.    Created resource Created service [input: imagePath, output: IMAGE] Here how to convert Imge file to thingworx IMAGE basetype?

How to ping Database server using javascript code in thingworx service ?

Hello,In one of my application i want to apply custom font size to the message and button label on Confirmation dialogue box.I am not able to apply it, can anyone help me with this issue?Thanks in advance.

Hi,   I have done the following binding, but still the edited data is not saving in the data base, the binding I have given in the below picture.   could you provide some solution?   Thanks in advance

Hi All, I am trying to design an mashup which will fetch data from MS-SQL database to info table, and further info table is mapped to mashup. Things are working fine when data is static i.e. in all iteration if data set is same. But my requirement is the data fetched from Database will be dynamic, each time it depends on user input.  I would like to know how to handle dynamic data with info table mapped to mashup

Hello @slangley we have the same issue for all our mashups after migrating to 9.3.4. We have more than 100 mashups.The button is not working on any of those. Can you assist?

Hi community, I am trying to display duration (difference between 2 dates). I converted it from decimal hours to hours.The problem I am now facing is the minutes are not displaying. The duration only changes after an hour.  Below is the code that I have written. Does someone know How I can solve this problem.  var decimalTime = parseFloat(duration);decimalTime = decimalTime * 60 * 60;var hours = Math.floor((decimalTime / (60 * 60)));decimalTime = decimalTime - (hours * 60 * 60);var minutes = Math.floor((decimalTime / 60));decimalTime = decimalTime - (minutes * 60);var seconds = Math.round(decimalTime);if(hours < 10){hours = "0" + hours;}if(minutes < 10){minutes = "0" + minutes;}let result = ("" + hours + ":" + minutes); The desired output should be e.g., 16:00. Then after two minutes I should see 16:02. However currently I am only seeing a change after an hour (i.e. 17:00 after sixty minutes). Many thanks

Hi, I want to change text colors of tree widget elements based on different conditions.The tree is created based on infotable which is output of a service. Need to add logic on service to change the text colors, Are there any way to achieve this ?Is it possible to add state definition on service ? Thanks

I can start Apache Tomcat and it running a while then stop, I checked the error log and found :Admin Password entered did not pass validation. Check inital admin password set in platform-settings.json. I also checked my platform-settings.json configuration, it is ok, I attached it as below:   Error Log: 2022-09-20 02:43:08.741+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Admin Password entered did not pass validation. Check inital admin password set in platform-settings.json2022-09-20 02:43:08.741+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Check the InitialPassword setting in the AdministratorUserSettings section in platform-settings.json. Password was blank or null. Please try again while following correct password policies: Minimum Password Length (System Default): 14, Maximum Password Length: 128, Does not contain blacklisted words.2022-09-20 02:43:08.741+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: Su

Hello, community, I am trying to filter my stream using the data filter widget. I wrote a service that outputs values from my stream. I've bound all data from the stream to the data filter widget. Took the query property of the widget and bound it to the grid. Then took the querychanged event from the widget to invoke my customer service. On runtime, I can query using my filter but the result (filtered data) does not appear on my grid. It only shows the number of rows that have been filtered. Please see the screenshot below. How can I solve this? I used this tutorial: https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Mashup_Builder/Widgets/ChipBasedDataFilterWidgetThemable.html Many thanks.

I recently updated thingworx to 9.3.3.When i set the SelectedRows source i get the following error while debugging:13:45:54 ERROR - Runtime exception handling data update for binding {"Id":"097e2722-4c44-48f8-babd-0eaa37bbd51e","SourceId":"GetSelected","SourceArea":"Data","SourceSection":"Things_Jens Test Thing","SourceDetails":"AllData","TargetArea":"UI","TargetSection":"","TargetId":"ptcsgrid-8","PropertyMaps":[{"SourceProperty":"","SourcePropertyType":"InfoTable","SourcePropertyBaseType":"INFOTABLE","TargetProperty":"SelectedRows","TargetPropertyType":"property","TargetPropertyBaseType":"INFOTABLE"}],"isBoundToSelectedRows":false,"nEntries":1}Exception: this.updateSelectedRowsProperty is not a function on line number 1 in file mashup-common-widgets-runtime.js?_v=9.3.3 i put a demonstration file in the attachments. if you change the getSelected binding to the Gridadvanced widget it works as expected. but it doesnt work on the new Grid widget.I am missing something

Hello all, Somebody kindly clarify the difference between Thingworx v9.1 dev & prdn instance license. what will happen if we use dev license for production server instance. Please clarify clearly!!!

Hi, How can I Filter the Things based on Property value ?Thanks,Shashi.

Hi Folks,   Whether LDAP or Azure AD will be faster to integrate considering minimum configurations on the Thingworx platform end. Please share if any guide or steps are already there to achieve the same.  

Hello, I need a functionality to determine the next execution date(s) of a scheduler based on it's cron and last execution date (or date range) but I could not find anything useable in Thingworx or Java. Having this capability I could provide an overview of the scheduled task to the End user.Is there any tool that could help me to achieve this?

In Collection Widget, when number of rows infotable is changing, the cells are expanding and collapsing horizontally. But I want the cells to get expand and collapse both horizontally and vertically.  How to do this?

I am an inexperienced user of Thingworx. We have a pre-existing Mashup which can plot historical data selected using the Date time picker. I would like to change it so that the data is selected based on the Batch Number rather than the date and time (this is a number variable that is already in the data). I am not sure how to do this,

I will trigger service to open particular tab in tab widget. So how to make its tab non clickable physically ? 

Hi, I configured TWX SSO using Okta as IdP.All configurations I believe are correct, I can even login to TWX with SSO, I can open Composer and view mashups. But even though I've given SSOAdmins and SSOUsers (My group mappings in SSO) run time permission for Things, to view, run services, subscribe and etc.When I log in through SSO I can't execute any service and nothing more. It's like the user gets in, but it does not get added to the UserGroups defined.I've also given the UserGroups permissions on PlatformSubsystem, EntityServices.Is there some kind of different way to grant permissions to SSO users?I even tested creating a user and adding this user to my UserGroups, and at runtime everything runs fine, I can execute services and whatnot.I believe the issue is happening when logging in, the logged SSO user is not getting added to the respective userGroup mappings. Thanks!

Good day, all. I hope you are well. I have a filter widget that filters through my stream. I want to take all the data in the stream and export it to csv I am struggling to write a service that does this. This link: https://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/index.html#page/ThingWorx/Help/Mashup_Builder/Widgets/DataExportWidget.html. Speaks of exporting passwords that are encrypted. It does not address my scenario. Does anyone know how I can achieve this? Many thanks🙂