How to migrate C-more tags of a DL project to Do-more

[Scot]

I came up with a formula for changing C-More tags from Direct Logic to Do-More. I don't know where a C-More forum would be, but this applies to a migration to Do-More CPUs.

In C-More, open the Tag Name Database and click Export. (Legacy C-More choose File->Export->Tag Name Database.) Then select the connected device tags for the DL processor you're replacing (if you are connected to more than 1 PLC). Save that to an excel file and open it.
It will be filled up to Column I. In the first blank column (J2) put in this formula:

=IF(LEFT(G25,2)="CT","CT"&OCT2DEC(RIGHT(G25,LEN(G25)-2))&".Done",IF(AND(LEFT(G25,1)="V",INT(RIGHT(G25,LEN(G25)-1))<378),"T"&OCT2DEC(RIGHT(G25,LEN(G25)-1))&".Acc",IF(AND(LEFT(G25,1)="V",INT(RIGHT(G25,LEN(G25)-1))>999,INT(RIGHT(G25,LEN(G25)-1))<1378),"CT"&OCT2DEC(RIGHT(G25,LEN(G25)-1)-1000)&".Acc",IF(LEFT(G25,1)="T","T"&OCT2DEC(RIGHT(G25,LEN(G25)-1))&".Done",LEFT(G25,1)&OCT2DEC(RIGHT(G25,LEN(G25)-1))))))

Then use the square box on the bottom right of the cell border to copy it all the way down column J to the end of the data.
Then select J2 to the bottom of that column (it should already be selected from that last step), copy it to the clipboard (Ctrl-C). Then select cell G2. Right click cell G2 and pick Paste Special. Paste the Values Only. Then right click the Column J header and delete it.
Save the spreadsheet.
Back in C-More, got to Setup->Panel Manager.
Click the device you're replacing. Write down the IP Address and settings if you're going to use the same values.
Change the PLC protocol from DirectNet to the Do-More you're going to use (Serial or Ethernet) and fill in the settings.
It will warn that all the device tags will be changed to <INTERNAL>. That's OK.
Then open the Tag Name Database again and pick Import. Find the Excel file and select it.
Check the box to Overwrite Existing Tags - Important. This will fix all those tags that were just assigned to <INTERNAL>.

When using the Do-More Designer's Migration Tool, choose the first options so all your tags are converted from Octal to Decimal.

I would also save this modified C-More project with a different name - just in case.


Hopefully, this will save someone a lot of work manually converting all their C-More tags from the Direct Logic octal to Do-More decimal. I probably should have posted this on a new thread so it could be found easier (done).


Edit:
I also found that I had to change the numbers in the ProtocolID column to 2510 (I'm using Do-More Ethernet - Do-More Serial might be different).
Another thing, when Exporting, don't include Internals - or delete them from the spreadsheet after. They just give errors when Importing.

Another Edit:
I updated the formula to convert V0-377 to Txx.Acc and V1000-1377 to CTxx.Acc.
If you use any upper V ranges, you're on your own. Check the PLC memory map in DirectSoft to re-map your own upper ranges.

Edit again:
Formula changed to add CTxx.Done

I also forgot to mention - data types need to be changed (specifically BCD types). You can try to change them in the spreadsheet but the C-More software does not like to change data types. You will have to do each one individually by hand. That involves changing every element that uses that tag to some other tag. Only then will the C-More software let you change the data type. Then go back to every element from before and change the tag back. It's a very tedious process but there is currently no other option - unless the C-More software was changed.