IoT & Connectivity

 Hello ThingWorx community members,!As part of our continuous efforts to improve our offerings, ThingWorx product management regularly reviews the software deliverables we provide to our customers as well as how we do so. As we had notified ThingWorx users with more than a year's advance notice via this Knowledge Base article, community post, and Product Release Calendar "standard support end dates" that the below three extensions will be discontinued past their End of Standard support date, we’d like to inform you that these are no more available for downloads from PTC Software Download portalThingWorx CSV Parser ExtensionThingWorx Twilio ExtensionThingWorx Google Widgets ExtensionHenceforth, customers desiring fulfillment of the use cases served by the three extensions as well as formal support would need to contact PTC partner- IQNOX.The latest versions of these extensions compatible with the ThingWorx 9.3.4 release are also available for community usage attached to this a

GUIDE CONCEPTStep 1: Completed ExampleStep 2: Connect to External DatabaseStep 3: Query Data from External Database  Learn how to connect, query, insert, and handle data from an external database. GUIDE CONCEPT This project will introduce how to utilize and incorporate an external database with the ThingWorx Platform. Following the steps in this guide, you will connect the ThingWorx Platform to a database, insert data, execute stored procedures, and query data.   YOU'LL LEARN HOW TO Connect ThingWorx to external databasesQuery databases and and handling resultsInsert data and running stored procedures NOTE: The estimated time to complete this guide is 60 minutes.  Step 1: Completed Example Download the attached DatabaseApplication.zip and import it into ThingWorx Composer. This download will provide examples that can be used as a reference or as a final copy as you walk through this guide. In this tutorial,

Step 4: Write Data to External DatabaseStep 5: Executing Stored ProceduresStep 6: Next Steps  Step 4: Write Data to External DatabaseYou’ve connected to the database, you’re able to query the database. Now let’s handle inserting new data into the database. The update statements and data shown below are based on the table scripts provided in the download. Examples of how the ThingWorx entity should look can be seen in the SQLServerDatabaseController and OracleDatabaseController entities.Running an InsertFollow the steps below to set up a helper service to perform queries for the database. While other services might generate the query to be used, this helper service will be your shared execution service.In the DatabaseController entity, go to the Services tab. Create a new service of type SQL (Command) called RunDatabaseCommand.Keep the Output as Integer.Add the following parameter: Name        &nbs

GUIDE CONCEPTStep 1: Examples and StrategyStep 2: Database ConnectionsStep 3: Query Data from External Database Connect to an existing database and design a connected data model. GUIDE CONCEPT There are times you already have your database designed and only need to integrate the ThingWorx environment. These concepts and steps will allow you to focus on development of your application while still allowing the ability to utilize the power of ThingWorx! We will teach you how to create a data model around your database design and connect to that database.  YOU'LL LEARN HOW TO How to connect an external database and created services to be used with itHow to design and implement a new data model based on an external resourceUsing data models with database services Note: The estimated time to complete this guide is 30 minutes.   Step 1: Examples and Strategy If you’d like to skip ahead, download and unzip the completed example o

Step 4: Write Data to External DatabaseStep 5: Executing Stored Procedures Step 4: Write Data to External Database You’ve connected to the database, you’re able to query the database. Now let’s handle inserting new data into the database. The update statements and data shown below are based on the table scripts provided in the download. Examples of how the ThingWorx entity should look can be seen in the SQLServerDatabaseController and OracleDatabaseController entities that you've downloaded Running an Insert Follow the steps below to set up a helper service to perform queries for the database. While other services might generate the query to be used, this helper service will be your shared execution service.In the DatabaseController entity, go to the Services tab.  2. Create a new service of type SQL (Command) called RunDatabaseCommand.3. Keep the Output as Integer.4. Add the following parameter: NameB

Step 6: Building the Data ModelStep 7: Next Steps Step 6: Building the Data Model You can build your data model using different methods. You can build your data model where the Data Shapes match with your tables, but what you'll realize over time is that you will often need custom Data Shapes. When you query for data, you will often need data from differing tables to be in one result set. Because of this, I suggest against making your data model based on the tables. You can start the basis for your model with the tables in mind, but know that this won't be the basis for long. Create Data Shapes Let's start by setting up two queries and the Data Shapes to match. The first query will be to find the list of classes a student is assigned to and query will be completed here. The second query will be to find all student in an active class and we'll ask you to create it based on how we did the first one. 1. In the ThingWorx Composer, click the + New button i

