Conor

MrPLC Member
 View profile  See their activity

  • Content count

    348

  • Joined

  • Last visited

Posts posted by Conor

  1. Posted

    Hi, I am running Wonderware ver 10, sp2. I am trying to write into a DB via SQL commands from InTouch. I was wondering if anyone has any examples of the script that I need to use. I know that I need to Connect to DB run command and then disconnect from DB. Basically I want to add data from flow meters to the DB, but as these will be continually updating, I am not sure of the correct way to script this. Any help would be great. Thanks, Conor

  2. Posted

    Hi, I am looking to run a script that collects data and then displays the values on a window. Something like; Valve open signal and machine at step zero count one. Then dump this data out at 12 am, 7 am and 7 pm I could probably write code in the PLC for this, but I am getting more experience with Scada, so I would love to do it in a script. Any help would be great

  3. Posted

    Sorry Bob, I didn't mean to do anything wrong. When you log on as an Administrator you should have 9999 access. When you are setting up the user names and passwords, you can set the access level for each user. You can define these access levels yourself, i.e. you can have an access of 3001 if you want. If you go into WindowMaker and log on as Administrator, then go Special -- Security -- Configure Users. Then you can set up usernames, passwords and access levels. Remember you have to logged on as administrator first!!

  6. Posted

    Thanks for that Ron, it was a fantastic post. I see what you mean about a programming course. As you say, it would have to be very specific, and if I did all the ground work to look into doing a course I would be well on the way on the learning curve. I find that my problem is that code wise I am not too bad, but when something more advanced comes in the code then I hit a brick wall. Sometimes I get bogged down with sequences. I can troubleshoot and then if needs be tweek the code for most things. The unfortunate thing is that sometimes code can be written very "complex", so that the programmer is the only real person that can understand it. If not someone has to spend a lot of time trying to decipher that programmers code. I downloaded the book by Hugh Jack from this website and have only just started it. Also, on my first post, I asked about the course from Scantime.co.uk. Would anyone recommend this?? A curse like this might be good for going down the self teach route. I have to thank you all again for your posts, it gives me a lot to think about.

  8. Posted

    Hi, I would have to agree with most of the other guys. We had to get a new laptop in work recently because the old one's comm port was shot. I insisted that we get one with a comm port. My boss wasn't impressed, but we got the new one with a comm port. The following week we had a problem with a device and the only way to connect was via the comm port. My boss knew then it was money well spent. Also, I think someone else mentioned it, but I seem to have had problems with connecting through USB to a PIC. Anyway, comm port all the way Just my 2 cent

  9. Posted

    Hi all, I am looking to further my knowledge in Controls, but where do I go? I have about 10 years PLC experience, mostly in troubleshooting, but some programming. I can write or modify programs, but when it comes to some of the advanced stuff I get bogged down. I have used mainly RS products. I am finding it hard to find a local college (in Ireland) that does anything in PLC's. There are some, but they are fairly basic courses in PLC's, which I know would be of no real benefit to me. This has lead me to looking for online courses. I also was searching on the net and found Scantime.co.uk. Has anyone done any training with them, and if so are there courses any good? Next, I did a Scada course in England a few weeks back with Wonderware UK/Ireland (SolutionsPT). I found this very good and it has helped me a lot in work. The reason I am saying this, is now I find myself thinking about doing an SQL or MySQL course. Maybe one of you guys can point me in the right direction. If I was in the States I would be looking into one of Ron Beaufort's courses, as I did a bit of searching and it looks like the are good. Thanks in advance

  10. Posted

    Thanks again Paul. I will have to look into the channel diagnostic file, I am not sure if this is set-up. On the housekeeping, do I use a System bit to do this?? I have seen that SLC's don't handle comm's as good as PLC5. I have another SLC, actually the one that I am doing the analogue checking on (in another post). Anyway, when I communicate to it over our network, ControlNet/Fibre/Ethernet it craps out alot, especially if I am trying to do on-line edits. The easiest thing for me is to go over to the SLC and connect directly into a hub that it is connected to. I don't get any of the crapping out then. Thanks again

  17. Posted

    Hi, One part of my plant has this comm's configuration; PLC5 (A=Main PLC) to Scada PLC5 (B=Peripheral PLC) to Scada SLC (C=Peripheral PLC 2) to Scada Each of these PLC's are connected to an unmanaged Hub (16 port) The Scada talks to each PLC I am getting comm's lost on my SLC. It is happening frequently, but with no seeming pattern. It could last a day, or a week or 2 weeks. When I loose comm's I have to power down the SLC to re-establish. Looking in RSLinx when the comm's are lost there is an X through the SLC. Is there somewhere that I can check in the PLC to see where the fault is occuring or maybe is there a cable issue. If this was a cable problem, would this not be happening constantly

  19. Posted

    Ok If I use a timer and then use a cop function to copy the value into an array of 10 bits. Then do a sub function to subtract first from last in the arrray to get a difference. If then I do a compare with the difference that is less than x Or is there a better way to do it?? Any help would be most grateful

  21. Posted

    Hi all, I was wondering if you could help me. I have a pressure transmitter and it has crapped out before and given false readings. The process runs up to 6 bar from 0, and then back down to 0. This decrease is gradual, i.e. it should take 2 mins. If my pressure goes haywire, or directly down to 0, this can cause damage to the next step of the process. I am getting an analogue signal back in from this transmitter, and then using a SCP to scale the data before I send it on to Scada. Hopefully one of you guys can help me out with this. Thanks

  23. Posted

    Hi everyone, I am wondering if anyone knows of any good programs out there that I can use for source control. Basically, I want to be able to create user accounts and be able to check in/out code via these accounts. I am just looking for more control over the code that we have in work. Is there any open source stuff out there, or do I need to splash out on software?? Thanks