Berti Baker

MrPLC Member
  • Content count

    299
  • Joined

  • Last visited

Everything posted by Berti Baker

  1. Data Logging Floating Point Access 2000

    Hi Peter,  Happy new year  <:-) To start off, is your DB file extension .MDB or .ACCDB?  CX-Supervisor uses ODBC drivers for writing Access files.  Most versions use Access 2010 drivers, although V4.2 uses Access 2016.  Regardless, you should be able to use any drivers to write ".MDB" database for use with any version "Microsoft Access desktop application", or 2010/2016 drivers to write the newer ".accdb" database for use with "Microsoft Access 2010" or later.  So there should not be any problems with versioning and all support floating point values. I've never heard of "...live Access field..." so not sure what you mean (can you explain further?), but I would highlight that it is important the data type of that data field needs to be correct to store floating point data. If it is a "Number" field have you used "Increase Decimals" button to add the decimal places? Does it display with decimal places in Access?  Also note the CX-Supervisor point must be "Real" instead of "Integer" type. Does the "Point Maintenance" dialog correctly show the decimal places? It's normal for managers to use Microsoft Access for offline data analysis, but not for minute by minute data monitoring. I thought the database was locked anyway so couldn't be accessed while logging - have you tried?  Sounds to me more they want a HMI screen, OEE Dashboard, Report or web page to monitor this Hope that gives some clues, Regards, BB  
  2. Issue Connecting to PLC through C-Link Network

    Hi, Been a long time since I used CLK.  Do I remember that you also have to set routing table in node 6, so it knows how to route replies back to node 1.  Have you done that already? Also remember there was a FINS communication Test tool where you could post Model Read (0501) to each node and unit to test comms    rgds BB
  3. Cx Supervisor Event

    For anyone else interested in this I make 2 comments, depending on correct understanding of OPs question: 1. To log values of Switches (inputs) going on and off during runtime, you are talking about creating a Point Audit Trail to MS-Access or SQL. See User Manual chapter 13 for full details, but put basically Enable Audit Trail from Project->Runtime Settings->Audit Trail Settings From each Point required, select Edit then [Advanced] and "Generate audit trail" really simple to achieve in a matter of minutes. 2.  Alternatively, to add you own logs to the system Event / Error log, write a script and call "LogEvent()" or "LogError()" script to write to the logfile with a message and timestamp Hope that helps, BB       
  4. DLV file format

    Hi Joan, No the DLV file is binary format, and also a compound file stream which is not documented anywhere and not normally easy to reverse engineer. Can you use CX-Supervisor itself !  There is a script command called "ExportLog" which can save the CSV file,  and all items not just 10 at a time!  You could even use OpenFile to select the filename you want, or maybe loop round your thousands of files automatically. I think you have to specify the file in series by number insead of date so you would have to fiddle a bit, but its a starting clue and sounds like you're clever enough to run with it ! Take a look but give an update if you need more help. Regards, BB
  5. CX-Supervisor screen with PDF Viewer

    Hi, Bit late too the party, but just to add...  The WebBrowser compenent can be easy way for PDF viewing for many, but like you say is just a web browser and no real control or security.  If you're down the KIOSK mode route then you want it more controllable. In the past I know I used a free PDF Viewer ActiveX control and placed on the page.  Through properties you could set the file, launch at specific page and control the menu available - exacatly all the control you need.  I can't find any trace of the name now but this could be a good route to investigate the options available these days. Regards, BB.
  6. CX-Supervisor new button responding intermittently

    Hiya. First,  when I've seen something like this it is when a small picture is placed over the button and the picture receives the presses instead of the button - if you click the corner it works OK .  For those in this situation the solution is easy - if you make the picture 'unclickable' the presses will pass through to the button underneath.  Just add an "Enable" animation to the picture with Expression: FALSE so that it is never enabled  Second thought though about if this is touch screen or driver etc, could be good test to display $MouseX and $MouseY on screen these are updated every click so you can see if CX-supervisor is actually getting all those clicks. Regards, BB
  7. Runtime not loading

    Hi Peter, CXSUPERVISORRES. DLL is the system language resources for the Runtime program.  It must be installed as part of the installation so I'm not sure why you would get this error but is not project related.  You can try any of the demo projects to confirm that. - Can you find this file in your installed folder (default <Program Files>\Omron\CX-Supervisor) alongside the SCS.EXE? - Try launching the runtime different ways - from Start->CX-Supervisor Runtime, double clicking on .SR2/.SR3 file or from Developer if possible.  Are you trying to do anything strange like install to a network drive / moved the SCS.EXE file / run through Remote Desktop etc? - These days "Run As Administrator" always seems like a good thing to try !! If all else fails, then uninstall and reinstall should find this file properly installed Best Regards, BB.
  8. CXSupervisor, CJ2M performance issues.

    Hi, Best ignore the theoretical bandwidth of USB-2 (who said it was 2 anyway?). Certainly I remember many early Omron USB ports were just using USB to Serial chipset running at 114Kb. You still see this with the CP1W-CIF41 Ethernet plug-in - still connected to a serial port ! Next thing is that theoretical bandwidth assumes you can process and pump out the messages quickly. For ALL PLCs this is a secondary task so latency means you never get near that.  Yes, with Ethernet you will easily achieve good performance. Appendix B shows you can expect over 1500 reads a second over Ethernet.  I realise time and cost are your factors here so your choice, but I would just knuckle down and reorganise the program memory and then recreate the CXS points and will still achieve this.  Like I said already once this week, FINS memory management is tedious to thanks for EIP tag addressing these days! Rgds BB
  9. CX-Supervisor - NX1P2 communication

    Then again, if you’re connecting to NX then better to create as ‘SYSMAC Device” and use SYSMAC Gateway for communications. Reading by Tag name means you don’t even need to modify or rebuild CX-Supervisor when you change variable locations, plus you don’t have to manually manage the FINS addresses to make sure they don’t overlap !! (Big bugbear!) Rgds, BB
  10. Cx-supervisor

    Hi,   Not much diagnostic information here. What version are you running? I suggest you register and upgrade to the latest available.    Have a look in the CX-Supervisor Error Log for any clues. Perhaps the values are zero just because the device is disconnected? Regards BB
  11. CX-Supervisor v 3.2 Educational bitwise problem

    Hi Geir,   This optimisation is particularly advised for serial connections, and FINS connection, but not so critical in Ethernet and EIP protocol.    Anyway there is no such limitations with the Educational version so this is not the reason.  Testword & 0x30 should work fine e.g. when the value = 48 Have you used Point Maintenance to check its value when it is not working? This should be the normal solution  Regards BB
  12. Hi All, Just to update, from V3.5 Release Notes: So should be all fixed now. Regards, BB
  13. rounding a value to nearest 10

    Hi, Here's a suggestion for the logic to use  Add 5 (half of 10) to make the result to round up or round down Divide by 10 Convert to INT type to truncate. Multiply by 10 So 32 would become (INT((32+5)/10)) * 10 = 30 or 37 would become 40. Sorted? Regards, BB    
  14. How do I display UNIT_BCD value from Omron PLC to Indusoft Scada

    Ha ha.  Yes problem of mixing software providers that don't understand proprietary data types. Your 3 options: 1) Use CX-Supervisor (or other Omron software like CX-Server OPC or CX-Server Lite) to correctly read the BCD format 2) Edit the PLC program, and convert all PLC variables to standard Integers 3) If its possible... Read as hex and then write conversion routines in Indusoft script that run every time a new value is read (yuck!) BB
  15. Licensed runtime and 2 hours demo - screen refresh

    Hi Milosh, If you're using V3.4 then upgrade to v3.5 as Readme lists bug fixes with animations and hanging. If you're running v3.5 and this sounds like a bug then worth raising with Omron direct on myOMRON. They are still actively fixing these things. Regards BB
  16. CX-Supervisor runtime startup question

    Hi, Yes (depending on PLC type).  If I remember then RUN on the old C series meant the program ran, but refused read and write communications requests - pretty critical for a SCADA app!  (in fact didn't the CS have it on physical font panel 'key' operation?). Anyway that's why CX-Supervisor assumes you really want this changed to Monitor mode.  You can use CX-Programmer to change the default PLC startup mode. This is the background but maybe for newer PLCs this behaviour has evolved Regards, BB
  17. Point import problem

    Hi Milosh, This used to work but is new and I got the same here.  Am told it is a bug and will be fixed in 3.51 version BB
  18. "Easy" way to change screen resolution

    Funny, I never found any problem with resize feature, and use it extensively exactly for this reason. If you set the "Screen Size" to the expected Runtime size, then the runtime appears best (sharper/less scaling blur). Also as Runtime IPCs are usually lower res, it means in development most of the screen still fits on the (larger) dev monitor which is handy. But you could still set the "Screen Size" to dev resolution - either way when maximised that entered size will be scaled to the actual screen size. Milos: I'd love to comment if you have any screen shots on the settings and effect? If you can get it working it could save you ages editing many pages !! BB
  19. CX Supervisor with SQL Server

    Hi, I agree, SQL Server Find should be quick with say less than 2 million records, and for a large database solution always work having a professional data expert design the tables and keys. Just to add CX-Supervisor DOES allow direct SQL text to be used if required. To do this programmatically look at the DBExecute with command parameter "SQL" (example in the installed Database Demo). Regards, BB
  20. Logging To A database

    Hi, In addition to the previous suggestion if you're using scripting to call DBGetLastError, then also suggest looking in the Error Log.  Assuming this is a local database then check the file path to your database on the new PC is correct (and/or DSN file contents). Do you have the Developer installed on this PC and can you "Connect" to the database from the developer? Best Regards, BB
  21. Datalogging

    Hi, Not sure which one you mean: Data Logging? Database writing? Logging to Database? Audit trail to database? But for general MS-Access usage, any version can be used.  The only real factor is whether you are using old  .mdb format or new .accdb format but both are supported. If you're calling script commands I recommend checking their return value, and on failure calling DBGetLastError.   Best Regards, BB
  22. CX-Supervisor PC crashing with alarms

    Hi, Did you upgrade CX-Supervisor since 2 years ago? What version are you running now? What does "stays out of memory" mean? If you mean the RAM usage is increasing until available ram is full the sounds like you have a memory leak. Normally you only have 500 alarms logged (configurable) so intentionally should not keep allocating more memory.  Regards BB
  23. Cx supervisor with cx designer and cx programmer

    Even more, as all "CX" products use CX-Server for communications, you can share the device and point configuration. The Point Editor has an Import from CDM and CXR format so are designed to be installed together.  BB
  24. Hi T, I have something similar. This looks like a defect (probably related to the new shaded and transparent drawing of objects added in 3.4) so I raised a ticket on myOMRON.com and indeed they confirmed it was already reported and the fix will be released shortly.  Hurray! Regards, BB
  25. adding signal???

    Hi Dunc, Do you mean the SYSMAC Gateway Console, and the Tag Monitor? The only thing that is likely is that you IP address changed or port needed to be opened.  For SGW comms this tool should be your first diagnostic step.  Glad you got it working, Regards BB