Search the Community

Showing results for tags 'Database Table'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Found 20 results

  1. 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.  
  2. 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!
  3. I want to create a database that keeps track of all of the different PLC and automation hardware (Remote I/O, Flex I/O, Robots, etc.). It would include data such as firmware version, when the backup battery was last replaced, location, etc. I have started doing this in MS Access but I was curious if anyone knew of an existing software that already does something similar?
  4. FactoryTalk SE - VB Script

    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!
  5. Hello.   I'm trying to communicate between two PLC's  using FINS function block _CPU011:ReceiveData.   PLC1: IP 192.168.1.50 (MASTER)   PLC2:IP 192.168.1.51 (SLAVE)   If I don't use »IP Address Table« everything works using NODE number &51.       The problem is that on the real project these two PLC's will be on different subnet.   For example:   PLC1: IP 192.168.1.50   PLC2: IP 192.168.2.50   So I will have to use »IP Address Table« to achieve communication between these two PLC's.   I tried to sett IP Address Table on MASTER: Node 1=192.168.2.50   But If I try to communicate I see that packet is sended to network but I've got error #1005.   Do I have to sett the SLAVE IP Address Table?   Hoe to do this?   What are the right settings for MASTER and SLAVE IP Address Table?     I'm attaching pictures of CARD settings.  I don't want to use CX-Integrator because I would like to make project to UPLOAD and forget.       Thanks.  
  6. C500/C120 Support

    Hi Could anybody tell me if the C500/C120 support tool in CX Programmer uploads the I/O table when it uploads the program from a C500. I have already backed up a program from a C500 using SYSWIN but SYSWIN doesn't allow me to edit, create or generate an I/O table, so when the program is downloaded to a sister machine, I get I/O errors that can't be cleared. Any help grateully received
  7. Legacy Factory Talk View Project

    Good morning everyone!   I tried to open an older project with Factory Talk View ME which was last opened with “FactoryTalk View Studio 5.0 “. The current version that I have installed and licensed is Release Number 9.00.00 (CPR 9 SR 9), Patch/Pack Number: 00, Build Number 241. Upon opening the project, I receive the following error message:   “The target HMI project is a legacy project (Factory Talk View v6.00 or earlier). Please use the legacy Tag Database utility to convert its tag database to the new format (Factory Talk View v6.10 or later) before opening the HMI project on a computer running on a 64-bit operating system. Refer to Help for guidance.”   I tried to use the Legacy Tag Database Conversion tool, selected “Create Factory Talk View Tag Database in new format”, then I selected “Factory Talk view Machine Edition”, selected the source folder and used the option to “Search Sub-folders”. After hitting the Next button it shows a list of available projects, but the one project that I try to convert is not listed.   Any ideas how to approach this? Is it possible to install multiple revision supports with Factory Talk View? So, far I always used the latest and just created the run time as an older version, if the panel I used wasn’t updated.   Please let me know what you guys think I should try.
  8. I am using FactoryTalk View Studio SE 8.20 to develop SCADA Application, and whenever I tried to open Tag Database it shows error "an error occurred while attempting to open the tag database editor" and not able to Open Tag database. Does anyone know solution for this? Error Screenshot Attached
  9. Hi, this is my problem, I created an app on FT Administration Console, in fact, one for network and one for local, I changed the connection to local on Log On FT, but, when I try to define the data points on Step 3 of configuration checklist, only shows me the network app, i select the app, after click OK, the FTTM freezes, anything else happens, I don´t know what am I doing wrong.  
  10. Hi guys, I'm attempting to implement a fuzzy logic controller from scratch. I plan on using a lookup table to assist with retrieving the membership value. Does anyone know how to implement a lookup table. I know there is a L9P_LKUP block in the LL984 editor..except I'm not sure how to actually enter in the parameters or read from it.   Kind regards, Luchek
  11. Hello everyone, I hope you are all doing very great, I'm new to Schneider PLCs and I have a project that I need to work on, so I will need your help with the following issues: *) How can one determine which Schneider PLC series is used if you only have a fuzzy picture of the PLC ?  *) I need to setup a historic of alarms, I have 13 PLCs, no connexion between them... I was thinking about creating a connexion between those PLCs and a database, so I need your help to determine a list of ALL the materials i will need (from cables to servers to a computer if necessary...) and some documentation on how that can be done... Thank you so much for helping me, Best regards
  12. Here is a recent post that I would like to share. Using Visual Basic 2015 we will log three holding registers from the PLC along with time and date into a Microsoft Access Database. We will log every minute into the database with the information that we collect from the PLC via Modbus TCP (Ethernet). All code will be done and shown so you can implement this in your application with different parameters. The information collected in the database can then be distributed or analyzed in the future. Visual Basic 2015 will be used with the EasyModbusTCP client/server library for .net. We will communicate to an Automation Direct – Do-More PLC. Using the free simulation software of the PLC Designer Software, we will retrieve three values of the Modbus Holding Registers using Modbus TCP. Once we have this information out of the programmable logic controller it will be placed in a Microsoft Access (2010) Database. This will be done by using a SQL command to insert the data. Read the rest of the post... Let me know what you think, Thank you Garry http://accautomation.ca/
  13. 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.
  14. connecting ixt4a to a cj1m/cp1l/ns network

    hi everybody i have a network with 2 pieces cj1m and 2 pieces cp1l communicating with a ns15 monitor. everything is fine. i need to connect an ixt4a monitor in that network. my question is : do i have to make new routing tables or it is not neccessary? my routing table for cj1m and cp1l cpus are attached. if then i have to make new routing table so that the cj1m will be able to communicate ixt4a monitor, how am i going to do it for both monitors? Any help will be mostly valuable and appreciated. thanks
  15. For some reason, some of the symbol names and comments in my symbol table in my project have disappeared. They are present in a previous version of my project. I would like to copy the symbol table from the old project version into the new project version. Can I do this by simply copying a few files from the old project folder into the new project folder? Which ones?
  16. http://accautomation.ca/now-you-can-have-robust-data-logging-for-free-part-1/ YouTube overview: https://www.youtube.com/watch?v=6Xa2HYVOxE0 Robust PLC Data LoggerWith traditional loggers, software will read the memory of the PLC and store in a local computer. If the network stops or the PLC communication fails then the logging will stop.Creating a robust PLC data logger allows the communication to be stopped for a period of time without losing any of the data for collection. This is accomplished by storing the data locally on the PLC until communication is restored. All of the data is then read without loss. The amount of time that the connection can be lost will be dependent on the memory size of the PLC and the frequency of the data collected.This series will walk you through the steps to create and implement a robust PLC data logger using the following equipment and hardware. Automation Direct – Do-More – H2-DM1E PLC (Ethernet Modbus TCP)Do-more Designer 1.3 (Simulator instead of PLC mentioned above)Windows based computer running IISVisual Basic 6Regards, Garry http://www.accautomation.ca
  17. I have a list of 100 faults for my machine. Each fault has an integer variable in the symbol table, containing an integer that matches its position in the list. Say I then want to add a fault in at position 12, I would then have to renumber all the following faults. Is there a built in way to do this automatically? Alternatively, if you have any other suggestions for achieving a similar thing, I would love hear them.
  18. I have had a GE 90-30 CPU331 in my house for 17 years with no trouble at all. I have a problem that I have never seen before. I was editing the program using LM90. I don't know what I could have done in the program to disable an output. Just 1. All the rest of the points in that group on that card still work. I swapped cards with no difference. All of the elements of the rung are true (highlighted). The output is not on or highlighted. The nickname over the output has ONE letter highlighted. The bit in the reference is "0" and is highlighted or "grayed out" (the cursor is not on it). I searched for coil conflicts. I am using this output contact lots of places but only one output. The logic is working correctly when I use another output or %M. This is an isolated output which needs to be in this group (moving it would be awkward). What does a "grayed out" reference bit mean?