Converting Tags in Studio

[Midknight 0]

I am currently in the progress of converting a RSLogix 500 code to RSLogix 5000.

The project I am working on uses FactoryTalk View Studio as a display and interface for various Inputs and Outputs.

Is there any easy way to swap out the tags of RSLogix 500 that are used in Studio with the tags I created in RSLogix 5000?

There are about 1500 tags and I really do not want to do this tag by tag. Is there a way I can do this through a CSV file?

[Michael Lloyd 85]

It's been a long time since I used RsView (<--- obviously. It's been FTView for a long time) but I think you can export / modify / import tags with FTView. 

 

[Midknight 0]

How do I go about the modifying portion? I can export the tags to CSV on FTView, and from the RS5000 project but the layout is different. Can I just plug in the names? address? And when IMPORTING the tags on FTView, will that replace the existing tags or just add on top of them? I am fairly new to using FTView myself and trying to look for a solution seems like it results in a "starting from scratch" type of idea.

[Michael Lloyd 85]

Make yourself a little "do nothing" application with a few tags in it and test the import / export on that.

If it works and If I remember right:

There's the tag in one column and then there's a ton of other stuff in other columns

You could copy the tags that need to be replaced into a standalone NEW worksheet, then copy the tags from the Logix program to another column, then have a number column to establish the sort order. Like so:

Oldtag 1  NewTag8     8

OldTag 2  NewTag27  27

Once you have the order done you could sort the New Tag and Number column on the number column

Compare the result. Then copy all the new tags over the old tags (in the exported sheet of course)

This assumes that you can get a block of the old tags so the copy paste is easy. 

[Midknight 0]

I will go ahead and try that method and update you as soon as I get it done.

I'll report my findings and issues too. But one concern is that the tag addressing on the CSV file off of FTView is ::[OTC Server Name]B9:0/14

This follows the data type and bit/pin used. But RS5000 uses tags, would the tag then become ::[OTC Server Name]Tag_Name?

[Michael Lloyd 85]

Just now, Midknight said:

I will go ahead and try that method and update you as soon as I get it done.

I'll report my findings and issues too. But one concern is that the tag addressing on the CSV file off of FTView is ::[OTC Server Name]B9:0/14

This follows the data type and bit/pin used. But RS5000 uses tags, would the tag then become ::[OTC Server Name]Tag_Name?

That's how I would think it would work.

I don't know if this will help but you can "add" strings together in Excel with the & symbol. I've attached a worksheet that I used to create structured text based IO mapping. It might give you an idea that will help. I have category's for pumps and valves in Sheet 1. That's where the IO is defined. The strings are created in the rightmost column in the individual tabs to the right of the first tab

IOM Builder Rev 2.xls

Edited 15 Mar 2017 by Michael Lloyd

[Midknight 0]

So I have went through with a trial program and exported the "Oldtags" to a CSV, changed the names, and imported, but for each re-entry, the ones I changed it added to the project instead of replacing the Oldtag with the Newtag. Two options came up when importing; to skip existing, or update existing.

Observing how this worked, it seemed to use the Tag Name as the reference point between the tags instead of order.

Knowing this, I can go through the CSV file and change the addresses of the Oldtags, and they do seem to update.

Your excel sheet gave me an idea, but that depends on if it is possible to break up an address that is in a single cell? (by characters or indentation without manipulating the original). Or it may be simpler then that. But this solution still has me going through each and every tag, but just changing the address now, instead of the entire tag.

Thus I don't have to go into the Display and change all the Tags used for each object.

Thank you for that example excel sheet though. It is very organized and well made.

Edited 16 Mar 2017 by Midknight