Search the Community

Showing results for tags 'cimplicity report odbc'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Found 18 results

  1. Hi, guys.I am struggling to develop a solution for a costumer in a Historical Alarm Viewer screen, I am new to Cimplicity and to database supervisory interface. Among other things, the customer is asking to:- Change the "A"; "R"; "G"; "N" notations under "log_action" column to somenthing more intuitive for the users (operation). Please have a look at the image "image.jpg";-Change the point manager process "MASTER_PTMR0_RP" log under "logged_by" column to the user that is currently logged in. Specificaly saying, when I send a command (changing a setpoint or issue a reset command, for example), although it is the user acting, the historical alarm viewer logs the action as "MASTER_PTMR_RP". I Imagine that is because this process is reponsable for exchange point data to/from the IHM points database, but it is still essential to the system administrator to know which user sent that reset command or changed the variable setpoint.The log inputs at the image "image.jpg" has boolean and integer commands (".CXX" sufix);-Log into the historical alarm viewer if the user logs out and what user logged in.It is valid to mention that I am using the ALARM_LOG table (apparently it is the only table working with the application, DATA_LOG, EM_LOG and the others simply do not work, they don't show any column at all, honestly I don't know why).I tried to use Microsoft SQL Server Management Studio to edit the table information, but, somehow, it seems to be blocked to edition.I imagine they are some specific configurations, but I have no idea on how to acomplish them. Maybe if I could use other tables would fulfill the requirements, but , like I said, they are not working (right now I am trying to re-configure the Database Logger from the beggingin to see if it works with other tables).If you could give me some inisights on how to change these settings I would be very grateful. I will be happy to give more information if needed.Thanks in advance.
  2. I am now part of a startup company based on energy optimisation of HVAC in buildings. I am assigned to have research on which SCADA system to select for HVAC energy optimisation. The model is in such a way that, we need to create a SCADA / HMI for the client's building on top of existing Building Management System (BMS) to achieve energy saving.  I am still an intern and I am requested to research on various SCADA options available in the market. I have few doubts regarding: 1. How can I select one SCADA / HMI over the other?  2.GE Cimplicity and Niagara 4 are two option which I am interested in. What is the major difference between both? (Price and functionality) 3. Is Tridium Niagara 4 a SCADA software? ( I read about it but I didn't understand as I am new to this field). Is it same like tia portal which is a software that is used to program plc and create user interface??
  3. Do you have a known ac repair expert in contacts who can help me fix the issue i am having with my air conditioning unit?
  4. Hello Dear Colegues. I am using historian 7.0SP6 (enterprise license). I have installed OPCAE collector to collect alarm and events data from a project in cimplicity in order to have an historical data of it. Also I have checked the Historian OPCAE interface box in the cimplicity project´s properties. The problem is that when I try to see the tags from OPCAE collector on historian administrator I have the following error "No Tags Matched The Criteria You Have Entered. Please Try again or Cancel your Search". Also, I am not able to see the "last 10 alarms in the collector´s configuration tab. What could causing this problem?
  5. Batch reports Comfort Panel

    Hi experts,   I need to generate the batch report for my project without any script , i check in our forum but previous links are all deleted. Can any one please provide sample backup please ?     Because i am really confused to achieve the batch process. In Report generation we can print the PDF file which the data's are already entered in that particular page but my requirement is, i need to take print out the following details 1.The parameters should be stored in report from my batch start to batch stop with date and time. 2.And also i want to take report for some particular dates (that dates should be selectable from HMI)  Any idea how to do this?      Please see the attached image (example) and am badly need this please help me  https://youtu.be/tvao1QLlHnM
  6. Hello, I have a fuel level reading system in a 2000 gallon diesel tank. the system has a slc 5 05 of rockwell. I need to connect the system to a printer located in an office 300 meters away from the tank. can someone give me lights about the type of printer I need and what communication technology to use, preferably wireless. Thanks.
  7. Dear Everyone can help     i have a batching system of about 12 materials and i need to generate a report for all batches in the day in runtime, i tried using SQL with Cicode but sometimes i can't find some material's data or to be Zeros. did any one here know a way to do that?? vijeo citect 7.4 thank you
  8. Cimplicity Auto Report Generation

    Dear All, I am having a problem with my cimplicity Auto Report Generation, When I Click on Generate Report, it shows "0 values collected" does anyone knows what's possibly could gone wrong here ??
  9. Hey Guys, I'm somewhat new to Data logging so try to bare with me. I'm trying to setup Data logging in Factorytalk View SE to log to my SQL database. I have created the 32-bit ODBC system DSN. Created the datalog model in FT View Studio and selected ODBC and it created my tables fine (Float, String, Tag). I chose Login required. I also setup a File backup path. With that being said, when I use the command DatalogOn- It will start the Datalog model without any errors, but will only log to the backup path. It isn't logging anything to my SQL DB. I thought it could be the firewall blocking it so I created a rule to allow connections through the specified port. SQL is also allowing Reading/Writing.  Let me know if you guys have any suggestions. Thanks!
  10. I am starting my own consulting business, so put my experience and technical know-how to work and ensure the success of your process control projects.  No project is too small!  I hold a Bachelor’s of Science in Electrical Engineering from The University of Arkansas, and obtained an Arkansas PE license in 2014.  After working for a Generation and Transmission company as a power plant controls engineer, I have decided to put my skills and experience to work as an independent consultant.  My SCADA/HMI experience includes GE’s Proficy Cimplicity software, and Rockwell Automation FactoryTalk View SE.  I also have experience programming controllers using GE’s Proficy Machine Edition, Rockwell Automation Studio 5000 and RS Logix, and Emerson Delta V. Check out my LinkedIn profile at https://www.linkedin.com/in/trevormarmstrong for more details regarding my experience and past projects. Contact me through these forums, LinkedIn, or via email at tmarmst@gmail.com any time for more information on my services or availability.
  11. Cimplicity 7,5

    Good Day There is a SCADA Cimplicity and controller Control logix 5561 AB. Communication between them is organized via Ethernet IP. It is necessary to transfer some tags from the Cimplicity to the controller Control Logix. How to do it better? Through Rslinx DDE OPC or write scripts in the Cimplicity? 
  12. Change Management LogIn(lost password

    I cant able to make any changes on the points (datatype from INT to DINT) on cimplicity workbench  everything thing is greyout!! i checked and found that the workbench has a change management logOn option asking to logon! Which asks for user name and password!! And No one here Now has the user name or its password!! what to do now on such cases , Also on doing modifications on logic developer validating project generates error  may be due to mismatch data type of that associated point on workbench.
  13. Could someone please generate PDF report for the ACD files on the attached .ZIP file? They are all RSLogix 5000 v20 files, I needed them for a university report which the deadline is today, but I don't have access to a computer with RSLogix 5000 :S Thanks!  ACD_files.zip
  14. 8_decimal Data Displays as only 4_Decimals !

    I am Facing Problem Getting Kwh Readings From My Satec MFM(PM130-PLUS), Required for an easy & reliable Monitoring On Energy Consumption . Connected via RTU Slave Interface with SCADA User Interface (GE_Cimplicity). Here's what happening : Actual Kwh Reading has 8_decimal data digits on MFM LED Display but on Cimplicity SCADA User Interface Screen It only able to Display it as 4_Decimals point digit, eg, 63290058 kwh shows as 0058 , and 15299999 kwh shows as 9999 , and then 15300001 kwh shows as 0001 i.e 1 only! Plz Do a Rply , your slight approach to my Query Will be highly Appreciated!! :)  
  15. Hi everyone...im new on clerarscada 2014 R1.1 . I dont know how to generate report in clerarscada 2014 R1.1 . Only report generation is remaining in my project. Is anyone known about this. Plz help me
  16. hi i am using vijeo citect 7.4 i generate a report automatically using a triger but the report generated in the .rtf form which any body can change the values in the report so i want to either make the report in the read only form or convert it automatically to pdf + i ' ve another problem i am tring to write a string in the report using the form {tag_name:############} where the tag_name is a variable string memory where i store in it a word "starter" when the report is generated only two letters "st" is generated can any body give me a solution for these two problems , thanks in advance .
  17. Cimplicity 8.0 Alarming

    Hi Guys, I am new to Cimplicity SCADA but I was familiar with HMI. Now my requirement is to separate / dedicate the alarms to each process or setup in the respective screen. Prior they have made all alarms to fire on all screens/ all process. Now idea to separate the alarms in the respective screen. In all screens on top, if I click on alarm object, its properties are Link Container and it has Link source file as xxx.cim and Link source Object as Alarm. Please guide me from the beginning, how they configured the existing alarms also I am not understanding. I need help please. Thanks a lot.
  18. I am getting this error. How to resolve this?