Previous in Forum: Camcorder as a cam to VoIP   Next in Forum: Thermocouples
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
3 comments
Rate Comments: Nested
hanyragab
Participant

Join Date: May 2007
Location: Cairo- Egypt
Posts: 2

scada data base

05/27/2007 3:35 PM

hello all

i have a scada system done by SIEMENS PLC step7 300 and my SCADA was programmed by WINCC flexible2005 advanced.

my problem is the following :

i want to build a data base using access or excel to record, display and print variables' values of my system

important for me

thank u

hany
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
Richard L
Power-User
United States - Member - USA Engineering Fields - Control Engineering - Never enough money

Join Date: Feb 2007
Location: Oregon
Posts: 292
Good Answers: 4
#1

Re: scada data base

05/27/2007 6:19 PM

I don't have the software myself but maybe this will spark a thought or two.

https://support.automation.siemens.com/WW/llisapi.dll?csquery0=excel&aktprim=0&extranet=standard&func=cslib.csinfo&lang=en&nodeid0=16502790&objaction=csbrowse&objid=16502790&siteid=cseus&subtype=133000
Register to Reply
GM1964
Guru

Join Date: Jan 2007
Location: Edinburgh, Bonnie Scotland
Posts: 1335
Good Answers: 23
#2

Re: scada data base

05/28/2007 5:30 AM

The SCADA data is stored in a CSV (comma separated variable) file, which can be imported into Excel by declaring the starting cell & automatic fill either down or across (check settings).

__________________
 Madness is all in the mind
Register to Reply
chrisg288
Guru
Engineering Fields - Electromechanical Engineering - Technical Services Manager Canada - Member - Army brat Popular Science - Cosmology - What is Time and what is Energy? Technical Fields - Architecture - Draftsperson Hobbies - RC Aircraft - New Member

Join Date: Sep 2006
Location: Clive, Alberta, Canada
Posts: 5916
Good Answers: 204
#3

Re: scada data base

05/28/2007 10:28 AM

I'm currently spending a fair bit of time working with excel and vba, so maybe in my spare time (lol) I could help you out. chrisg288@hotmail.com

I also have done data projects with control systems before when I worked for Johnson Controls. If the data is csv, then I wouldn't need to know much about the software you are using.

Chris
Register to Reply
Register to Reply
Have a Different Question?
3 comments
Copy to Clipboard

Users who posted comments:

chrisg288 (1); GM1964 (1); Richard L (1)

Previous in Forum: Camcorder as a cam to VoIP   Next in Forum: Thermocouples

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Communications & Electronics:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (152 right now)
Show Members
Advertisement