Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by John_R

  1. Define an array of MB's say, MB101 through MB132, these are the bit coils that your alarms will trigger. Use the Bit to Num FB (under vectors); A = the starting MB of your array, MB101 B = the DW where you want to store your "bit word", DW1 C = the length of you MB array, const 32 if MB104 is on, then the forth number of the DW will be 1 if MB128 is on, then the 28th number of the DW will be 1 and so on....
  2. Well, another couple of weeks of trial & error, and I'm still having this issue... I set up another computer with a fresh install of Win10 (thinking maybe something was amiss with the previous computer). DataXport ran for a day and a half before it popped up this same 3709 Runtime Error... And the error still pops up almost daily, getting pretty frustrating..... Anyone else have any ideas? JohnR
  3. Plus, with the Data Table method you can use the DataXport utility to copy the Data Table to an Excel file, saved into a folder or emailed to someone... JohnR
  4. AAAAHHHHRRRRGGGGGG!!!!!! Went a little over a week without an error, now suddenly I'm back to a couple times a day.... Win10 does not show any updates installed in the last two weeks.... Again I ask, am I the only one who is having this issue? Maybe I'll try a different computer, perhaps there is a ghost in this machine. JohnR
  5. Good news, I think.... Seems my computer received a big Windows Update late last week, and since then I have not had this error (mind you it had gotten to the point where it would pop up the error several times a day in the last week). And the problem seems to have started the last time I had a big update..... Time will tell.... JohnR
  6. Anyone out there in Creatorland have any suggestions? Is anyone else having this issue or is it just me? I am running ver 3.1.23 of DataXport which appears to be the latest, and it is the only app running on a fresh Windows 10 PC I've tried adjusting my schedules, and how many sites I read from, and I tried writing to the local PC where DataXport is running, all with the same inconsistent issue. JohnR
  7. this is what I'm thinking, it happened every now and then when I was using Win7 and Office 2010 (installed locally), but the issue started happening more often when I upgraded to Win10 and Office 365 (cloud based). I'm thinking that sometimes we are stepping on each other, that is, the end user program goes out and reads the Excel files 4 minutes after I start my read/write process and perhaps he is trying to open the newest Excel [NOT RESPONDING] file before I'm done writing it....😴 I changed the times on my schedule this morning to give a bigger gap between my write and his read, we'll see if that helps.... JohnR
  8. 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
  9. 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
  10. 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?
  11. 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
  12. 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
  13. 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.
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
  21. 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
  22. 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"
  23. +1 Aus, I've mentioned a couple times in the past that I have made up a drill template that I lay over the snap module and put some holes in it. seems it's been a few years back when the PCB on the snap was changed to allow clearance in the corners, and screw bosses were added to the PLC's, so it seems there was a plan for screwing the snap on, but just never implemented. I would like to see the snaps delivered with holes in place, and a set of screws for mounting. And as Aus said, the pins could be a bit longer also. JohnR
  24. Aus, you are correct, that is much simpler then my net full of math...... Flex, I'm not sure why MF's are excluded from a lot of stuff either, but at least you bumped my mind into looking at the Float functions available.... We are a little closer to an Elegant solution JohnR
  25. Flex, this is the direction I was leaning, something like a Vector-Shift-Left, plug a value into the starting address, which then bumps the rest of the values down, then do the math. I see the Store Direct under Math/Float/Basic functions, but (unless I'm missing the obvious), you can't do vector functions with MF's. So, are you thinking that I should have a net with 6 of these Float Store Directs in series, each moving the previous value to the next, then doing the math? Aus, I was thinking that if I plugged one value in and dropped one off, then did a sum & divide, that would be a rolling average.... JohnR
  • Create New...