×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Saving values to external file

Saving values to external file

Saving values to external file

(OP)
I have two questions:

1.  Using a Micrologix 1000, can I turn on and off certain functions based on the time of day?  I've searched for a clock function to use and am coming up empty-handed.

2.  At the end of each day I would like to transfer information from my counters and timers to an external excel spreadsheet/database.  Is this possible and how can I get started?

Any help is appreciated.

Thank you,

Ty

RE: Saving values to external file

I'm not familiar with Micrologix 1000, but with other AB PLC's  you can set up DDE links in you spreadsheet to read specific registers through RSLinx.  Another other option invovles custom VB program with OPC or DDE link to data files.

RE: Saving values to external file

The lowest AB processor with a real time clock is the ML1200, and you must buy and install a 1762-RTC module. For data collection in Excel you must have something other than RsLinx lite, the lite version doesn't support DDE or OPC.

You might find some interesting examples here:
http://forums.mrplc.com/index.php?dlcategory=3

RE: Saving values to external file

If you have to trasfer data to an excel sheet, then you can use Excel's VBA to get the computer's date and time.  When you transfer data to excel, it will create a 'change' event where you can move the date and time values into some PLC registers and keep track of the time in the PLC by monitoring these values.

To transfer data to/from excel, you set up DDE or OPC topics up in RSLinx.  I think you need RSLinx Professional to use OPC and DDE.

Hope this helps.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources