IoT & Connectivity

Hello, I am uisng Thingworx 8.3 and Windchill 11.1. In Windchill connector there is a service called "GetCreoDataView" .  This service returns thumbnail, structure, files. Files in service consist of file name, linkHTML, URL, icon . But, I am not able to download file. linkHTML is not working and also URL.   How to use them, or is their any other way to download representation files?       linkHTML I get is ,         http://gt026.galaxy.com:8080/Thingworx/MediaEntities/ptc-windchill-integration-connector-proxy/Content/servlet/WindchillAuthGW/wt.content.ContentHttp/viewContent/tank_drw.pdf?u8&HttpOperationItem=wt.content.ApplicationData%3A586480&ofn=tank_drw.pdf&ContentHolder=wt.viewmarkup.DerivedImage%3A586468&forceDownload=true&wt.effectiveUid=Administrator

Hi there,   Has anyone come across or developed an updated version of the Dygraph and Timeline Chart Widgets so that they are responsive.   We have a series of JSON data being streamed in from live assets and these get populated well the existing ootb widgets, but we need these to autoadjust based on the different devices these can be viewed on.   Regards, Andrew

External email from: Anderson_Perry_6@cat.com I am able to generate the tags and everything looks correct but they will not read the values.  I am using an Allen-Bradley 1769-L16ER-BB1B Compact Logix controller

I am getting Object Object written in infotable if I make a cloumn editable and the value is null there and that cell comes as non-editable   Related to previous post

Hello Guys,I have big difficulties with configuration of LDAP authentication in ThingWorx 7.3.2-b39 (I am not LDAP expert at all).I have created DS entity using com.thingworx.security.directoryservices.LDAPDirectoryService and configure it to some publicly available LDAP, and it works correctly:Obviously I had to create user Entity in ThingWorx manually - which is very bad and I believe with this DS it is not possible to create users automatically. But stil - I can login to ThingWorx using LDAP credentials (not ThingWorx credentials).Although, I've figured out that I can use different class for DS Entity: com.thingworx.security.directoryservices.ActiveDirectoryDirectoryService, which has all necessary functionalities for user/group management. Unfortunately, I am struggling to get it work, I have tried hundreds of different configuration combinations and the DS authentication seems to not work at all (there is nothing in the logs, HTTP basic authentication is activated so eventually I

Hi, i want to create a model with a dataset of industrial plant. I have  found only the file.cvc but Analytics want also the file json. I search to do the file json by the file csv but i don't know well how i can do. After this i want to use the model that i will create with this dataset( i know how create a model by a dataset) to test it with other data to know if it predict the failure or not but i haven't idea how to do this. Someone have any advice for these questions ? Thanks. 

I have a collection widget made up of cells which act as columns. Each column is comprised of value displays which, when clicked, open a pop-up with more information (5-8 value displays per column).   The client using the mashups have reported an issue with the value displays not being clickable within the collection widget.   The client is viewing the mashups on an iPad Air 2, has tried in Chrome and Safari, and is running the latest version of iOS (12.x).   I have tried changing the z-index of the value displays to ensure they sit on top of the stack, but I have quickly run out of other ideas for workarounds. This issue did not occur when formerly using the repeater widget (although there was a separate issue with load/unload that made the repeater not viable either).   Are there any known issues with compatibility with iOS 12.x? Or are there any other ideas for trouble shooting? The issue coincides with other buttons/value displays necessitating double clicks to

Where do I run this command?   Re:  post

Hi, After reading “Deployment Architecture Guide for ThingWorx Version 8.x, version 1.1”, I can’t find documentation to install and configure Thingworx foundation on Google cloud. I heard that it is supported but I can’t find any oficial documentation to implement it.I will appreciate any help to install the platform on Google. Thanks in advanced.

Hi,   In Thingworx composer v7.4.1, I could duplicate a service in a Thing and save it as a new service, however i don't see the same function in a ThingShape.   Is there any suggestion?   My Bests, Hung Tran

Hello Everyone,   I would like to use the SpotlightSearch function from System/Resources/SearchFunctions. When using Postman to execute this service with a Rest Call I get a "405 Method not allowed Status". I use the following call: POST https://IP-Address:Port/Thingworx/Resources/SearchFunctions/SpotlightSearch The Authorization credentials are correct and the calls work for services of normal Things.   Am I missing something, or why is that not working?   Another Thing I would like to know is how to define the "Tags" parameter for the SpotlightSearch in the body.   Any help is appreciated very much.   Best Regards, Dominik

When I run the thingworxPostgresDBSetup.bat script, I am getting the following error:   psql:./thingworx-database-setup.sql:14: ERROR: could not create directory "pg_tblspc/16404/PG_9.4_201409291/16405": No such file or directorypsql:./thingworx-database-setup.sql:16: ERROR: database "thingworx" does not existPressione qualquer tecla para continuar. . .    

