top of page

Forum Posts

MS Bhatti
Apr 25, 2023
In Questions & Answers
To log data in MS SQL Server Table using Node-RED, you can follow these steps: Install the node-red-contrib-mssql-plus module in your Node-RED instance. This module provides nodes for interacting with MS SQL Server databases. Create a new MS SQL Server database table where you want to log your data. Add an mssql node to your Node-RED flow, and configure it with the appropriate database connection details. Add a function node to your flow, and write the code to prepare and insert data into the database table. Here's an example code: javascriptCopy code var timestamp = new Date().toISOString(); var value1 = msg.payload.value1; var value2 = msg.payload.value2; var sql = "INSERT INTO mytable (timestamp, value1, value2) VALUES ('" + timestamp + "', " + value1 + ", " + value2 + ")"; msg.topic = sql; return msg; This code takes the current timestamp, as well as two values from the msg.payload object, and inserts them into the mytable table. You can customize the code to match your own table schema and data types. Connect the function node to the mssql node, and deploy your flow. Now, whenever your flow receives new data, it will be logged to the MS SQL Server table. Keep Testing ! Keep Learning !
0
0
24
MS Bhatti
Mar 28, 2023
In Questions & Answers
WinCC Flexible is a software package used for programming Siemens' HMI (Human Machine Interface) devices. Here is a general guide to installing WinCC Flexible on your PC: Check your PC meets the system requirements: Ensure your PC meets the minimum system requirements before installing WinCC Flexible. Check the Siemens website for the latest system requirements. Obtain the WinCC Flexible software: You can obtain the WinCC Flexible software from a Siemens distributor or partner. Make sure you have the installation files or DVD. Run the installation file: Insert the WinCC Flexible DVD into your PC, and run the setup.exe file. Alternatively, you can download the software from Siemens website and run the setup.exe file. Follow the installation wizard: Follow the on-screen instructions to complete the installation. The installation wizard will prompt you to accept the software license agreement, choose an installation location, and select the components to install. Activate the software: After installation, you need to activate the software. To do this, launch WinCC Flexible, go to the Help menu, and select "Activate WinCC Flexible." Follow the activation instructions provided during the installation process. Configure the software: After activation, you will need to configure the software to connect to your hardware. Follow the instructions provided in the WinCC Flexible user manual to configure the software. That's it! Once you have completed these steps, you should be ready to use WinCC Flexible on your PC. Happy Support !
0
0
20
MS Bhatti
Mar 28, 2023
In Questions & Answers
Installing RSLogix 5000 on your PC involves a few steps. Here is a general guide to get started: Check your PC meets the system requirements: Ensure your PC meets the minimum system requirements before installing RSLogix 5000. Check the Rockwell Automation website for the latest system requirements. Download RSLogix 5000 software: Once you confirm that your PC meets the minimum system requirements, download the RSLogix 5000 software from the Rockwell Automation website. Run the installation file: After downloading the RSLogix 5000 software, run the installation file to begin the installation process. Follow the installation wizard: Follow the on-screen instructions to complete the installation. The installation wizard will prompt you to accept the software license agreement, choose an installation location, and select the components to install. Activate the software: Once you have installed RSLogix 5000, you will need to activate the software. You can activate it online or by phone. Follow the activation instructions provided during the installation process. Configure the software: After activation, you will need to configure the software to connect to your hardware. Follow the instructions provided in the RSLogix 5000 user manual to configure the software. That's it! Once you have completed these steps, you should be ready to use RSLogix 5000 on your PC. Happy Support!
0
0
12
MS Bhatti
Mar 23, 2023
In Questions & Answers
The MBE (Modbus Ethernet) driver in Proficy iFIX is used to communicate with Modbus devices over an Ethernet network. Here are the steps to configure the MBE driver in Proficy iFIX: Open the iFIX WorkSpace and click on "Configure" from the menu bar. In the "Configure" window, click on "Drivers" in the left pane. In the "Drivers" pane, scroll down and select the "MBE" driver from the list. Click on the "Properties" button at the bottom of the window. In the "MBE Properties" window, configure the following settings: Driver Name: Enter a name for the driver. Port: Enter the Ethernet port number or IP address of the Modbus device you want to communicate with. Baud Rate: Select the baud rate that matches the Modbus device. Data Bits: Select the data bits that match the Modbus device. Parity: Select the parity that matches the Modbus device. Stop Bits: Select the stop bits that match the Modbus device. Timeout (seconds): Enter the amount of time the driver should wait for a response from the Modbus device. Retry: Enter the number of times the driver should retry the communication with the Modbus device before giving up. 6. Click on the "OK" button to save the MBE driver properties. 7. In the "Drivers" pane, select the "MBE" driver and click on the "Tags" button at the bottom of the window. 8. In the "Tags" window, click on the "Add" button to create a new tag. 9. In the "Add Tag" window, configure the following settings: Tag Name: Enter a name for the tag. Data Type: Select the data type that matches the Modbus device. Address: Enter the Modbus address of the tag. Size: Enter the number of words that the tag occupies. Access: Select the access level for the tag. 10. Click on the "OK" button to create the new tag. 11. Repeat steps 8-10 to create additional tags as needed. 12. Click on the "OK" button to save the tags. 13. Close the "Configure" window to finish the MBE driver configuration. Once the MBE driver is configured and the tags are created, you can use them in iFIX to read or write data to the Modbus device over the Ethernet network. Happy Support !
1
0
79
MS Bhatti
Mar 23, 2023
In Questions & Answers
Proficy iFIX is a popular SCADA (Supervisory Control and Data Acquisition) software used in various industries to monitor and control industrial processes. To take a backup and restore a project in Proficy iFIX, you can follow these steps: To take a backup: Open the iFIX Workspace. Click on the "Project" tab in the menu bar. Select "Backup/Restore" from the dropdown menu. In the "Backup/Restore" window, click on the "Backup" tab. Choose the project you want to backup from the list. Select a backup location and provide a name for the backup file. Click on the "Backup" button to start the backup process. Once the backup is complete, you will receive a confirmation message. To restore a backup: Open the iFIX Workspace. Click on the "Project" tab in the menu bar. Select "Backup/Restore" from the dropdown menu. In the "Backup/Restore" window, click on the "Restore" tab. Browse to the location of the backup file. Select the backup file and click on the "Restore" button. In the "Restore Project" window, choose the project destination directory. Click on the "Restore" button to start the restore process. Once the restore is complete, you will receive a confirmation message. It is important to note that before restoring a backup, ensure that the iFIX version matches the version of the backup file. Also, make sure to close the project before starting the backup or restore process to prevent any data loss or corruption. Happy Support !
1
0
7
MS Bhatti
Mar 21, 2023
In Questions & Answers
Here is a sample VB Script code that demonstrates how to insert data into an MS SQL database using ADODB connection: vbnetCopy code Dim conn Set conn = CreateObject("ADODB.Connection") ' Set the connection string for your SQL Server database conn.ConnectionString = "Provider=SQLOLEDB;Data Source=yourServerName;Initial Catalog=yourDatabaseName;User ID=yourUsername;Password=yourPassword;"' Open the database connection conn.Open ' Create an SQL INSERT statementDim sqlInsert sqlInsert = "INSERT INTO yourTableName (column1, column2, column3) VALUES ('value1', 'value2', 'value3')"' Execute the INSERT statement conn.Execute sqlInsert ' Close the database connection conn.Close ' Clean up the connection objectSet conn = Nothing In the code above, you need to replace the values for "yourServerName", "yourDatabaseName", "yourUsername", "yourPassword", "yourTableName", "column1", "column2", and "column3" with your own values that match your database setup. You can add more columns and values to the INSERT statement as needed, and use variables to dynamically insert data from your VBScript code. Note that this code assumes that you have already installed the SQL Server OLE DB Provider and have the necessary permissions to access and modify the database. Happy Support
1
0
4
MS Bhatti
Mar 21, 2023
In Questions & Answers
The process for restoring a license for Proficy iFix may vary depending on the specific circumstances, such as whether you have a backup of the license or not, and whether you are trying to restore a license for a new installation or an existing installation. Here are some general steps you can follow to restore a license for Proficy iFix: If you have a backup of the license, locate the backup file and copy it to the computer where you want to restore the license. If you don't have a backup, proceed to the next step. Contact your software vendor or GE Digital technical support to request a license file for your iFix installation. You may need to provide some information about your installation, such as the version of iFix and the computer name. Once you have received the license file, save it to a location on the computer where iFix is installed. Open the iFix License Manager from the Start menu or the iFix program group. In the License Manager, click the "Restore License" button. Browse to the location where you saved the license file and select it. Click the "Open" button to restore the license. After the license is restored, restart iFix for the changes to take effect. If you encounter any issues during the license restoration process, it may be helpful to consult the iFix documentation or contact technical support for further assistance. Happy Support
0
0
35
MS Bhatti
Mar 14, 2023
In Questions & Answers
To take a backup of a Microsoft SQL Server database, follow these steps: Open Microsoft SQL Server Management Studio and connect to your SQL Server instance. In the Object Explorer pane, right-click on the database you want to backup and select "Tasks" > "Back Up..." from the context menu. In the "Back Up Database" window, select the database you want to backup from the "Database" dropdown list. Choose the backup type you want to perform from the "Backup type" dropdown list. There are three types of backups: "Full," "Differential," and "Transaction Log." A full backup contains all the data in the database, a differential backup contains only the changes since the last full backup, and a transaction log backup contains all the changes made to the database since the last transaction log backup. Specify the backup destination by selecting the "Disk" option and providing a file path and name for the backup file. Optionally, you can configure additional backup options such as compression, encryption, and backup expiration. Click "OK" to start the backup process. Once the backup process is complete, you will have a backup file that you can use to restore the database if needed. It's important to regularly perform backups to ensure that you have a recent copy of your data in case of data loss or other issues. Happy Support!
1
2
43
MS Bhatti
Mar 14, 2023
In Questions & Answers
To create a customized table in MS SQL Server, follow these steps: Open Microsoft SQL Server Management Studio and connect to your SQL Server instance. Right-click on the database in which you want to create the table and select "New Query" from the context menu. In the new query window, type the following syntax to create a table: CREATE TABLE table_name ( column1 data_type constraints, column2 data_type constraints, ... columnN data_type constraints ); Replace table_name with the name of the table you want to create. Define the columns you want to include in the table, along with their data types and any constraints. For example, you might define a column with the INT data type and a NOT NULL constraint like this: CREATE TABLE Customers ( CustomerID INT NOT NULL, FirstName VARCHAR(50) NOT NULL, LastName VARCHAR(50) NOT NULL, Email VARCHAR(100) UNIQUE, Phone VARCHAR(20), Address VARCHAR(200), City VARCHAR(50), State VARCHAR(50), Zip VARCHAR(10) ); In this example, the Customers table includes columns for CustomerID, FirstName, LastName, Email, Phone, Address, City, State, and Zip. Execute the query by clicking on the "Execute" button in the toolbar or by pressing F5. Your new table should now be created in the database. You can verify this by expanding the Tables folder in the Object Explorer and looking for your table. Note that you may need to adjust the data types and constraints you use based on your specific needs and the data you plan to store in the table. Happy Support
0
0
3
MS Bhatti
Mar 14, 2023
In Questions & Answers
To import a table into MS Access, follow these steps: Open MS Access and the database in which you want to import the table. Click on the "External Data" tab in the ribbon at the top of the screen. Click on the "Import & Link" dropdown menu and select "Import Access Database." Browse to find the database that contains the table you want to import and select it. Choose the option to "Import tables, queries, forms, reports, macros, and modules into the current database." Select the specific table you want to import from the list of objects in the source database. Choose the location where you want to store the imported table within the current database. Click "OK" to complete the import process. After completing these steps, the table should be imported into your MS Access database and ready to use. Happy Support
1
0
4
MS Bhatti
Mar 14, 2023
In Questions & Answers
To import a table into MS Access, follow these steps: Open MS Access and the database in which you want to import the table. Click on the "External Data" tab in the ribbon at the top of the screen. Click on the "Import & Link" dropdown menu and select "Import Access Database." Browse to find the database that contains the table you want to import and select it. Choose the option to "Import tables, queries, forms, reports, macros, and modules into the current database." Select the specific table you want to import from the list of objects in the source database. Choose the location where you want to store the imported table within the current database. Click "OK" to complete the import process. After completing these steps, the table should be imported into your MS Access database and ready to use. Happy Support
0
0
0
MS Bhatti
Mar 14, 2023
In Questions & Answers
The Schneider M200 PLC Simulator is a software program that simulates the operation of the Schneider Electric M200 series programmable logic controller (PLC). This software allows users to create, test, and debug PLC programs without the need for actual hardware. To use the Schneider M200 PLC Simulator, follow these steps: Download and install the Schneider M200 PLC Simulator software on your computer. Launch the software and create a new project. You will be prompted to select the M200 series PLC model that you want to simulate. Use the software's interface to create a ladder logic program that you want to test. The software has a range of functions and instructions that you can use to create your program. Once you have created your program, you can simulate its operation by running the simulation mode. The simulation mode allows you to test your program's logic and functionality without the need for actual hardware. Monitor the simulation in real-time using the software's simulation tools. You can use these tools to view the status of inputs and outputs, view data tables, and monitor the program's execution. If you encounter any errors or issues during the simulation, use the software's debugging tools to diagnose and correct the problem. Once you have tested and debugged your program, you can save it and export it to a real M200 series PLC for actual hardware implementation. It's important to note that while the Schneider M200 PLC Simulator is a useful tool for testing and debugging PLC programs, it cannot fully replicate the behavior of real hardware. Therefore, it's still essential to thoroughly test and validate your program on actual hardware before implementing it in a real-world environment. Happy Support
0
0
6
MS Bhatti
Mar 14, 2023
In Questions & Answers
To use a PC-based HART communicator to configure a VegaPuls 64 radar gauge, you will need the following: PC-based HART communicator software: There are various types of software available for this purpose, such as PACTware, HART Communicator, and FieldCare. You can choose any software that is compatible with your PC and has the necessary communication protocols for your gauge. HART modem: You will need a HART modem to connect your PC to the VegaPuls 64 radar gauge. The modem should be compatible with your PC and have a HART communication protocol. Connection cables: You will need to connect the HART modem to the VegaPuls 64 radar gauge using the appropriate connection cables. The cables should be compatible with your modem and gauge. VegaPuls 64 radar gauge manual: You will need the manual for the VegaPuls 64 radar gauge to understand its configuration parameters and other details. Once you have all the necessary equipment and software, you can follow these steps to configure your VegaPuls 64 radar gauge: Connect the HART modem to your PC and install the necessary drivers. Connect the HART modem to the VegaPuls 64 radar gauge using the appropriate connection cables. Open the PC-based HART communicator software on your PC. In the software, select the HART modem and the VegaPuls 64 radar gauge. Enter the device address of the VegaPuls 64 radar gauge in the software. You can find this address in the manual. Once the software establishes a connection with the VegaPuls 64 radar gauge, you can start configuring it using the various parameters listed in the manual. Save the configuration changes and disconnect the HART modem from the VegaPuls 64 radar gauge and PC. It's important to note that you should only attempt to configure your VegaPuls 64 radar gauge if you have the necessary knowledge and training in using PC-based HART communicator software and radar gauge configuration. If you're not sure, it's best to consult a professional or the gauge manufacturer for assistance. Happy Support
0
0
9
MS Bhatti
Mar 14, 2023
In Questions & Answers
To check data on Modbus via Modscan, follow these steps: Download and install Modscan from the internet. Connect your Modbus device to your computer using a serial or Ethernet cable. Open Modscan and click on "File" -> "New." In the "New Project" dialog box, select your connection type (serial or Ethernet) and enter the necessary details (such as the COM port or IP address). Click "OK" to create the new project. Click on "Communication" -> "Connect" to establish a connection with the Modbus device. In the "Data Table" section, select the type of data you want to read (such as input registers or holding registers). Enter the starting address and the number of registers you want to read. Click on "Read" to read the data. The data will be displayed in the "Data Table" section. You can also write data to the Modbus device by selecting the "Write" option and entering the data you want to write. When you are finished, click on "Communication" -> "Disconnect" to close the connection. Note: Modscan is a powerful tool for testing and troubleshooting Modbus devices. However, it's important to use it carefully and follow the manufacturer's guidelines to avoid damaging the device or causing other problems. Happy Support
0
0
18
MS Bhatti
Mar 14, 2023
In Questions & Answers
This is a helpful topic for the Users of Advance Vessel ERP Interface System of Advance Engineers To compact and repair an MS Access database, follow these steps: Close the database and make a backup copy of it. It's always a good idea to make a backup before performing any database maintenance. Open Microsoft Access and click on the "File" tab. Click on "Info" and then click on "Compact & Repair Database." In the "Compact & Repair Database" dialog box, navigate to the database you want to compact and repair. Click on the "Compact" button to start the process. This may take some time depending on the size of the database. Once the process is complete, you will see a message confirming that the database has been compacted and repaired. Click on "OK" to close the message box. Close and reopen the database to ensure that everything is working properly. Note: It's recommended to perform this maintenance task regularly to keep the database running smoothly. Happy Support
1
0
21
MS Bhatti
Sep 23, 2022
In General Discussion
Hi We are regularly updating our Advance TFMS System . I Am looking for suggestions how we can improve on the same , so that the software is more useful to you.
0
0
5
MS Bhatti
Feb 05, 2022
In General Discussion
Welcome to the Advance Engineers Online Forum! We are excited to launch this new forum where our community of professionals and experts can come together to share knowledge and discuss industry topics. Here you can ask questions, answer queries, and engage in meaningful conversations. Our goal is to provide a platform where everyone can benefit from the collective knowledge of our community. Whether you’re a novice or an experienced professional, we’ll have something for everyone. With a wide range of topics and categories, you can find the answers you need quickly and easily. In addition to the discussions, we’ll also have regularly updated content from our experts, giving you the latest insights and trends in the industry. We also host regular webinars and events for our members, so you can stay up to date on the latest developments. Share your thoughts. Feel free to add GIFs, videos, #hashtags and more to your posts and comments. Get started by commenting below.
1
0
5
MS Bhatti
Feb 05, 2022
In General Discussion
Welcome to Advance Engineers' Forum! We are a group of passionate engineers and professionals who are dedicated to making the world a better place through the exchange of knowledge. Our forum is open to everyone, no matter your experience level or expertise. From experienced professionals to students and hobbyists, we welcome all to join us and contribute to our knowledge base. We invite you to start the conversation by introducing yourself and sharing your background and experience. With the power of collective knowledge, we can create a vibrant and dynamic community that is poised to make a real difference in the world.
1
0
3
MS Bhatti
Feb 05, 2022
In General Discussion
We want everyone to get the most out of this community, so we ask that you please read and follow these guidelines: Please follow these Rules ✅ Be Kind and Courteous We're all in this together to create a welcoming environment. Let's treat everyone with respect. Healthy debates are natural, but kindness is required. ✅ No Hate Speech or Bullying Make sure everyone feels safe. Bullying of any kind isn't allowed, and degrading comments about things like race, religion, culture, sexual orientation, gender or identity will not be tolerated.
1
0
4

MS Bhatti

Admin
More actions
bottom of page