PLC/SLC address convert to Logix

Phrog30

Member
Join Date
Dec 2006
Location
Montgomery, Alabama
Posts
1,048
Does anyone know if a utility exists that will convert the syntax of SLC/PLC addressing into Logix, whether text, excel, etc.?

I have exported the ASCII database from a PLC5 program and would like to convert it from "B3:1/15" to "B3[1].15" in a click of the mouse. I was able to use search and replace, but it misses things, depending on bit or word level, timers, counters, etc.

James
 
I would like some excel gurus to help with this also. I have having the same issue. Can't get excel search and replace to do what I need to do to convert this SLC address to CLX.

Nxx:xx to Nxx[xx] but need to maintain the numbers so I don't have to do a bunch of search and replace for N16, N17 etc.. Can easily search and replace the : to [ but can't add the ] to the end of the replace.

Booleans were easy to search for : [ then / with ].
 
Last edited:
B3:1/15 convert to B3[1].15

Use the following formula in excel:

=SUBSTITUTE((SUBSTITUTE(A3,"/","].")),":","[")

Where A3 is the cell of the original address.

Hope this helps you out.
Regards,
 
I forgot to mention, I am doing this for Wonderware. So the galaxy dump puts all of these address in 1 row that is a mile long. A6, B6 ---- all the way to BBX6
 
Excel + VBA could do this pretty quickly, but if you aren't a VBA guru then gclshortt's suggestion works.

OR

Use the mapping function in the Logix program and don't touch WW. (Doesn't work w/strings from what I remember, so you'll have to fix that if you are referencing string tags in WW).
 
Back in the day, I used KEDIT (a file editor) for this.
That was the DOS days, and KEDIT was the best thing going, for line editing.
You could tell it, for example, to change "the third comma in every line to a 'x' ', and such commands.
Very helpful
 
It's been a while but I believe the Translate Tool in RSLogix 5000 takes care of this for you.

**Never mind. I started to reply and then stepped away for an hour before finishing.
 
Last edited:
Can't get the file uploaded since it is a .csv

I did originally try the SLC/PLC mapping in the CLX but the DAServer just stays in (20:Initializing)
 

Similar Topics

Good day colleagues, I have a problem with a plc slc 5 since I export the tags to my factory program to load them into a panel view 1000 plus 6...
Replies
0
Views
87
Hi long time out... I´m in a project now, that request to upgrade an old SLC to a new ControlLogix. Just the PLC. It is connected now to a...
Replies
5
Views
1,915
Everyone, i am in the process of purchasing the Slc 500 version of software to support what we have and i have a question. Several of our...
Replies
9
Views
673
I used up my last new Allen-Bradley SLC 5/04 controller. Does anyone have info on a good reliable place to get a new one for a decent price, or...
Replies
3
Views
486
Hello, We have an older machine that has a standard PanelView (2711-T10C3) connected over DH485 to a SLC 5/04 PLC via a 1761-NET-AIC module in...
Replies
1
Views
658
Back
Top Bottom