Jump to content

John_R

Members
  • Content Count

    135
  • Joined

  • Last visited

  • Days Won

    2

John_R last won the day on May 21

John_R had the most liked content!

Community Reputation

8 Neutral

About John_R

  • Rank
    UniGuru

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

2,290 profile views
  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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?
  9. 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
  10. 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
  11. 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.
  12. 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
  13. 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
  14. 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
  15. 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
×
×
  • Create New...