Data logging in SQL and Reporting in TIA Portal V15 - WinCC Runtime Advance

#WinCC #SQL #Reporting #DataLogging #insert
Check out our affiliate - Discount on Earbuds : amzn.to/3YzMtQV
Reporting tool with Data logging into SQL - for TIA Portal V15 - WinCC Runtime Advance.
This Video demonstrates a tool for generating report based on user defined time interval.
In first part of the video , VBScript is created to insert data into SQL server.
in Second part , data are retrieved from SQL and generated report using Reporting tool.
Link for VB Script to insert into SQL : stableautomatio...
Link for TIA portal V15 Demo project used in Video : stableautomatio...
Contact : [e-mail] for more information / activation / buy this the tool.
Reporting tool Version 2 is available : • SCADA Reporting Tool (...
Check out other training videos:
Siemens Software License - Online software Delivery / OSD
• Siemens OSD - Online S...
S7 200 PLC data over OPC DA - PC Access SMART
• S7 200 PLC data over O...
Siemens LOGO PLC as Modbus TCP Client
• Siemens LOGO PLC as Mo...
Synchronize Siemens HMI time with S7 PLC using Area Pointer
• Synchronize Siemens HM...
S7 200 SMART Analog Input scaling (Applicable for SMAI04 / AI08 / AM03 / AM06)
• Synchronize Siemens HM...

[@urmilabenbhatt6764]

Very intelligent Bhargavmama

[@adlimusthaqeem6677]

Hi, how to include the date time each time the data is insert into the sql?

[@kenankalayc7271]

sorry but i want to ask something. why everybody told about write value to sql by a button ? data loging should be working only button or automaticly from any tag ? from the input or output ?

[@StableAutomation]

That is for demo. Automatically is possible by scheduling event.

[@kenankalayc7271]

@@StableAutomation i mean from the digital input. scheduling yes its possible but another kind i can not found it. for exaple İf %i0.1 active then the 3 value write once to sql . i have cheked the simens support page but i can not see anything

[@StableAutomation]

@@kenankalayc7271 in your HMI tags , select your DI , then properties - Events - value change and select your VB script name in add function.
Note that it will trigger from every value change

[@kenankalayc7271]

@@StableAutomation yest its not reacted sorry digital input, int word real or another its not reacted. have reacted only io numerical input but its nothing thanks.

[@vargheseeralil8346]

Hi, I have purchased the VB Script but it has been displayed to me in an unreadable pdf format. I will share my receipt number. Can you please send me the script in proper form.

[@StableAutomation]

hi, thanks for your purchase. Please share your email id / number. I will check and share by mail

[@TheTIAHUB]

Sir pls explain how are you showing date and time

[@amitkaushik362]

My SQL Datalogging started but Reporting tool is showing error (Run Time error '50290') while generating report , please resolve

[@StableAutomation]

Open config.ini file with notepad , and make sure all paths are correctly defined.

[@amitkaushik362]

All paths are correct as per your video ,but in my case Excel File shows run time error after pressing generate ,after clicking ok excel open but no data is there

[@jorgematassanz5169]

Hi. Can you create the database and table directly from Management Studio or do you need the reporting tool to create them? I have followed your steps but the data is not being inserted into the table...

[@StableAutomation]

From reporting tool itself you can create database and table, in the reporting tool add your server name and then press create database and create table button

[@industrialtechnologies8915]

yes you can create from management studio.

[@vijaysridhar9063]

When i am clicking insert button data is not stored in SQL table and no error

[@StableAutomation]

Have you created database and table from reporting tool provided ? Then same script should work.
If you are using different tage names , make sure your SQL column names are correct in script.
Even a single mistake will not let you insert data.
So check throughly

[@aliosmantopkan8339]

'Define Variable of script
Dim FolderWay,ObjectWay,FileName,File,FileExist,Apendix,Row
'Define folder way
FolderWay = "C:\Users\User\Desktop\TEST\ExcelExample.xlsx"
'Creating of object containing way to folder
Set ObjectWay = CreateObject("Scripting.FileSystemOject")
'If folder no exist,create it
If Not ObjectWay.FolderExists(FolderWay) Then
ObjectWay.CreateFolder FolderWay
End If
'Define File name
FileName = "TEST_eXCEL_File.csv"
'Create new object to control file existence
Set File = CreateObject("Scripting.FileSystemObject")
'Check if file exist in defined folder way
FileExist = File.FileExists(FolderWay & "\" & FileName)
If FileExist = False Then

'Create file
File.CreateTextFile(FolderWay &"\"& FileName)

'Set apendix of excel file
Set Apendix = File.OpenTextFile(FolderWay &"\"& FileName,8)

Apendix.WriteLine("Data 1 ; Data 2 ; Data 3 ; Data 4 ; Data 5 ; Data 6 ")

Apendix.Close

'Clear Object
Set File = Nothing

End If
Set File = CreateObject("Scripting.FileSystemObject")
Set Row = File.OpenTextFile(FolderWay & "\" & FileName, 8)
Row.WriteLine( SmartTags("E_1") &";"& SmartTags("E_2") &";"& SmartTags("E_3") &";"& SmartTags("E_4") &";"& SmartTags("E_5") &";"& SmartTags("E_6"))

Row.Close Merhaba bu şekilde Script yazdım klasör oluşmuyor nadeni nedir?

[@tarunsharma8010]

what is this reporting tool ? have you created a little application of your own???
if yes its in which language?

[@StableAutomation]

It's tool that I have created in VB ,

[@apmvillageviewers4015]

I can't download the reporting tool. Because the link is not opening....can you help me

[@StableAutomation]

Plz check again. I have checked and all links are working fine.

[@vijaysridhar9063]

I am getting an error when I generate "Each group by expression must contain at least one column that is not an outer reference.

[@StableAutomation]

first you need to generate database, Table and column prior to generate report. Make sure database, Table and coulm name are identical in your SQL and reporting tool.

[@firdausimax2537]

hello sir, may i know how you insert date and time in sql table column if using vb script (not the reporting tool that you created)

[@StableAutomation]

create a column with data type DATETIME and value NOT NULL DEFAULT(GETDATE())

[@pavankumar-pt6vk]

@@StableAutomation I used datetime as not null even though datetime not inserting.

[@industrialtechnologies8915]

@@pavankumar-pt6vk not only null but DEFAULT(GETDATE()) put also this into property

[@TheCompany2024]

All very interesting, but the resolution of the clip is so bad I can't read anytjing. Pitty !

[@sumita4187]

I want to know how you have created the Reporting tool to restore the values from server.Its very urgent.Can you make a video on that

[@StableAutomation]

We have created using Visual Basic.
If you require , kindly send details on [e-mail].
We can create customised reporting tool.

[@shankarjadhav4737]

Hi
Want save report in pen drive using HMI please guide me

[@aliosmantopkan8339]

Merhaba v15 demo proje ve komut dosyası için kaç USD ödememiz gerekli ve Banka IBAN No verirmisiniz

[@ardaarsen]

Hmm interesting. I have created an excel add-in instead and didnt do any vbscript with scada

[@StableAutomation]

Are you fatching data from trend logs ?

[@binitkumar8867]

I am pay 100 rupees for VB Script to insert into SQL but how to find

[@StableAutomation]

@@binitkumar8867 your payment is confirmed. I will send you code by mail

[@utsavsankhari9470]

@@StableAutomation mine is confirmed send mine

[@StableAutomation]

@@utsavsankhari9470 generally page redirects after successful payment. If it has not , send your mail id registered during payment, I will check and send you the code.

[@StableAutomation]

@@utsavsankhari9470 plz check your email.

[@bociltusun586]

can you give scrip for the reporting tool?

[@StableAutomation]

We can develop tool for you if required. Plz check this latest version - th-cam.com/video/tyOM2M1jCNM/w-d-xo.html

[@bociltusun586]

@@StableAutomation, in the meantime I want to learn the script. can you share the script?

[@arunthangaraj8364]

Hi posted a tutorial video for others why you hiding the script.its distruibing

[@StableAutomation]

You can download readymade script by paying very small amout. Plz Check in video description.
Those who are interested are paying and downloading.

[@tarunsharma8010]

DO i need to install separate SQL server or the bundled one in enough ?
as in my installation of TIA portal its server 2014 version whereas in your video its 2012

[@StableAutomation]

Its OK , sql server version comes with TIA , you night have newer version , V15/ V15.1 i guess

[@christopherimantaka4153]

what is the password for Reporting tool settings ?

[@StableAutomation]

abc - for going into settings

[@aliosmantopkan8339]

Merhaba banka ıban numarası verirmisiniz

[@StableAutomation]

do you require reporting tool for TIA Portal ?

[@vijaysridhar9063]

How to insert date in SQL using Tia Portal vb script

[@StableAutomation]

Plz check this video : th-cam.com/video/ThGKjXjiFGg/w-d-xo.html

[@truongchau7040]

You can insert datetime by SQL Data (Default value or Biding : GetDate())

[@hichemlabib1876]

check your email please

[@StableAutomation]

I have replied. Plz check