Search the Community

Hi there, I am having issues writing data from a DTI table to file. I created ladder logic to write data to files on a regular basis. I couldn’t use the normal Data Sampling functions, as although I need to log to file regularly, there are times when the (measured) system state is unknown. At these times I have to stop regularly logging to file and wait until a certain period has elapsed before I can accurately assess the system state and start logging to file again. So what I do instead is regularly write a row of data to a DTI table, inserting it at the top so that the rows all move down one, using the Insert Row in DTI function. When the system state is known, I write a row of data from the DTI table to file every 2 seconds. When it is unknown, I record the row of data in the DTI file, then when the system state becomes known again, I "catch up" writing all of the rows I have not yet written to file from the table, one at a time. This has to be done one row at a time as the files are appended to one row at a time and so the oldest data is at the top of the file, but at the bottom of the DTI table. I am logging rows one at a time using the Store DTI to File function, appending to file and using the CSV option to make sure I get a CSV file as well as the default UDTF file. This is because it’s easier for the end user to open a CSV file rather than have to convert it first, even if it does come inside a .zip file. I was sent a converter that converts UTRF and USMP files to CSV, but not UDTF files - is a converter available? When logging to file, I start at a certain time and use that as a date/time stamp (in the format yyyy-mm-dd_hh'mm'ss) for my file name, so before the weekend, I set the PLC logging every 2 seconds, and it started with a file name of "Data_2014-12-12_18'24'37". I set the ladder up so that if the number of samples in the file exceeds 60,000, then the file name changes, so that I can start logging to a different file and so split up the data into multiple smaller files that will open, even in old version of Excel. So after a couple of days, it made a new file name, "Data_2014-12-14_03'46'06" and started logging data into that. The issue is that while the PLC made both a UDTF file (which I can’t open) and CSV file (in a .csv.zip file, which I can open) for the first file ("Data_2014-12-12_18'24'37.udtf" and "Data_2014-12-12_18'24'37.csv.zip"), it didn’t make a CSV file for the second file. I have looked for these files on the SD card of the PLC using both Uniapps and FileZilla, via FTP. There is more (perhaps linked) strange behaviour when looking at the SD card contents via FileZilla/FTP, and pressing F5 regularly to refresh the view of the contents of the DT folder on the SD card. There is, in the DT folder, a .csv file, with the first file name ("Data_2014-12-12_18'24'37.csv"). This file is not inside a .zip file, and, even though the logging to file is now stopped, the file is seen to grow in file size from very small to about 7.5 MB, then another strangely named file, like "ziFheLDg", or "ziMqNiMw" will appear, then that file will disappear and the .csv file will shrink in size and then grow again. This seems like it might be the PLC regularly re-writing the UDTF file to a CSV file, then zipping it into a .csv.zip file, but that’s just a guess. But the thing is that it’s still doing this for a file that’s already been written to, and so doesn’t need re-writing to a .zip file. When the file name has been changed and a new file is being written to, how can I get the "also save as CSV" option to stop writing the old file to a .csv.zip file and start doing it on the new file?

Does UniOPC support historical data access (HDA)? If so, is it possible to access data tables in memory and on SD card? How? If not, what is the recommended way to do a fully automized download of logged data? I am using Vision OPLCs. Thank you for clarification, Ronald

G'day! I'm having some issues retrieving info from a specific row in a table, is there an easy way to do this? I've tried using "Read Row from DTI", but it asks me to use a struct as an output with the same row structure, but I want this rows output to go into a single variable. Thanks, Exouxas

Hello, My project involves filling a data table with real time data, and in order to progress through the experiment it needs to read the last 100 values recorded, sort them, and then get the resultant range. So I only need to read the last 100 values of the column I am currently fillling up during the program, but I only see a function that copies the entire row to a vector. This wouldn't work as the column has more numbers than the MI memory has operands. Is there any way to only put part of a column into a vector? Thanks in advance!

Hello, I'm using UniLogic and I want to copy only a column for example recipe names. In the VisiLogic software this is possible with a function under data tables. How do I do this in UniLogic? Thanks, Jan Martijn Lenselink

I want to copy from an Array (INT16 × 15) to a single DTI cell which holds a similar array. In effect I'm trying to copy one dimension to another. Does the function 'Copy array to column in DTI' allow this? The compiler allows me to set the function up, but no data seems to be transferred. Regards, Robin Proctor

Hello everyone, I have a few questions about the software Unilogic and using it together with the USP-070-B10. First, what I want to know if it is possible to read the files on the SD card in the map "/DT" and especially the files for the data table because I want to show the user which files are on the sd card, but I dont want to use the uniapps menu. I have created now that everytime the user send a file over ftp to the PLC, the data table will add a new row with the name, but if the user change the sd card or remove a file from it, the PLC need to see this also. Second, I have created a data table with strings, if I'm trying to search for a specific string a column. But if the string is for example 10 long and the word I'm trying to search is only 4 long, I cannot find it. But if i make search first from 10 long and the second 9 and the third one 8 the value will be found. but the fourth value cannot be found with a length of 7. this mean that I can only search for 3 different lengths, but if the users insert more different values between 1 and 10, only a few values can be found in the data table. But if you use integers and search for integers he can find all the values. how can this problem been solved? the search value will be typed in a text box on the display. third, Is it possible to program on the PLC that if there are any excel files on the SD card to create a data table file on the PLC itself. then the user can send the excel file through TCP to the PLC and does not need to send the data table file. If someone could help me with this problems, you would be thankfull! Leon

We have used Pcom to communicate to the data tables in the vision series. How do you recommend communicating to the data tables with the unistream? I would like to connect to a database that I built in Ms access. What would be recommended method?

Hi all, I've been spending almost one day looking how I could compare to ASCII strings without success unfortunately. The idea is to compare a string from the HMI (username) with a String inside a user account data table loaded into a struct row after row. This is just to be able to make a kind of login function with user and password protection. Guillaume

I am using a V1040 with a Data Table in which I need to write/edit values. The Properties setting for allowing this is greyed out. Can someone tell me perhaps why and how to fix it? Thanks.