Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Write/Store Data as table in WinCC

Created by: Karls1 at: 5/16/2014 2:14 AM (13 Replies)

Rating (2)

Thanks 3

Result pages:: |; 1 | 2; |

14 Entries

Entries per page: 10 | all

5/16/2014 2:14 AM	Rate (0)
Karls1 Posts: 139 Rating: (5)	Dear Experts, as subject mentoned, is it possible in WinCC? i want to write some data record in WinCC and also with editing possibility. Any links or samples? thanks!
Karls1 Posts: 139 Rating: (5)
Suggestion To thank Quote Answer

5/16/2014 9:30 AM	Rate (0)
Madhava Silver Member Joined: 11/26/2011 Last visit: 6/29/2023 Posts: 508 Rating: (23)	Can you put more detail in that ? What exactly you want to do ? I think this is what you want User Archive

Suggestion To thank Quote Answer

5/16/2014 10:51 AM	Rate (0)
Komi Posts: 291 Rating: (69)	C.kt Dear Experts, as subject mentoned, is it possible in WinCC? i want to write some data record in WinCC and also with editing possibility. Any links or samples? thanks! Hi C.kt, I saw you've written "write/Store Data as table in WinCC" as subject. But I would like to suggest you to take use of other format of DataSource such as Access .mdb file or so on. That will be more easier. BTW, ~ just asking curiously: Do you mean that you want to have a DataGrid or XLS_Spreadsheet or somthing similar to show your recordset in Runtime & user can modify its value from RT interface? Best regards, Komi
Komi Posts: 291 Rating: (69)
Suggestion To thank Quote Answer

5/18/2014 12:58 AM	Rate (0)
Karls1 Posts: 139 Rating: (5)	Komi C.kt Dear Experts, as subject mentoned, is it possible in WinCC? i want to write some data record in WinCC and also with editing possibility. Any links or samples? thanks! Hi C.kt, I saw you've written "write/Store Data as table in WinCC" as subject. But I would like to suggest you to take use of other format of DataSource such as Access .mdb file or so on. That will be more easier. BTW, ~ just asking curiously: Do you mean that you want to have a DataGrid or XLS_Spreadsheet or somthing similar to show your recordset in Runtime & user can modify its value from RT interface? Best regards, Komi Dear Komi, Exactly, i like to store Data (record set) based on User Key-In and User Can Modify from RT interface whenever necessay. I didn't install microsoft offices in client and i will need somthing similar to show my record set. Any ideas or samples will be great for me. Many Thanks in advance.
Karls1 Posts: 139 Rating: (5)
Suggestion To thank Quote Answer

5/18/2014 6:28 AM	Rate (1)
S7 AUTOMAN Posts: 515 Rating: (56)	C.kt Dear Experts, as subject mentoned, is it possible in WinCC? i want to write some data record in WinCC and also with editing possibility. Any links or samples? thanks! hello, How do you export as a CSV file process values displayed in WinCC Online Trend Control? or somethingelse?
S7 AUTOMAN Posts: 515 Rating: (56)
Suggestion To thank Quote Answer

5/18/2014 7:08 AM	Rate (0)
Saggy Silver Member Joined: 11/8/2011 Last visit: 11/5/2024 Posts: 387 Rating: (43)	C.kt Dear Experts, as subject mentoned, is it possible in WinCC? i want to write some data record in WinCC and also with editing possibility. Any links or samples? thanks! hi, Which appliaction you are using?? is it for receipe then User archive you can go for find here manual Hope this helps

Suggestion To thank Quote Answer

5/19/2014 1:52 PM	Rate (0)
PPPD Advanced Member Joined: 7/19/2008 Last visit: 9/10/2024 Posts: 60 Rating: (8)	I UNDERSTAND YOU ARE LOOKING OUT TO FETCH THE ONLINE DATA IN TO SOME TABULAR FORMAT FROM WINCC. THIS CAN BE DONE USING EXCEL AND THE DATA CAN BE IMPORTED TO EXCEL AS A TABLE USING GLOBAL SCRIPT. I MEAN WE NEED TO WRITE GLOBAL ACTION AND THE THERE HAS TO BE A TRIGGER TIME DEFINED WHEN THE DATA TO BE FETCHED FROM THE WINCC. THIS IS VERY EASY ...... HOPE YOU LOOKING FOR SOMETHING LIKE THIS.

Suggestion To thank Quote Answer