Hello.I have added reference lines to my chart but i cannot see the labels. Also, anyway to customize the colors for each reference line? I am using ThingWorx 9.3.2-b411 

Hello @Pedro_Sanchez ,   Same kind of problem we are also facing now in v9.1.   if you got any resolution for this case, kindly share with us, which will be of great help   thanks

Hi,   I have a question. I spend a decent amount of time coding checks if something is allowed to happen. mostly because it is so easy to enable, disabled/hidden buttons.   You can just edit this html on the frontend:   disabled button. but in the front end I can just remove disabled="" and I can use the button. remove display: none; and you can use the button     Is there a way to disable clicked event on runtime? Or something else that the end user can't change themselves

Hello , I am trying to connect thingworx with KepserverEX but getting following error  Error ThingWorx Native Interface Connection to ThingWorx failed. | Platform = localhost:443/Thingworx/WS, error = could not initialize a secure socket connection. Any help would be appreciated !! Thanks

Hello, I have recently installed thingworx 9.3 using installer . I want to know which option is recommended for installation manual or installer one? Does it make any difference if I choose between both of them? Thanks 

Hello,Our ThingWorx solution has been facing an issue where, upon changing the Language of the solution, the Charts and Graphs have their styling options changed. I have attached two different pictures that more accurately portray this issue: it is the exact same graph with the only difference being the selected language. What could be causing this issue?

Hello , I am working on a project and want to configure cross origin resource sharing . Can we enable Cross origin request in Thingworx? Thanks in advance

Is there a way to combine different mashups from different Thingworx enviroments? So each of our sites has a Thingworx enviroment set up is there a way to pull in different reports into one dashboard?

GUIDE CONCEPTStep 1: InstallationStep 2: Create GatewayStep 3: Create an AppKeyStep 4: Connect to Foundation   Connect Devices and Equipment Using Industry-Standard Protocol Drivers in ThingWorx   GUIDE CONCEPT   This guide has step-by-step instructions for connecting ThingWorx Kepware Server to ThingWorx Foundation.   This guide will demonstrate the ease of connecting edge industrial equipment to ThingWorx Foundation without installing any software on production equipment.   We will also show how connecting different systems and devices improves operations through the creation of business intelligence.     YOU'LL LEARN HOW TO   Connect ThingWorx Kepware Server to ThingWorx Foundation Secure the connection with an Application Key Create an IndustrialGateway Thing Map ThingWorx Kepware Server Tags to ThingWorx Foundation Thing Properties Visualize Data from connected digital assets   Note: The estimated time to complete th

Step 5: Bind Industrial TagStep 6: Log to Value StreamStep 7: Visualize the DataStep 8: Next Steps Step 5: Bind Industrial Tag Now that you've established a connection, you can use ThingWorx Foundation to inspect all available information on ThingWorx Kepware Server. ThingWorx Kepware Server includes some information by default to assist you with verifying a valid connection with ThingWorx Foundation. Create New Thing In ThingWorx Foundation, click Browse > Modeling > Industrial Connections. Click IndConn_Server.At the top, click Discover.The Discover option is exclusive to Things inheriting the IndustrialGateway Thing Template and displays information coming from ThingWorx Kepware Server. Expand Channel1.Click Device1.On the right, you’ll see Tag1 and Tag2, which are pre-defined Tags to assist with connectivity testing. Click the checkbox next to Tag1.Click Bind to New Entity. In the C

Guide ConceptStep 1: Completed Example FilesStep 2: Create Reusable MashupStep 3: Configure MashupStep 4: Define Entity ParameterStep 5: Use Mashup Template as ComponentStep 6: Next Steps Implement reusable Mashup Templates and Shapes in your IoT application.  Guide Concept This guide will introduce you to creating your own advanced responsive ThingWorx user interface templace. You’ll learn some best practices and tips for creating a UI for your IoT application. With Mashup templates, you’re able to quickly and easily build pages that will look alike and have some of the same functionality already programmed. Following the steps in this guide, you will create reusable content and develop scalable user interfaces. We will teach you how to make UI development easier and more efficient for all of your IoT application needs.  You'll learn how to Utilize ThingWorx using best practices for UI designCreate Entities to make development faster and sc

Hello. I have a static Mashup; it is left aligned, but as per the client's requirement, it needs to be center aligned on a page/screen; how can we do that?All the Widgets or the whole design are in a single container(which is static). Alignment is not possible for it.Any CSS that can be added to the Container to align it in the center?Thanks,

Step 1: Example and StrategyStep 2: Utilizing Logging FunctionsStep 3: Logging Complex ObjectsStep 4: Viewing and Filtering LogsStep 5: Next Steps Utilizing the ThingWorx monitoring system Guide Concept Being able to view your logs is an important part of knowing what is happening in your system. You can't keep things secure if you don't know who is doing what. These concepts and provide you with ways to find information about what is going on in your application and system. We will teach you how to access the monitoring panel and help keep your application running the way you need it to.  You'll learn how to How to log data and capture useful informationHow to filter and find what you need in the monitoring pages. NOTE:  The estimated time to complete this guide is 30 minutes  Step 1: Example and Strategy If you’d like to skip ahead, download the completed example of the Aerospace and Defense learning path: Aer

Guide ConceptStep 1: Medical Learning PathStep 2: Import SimulatorsStep 3: Create Data Shape Learn how to store and display medical device data for a Service opportunity. Guide Concept In this guide, you’ll learn how to combine information from multiple Edge devices into a single, logical Thing. You’ll then create a GUI to display this combined information (as well as retrieve new information on demand) to facilitate a “Medical Service Play”.  You'll learn how to Create a Data Shape and Info Table Property to store Medical DataCreate a Service to combine data from multiple Edge devices into a single, logical ThingCreate a Mashup to view and retrieve Medical data NOTE:  The estimated time to complete ALL parts of this guide is 60 minutes  Step 1: Medical Learning Path So far in this Learning Path, you've been able to connect both an embedded controller (simulated by a Raspberry Pi) and a PC to ThingWorx Foundation. This is

Step 4: Create ThingStep 5: Create ServiceStep 6: Create Mashup  Step 4: Create Thing Now that we have a Data Shape to format the combination of data coming from the various sub-systems, we can now instantiate a Thing with an Info Table Property to hold all of said data. Click Browse > Modeling > Things. Click + New.In the Name field, type MDSD_Thing.If Project is not already set, search for and select PTCDefaultProject.In the Base Thing Template field, search for and select Generic Thing. At the top, click Save. Add Info Table Property We now have a Thing to aggregate the MRI sub-system information, but we still need a Property to perform the actual storage. We'll use an Info Table Property for this, with the columns of the Info Table formatted by the Data Shape we created in the previous step. At the top, click Properties and Alerts. Click + Add. On the right in the Name field, type MDSD_InfoTable_Proper

Step 7: Access DataStep 8: Test ApplicationStep 9: Next Steps  Step 7: Access Data Now that we have a basic display in-place, we need to access the backend data. To do so, we'll make use of built-in Mashup Data Services. At the top-right, ensure that the Data tab is selected. Click the green + button. In the Entities Filter field of the Add Data Pop-up, search for and select MDSD_Thing.In the Services Filter field, type getprop.Click the arrow beside GetProperties.Note that the GetProperties() Service has been added to the right section.Check the Execute on Load checkbox. At the bottom-right of the pop-up, click Done.Note how the GetProperties() Mashup Data Service has been added to the top-right under the Data tab. Bind Info Table Property Now that we have access to the Data Service within the Mashup, we'll use it to pull backend data into the Mashup (specifically, the aggregated Info Table Property), and then bind it to the Grid Widge

Hi,Was migrating the dashboard from 8.4.x to 9.3.x, when migrating the List Widget, can't see View property of List which is present in the 8.4.x version was missing in the 9.3.x..Below is the picture of the Legacy widget property which is missing in the 9.3.x.. How can view property can be configured in the 9.3.x ?Thanks,

Hi, I am using the MQTT template to subscribe to MQTT values, but when I query for property history I only get the values which I set manually. I think it's a permission problem. Any help is appreciated. Thank you!

Hey @krishnakomal ,   Do you know how to change the color of dropdown scrollbar by using CSS? Here I attach SS. Please help me in this.      Thanks.