Hi, So I have a mashup which selects a number of properties for a thing. It then loops through each of these properties and Queries the property history. The goal is to take each history infotable and add it to an overall history table with all of the properties and timestamps. The following tables may give more of an idea:   table1 - overall table (starts without any values) timestamp Property1 table2 - property1 history table timestamp Property1 1 x 2 y So after the first iteration table1 will look the same as table2. For the second iteration/property the overall table should become: timestamp Property1 Property2 1 x   2 y   Table3 - property2 history table timestamp Property2 1 z 3 x After joining the overall table to the second property table, it should become: timestamp Property1 Property2 1 x z 2 y - 3 - x The method for this should work for any number of properties. I tried using a full join then a distinct but

Hi, after an installation on windows server 2016 of thingworx fondation 8.3.2 and thingworx analytics 8.3 on the same pc, i try to do this guide https://developer.thingworx.com/en/resources/guides/analytics-builder-quickstart/abq-conclusion. The server apparead connected but when i try to do a model the validation set is nan and i don't see the prediction scroed and the model result. I don't know well the reason, any suggestions?

  Hi, I have followed  https://community.ptc.com/t5/ThingWorx-Developers/rest-api-returns-an-html-page-How-to-access-the-data/m-p/501682 But still it seems there is some problem.    I am using this piece of code from a node application, to get a property value using REST.   var data = JSON.stringify(false); var XMLHttpRequest = require("xmlhttprequest").XMLHttpRequest; var xhr = new XMLHttpRequest(); xhr.withCredentials = true; xhr.addEventListener("readystatechange", function () { if (this.readyState === 4) { console.log(this.responseText); } }); xhr.open("GET", "http://localhost:8080/Thingworx/Things/ThingName_Example/Properties/uploadPath"); xhr.setRequestHeader("Content-Type", "application/json"); xhr.setRequestHeader("Accept", "text/xml"); xhr.setRequestHeader("appKey", "PPPP9f16-XXXX-XXXX-XXXX-1b719e2UUUUU"); xhr.send(data);       and the result i get is :-  <HTML><HEAD><TITLE>Property Value For CMU_TH_DOCUMENT

Hi,   I am trying to retroactively insert an alert via a service into the alert summary and history with a custom date time. I know I can insert into the alert history by just inserting into the AlertHistoryStream. However, I am not sure how to insert into the Alert Summary. If this is not possible another option would be to retroactively fire the alert even with a custom date. We are trying to achieve complex alerting, but we want to leverage as much of the built in alerting as we can.   Thanks, Brandon

Hello Everyone, I had few question related to service execution and associated subsystem 1. Does anyone know if Datatable related services (like Add, Update, Delete) etc are handled through 'Stream Processing Subsystem' ? I do see a separate subsystem for valuestream but there is nothing specific to Datatable so I was wondering if the services are queued for processing (when multiple threads are trying to access the same data table) using Stream Processing Subsystem ?   2. The other question I had was with respect multithreading ! When Thing service (same or different) is called from an external system using REST api, will Thingworx spin up a new thread for each call ? Please clarify, 3. Also which subsystem handles the execution of thing services ? Are they executed innediately or queued based on active threads and other parameters? 4. Finally is there a way to monitor what threads are active in memory ? which processes are taking long time than usual etc ?   Appreciate

I want each cell of one entire column in a grid to have drop-downs, so that the user can select the value from the drop-down when the table is editable. Is it possible to achieve this functionality using any of the grid widgets (grid, advanced grid ..etc ) in Thingworx? What should i do to implement this functionality?

Hello, I am creating an external Thingworx widget, and am passing a Thingname (string) as a property of widget. Now inside widget I would like to call the generic services like 'GetBooleanPropertyValue' or 'GetIntegerPropertyValue' or for that matter any other custom service that I have defined in that Thing (Thing is created in composer). I am not able to figure out a way to do so. What I have realised is , we have something like ..'TW.Runtime..' using which we can do so. for ex, if I need to access current session information I use something like 'TW.Runtime.Session.SetSessionValue'. Also there is one more function, 'TW.IDE.getThingInfo' regrading which I am not able to find any details.   Another part to my question is , do we have any standard documentation/guide which provides information on list of Js functions like TW.Runtime or TW.IDE ... I referred to https://community.ptc.com/t5/ThingWorx-Developers/Where-can-I-get-a-list-of-all-Thingworx-s-Js-function/td-

Hi, Whenever a datashape is created from a sql query it becomes static. If I make any changes in the query like adding a new column or removing I have to again create a new datashape. But is it possible that the datashape becomes dynamic and adjusts according to the query whenever it is changed?   Thanks, Shalini V.

Hi,   i have many Things with "Database" as Thing Template and i would like to make a service which sets the password to the database automatically (on running the service).  i looked into the snippets and found nothing so i thought it might be a security policy.   is it possible? Thanks 🙂

Does anyone know if there is an Event that is triggered upon server startup?  I want to send the admins an email when the server boots in case of unexpected reboot.  

I need to know how the thread works in ThingWorx, how the server gets busy and hoe does the internal queue process the threads later, for the application and when is contented to a DB. 

How to export data table entries directly to Excel file rather than .CSV file without using data export extension tool?

Hello All, I created datatable contains 2 primary key(col1, col2).I insert 2 records("a","bc")("ab", "c") into the table, but auto generated key field conflicts and updated(not insert). How can I insert these two records in that datatable?