Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

vbscript to connect to wincc archive data

Created by: praveen.pg at: 1/28/2009 6:09 AM (2 Replies)

Rating (0)

Thanks 1

3 Entries

1/28/2009 6:09 AM	Rate (0)
praveen.pg Posts: 5 Rating: (0)	hi.....please dont mind if i am boring you. I am new to VB and VBScript as well as Wincc v6.2. my job is to get archive data(tag logging archive) from wincc database and to store it in Excel sheet. can anybody provide me the full code how to connect (connection string) to wincc from vbscript and getting data from it and then generating excel sheetand to export the retrieved data into the excel file. actually what i need is to get the values of various tags between a time interval.so i need to create a form(Vb form) that asks like this... Enter start time---------------------------- Enter end time---------------------------- Select which report you need::1)minute report 2)hourly report. Click on the followingbutton(s) to generate excel report. DG1button1 DG2button2 DG3button3 MTpanel1btn4 MTpanel2btn5 Mtpanel3button6 the above is the sample form i need.so first 1) i will enterthe start time and end time(example::start time:9 and end time:10). 2)using a check box i will select minute report(actually here the setup is for every one minute the tag values are entered into the wincc).so in out put, recordsshould be displayed with times like : 9.00, 9.01,9.02...............9.59 and with appropriate values for varoius tags(ex:-KWH, HZ, MVRH...and so on). 3)and i will click onone button shown above(dg1,dg2,...........). so depending on my input data(1).timings 2).report type 3).for which device i need report(buttons represent devices) the output should be generated in an excel file .so further the client cal view excel sheet and then process the data. so can anyone please tell me the procedure to create the form and actions to write when submitting the form.importantly how to connect to wincc databese( i need exact syntax)and to generate excel sheet dynamically with retrieved data. so i can gethike for my job if any one help me. thanks and regards praveen.
praveen.pg Posts: 5 Rating: (0)
Suggestion To thank
This contribution was helpful to 1 thankful Users Smita Gadade

1/28/2009 8:44 PM	Rate (0)
Prog-Ana Posts: 7 Rating: (2)	I did archiving program for pcs7. I used C#.net 1- I connect with sqlserver Ado.net. 2- use this function to decompressed the data 3- The function is working well and the number is correct , and you can call the function directly by using select * from fn_cctlg_GetValuesByID(1,'10/25/2008 00:00:00','10/25/2008 01:00:00') under sql server. The problem was there is shifting 6 hr. so that is made the confilict between the function report and xlreporter report because there is a 6 hr shifting .My boss said it's GMT problem. 4- for excel you can call this function by Execute("Select ....") after connecting with the db. Best wishes, Prog_Ana; Attachment getvaluefunction.zip (660 Downloads)
Prog-Ana Posts: 7 Rating: (2)	Last edited by: Prog-Ana at: 1/28/2009 8:55 PM
Suggestion To thank

1/28/2009 11:20 PM	Rate (0)
CS Moderator Moderator Joined: 9/1/2005 Last visit: 1/22/2025 Posts: 4114 Rating: (195)	closed cause question posted twice. The second thread with the subject wincc to excelis published within the same conference . Best regards CS Moderator
	My Forum is the place to personalize your profile, track your topics, and maintain content that interests you. Best regards CS Moderator
Suggestion To thank

|

Share this page:

Share this page on...

Follow us on