Jump to content

Search the Community

Showing results for tags 'data tables'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Our Community
    • Come on in!
  • News and Announcements
    • UniLogic 2021-- UniCloud IIoT Cloud Platform, EtherCAT & more!
    • VisiLogic:9.8.64 - Link to mobile app, Ladder: 2x the Space!
    • New!!! ***** U90 Ladder*****
  • UniStream HMI + PLC Programmable Controllers & UniLogic Software
    • UniStream: Hardware
    • UniLogic Software
    • UniLogic UDFBs
    • Industry 4.0, IioT, MQTT, OPC UA
  • Vision, Samba, Jazz and M90 PLC + HMIs & Software
    • Vision & Samba PLC + HMI Controllers & VisiLogic Software
    • Jazz, M91 PLCs and U90Ladder
  • Motion! Servo Drives, Motors, Actuators, & VFDs by Unitronics
    • Motion: Unitronics Servo Drives, Motors, Actuators, VFDs--by Unitronics
  • UniCloud: the end-to-end IIoT Platform for Unitronics Controllers
    • Everything UniCloud!
  • Software Utilities
    • SD Card Suite
    • Remote Operator
    • Remote Access
    • DataXport and DataXls
    • UniDownloader
    • UniOPC
    • UniDDE
  • Utilities for .net and Visual Studio
    • Unitronics PCOM Protocol
    • COM Object ActiveX .dll
    • .NET driver
  • Project Design
    • ...I have a project...what hardware do I need?
  • User Application Stories
    • Just finished a great project?
  • Tips and Tricks
    • Best Programming Practices
    • Tips and Tricks
  • Job Board
    • Projects seeking Programmers
    • Programmers seeking Projects
  • General Discussion
    • We're Listening...
    • The Lounge
  • News and Announcements Copy

Blogs

  • Unitronics' Blog: PLCs, HMIs and more
  • Saragani's Blog
  • Simon's Blog
  • Ash Neilson's Blog
  • Joe Tauser's Blog
  • Unitronics en Español
  • Powered by AMPS
  • Alldrives UK's Blog
  • Unitronics, Howman Style
  • PLCNewbie's Blog
  • Telestar Automation Blog
  • Webinars Collection
  • Tim's Corner
  • Blog
  • TELESTAR (Italian)
  • i4 Automation
  • i4 Automation (UK)
  • Unistream UDFB's

Categories

  • From Headquarters: Sample Applications
    • From Headquarters: VisiLogic
    • From Unitronics: U90 Ladder applications
  • User-submitted Applications
    • From Users: VisiLogic applications
    • From Users: U90 Applications

