FightingMongoose

MrPLC Member
 View profile  See their activity

  • Content count

    7

  • Joined

  • Last visited

Posts posted by FightingMongoose

  1. Posted

    It is GE PLC. The excel route is what I was hoping for, but I'm new to using GE plcs and can't seem to find any information on how to setup excel to force the registers.

  2. Posted

    Hi All,

    Bit of a noob here. I started a new project where the client is upgrading their SCADA system, and as such every discrete needs to be toggled, and every analog range needs to be tested.

    I've created an excel database with every register, however, changing the value in the tag is too manual for me and I'm trying to find a way to increase the automation.

    I am looking for a solution where I can write directly with the tags instead of fumbling through the horror which is Proficy. I've seen some mentions of using the trial version of Ignition but I am struggling to get that to a useable state. 

     

    Any ideas greatly appreciated.

  3. Posted

    I ended up making an excel macro to do it for me - worked on my test plc.

     

    Sub testing()
    Dim rng As Range
    For Each rng In Selection
    rng.Select
    Selection.Copy
    AppActivate "Logix Designer", True
    SendKeys "{F2}", True
    SendKeys "^V", True
    SendKeys "{ENTER}", True
    SendKeys "{ENTER}", True
    SendKeys "{ENTER}", True
    Application.Wait (Now + TimeValue("0:00:2"))
    AppActivate Title:=ThisWorkbook.Application.Caption
    Next
    End Sub
     
    Need to have your controller tags open with the description column selected at the tag you wish to start at, highlight the comments you wish to paste in, and enjoy your coffee!
     
    Unfortunately I can't figure out how to get it to quit on a keypress (incase you start pasting where you don't want to!)
     

  4. Posted

    21 hours ago, Michael Lloyd said:

    It might not sound like it would be faster but I've had pretty good luck with putting the Description in Excel, have the Tags open on one screen and the Excel sheet open on the other, and copy / paste from Excel to the tag description. Once you get a rhythm going it goes pretty quickly. You can construct tags in Excel by putting word or word groups in several columns (make sure to put spaces where you need them) and using a formula to create the tag. Something like A1&B1&C1

    This is my usual go to, but after having done it 3+ hours on the last project I've had enough! :P

     

    21 hours ago, ElectronGuru said:

    That is unfortunate. I'd like to mess with this on one of my demos. What is the controller you're using, and what version of Studio?

    Meanwhile, here's a couple of work-arounds:

         Print hard copies of the tags and put them anywhere a tech or programmer might need to view them. In the panel door pocket with the schematics, at a console desk, etc.  

         Manually enter them as needed from the printed hard copy. Time consuming and tedious, but better than nothing.

         Sooner or later there will be a scheduled or forced outage; do a download then.

    I know this isn't terribly helpful, but it's all I can offer until I can attempt to re-create what you're doing.

    Using a variety of controllers/revisions, typically L85E V30 - the test PLC I've been trying to get it to work on is an L75 v30 on studio 5000.

    1 person likes this

  7. Posted

    Hey guys, hoping someone has a solution to this. I've got a live PLC that can't be taken offline for a download.

    I have a bunch of new SCADA points in the format of PLC_SCADA[0].0 - [999].15, and I need to add comments to them.

    I created the new logic in an offline copy, but when I paste the rungs over the comments don't follow. 

    I've tried using the import .csv in the Tools dropdown, but it can't be done while online with the controller. If I try in an offline copy, it requires a download.

    I've tried exporting/import rungs as .L5K/L5X, but because the tags are Produced/Consumed, the comments don't update.

     

    For smaller projects I've gotten away with copy pasting, but when the larger ones come around that have 300+ new scada points, it becomes very time consuming.

     

    Any ideas of things to try? I've tried searching to see if I can use a structured text routine to populate the comments for me but I can't find any documentation showing how to write comments to tags. 

    I was going to try DDE with Excel but it appears that is only useful to write/read tag data?