5/19/2014 3:19 PM	Rate (0)
Saggy Silver Member Joined: 11/8/2011 Last visit: 11/5/2024 Posts: 387 Rating: (43)	PPPD I UNDERSTAND YOU ARE LOOKING OUT TO FETCH THE ONLINE DATA IN TO SOME TABULAR FORMAT FROM WINCC. THIS CAN BE DONE USING EXCEL AND THE DATA CAN BE IMPORTED TO EXCEL AS A TABLE USING GLOBAL SCRIPT. I MEAN WE NEED TO WRITE GLOBAL ACTION AND THE THERE HAS TO BE A TRIGGER TIME DEFINED WHEN THE DATA TO BE FETCHED FROM THE WINCC. THIS IS VERY EASY ...... HOPE YOU LOOKING FOR SOMETHING LIKE THIS. Hi, Is it possible to share global script with example project Thanks in advance

Suggestion To thank Quote Answer

5/20/2014 6:03 AM	Rate (0)
PPPD Advanced Member Joined: 7/19/2008 Last visit: 9/10/2024 Posts: 60 Rating: (8)	A sample script is as follows..... Sub OutputValue_OnPropertyChanged(ByVal Item, ByVal value) Dim a Dim i,M2_MODE, M3_MODE,M4_MODE, DEL Dim objExcelApp Dim fso Dim fso1, f,fName 'Write the operating mode(A:Auto/ M:Manual) into variables M2_MODE,M3_MODE,M4_MODE 'If HMIRuntime.Tags("CONTROL_WORD").Read And 2 Then 'M2_MODE= "A" 'Else 'M2_MODE= "M" 'End If ' 'If HMIRuntime.Tags("CONTROL_WORD").Read And 4 Then 'M3_MODE= "A" 'Else 'M3_MODE= "M" 'End If ' 'If HMIRuntime.Tags("CONTROL_WORD").Read And 262144 Then 'M4_MODE= "A" 'Else 'M4_MODE= "M" 'End If '*********************************************************************************** Set fso = CreateObject("Scripting.FileSystemObject") 'Check whether working file (BATCH_REPORTS.xls) exists If (fso.FileExists("D:\BATCH_REPORT.xls")) Then 'Check whether working file (BATCH_REPORTS.xls) exists Else 'If working file (BATCH_REPORTS.xls) does not exists then create it Set objExcelApp = CreateObject("Excel.Application") objExcelApp.Visible = False 'Open the Template (Read only & Hidden file on the mentioned path) objExcelApp.Workbooks.Open "D:\BATCH_REPORT.xlt" objExcelApp.DisplayAlerts = False 'Save the template as working file (BATCH_REPORTS.xls) objExcelApp.ActiveWorkbook.Saveas"D:\BATCH_REPORT.xls" objExcelApp.DisplayAlerts = False objExcelApp.Workbooks.Close objExcelApp.Quit Set objExcelApp = Nothing End If '********************************************************************************** i=value 'i = Batch count If i>0 Then i=value+7 'Excel sheet row number Set objExcelApp = CreateObject("Excel.Application") objExcelApp.Visible = False objExcelApp.Workbooks.Open "D:\BATCH_REPORT.xls" 'Set internal tag "script_run" =1 to hide the intermmediate reports button HMIRuntime.Tags("script_run").Write 1 'Write the data into excel sheet objExcelApp.Cells(i,1).Value =Date() objExcelApp.Cells(i,2).Value =Time() objExcelApp.Cells(i,3).Value =value '****** FLYSH ******** objExcelApp.Cells(i,4).Value =HMIRuntime.Tags("SP_M2_COMP.2").Read 'objExcelApp.Cells(i,5).Value =HMIRuntime.Tags("SP_M2_COMP.2").Read objExcelApp.Cells(i,5).Value =HMIRuntime.Tags("ACT_FLYASH_QTY").Read '****** CEMENT ******** objExcelApp.Cells(i,6).Value =HMIRuntime.Tags("SP_M2_COMP.3").Read 'objExcelApp.Cells(i,8).Value =HMIRuntime.Tags("SP_M2_COMP.3").Read objExcelApp.Cells(i,7).Value =HMIRuntime.Tags("ACT_CEMENT_QTY").Read '****** CELLULOSE ******** objExcelApp.Cells(i,8).Value =HMIRuntime.Tags("SP_M3_COMP.3").Read 'objExcelApp.Cells(i,11).Value =HMIRuntime.Tags("SP_M3_COMP.3").Read objExcelApp.Cells(i,9).Value =HMIRuntime.Tags("ACT_CELLULOSE_QTY").Read '****** PIGMENT ******** objExcelApp.Cells(i,14).Value =HMIRuntime.Tags("SP_M3_COMP.4").Read 'objExcelApp.Cells(i,20).Value =HMIRuntime.Tags("SP_M3_COMP.4").Read objExcelApp.Cells(i,15).Value =HMIRuntime.Tags("ACT_PIGMENT_QTY").Read '****** WALLOSTONITE ******** objExcelApp.Cells(i,10).Value =HMIRuntime.Tags("SP_M3_COMP.5").Read 'objExcelApp.Cells(i,14).Value =HMIRuntime.Tags("SP_M3_COMP.5").Read objExcelApp.Cells(i,11).Value =HMIRuntime.Tags("ACT_WALLT_QTY").Read '****** SAND ******** objExcelApp.Cells(i,12).Value =HMIRuntime.Tags("SP_M3_COMP.6").Read 'objExcelApp.Cells(i,17).Value =HMIRuntime.Tags("SP_M3_COMP.6").Read objExcelApp.Cells(i,13).Value =HMIRuntime.Tags("ACT_SAND_QTY").Read 'objExcelApp.Cells(i,16).Value =HMIRuntime.Tags("SP_M4_COMP.2").Read 'objExcelApp.Cells(i,17).Value =HMIRuntime.Tags("ACT_SOD_BENTONITE").Read 'objExcelApp.Cells(i,18).Value =HMIRuntime.Tags("SP_M4_COMP.3").Read 'objExcelApp.Cells(i,19).Value =HMIRuntime.Tags("ACT_AL_HYDROXIDE").Read '****** NT COMP. ******** objExcelApp.Cells(i,16).Value =HMIRuntime.Tags("SP_M3_COMP.2").Read 'objExcelApp.Cells(i,23).Value =HMIRuntime.Tags("SP_M3_COMP.2").Read objExcelApp.Cells(i,17).Value =HMIRuntime.Tags("ACT_NTCOMP_QTY").Read '****** MODE(A:AUTO / M:MANUAL) ********** 'objExcelApp.Cells(i,25).Value =M2_MODE 'objExcelApp.Cells(i,26).Value =M3_MODE 'objExcelApp.Cells(i,27).Value =M4_MODE 'Write the Batch count into 110'th row & 8'th column objExcelApp.Cells(110,8).Value =HMIRuntime.Tags("BATCH_COUNT").Read objExcelApp.DisplayAlerts = False objExcelApp.ActiveWorkbook.Save objExcelApp.DisplayAlerts = False objExcelApp.Workbooks.Close objExcelApp.Quit Set objExcelApp = Nothing 'Reset the internal tag "script_run" to unhide the intermmediate reports button HMIRuntime.Tags("script_run").Write 0 End If End Sub

Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Saggy

5/22/2014 9:57 AM	Rate (1)
Komi Posts: 291 Rating: (69)	C.kt Komi C.kt Dear Experts, as subject mentoned, is it possible in WinCC? i want to write some data record in WinCC and also with editing possibility. Any links or samples? thanks! Hi C.kt, I saw you've written "write/Store Data as table in WinCC" as subject. But I would like to suggest you to take use of other format of DataSource such as Access .mdb file or so on. That will be more easier. BTW, ~ just asking curiously: Do you mean that you want to have a DataGrid or XLS_Spreadsheet or somthing similar to show your recordset in Runtime & user can modify its value from RT interface? Best regards, Komi Dear Komi, Exactly, i like to store Data (record set) based on User Key-In and User Can Modify from RT interface whenever necessay. I didn't install microsoft offices in client and i will need somthing similar to show my record set. Any ideas or samples will be great for me. Many Thanks in advance. Hello C.kt, Now my emphasis is to test WinCC-RT interface for inputting. It seems quite a possibility by taking use of MSFlexGrid as shown in the attachment. But in consideration of the problematic registration of MSFlexGrid control (.ocx) in a Win7 64-bit platform, I'm thinking that maybe I should take use of an OWC Spreadsheet insteading of MSFlexGrid. Would you please give me an example of the "DataSorce" you're going to read/write in such as .xls or .mdb format ? As well as ~ the OS & WinCC version you're using. Then ~ I'll try to make you a sample project :-) Best regards, Komi Attachment FakingInput_onMSFlexGrid.JPG (548 Downloads)
Komi Posts: 291 Rating: (69)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Karls1

|

Share this page:

Share this page on...

Related topics by keywords:

WinCC Installation Options General

Follow us on