Categories

  • Articles
    • Forum Integration
    • Frontpage
  • Pages
  • Miscellaneous
    • Databases
    • Templates
    • Media

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

  1. Hi, I'm trying to build a log for my system using the Store DTI to File function. This runs after the struct containing the date is inserted into row 0 of a table, which should be appended immediately to the log file. The writes are sufficiently spaced (~30 minutes) that the SD write interval isn't an issue. I've found that when using option 2 "Only CSV" for the "Create CSV" input (F), the file is simply overwritten, and only ever contains 1 row. Option 1 "Create CSV File (All - udtf,csv,csv.zip)" does append correctly. In both cases "Append to File" (E) is set to 1 "Data will be appended to the file". This looks like a bug to me, and combined with the missing documentation for those options, I've wasted a little more time than I'd like trying to figure that out. Option 1 is an acceptable workaround, so I don't need further support, but this should be fixed. Sandy
  2. Hello, I have an application in mind where there are multiple portable machines on an assembly line that each perform the same basic function (lets say they are volumetric dosing machines). Each has its own PLC. There are about 100 different products and each unit has 3-5 different doses of said product as the unit moves through the assembly process. Of course each machine could have its own recipe table but then keeping all the individual machines in sync becomes very challenging. I want to have a central remote database/table (preferably a user friendly excel file). From each machine I would like to be able to "pull" the latest recipe list. One user (production manager) would control the master excel file and then all machines can update from that. Within Unistream it seems i can load a DTI from a remote file however that file must reside on the SD card. I can also import or create a DTI from an excel file however that tool is only available from within unistream. I want the end user to be able to do that from the (virtual) HMI but there does not seem to be a related ladder function. I can see a way to do this through SQL however that is a little more cumbersome because the user would need to manage the SQL database somehow and that interface would likely be excel so why not skip the SQL part. Further to this concept, is there a way to group PLC's and communicate with said group from one HMI/webserver? From the above example, once the recipe file is loaded i would like the user to be able to choose 5 machines out of a group of 10 to assign to a job and then enter the Product ID# to call up a recipe and then have all the machines assigned to that group call the same recipe from that product. Basically i'm wanting to avoid having to go to each of the 5 machines and enter the product ID# independently. Similarly, it would be cool to command all machines in a set group to "pull" the master recipe list at the same time, just to avoid have to repeat the same command for each machine. Machines are portable so not hardwired to a network but would each have a wifi adaptor. The mater "excel" file would reside in a folder on the network. I hope that makes sense. Please feel free to ask me to clarify anything. Thank you.
  3. Hi, Where do I find how to change the data table font size appears in the HMI screen?
  4. Hello all, I have to read and make a sum of datas from a column of a data table . Can you help me how to resolve it? Thank you
  5. Hi, After removing some unused fields from a data table then compiling I received the following error "Data Table delegate creation error, please contact Technical Support" What does this mean and what do I need to do to rectify this error. Thanks in advance
  6. Hi, I am facing one issue when adding strings into the 7th row in the index data table, with no issue before that. The error message is "Value is not available". What does this mean? Thanks, Charles
  7. I'd like to use a list in a combo box from a data table column on Unistream PLC. Is it possible? If yes, which is the easiest way to realize this? Thanks in advance for the help,
  8. Is the help topic "LF: Write Value to DTI column" referring to the toolbox item "Set DTI Column Value"?
  9. Hello, i have a question regarding the file name in a store dti to file function. i need to create a new file every time i run the function which is set to happen every day at 6am. is there a character restriction in the target file name string? i would like to utilize the dd/mm/yy string that the RTC to ASCII V2 function creates as my file name if possible. at this point i am pre planning a project and do not have a physical controller to test. thanks ricardo
  10. I like to link different Data Tables (Indexed) to one Function as IN parameter. Has someone done this already? What I'm doing wrong? (Please see example Function1 Rung 1; Direct linking is possible Function1 Rung 2)
  11. Anyone want to attempt to interpret this warning alarm? "Inserting rows to an 'Indexed Data Table' when the insert index in a small number can increase scan time and cause a CPU Watchdog." Is there a typo in the message? This warning didn't exist in an earlier version of UniLogic and I'm not sure what to do about it.
  12. we are trying to use a plc to connect to the network so it can automatically reload a data table periodically to make sure it is up to date. As well as how to have an excel sheet be converted to a udtf format for the plc so that we don't need to manually do that each time. I am currently only finding how to load files from an SD card, and not how to use the Ethernet connection to retrieve files.
  13. Hi, I wanted to know if there is a possibility to attach a date table in an email. Please, I would greatly appreciate your response.
  14. Partners, I'm having trouble moving information from one DATA TABLE to another with the same structure. The structure of my data table is as follow: Floor/number/day in/month in/year in/day out/month out/year out/hour in/time in/hour out/time out/money/quarter When a specific event happens, program calls a function that saves date and time (year in, month in, day in, hour in and minite in) in specific place of data table index A (this way I know where this event happened, becouse the first two columns on the table are the reference of the place) In table A the first to columns have constants values and never changes. When another event happen program calls another function that reads a specific row of table A and paste it on row 0 of table B adding as well the rest of the items that are mising (year out, month out, day out, hour out, minute out, money and quarter) that are calculated in this function. So table B is a registry of the events that ocurred. When I visualize TABLE B, I see all the information except the two first columns that are set as 0. I wonder if there is something Im doing wrong or if is it a specific whay of doing that. Thank you so much for your help. Marcelo
  15. Hi Everyone, I'm new in Unilogic and I would like kwon how to export data tables to Excel since a HMI button. The PLC reference is USP-104-B10. Please, it's urgente.
  16. I need to send a DTI Column into array, but UniLogic help is not clear, please could you give me an example of ladder logic ?
  17. Hello all, I'm pretty new to controllers but I have done some research around. I have sensor data, along with real time data that i'd like to store in a data table and transfer it once a day to my PC. The sensor works all the time, so i'd like to store sensor data every 60 seconds inside the table, and one a day (1440 lines) to send it as a .csv file. My local Unitronics supplier suggested my to get USC-B3-T20 for this application. Problem is that the data table stays empty for some reason, information won't push into the table. Please see attached photo of my project and also file. I'd be glad for a direction. Thanks. Project.pdf Stack 5 TVOC Measurement.ulpr
  18. What is the most efficient way to store date and time in an excel table so that it is easily view able in Excel? I converted it to a string, but the strings take up too much PLC memory. Excel can't natively interpret Unix time, so that won't work either. Is there something else Excel can interpret that I can store it as?
  19. Dear All, I am doing as follow: import a CSV file (copied from USB stick in the "data folder") with a single row of 23 Strings (each String is 25 lenght); create a UDTF file from this CSV; upload the UDTF to a DTI; read the DTI row. each of these action is done in a specific ladder rung; each rung check if the previously action was perfomed without problem...then at the end my CSV is converted; the DTI il filled with right values but when I read the DTI row I don't have any error (exist status "0") but the struct variables is not filled (all single field is empty)...I tried to write the DTI with the same struct and all works...the DTI take the new value...I forced the action (cvs->udtf->dti->read) then the DTI take the value of the CSV file but nothing change...the struct fields still have the previusly values. what can be wrong?
  20. I have a 480 Data for every minutes Now I want sum it up and divided by 8 hours average? How to sum up all data from data table and how to sum selected data for example 1st 15 minutes data average
  21. Hello. Am programing Unistream PLC model USP - 070-B10/B08. The program i need to make is User Logs with Data table. With UAC i add needed users also am making Data Table indexed and am writing the logs (log in or out ) into the data table. Also there is a possibility to enter in the HMI the batch number/lot that is later added to the Data Table depending on the user who is logged in at the moment. After that with a button on the hmi i set bit and Store DTI to file block is added. As i can see everything is good and this DTI block does not give me error. After i open the ftp server the SD CARD is empty. I chose in DTI file block to save it as .csv file format. I have no idea what might be happening. The sd card is 16 G card that i format FAT32. Please Help Thanks.
  22. Dear Sir, I'm using UniStream PLC and I have log Data to data table and make data table Retain. i have problem it that Data table row is limited for retain Data because data table save in RAM. How make data table directly into SD Card? And any way to show Data which in SD card directly HMI Data Table?
  23. Hey, Each day we want to start writing data to a new file. Our file name string is updating fine using the rtc to ascii UDFB, but our store DTI to File status turns 1 when the filename is updated with the new date. Then after another full "day" it becomes -35. However if we never change the filename the data recording continues to work fine. I apologize if this is already explained in another forum but I wasn't able to find one. Thanks for any help your willing to give.
  24. Hello, We are able to log sensor data to the data table, we record it once every 5 seconds. However, after 10 recordings we are trying to write the 10 lines to a csv file. (Ideally appending it) Firstly, appending just doesn't work (when we put the 1), the file doesn't update at all. When we put 0 to override, the values go in but only one and a half rows. Any ideas? Thanks!
  25. Hey, What is the best way to get a column to show the Date and Time information? Right now I have a separate column for each feature like month, day, year, hour, min, second but that's definitely too bulky. I can't seem to find how to create a single string of the date and time information, what would be the best way to solve this? Thanks.
×
×
  • Create New...