ThingWorx

While using the Resources["CSVParserFunctions"].WriteCSVFile API withHeader: true, The order of columns are changed in generated CSV File. How to maintain the same order of columns in CSV File.Resources["CSVParserFunctions"].WriteCSVFile({path: "/"+formattedDate+"/"+FolderName+"/"+FileName /* STRING */,data: ExportData /* INFOTABLE */,fileRepository: "WCCompareXA_Repository" /* THINGNAME */,withHeader: true/* BOOLEAN */});

I am converting a json dataset to a datashape using this code but it returns an empty infotable:  let transformData = function (input) { try { const transformedData = { fieldDefinitions: {}, data: [] }; // Iterate over each record in the input data input.records.forEach(function(record, index) { // Create the field definitions (same as before) transformedData.fieldDefinitions["occurence_" + index] = { name: "occurence", aspects: { isPrimaryKey: false }, description: "", baseType: typeof record.Occurence__c === 'number' ? "NUMBER" : "STRING", ordinal: 4 }; transformedData.fieldDefinitions["productCode_" + index] = { name: "productCode", aspects: { isPrimaryKey: false }, description: "", baseType: "STRING", ordinal: 2 }; transformedData.fieldDefinitions["errorCode_" + index] = { name: "errorCode", aspects: { isPrimaryKey: false }, description: "", baseType: "STRING", ordinal: 3 }; transformedData.fieldDefinitions["id_" + index] = { name: "id",

Hello, I am using MS SQL Server with Thingworx (AMU).I have a table, in which I have start time column, which data type is time(0). Once Start time shown on application, Thingworx is automatically converting UTC values to IST but there is approximately 58 min lagging and some other issues as well. Refer the attachment. I tried changing time-zone to UTC of my local system, then time in application is 29 min behind. Please let me know any work around for this.

When ever tomcat restart the TWX, it gives following error in Application Log:       Error draining persistence providers queues: java.lang.NullPointerException       After that TWX Shutdowns..Followed this Article . But issue still exist.@slangley @PaiChung Thanks,Shashi.

Is there any api to find uncommon values present in two infotables. 

Hello, I am looking to get Graph.JS working within my Thingworx environment so I can have a bit more customization options with graph settings. I've reviewed documentation here saying this is how third party javascript should be embedded into a custom widget.Following a similar structure, I attempted to import 3rd party code via https://cdnjs.com/libraries/Chart.js by adding the following into my widget, that way I don't have to download the files. However, this seems not to work. Is it required to download the 3rd party files to get them into a 3rd party widget? If not, how do I use these hyperlink-style imports that might be commonly used, for example this Jquery link:<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>  

If I want to implement digital twin to a customer, can I achieve it using Thingworx. Are there any products specifically used for digital twin in PTC?Can some examples and design be suggested to achieve Digital twin ?

While i am trying to create one more Kafka extention its trying to delete the current kafka extention that is not required to me can any one help what is I am doing wrong  KafkaThingExtensionPOC:1.1.3ExtensionPackage KafkaThingExtensionPOC:1.1.3 upload attempted and it is not an HA compatible extension. KafkaThingExtensionPOC:1.1.3Cannot update existing Extension Package [KafkaThingExtensionPOC] because it is trying to remove the following Entities that are still in use: [entity: KafkaProducer, used-by: Thing : KafkaThing] I already have KafkaProducer i want to create new one with name KafkaProducerPOC any help appriciated

hi everyone, I have created the structure as you can see with parentId and id. But i am unable to see the button to expand the rows to see his childs instead its showing me everything in plain entries. Any idea?        Tree advanced widget binginds  

Hi There,Is there any possibility to get web Push notification in Thing Worx? Any OOTB widget or extension available?My Requirement is that when the user has minimized the Thingworx browser, then the user will be able to receive the notification, like Web Push Notification. Thanks in advance

Greetings,In here I have the license for 10 users though I still can add two users but it gives this message to access the navigate to can create project and so on for the new developers  as well in here I think I have a problem with subsystem though is there a linux command for the subsystem I am using these commands for the ThingWorxFoundation as :sudo /usr/bin/systemctl stop ThingWorx-Foundationsudo /usr/bin/systemctl start ThingWorx-Foundation  

I am working with thingworx 9.5.I want to use the insert into sql database command. I want to have the database I want to insert the data into as a variable input, but this doesn't seem to be possible. I made an example of how I am trying it but I keep receiving errors: insert into [[Table]] (logid,message,source,category,servicename,level,country) values ([[LogID]],[[Message]],[[Source]],[[Category]],[[ServiceName]],[[Level]],[[Country]]); When I change the [[Table]] parameter by the name of the db, all is fine.error returned is: Execute Update failed: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1" Position: 13 Does anyone have a workaround for this?Kind regards

Hi,I’m currently using Thingworx 9.3.9 and facing an issue while trying to update the property values of boolean properties in a Thing. I’m using the UpdatePropertyValue default service for this purpose.However, the service is not allowing me to update the values for the current time. When I try to update the values for current time minus 2 or 4 minutes, it works, but not consistently.Note: The DataChangeType for these properties is set to value.Method 1: I am using a dynamic DataShape for updating the property values via UpdatePropertyValue.------------------------------------------------------------------------------------------------------var currentTime = new Date();currentTime.setMinutes(currentTime.getMinutes() - 2);var DataShapeparams = {infoTableName: "MyUpdateTable" /* STRING */};var UpdateEntryIT = Resources["InfoTableFunctions"].CreateInfoTable(DataShapeparams);var nameField = new Object();nameField.name = 'name';nameField.baseType = 'STRING';UpdateEntryIT.AddField(nameField

I have to automate the services from scheduler to generate 10 reports every week based on the hardcoded 10 inputs in service. Each report generates after fetching data from windchill and it service executes upto 5 minutes to generate one report. In this case the server should be available for 1 hour in backend for the generation of all reports.    What are the configuration steps needed to run services for continuous 1 hour.

 Unable to checkout branch and not showing branch in "Branch/Commit", which I created in Azure Devops

I tried to create an Oracle database trigger using Thingworx,Database connection successful.I created a command serviceAn exception message is displayed after the command is executedHow can I resolve this exception

Hi TeamI have an issue a with a PostJSON request.I have tested succesfully the content below with PostMan.When invoking this a POSTJSON request, seems it can not handle orrectrly the content data.          var c=[ { 'login':'temp', 'SensorData':[ { "Timestamp": 1727265323000, "Quantity": "Temperature", "Value": "19.2", "Unit": "°C", "DataType": "Decimal", "ValueOK": true } ] } ] ;   let params = { proxyScheme: "https", headers: { "Client": "xxx", "Branch": "xxx", "Api-Key": "xxx", "version": "3.0" }, url: "https://api.platform.twinzo.eu/v3/sensors/batch", content: c, }; // result: JSON let result = Resources["ContentLoaderFunctions"].PostJSON(params); Any idea of why it fails ? "Message": "sensorContract.array:\n\tCannot deserialize the current JSON object (e.g. {\"name\":\"value\"}) into type 'System.Collections.Generic.IEnumerable`1[Core.Contract.V3.Sensors.SensorBatchContract]' because the type

I have a menu with a user group assigned to each menu item as follows..There are no users in the test group, and only a few users in the tampa group. However, I am still able to see these menu items in the UI when I sign in. I have tried non-admin user's as well as admin. All users can still see these menu items. What is wrong here? Shouldn't these items be restricted to the user within these groups? This is version 9.0.4

Hello,My customer is today running THX 9.3.7 with SQL BDD.The project has turned to a large amount of machine data storage and analysis. We are, so, thinking about a move to a InfluxDB system. Several questions are coming to us:- Is the move to influxDB able to solve our performances issues? How to verify that it could be the good solution?- In order to do this move, are there some existing procedure, REX, advises? Best regards, 

Hello My tomcat is not starting and when i check in application logs it shows me error related to license . Please find below error and help fix it License file is renamed to ignored_license_capability_response.bin Thanks

Hello I am not able to fetch device id for my thingworx can someone please help me find it? Thanks

Hello , Can anyone please guide me how to read properties from azure in Thingworx? Thanks

Hi,I'm trying to display an image + text in a dropdown. I have tried two methods..i) under "renderer and state" in the dropdown widget, I'm using a state definition under state-based style definition to add an image. But upon selecting the item we can unable to see the image.ii)creating an infotable with a html field and using it as the display field in the dropdown widget, in this case the text is coming up but the image isn't.Please let me know if their is a way to achieve this, thanks!  

Hello thingworx members, I want to change the color of cell based on a values in advance datagrid. The values are result of SQL query. The column name and it's values are dynamic. Is there anyway I can change the color of cell in the advance datagrid without using  datashape in the state formatting option. Thanks 

Hi everyone,  I would like to use the Tree widget in mashup and my structure for now planned is look as below:- - Step 01   -- Sub step   -- Sub step-Step 02   -- Sub step   -- Sub step So i am going only two levels down so parent and its child thats it. But i am unable to find the format of the data it accepts. Can someone please write the format which it accepts either they are an infotable into an infotable to access it or does it work otherwise? Thanks