Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


JohnR last won the day on February 8 2018

JohnR had the most liked content!

Community Reputation

6 Neutral

About JohnR

  • Rank

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

2,070 profile views
  1. +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
  2. 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
  3. 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
  4. Hey All, Anyone have an elegant way to do an average on floating (MF) numbers? I am reading a float value from a device every 10 seconds, but saving that value once a minute to a Data Table, I would like to keep a running average of the 6 reads per minute and store that instead of whatever the value is at that instant. Some sort of FIFO arrangement where the newest value comes in and the oldest value drops off with an output value of the running average. I've used the Filter FB before with integers, but that doesn't work with floats (unless I'm missing something). Any Ideas? Regards, JohnR
  5. Yep, been thinking about that lately, I've been making tounge-in-cheek comments about retiring for a couple of years, and the bosses say "yeah, yeah, sure you are, who'd take your place?".... I got a new manager last fall, and first thing I said to him was, "well you know, I turn 62 next year, and I'm thinking about retiring"..... 🏝️ Now I have a young protege that I'm supposed to teach "everything I know" (by osmosis I suppose because I still don't get a lot of one-on-one time with him), but he's a sharp young man and slowly picking up on things. JohnR
  6. +1 to that Aus, I cringe every time our IT guy moves something else to a cloud based app. we lost our internet connection last week (fiber cut somewhere), and the whole front office went idle cause no one could get to their work.... geez Aus, I haven't heard that term since they started making sliced bread🙃
  7. In my case the answer is YES...... We probably ALL have at one time or another But that's the reason we're so anal about saving to multiple locations, lesson learned.
  8. Same here Flex..... I save to a new file name daily, appending the file name with the days date, such as; 1210 formax 03 20 19.vlp If I do a lot of changes I will sometimes add an A, B, C after the date and have multiple saves in a day, plus I add the PLC model to the name also. So far as storage, I work off a USB hard drive, and try to be diligent about copying my files to my C drive and a network drive. And as in other recent discussions, I'll save my version number somewhere on a display; v032019
  9. Thanks Guys..... It was as simple as changing the site option from "create Excel file" to "create .csv file" and using the default comma separator..... In all my other DataXport sites I've used the Excel file option and it always worked as expected, but this is my first time dealing with floating numbers... Live and Learn 🤓 JohnR
  10. +1 to what Flex says..... This beta version seems to be a big problem lately, it's great that the beta is available for seasoned users to experiment with and help find bugs, but we are seeing too many new users grabbing the beta version for their first programming experience....
  11. Hey All, Today's dilemma..... I'm doing some data collection from a mass flow meter, saving values to a data table which I grab from the PLC using DataXport. The values I'm saving to the data table are floating numbers (MF's), and when I look at the data table the values look fine. But when I open the excel file created through DataXport, the floating numbers somehow get changed to "Number Stored as Text", and the guy who is analyzing the data isn't happy with this format.... I can do a conversion in my logic from the MF to an ML or an MI, and the guy will have to be happy with an implied decimal point to either 6 places or 3 places. But I'm wondering if anyone knows the reason for the float to text phenomenon, or how to change the way the excel file saves it? JohnR
  12. I don't think so.... to me, setup and programming is the physical installation and programming (designing, panel building, debugging, installing). while commissioning is the act of putting the equipment into service (installation, final testing, and "handing the keys" over to the end user). My 2 cents, others may have differing opinions.... JohnR
  13. Within DataXport you will create a "site", Under Design, you create; the comms connection of the PLC (PLC name, IP address, port etc.), the data table you want set a schedule for it to run Under Project/Excel/.cvs file properties. you define the folder on your PC to store file. And you can also setup emails for the report. You can also do this manually within Visilogic; insure you can connect to the PLC, while offline, open the Data Table and click the icon that says "read data structure and files from PLC" highlight the cells you want to save and click the "export to excel icon" JohnR
  14. I typically use DataXport to create an excel file from the Data Table, and save it to a folder on my PC You can set up a schedule a weekly time and where to save it. or you can have it send an email....
  15. +1 to both Aus and Flex regarding reading an entire vector and picking out what you want if they are close, or separate reads if they are spread out. Similar to Flex's example, I typically use a state machine of sorts, to step through each read via an index count (which is reset after the last read).
  • Create New...