Search the Community

Showing results for tags 'legacy tag database conversion'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Found 42 results

  1. 2 Words to Real

    Hi:       There are 2 Word, Let say  Word_0 = 5c29, and Word_1=3e8f, I combined that 2 word into  DWord=3e8f5c29; The result converted online (https://www.scadacore.com/tools/programming-calculators/online-hex-converter/) to Float will be 0.280 (expected result).   But with DWORD_To_Real , i get this result :    1.0354898e+09    REAL          May I know how to convert the 2 words into Real (Float ?) Omron PLC: NX1    
  2. I would like to get some feedback or alternate suggestions in terms of monitoring a database connection. The attachment here shows the current programming for the DB_Connect function block which requires the Execute input to constantly be ON.  From what I can tell, if the connection is dropped - let's just say the Ethernet cable is unplugged - this input will still be on, and according to the function block, still connected. The Get1minClk is in place to continuously try establish this connection once powered on, but I cannot find any way to periodically check this connection without dropping it and reestablishing it.  My understanding is the _DBC_Status.Run only checks that the PLC service is running properly, but is there a way to monitor a heartbeat of the connection TO the database?  The only way I've found thus far is to drop the connection and reconnect.  But this would be detrimental to the system as it would possibly be reconnecting to the database while trying to write to out to it and hold up the show.  As it stands in the second image, the Ethernet cable is unplugged, but the connection shows no errors. Thanks and happy Friday! -K  
  3. Hey guys,   I am looking to query a database through FactoryTalk SE.  I will be scanning packages, and using that bar code to find a lane assignment from the database.     My question has to do with where the VB script will reside in the FactoryTalke SE program.  I want this script to run at all times.  I see that each screen has a "VBA Code" but I am assuming that these will only run when the screen is visible.   Where does this have to be stored in order to run all the time?   Thanks In Advance!
  4. Hi friends, The scene is like this... I have some 200 energy meters whose readings are continuously logged at 15-min intervals into a logging table. The meter does not have any other value logged. Let's consider these readings as analog tags. However these tag values are continuously increasing to ever larger numbers. Thus we have a problem for display on trends. Customer now requires that the Citect shows usage trends for any meter for a specified period of the past. That is to say, the meter that he wishes to observe is selected - along with a period typically between 2 dates (perhaps also with a sampling period) - and the trend must appear. So in other words, given a single trend object, how do you make values appear for any selected tag on this trend. Perhaps this can be overcome by some genie/super-genie mechanism. My approach to this is...For the selected meter, I use SQL to query the 15 minute logged values (also taking into account the required sampling period) taking the reading on starting date as initial. All values thereafter are subtracted -within the SQL query- and the result of this query is kept in a 2 dimensional array(x for time, Y for value) or a new database table so that the trend displays values starting with zero. This much I can do with Cicode. After this, I need a method to display the values so obtained in a trend object. Essentially this is the same as feeding a trend object with a set of X & Y values that I have in the form of an array or in a database table. I shall greatly appreciate any help to meet the above objective. Thanks for looking in. With best wishes.
  5. Hi, I have old E600 HMI and i want to convert the program to new c2 or x2 series hmi, is it possible to convert program to new one by some procedure or software, Thanks Amin
  6. Hello people! I'm using a NX1P2 controller combined with a CIF105 serial card installed on it. For my project, I get some data that are in ASCII form and I want to keep that form when are extracted in a .csv file. I have established the communication for getting the data but, the problem is that I cannot extract the data in the ASCII form. Data extraction comes in Hex form. I use the NX_SerialRcv instruction for the communication and the AryToString conversion for the data. When using the Watch Tab Page I can display the data in ASCII form but, as far as I understand, this is only for online monitoring. I went through topics here and OMRON manuals for finding any Hex to ASCII conversion instruction but the only info I came across was for CX controllers which cannot be implemented to NX controller. Is there any similar instruction for NX controller or I should create a new Library for the conversion? Any tips and/or a sample would be highly appreciated! Thanks! Man31    
  7. 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.
  8. Dword to Float on FX3GE

    Hello! I have a float number (HEX: 3CA01D0F) in Big Endian. It's 0.0195451062. I get it from the sensor and store it in a double word variable. Could you help me? How can I convert DWord to Float? If i use DFLT instruction, It treats DWord as an integer (1017126159) and just gives me 1.017126 e+009 Thanks in advance.
  9. I am having a problem getting citect to write to my sql database.  Whilst it will write I am restricted by the length of a single cicode command. I think its 255 characters. For my problem I am trying to write 48 tags to the database in one write command to obtain 1 time stamp. Is it possible to write multiple times to the same tables row ? Currently when I write a new row is created at the given timestamp. the cicode is attached. A solution would be to do 4 writes of 12 tags at a time but all would need to go in the same MSSQL table row. I'm ok using the data instead of time and date as this write only happens once each day Any help would be awesome..   *********************************************************************************************************************************** /* **    FILE:        SpurLoad.CI ** * Load Tags from Citect in TO temp array */ STRING tagname[24]="M340_PwrCtrl_SLD0000","M340_PwrCtrl_SLD0030","M340_PwrCtrl_SLD0100","M340_PwrCtrl_SLD0130","M340_PwrCtrl_SLD0200","M340_PwrCtrl_SLD0230","M340_PwrCtrl_SLD0300","M340_PwrCtrl_SLD0330","M340_PwrCtrl_SLD0400","M340_PwrCtrl_SLD0430","M340_PwrCtrl_SLD0500","M340_PwrCtrl_SLD0530","M340_PwrCtrl_SLD0600","M340_PwrCtrl_SLD0630","M340_PwrCtrl_SLD0700","M340_PwrCtrl_SLD0730","M340_PwrCtrl_SLD0800","M340_PwrCtrl_SLD0830","M340_PwrCtrl_SLD0900","M340_PwrCtrl_SLD0930","M340_PwrCtrl_SLD1000","M340_PwrCtrl_SLD1030","M340_PwrCtrl_SLD1100"; /* add array TO hold values */ STRING tagval[24]; INT hSQL; FUNCTION SQL_INSERT_lds() /* Loop FOR number of tags (13 lots of 30 min) TO be read adding to array Variables */ INT i;     FOR i = 0 TO 21 DO              tagval = TagRead(tagname);              END      /* Open ODBC connection TO CitectDB configured in ODBC Manager with DSN_SQL */          hSQL = SQLConnect("DSN=DSN_SQL"); /* IF connection IS OK, insert in TO table "lds" the values */ IF hSQL <> -1 THEN     SQLExec(hSQL, "INSERT INTO lds (dateandtime,S0000,S0030,S0100,S0130,S0200,S0230,S0300,S0330,S0400,S0430,S0500,S0530,S0600,S0630,S0700,S0730,S0800,S0830,S0900,S0930,S1000,S1030) VALUES (SYSDATETIME(),'"+tagval[0]+"','"+tagval[1]+"','"+tagval[2]+"','"+tagval[3]+"','"+tagval[4]+"','"+tagval[5]+"','"+tagval[6]+"','"+tagval[7]+"','"+tagval[8]+"','"+tagval[9]+"','"+tagval[10]+"','"+tagval [11]+"','"+tagval[12]+"','"+tagval[13]+"','"+tagval[14]+"','"+tagval[15]+"','"+tagval[16]+"','"+tagval[17]+"','"+tagval[18]+"','"+tagval[19]+"','"+tagval[20]+"','"+tagval[21]+"')");     SQLEnd(hSQL);     SleepMS(100); SQLDisconnect(hSQL); ELSE     Message("Error Message","SQL TRADING DAY DATABASE WRITE FAIL",48); END END   SpurLoad.ci
  10. Can anyone explain to me what this would mean in a COP instruction? Source: #N[N187:4]:[N187:5] Dest: #N[N187:1]:0 Length: 20 I am doing a PLC5 conversion to rslogix5000 and some (most) of it has been a nightmare -.-
  11. Hi All, I've some problems after converting a cqm1-cpu41 program to a cj2m unit. I am still trying to identify all problems  but the most annoing at this moment is the following. This cpu is connected to a proface HMI, and commands the screens that are shown,  through D1. I am keep getting screen #9 ("press reset"). if i press and hold ALARM_RESET (0.07) and the timer hits, I get the main screen that i want.But after releasing ALARM_RESET (0.07) screen #9 is back again (so that value is wriiten in D1)   This is a snippit of the converted program (exactly the same as the old program) There isn't any other code writing #9 in D1.  The strange thing is that line 210 is doing exactly that ( IF NOT ALARM_RESET (0.07) -> MOv #9 to D1 ) what is see, but how in earth did this work in the old CQM1 unit ? I suspect something with cycle time ? Maybe in the old unit line 217 was executed later and #A was written in D1 'over' the #9. Anyone has some thoughts on this ? Thanks in advance  Jeroen  
  12. I am working on  calculating a checksum value for a command that is to be sent from an Allen-Bradley CompactLogix PLC to a Mass flow controller. An example of a command is the following: "@@@022SX!20.00;CHECKSUM".  1. The checksum is the sum of every characters' ASCII code value (starting from character 3).  2.Then this sum (which would be in decimal format) has to be converted to HexaDecimal 3. Finally, the last two characters of the result have to be extracted and that would be the value of the checksum.  (For Ex: the value of every individual characters' ASCII code (starting from point 3) of the above command is 715. in HexaDecimal, 715 = 2CB. So , the value of the checksum for this command would be 2CB) I got to the point where i found the sum of ASCII code. Any idea on how to convert that to  a HexaDecimal and then convert that HexaDecimal to a string so that I could concatenate it to the command string??   
  13. Conversion from A to Q

    Good Evening everyone, I do realise that this has possibly been done before but quite a few years ago and the links no longer seem to work or links to Mitsi pages that are in Japanese, so please excuse me. I have soem A series PLC kit that needs replacing and I have bought all new Q series stuff to replace(where possible). I have been languishing a little on this project now for a few months but need to get moving. I purchased a GOT HMI and got a good deal on the HMI and the complete Mitsubishi Software Suite the local Mitsi guru said that was all I needed to get the job done. But afetr delving into what came inthe box it seems I need a A - Q Conversion Support Tool https://www.mitsubishielectric.com/fa/products/cnt/plca/pmerit/renewal/case/support_tool.html However I cannot find the software on any of the DVD's that I have and I cannot seem to find a download. So I am stuck now. Can anyone help point me in the right directon? Any Help greatly appreceiated. Thanks in advance.    
  14. Original FX3U project written with GX Developer FX Version 8.45X. I now want to program an FX5U with the same program (well, slightly modified). I have MELSOFT GX Works3. How do I import / convert the original project? I have done a web search but can't find the answer. The installed help files don't seem to cover the topic either. Many thanks.
  15. I have to replace a PLC5 with a new 1756-L73. There are (3) panels involved in system. The main panel controls (2) other panels remotely via each their own 1771-ASB module. Time is of the essence on this project so I am trying to find ways to reduce the required downtime needed to make the switch over. I am going with AB's new conversion method of using the existing swing arms assemblies into a mounting adapter then the c-logix rack on top of that. Question - Can I convert the (2) remote panels first or can they only be done once the main panel with the PLC has been converted over? The remotes only have input & output cards in them.
  16. I am having problem converting a DWORD variable to a floating point decimal.  I've tried using the DWORD_TO_REAL function. Having the hex value "41E9B814" as an input I was expecting to get "29.2148819" as an output. However, I'm getting "1.110194.." as the output. Any ideas?    
  17. In the machine is array with size 100 (ARRAY [1..100]]. Can I simply change it to 200 without data loss?
  18. Hi Everyone, Learning the ropes of SoMachine V4.2 (coming from Arduino and Ucontrollers), I am using a Sequiental step style program and I am receiving 4 error messages. I'm trying to understand why it won't compile.   POU for implicit check is missing. It is recommend to add the POU. C0032: Cannot convert type "IeSFc.SFCStepType(iesfc,3.4.2.0 (systen))'to type BOOL "Same error for a different ladder (the output of ladder rung hits the transition step, the transition is a bool which kicks off the beginning of another ladder rung). C0032: Cannot convert type BOOL to "IeSFc.SFCStepType(iesfc,3.4.2.0 (systen)) Are these two different "data" types?   Thanks in advance!
  19. Hi Everyone,   Learning the ropes of SoMachine V4.2 (coming from Arduino and Ucontrollers), I am using a Sequiental step style program and I am receiving 4 error messages. I'm trying to understand why it won't compile.   POU for implicit check is missing. It is recommend to add the POU. C0032: Cannot convert type "IeSFc.SFCStepType(iesfc,3.4.2.0 (systen))'to type BOOL "Same error for a different ladder (the output of ladder rung hits the transition step, the transition is a bool which kicks off the beginning of another ladder rung). C0032: Cannot convert type BOOL to "IeSFc.SFCStepType(iesfc,3.4.2.0 (systen)) Are these two different "data" types?   Thanks in advance!
  20. Hi all, I am new AB family, currently got into a new project but i have following doubts, Please clarify my following doubts. Project Details : I need  to implement 21CFR part 11 Compliance in AB HMI (1&2) -  2711P-T10C4D1 & 2711P-T6C5D As per my study, i understand that 21CFR can be imlemented by FactoryTalkView(FTV) ME edition V10.00. But HMIs currently available are programmed using FTV 5.0 version. Can we upgrade the FW version of HMI and convert the old HMI backup (from FTV 5.0) to new Backup (FTV 10.00) and load it  without disturbing the old backup HMI screens/settings ? So, Please give me solution .... If you have datasheets, documents, Videos also , kindly share with me. Thank You in Advance, Thanks & Regards, M.Monish Kumar monish.uatpl@gmail.com  
  21. Hello, I am having an issue with FIX Dynamics Real Time Database and the database columns available within when trying to query the database. On a system running iFIX 5.0, there are 19 data columns available, LHS of attached screenshot (in the screenshot example, crystal reports is used to view the columns). However in iFIX 5.9, only 15 columns are available (RHS of attached screenshot ), how can these missing columns be made available to be accessed? Regards, John
  22. Good day, I would like to extract the FT View SE Alarm Log. We currently have got a Excel spreadsheet set up with a connection to the FTAE SQL Database.  When I refresh the data, Excel give an error telling me that the data is more than what can be displayed in a spreadsheet. So it then discards the latest data. I have tried setting a database limit in the Factory Talk Administration console to only keep the last 60 days worth of data but it does not seem to take effect. I get data from January 2017 up to 15 October 2018. Is there a way to configure the ODBC connection in excel to only give me the data for the last 30 days or is there someone that can help me to limit the size of the database? I have attached the current connection config.
  23. Anyone with knowledge of a VBA Run-time error '4205'  Can't find the project database! VBA stops at gTagDb.GetTag  Here are some things I already tried.  Cleared the CACHE files in the project.  Deleted .CAC file in TAG folder,  Removed Watcom SQL 4.0 from ODBC User DSN.  Uninstall and Re-install RSView32 Works 7.50 and then upgraded to 7.60.  
  24. Hey guys,   I have worked on the FTView ME platform many of times.  I am now working on a FTView SE (Local Station) application, and I am having trouble connecting an Offline .ACD file to my program so that I can design.   If someone could help me with this it would be greatly appreciated.   Thanks in advance!
  25. mitsubhishi serial drivers

    Hello write now i am working with Q6UDEH PLC  project in which (nextgen 2000) 6021 card is used for conversion of serial to Ethernet data & vice versa , is it possible  by only installing the Mitsubishi serial drivers ?? or can anybody tell me how these Mitsubishi serial drivers works ??