SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

SQL on VBScript for 1200 Comfort Panel

8/22/2022 8:19 PM	Rate (0)
Siemens_Repair_Man Posts: 10 Rating: (0)	Guys, I have 1200 Comfort Panel. I created csv file with some data in it. I would like to write SQL in VBScript to query the data on csv file. Could you please show me how to make just simpliest one like SELET * FROM ____.csv. That is it. I need to know how to approach to use SQL in VBScript for 1200 Comfort panel Thank you in advance
Siemens_Repair_Man Posts: 10 Rating: (0)
Suggestion To thank Quote Answer

8/23/2022 3:54 PM	Rate (0)
rdoliveira Platinum Expert Joined: 4/26/2012 Last visit: 1/9/2026 Posts: 1657 Rating: (191)	Hi, if you can detail more what you want to do. Is a TP1200?. SQL commands you will use with a database, there are more things that influence, I tested something with Professional PC. In a .csv you will have to use VBscript commands to open the file and read the data. take a look at this if it helps you. LINK LINK good luck
	Last edited by: rdoliveira at: 08/23/2022 16:11:40 Last edited by: rdoliveira at: 08/23/2022 16:21:30 "Always make a backup before performing any tests and check the best time to do so. Obrigado.
Suggestion To thank Quote Answer

8/29/2022 8:30 AM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 1/16/2026 Posts: 16644 Rating: (1944)	Hello Siemens_Repair_Man with SQL Commands you can only work if you communicate with a SQL Server or database. Comfort Panels cannot connect to a SQL Server Database, only PC based systems! to read out csv File you can use VB Script on the Panel but not with SQL Syntax: https://support.industry.siemens.com/cs/ww/en/view/59604194 bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer