Jump to content
JohnR

seperate excel folders from same plc?

Recommended Posts

Hey All,

 

I currently use DataXport to get to retrieve data reports from 6 different PLCs.

 

Under the Excel options there is a checkbox to save each PLC to a seperate folder, which so far has been what I want.

 

Now, I have set up a completely different data table report on one of these PLCs, and I've found that I can set up two sites with the same PLC name within DataXport so each set of data can be retrieved at it's specified time, but the two different reports still get dumped into the same folder, and of course each report is looked at by different people, so they they have to sort through the files to find theirs......

 

Seems like it would work better if you could name the sites (instead of defaulting to PLC name) and have the checkbox allow you to save each SITE to a seperate folder.......... (you guys listening??)

 

anyone have ideas on how to seperate these?

 

Regards, JohnR

 

Share this post


Link to post
Share on other sites

Is there a reason that the PLC names cannot be changed? Currently the only solution would be to change the PLC name so that they are placed within separate folders.

Share this post


Link to post
Share on other sites

Alexander, thank you for your response, but I think you missed my point.....


"Is there a reason the PLC names cannot be changed"

As I said, I'm retrieving two different reports from the SAME PLC, and obviously I cannot give the PLC two different names......


"Currently the only solution would be to change the PLC name so that they are placed within separate folders"

Currently, yes that is correct, but how about in the future? Can the program be updated to so the Site name can be different from the PLC name?

In the Site setup you would specify the PLC that is to talk to, but be able to name the Site a unique name. Then in the Excel setup you could have it save to seperate folders based on the Site name instead of the PLC name.

Regards, JohnR

Share this post


Link to post
Share on other sites

I haven't tried this and maybe it won't work, but could you change the PLC name on the fly each time you want to write to a different folder? You can set the PLC Name via ladder by using the Set PLC Name FB on the Com menu.

Share this post


Link to post
Share on other sites

Maybe it's just the IP that has to cycle to change, but I typically set my communication parameters including the PLC Name based on a First Scan bit.

I guess I could try changing the Name based on time of day, making sure it has the right name at the right time for the right report........

and then I'd have to keep track of what time of day it is, and what name is being used should I want to Remote into the PLC.

 

but it still seems to me that the "Powers That Be" could make DataXport a little more agile......

Share this post


Link to post
Share on other sites

Two lines of code to change the PLC name, and you should already be keeping track of time of day, or whatever the criteria is for the different report folders. This sounds like an incredibly simple workaround for now.

 

If you find that you need to regularly remote in, then use 3 names. Change the name immediately before writing each of the two reports and immediately change it to a third name after writing is complete. The PLC will have that 3rd name 99% of the time for you to remote in.

Share this post


Link to post
Share on other sites

Hmmm... Well the Time of Day for the reports is a function of the Site layout in DataXport, not anything controlled by the PLC program, and I would have to keep them in sync.

Which gets me thinking... there is a checkbox in the Site layout to set a MB when the PLC is accessed, perhaps I can make a couple more sites that run a minute before I want to retrieve a report, the first Site would basicly just set a MB which changes the PLC name for the next Site to retrieve the report, and the Set MB of that Site would cause the PLC to change back to the base name for the remote access.

I'll play around with that and see what happens....

Share this post


Link to post
Share on other sites

By the way, I don't think changing the IP address requires a power cycle either. You can one-shot the TCP/IP Card Init block with the new address at any time.

Share this post


Link to post
Share on other sites

The only caveat I've found so far, is that this PLC is a server with 3 remote V280's as clients, and they also have to talk to this PLC by the default name, so for that 1-minute window while the PLC has it's name changed from the default, the clients lose communication.

I just noticed this yesterday when one of the operators called and said it lost communication (i have text that pops up for lost comms), but when I checked it everything was okay, then I looked at the clock, that 1-minute window had just finished, ah-haaa.....

Share this post


Link to post
Share on other sites

Hmmmmm,

 

well I have to revisit this, perhaps my comm lose glitch was something other than the name change (you know, you tend to question the last thing you changed when something glitches).

 

We are using the Remote PLC DataCom FB for the server/client connection, which is UDP, and I think that just uses the IP's and not the PLC Names?

 

I'll have to try to monitor this and prove myself right or wrong.......

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×