Jump to content

JohnR

Members
  • Content Count

    130
  • Joined

  • Last visited

  • Days Won

    2

JohnR last won the day on May 21

JohnR had the most liked content!

Community Reputation

8 Neutral

About JohnR

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

2,219 profile views
  1. In each Vision PLC, I take a reading every minute, which is saved to a Data Table. DataXport then connects with each PLC at a given schedule, copies the Data Table, and saves to an Excel file on a shared network drive. (some of the PLC's are read only once or twice a day, others are read every 15 minutes as the end user of the data wants close to real time updates). The end user of the data, reads the Excel file on a similar schedule (but not at the same minute) and puts it into fancy charts and graphs for every one to see..... run time error 3709 says; "The connection cannot be used to perform this operation. It is either closed or invalid in this context." I'm not sure if the connection in question is the connection from DataXport reading one of the PLC's, or from DataXport saving an Excel file to the network drive. And of course, the error always seems to pop up when I'm out of the plant for a couple of days, and then I have to listen to the end users griping about missing information... Which of course make me look like an incompetent boob having created such an unstable data collection process.... JohnR
  2. I've googled it too, but it seem all the posts are older and not relevant to windows 10.... And these fixes seem to point more to a VB error containing an "Invalid Procedure Call" rather than the message I'm getting from this 3709 error... Any other ideas out there guys? JohnR
  3. A few days ago, I ran the Windows Update and it installed a few updates but I did not see this one (KB4512486) listed among them. I went to the MS page about KB4512486 and tried to install from there but it said my system was up to date. And again this morning, error 3709 any other ideas?
  4. Hey all, I am running DataXport with 7 different PLC's (sites) in the project. Each site has it's own schedule, and there are no overlapping times. The PC that is running DataXport is a Win10 machine, and this is it's only function in life. It sits under my workbench, and I occasionally check on it. I have been running like this for quite some time with no issues except this; Every now and again, this error will pop up and DataXport ceases to run (it is still open, but not doing anything). When I click the OK button on the error message, DataXport closes and the error message goes away. I restart DataXport and it comes up running like nothing happened. Looking back at Call Log I find that the error does not correlate to any particular site, time, or day of week. Does anyone know what Run-time error '3709' is supposed to be telling me? Anyone else had this issue? Oh, and it also happened from time to time back when I was running this on a Win7 machine..... Regards, JohnR
  5. I collect a lot of data on multiple PLC's, and I started out using the email function of DataXport to send to different supervisors/managers. But another side to using the DataXport utility is that you can set it up to dump your files directly into a network folder, provided your PLC stuff resides in the same network infrastructure as the production supervisors office network. JohnR
  6. And on the subject of UniCan.... You can also easily monitor the status of MB's from one PLC to another; use the "Bit to Num" to encode a block of 16 MB's (MB 100-MB 115)to an MI (MI 100) compare the number in the Bit to Num MI to the previously stored number if it has changed, then trigger a UniCAN SEND then update the Last Bit to Num with a Store The order of these three nets is important.... On the other PLC (after setting up the UniCAN INIT and PLC Net ID), All you need is the complementing "Num to Bit" to decode this number back to discreet bits. You can map whatever you want to the MB's at each end. Reverse the process with a different block of MB's to send bits back the other way.
  7. Well, there ya go.... I could see that the conversion to exponent was happening on numbers smaller than 0.0xxx but never thought this would be happening within the Vision logic/math. The mass flow sensor has a lower threshold setting that below this setting it outputs a zero. The Quality Assurance guy working with this data was freaking out because he was getting zeros (even though I affirmed that this is the nature of the process, sometimes the control backs off enough that it stops the flow). I had turned down this threshold setting so we we getting more numbers than zeros, which I believe is when we started seeing the exponents, which freaked out the QA guy even more. probably my quickest fix is to bump up that threshold until I get above that 0.0xxx point. Thanks Joe...... JohnR
  8. I captured this today, the Vision data table on the left, the DataXport created Excel file (.csv format) on the right the number is stored in the data table as E-notation, and shortened when stored into the excel file at this point I'm still guessing this is created within the mass flow device, I've not yet been able to verify this with the oem but I cant see that vision would be reformatting this on a modbus read
  9. Hey Aus, Thanks for the input.... Unfortunately, I blow out the data table every morning, so by the time I wanted to compare that to the data in the excel file it was already gone. I will have to monitor it through out to day and see if I can catch it misbehaving. in yesterdays data my numbers range from 0.1059184 up to 7.88904 (and everything in between), and the two exponents come in with one zero after the decimal place. 0.0924 & 0.0856, so perhaps this device just outputs in exp when the numbers get this small. I will have to get hold of the tech from the mass flow place and see if he can confirm JohnR
  10. Hey All I have a data monitoring control that talks to a mass flow meter via modbus. I"m simply reading a float number and storing it to a data table every minute. I then use DataXport to put the data table into an Excel file that our bean counters use for what ever they do.... An issue I've been shown is that occasionally I get an number in exponential form, and this of course muks up the bean counters report. At this point I'm trying to figure out if this is what Unitronics does when it sees too many decimal places in a float or if that's what I'm getting from this mass flow device. Anyone have any insight on this? Is there an easy way to limit how many decimal places, or round it off at X number of places UPDATE I was thinking that I was getting an exponential when the number had too many decimal places. but I've dug out my scientific calculator and see this is not the case two numbers on yesterdays data are ; 9.24E-02 which converts to 0.0924 8.56E-02 which converts to 0.0856 so at this point I'm leaning to the issue being from the device not something with in unitronics Opinions???? JohnR
  11. here"s a little "Modbus Checker" program that I use with a V120 for testing Modbus controls to A-B powerflex VFD's You can dissect this and see how the Modbus is done in Vision Of course there are some hardware settings also, you must set the jumpers in the V120 to make port-2 RS485 and set the powerflex to run on modbus you will also need a cable going from RJ-11 to RJ-45 I don't have the pin-out in front of me but I'm sure it's easy to find... JohnR V120 PowerFlex.vlp
  12. This is interesting, as I have been running like this for several years without issue. I copy the entire DataXport folder and rename it. It seems more that something has corrupted the .ulp as I copied it to another PC and get the same error. I did some digging and found an archived copy and it started without issue, so I got that under control. Something else I noticed while dealing with this; DataXport wants to open with the last .ulp it ran (which is expected), but if the last .ulp wont run (as in my case), then DataXport just falls flat on it's face. You would think (that like most programs) it would tell you that the file cant be opened, and prompt you to start a new file. Just my opinion... JohnR
  13. Hey All, I ran into a snag this morning, I have a pc whose only job is to run 3 instances of DataXport, and collect data from different processes around the plant and dump them into folders on out network. Something happened overnight, and my DataXports stopped responding, I got them to shut down, then rebooted the pc. One of them started up ok, but the other two wont start. One gives me this error; And the other this; Anyone a way to fix these? Regards JohnR
  14. Hey All, I have a possible upgrade project coming up, replacing some old automation direct plc/touchscreen controls. my first plan was to use a V570 (or V700) and do my I/O expansion rack style so I can have the HMI in the panel door and put my I/O a couple foot away without re-routing (much) existing wiring. But, now I'm thinking of going UniLogic/UniStream, a bit overkill for the project, but would be my introduction into this product line. I've played around with UniLogic a bit but haven't yet built a real project. I've been going through the hardware aspect on Unitronics Website and think I got it figured out but thought I'd throw this out to the forum community to double check my thinking. the existing project consists of; 20 digital inputs (sinking) 18 relay outputs 10 analog in 2 analog out So going through the Uni-I/O list I come up with the following modules to cover my needs: (2) UID-W1616R to cover my digital ins and relay outs (1) UIA-0800N for 8 of my analog ins (1) UIA-0402N for 2 more analog in and 2 analog out then it looks like I need; (1) UAG-XK125 Uni-Local expansion adapter (1) USC-P-B10 CPU-for-Panel (1) USP-070-B08 HMI Panel Does this look correct, or am I missing something? Regards, JohnR
  15. I always tell my guys that get confused, "to a computer, zero is a much a number as one is, only people think zero means nothing"
×
×
  • Create New...