IoT & Connectivity

Hi,We have Postgres as an Model DB, InfluxDB as an Time series DB. Will it be possible in a Thing, few logged properties can be stored in the InfluxDB and few on Postgres ?Because we run a retention policy every month for Influx DB, which purges Data on Monthly basis, there are few properties that are getting logged to be excluded from the Purge.So if I assign a Thing with ValueStream of InfluxDB everything gets purged, there are few properties that should be excluded for client data Analysis.Thanks,

Hi, I'm storing less frequent data in configuration table, however when i ty to fetch the data using  getConfigurationTableRow service only one value is fetched that too old value. How to fetch latest value from configuration table. Is there any way that updates value of config table instead of adding more data,Thanks,Adarsh

How to convert infotable datas to xml in thingworx . Kindly tell me any rest call or js code or extension.

how to read and write .xml files in thingworx

Hi everyone. I have created a service that adds stream entries to only a few specified columns if a certain boolean condition is true. If the boolean condition is false then the service updates the stream entry by filling in the rest of the column values. I passed the infotable that holds the values and a current streamID to the updateStreamEntries snippet. This does not work, I keep getting the error :  Invalid number of values provided to UpdateStreamEntry. How can I fix this?

I see that the maximum rows handled by INFOTABLE is mentioned as 500. Can we store more than 500 rows Infotable in a variable? like if we call a service say GetImplementingThings() inside another service which returns more than 500 rows,  can TWx still can iterate through that INFOTABLE variable and carry out rest of the process say inspect  or update a property? What is the best way to handle 

Hi all, I want to reset all the properties of a thing to respective default values, how can this be done? Thanks,Sujith

  I want to push values to child infotables dynamically using nested for loop, in the above code the "infoname" parameter is the child infotable names which are dynamic.  While executing the code i am not getting any issue, but the infotables are showing blank.if i am passing the actual name instead of "infoname parameter" the values are showing in that particular infotable. Is there any way to pass values to child infotables dynamically?

I am logging the service checkpoints using logger.info and calculating the total time using logger.debug functions. But I cannot see these messages in script logs. Where else can I find them?

Hi,I am trying to add rows with new values to a stream.By doing the following:  But I keep getting the error above. Can someone please help me understand what the error means and do you know how I can fix this? Many thanks 🙂

Hi team, I want to change the default tooltip format on the Line chart. We have a requirement where we are using the Line chart as a step chart on Thingworx 9.3 version. The default tooltip is "Wed Mar 02 2022 02:59:16 GMT +0530(India Standard Time), Signal:1", which I want to change to "2022-03-03 02:59:16, Signal:1". I came across the Localization tables in TW where you can customize the tooltip. By following this link https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Mashup_Builder/Widgets/CreatingCustomChartTooltips.html I created a new token, now I am getting "Signal:1" on the tooltip, but I am not able to understand how I can customize the Timestamp. The default token is "${label}, ${series}: ${value}".   Thank you!!

Hi , After clicking on upload button, Is it possible to disable the Upload button available in file Upload widget.After successful file Upload , Upload button should be Enable.  Regards,Hareef 

I am getting same error msg in TWX 9.3.1 while using GetText.  However I was using it successfully in TWX 8.5.9 to receive JSON output data.  But same code not working in TWX 9.3.1.  Any alternative to get the result here?

Hi All,I used the REST api /Thingworx/ExtensionPackageUploader to upload a zip extension. The request was successful and I do see the extension in the server where it is running (/ThingworxStorage/extension). But for some reason I cannot see the extension showing up in Composer. Did I missed anything? 

I am learning the Button, when it come to step 2, Click and drag the clicked service shown in the drop-down onto a free area of the Mashup canvas, i can't get the ResetInputsToDefaultValues service.the guide displays this:however i get this: 

  Question: What should I know about using ThingWorx with InfluxDB to store my time series data? Hi, ThingWorx users!   It’s here! Thanks for waiting patiently since my previous post announcing ThingWorx’ new support of InfluxDB as a time series persistence provider.   As of our 8.4 release, you can now use InfluxDB to store your ThingWorx time series data with incredible power and ease.   Want to learn more? Check out the following FAQs:   1. What is InfluxDB? Who is InfluxData? InfluxDB is a time series database designed to handle high write and query loads. It is meant to be used as a backing store for any use case involving large amounts of timestamped data, like monitoring, application metrics, IoT sensor data, and real-time analytics that you’d find in ThingWorx.   InfluxDB is created by InfluxData, an awesome company that we are proud to call a PTC partner.   2. When would I want to use InfluxDB for IIoT? While the ThingWorx IIoT platform

Hello,We are trying to communicate a Allen-Bradley ControlLogix Ethernet with a Allen-Bradley ControlLogix Server Ethernet but without success, could you provide us an project example or give us some ideas of how to do that?We are using a ControlLogix running both Master and Slave in the same computer, and what we did were:1 - Create a Allen-Bradley ControlLogix Server Ethernet, create a LogixAddress and create an item pointing to the LogixAddress.2 - Create a Allen-Bradley ControlLogix Ethernet and set to connect to my computer IP. Create an item pointing to the LogixAddress.3 - Run the OPC Quick Client and we see that the Master tag has quality bad, follow image: Best Regards, Eduardo.

Hello, Everyone. I wnat to use a Proportional chart like as picture.  I have completed the tutorial. A proportional chart was created. (https://developer.thingworx.com/en/resources/guides/display-data-charts/ddc-configure-charts)    But, If I unchecked "Single data source" It doesn't work.I would like to show the operating time of the equipment at a specific time in a proportional chart.How can i do ?Please provide it. If you have a sample program. Best regard,

When using any data change input to Subscription to update a same property, say a JSON or an INFOTABLE, will that work synchronously for any given remote things. Because if all the property change in a very short  span of time(sometimes no difference in time at all), will it overwrite the JSON or INFOTABLE? What is the best way to do the modelling in this case?

Hi, When we run the below script, we are facing an out of memory issue and Thingworx tomcat service restarts automatically. we have run the below script manually from composer with execute option in a batch of 25 & 50 vin's in input array, the scripts executes and prints the final array in the script logs but internally it is causing out of memory issue, Can any one please let us know what is the issue in this script and why this is creating out of memory issue becuse we do not see any errors in the logs also.   Script: serviceName = "updateDeviceNum";//sample input format :{ "vin": ["123456786", "456782354"]} var inputArrayVin = inputVIN.vin;//logger.info(myName + " inputVIN " + inputVIN);var inputLen = inputArrayVin.length;logger.info(myName + " inputLen " + inputLen);var arValueUpdated = [];var arSkipped = []; for (var i = 0; i < inputLen; i++) {//calling the getAsset using VIN to get deviceIDvar getAssetByVINURL = "https://**********" + inputArrayVin[i];var apiPara

I'm installed ThingWorx Foundation more when I get on the screen I can not proceed already tried all bank password , bank user etc .

In slider widget, accuracy in selecting  value is low. Any other widget available to select range or any extension available ? 

Any Documentation available for project portfolio management?

Hello, I am sending data to my Things. Those data are in an infotable like this:my lastSession json looks like this:  However, sometimes I will send the same data but my lastSession will change but keep the same ID.I want to log all my data. However, when a lastSession comes with the same ID as the old one, I want to replace the data and not log them.I tried to PurgeSelectedPropertyHistory but it did not work. Does anyone have an idea ? 

Hi, community, I have been spinning my wheels with getting the differenthe ce between two dates and time.The aim is to find the duration between the time a device is turned off and when that device is turned on. I have two different services that output a datetime value. One service outputs the time the device is turned on and the second service outputs the time the device is switched off.I then created a third service that calculates the difference between the two times. Below is what I wrote in my third service:var date1 = parseDate(onTimes_Input, " dd-MMM-YYYY HH:mm");var date2 = parseDate(offTimes_Input, " dd-MMM-YYYY HH:mm");let result= dateDifference(onTimes, offTimes); when I execute the above, I get the following error: Error executing service getDuration. Message :: Invalid format: "1661387400000" - See Script Error Log for more details.  Does anyone know what this could mean?Best RegardsJay_nisaa 🙂