papouchka

Hello, As part of an industrial project, I need to use the MQTT protocol for data sharing. I saw in the configuration that the Unistream PLC offered several secure transfer options. For each option, it says MQTT/SSL. I'd like to be sure that under the term SSL is actually TLS version 1.2 and not the old SSL. Can anyone confirm this? Thank you.

Hello, I'll answer myself. In the call code for the procedure stored in Unilogic, there was a comment before the call that the server didn't like. By removing the comment, everything worked correctly.

Hello, I am testing the principle of calling a stored procedure in Unilogic 1.33.236 but I have a visible error message in the structure associated with the request: Status: -5 (Not documented in the Unilogic help) Status report : 2031 no data supplied for parameters in prepared statement I am working with a MySQL database. The connector is correctly configured. In PhpMyAdmin, I created a stored procedure to insert data in a table with the name of the dynamic table as described in this link: https://support.unitronics.com/index.php?/selfhelp/view-article/sql-dynamic-table-name but adapting it to MySQL. Here is the code for the stored procedure: DELIMITER $$ CREATE PROCEDURE `insert_data`(IN `idStation` INT, IN `ts` INT) BEGIN SET @varTable = CONCAT('bd_acquisition_',idStation); SET @query = CONCAT('INSERT INTO ',@varTable,'(`id_station`, `date_time`) VALUES(',idStation,',FROM_UNIXTIME(',ts,'))'); PREPARE dynQuery FROM @query; EXECUTE dynQuery; DEALLOCATE PREPARE dynQuery; END$$ DELIMITER ; I tested the call in phpmyadmin CALL insert_data(10,123456); and it works fine. I've tested the call in the LADDER code by giving input values in hardcodes directly in the SQL statement and it works very well (without checking "Is Executing Stored Procedure") But I'd like to provide the input values through the SQL Query block and that's where it gets stuck...The problem comes from the call with the placeholders. Nothing works: ? , :param , @param , With or without "Is Executing Stored Procedure". Does anyone have any ideas? Thanks in advance

Hello, I'm re-launching this topic to find out what is the status of the background color customization function in "State Machine Button". I am creating a HMI with a tab system to access different settings and I would like to be able to change the background color of these tabs to see which one is active, inactive and in use (Focus). The background color would be a definite plus for a better user experience. Do you have an idea for a replacement? Sincerely, Translated with DeepL

Not at all. Flex proposes to configure Excel to take into account the decimal separator that you want. I found Unistream Data Converters Suite on this link : https://www.unitronicsplc.com/software-unilogic-for-programmable-controllers/ At the bottom of the page.

It's an idea but it adds extra processing. On the principle it bothers me a little. I have the impression that I can't do the configuration I want. I have just tested the converter proposed by unitronics which allows to obtain an Excel compatible file from an udtf (Comma Separator) and it works. I will go with that for now. Thanks for your help.

Thanks for the info but I'm already in decimal separator with the comma in excel. This works fine for data entry but not for a csv import into excel. The automate saves the reals with a point as separator which is always present when importing into Excel. I then do an automatic replacement of the dot by a comma, it doesn't take much time but it has to be done every time, which is annoying. The objective is to know if we can configure this decimal separator directly in the automate so that the real numbers are recorded with the comma as decimal separator!?.... any idea?

Hello, I am re-launching this topic because I have the same problem. I save at regular intervals a data table into a csv file with the ladder function : store DTI to File. I use the parameter F to 1. When I export the csv file to import it in Excel, I have to manually replace all the dots by commas to use the results in excel formulas. Is there a way to configure the decimal separator to indicate the comma and not the dot ? Translated with www.DeepL.com/Translator (free version)

Thank you very much. I knew there was a sync but I didn't think to look in the UniApps config. Have a nice day

Hello, I am testing the API REST module to retrieve the INSEE code of the French communes according to the Postal Code. I would like to know if we can create a array of struct in Unilogic in order to match the results of the query ?

Thank you very much. I managed to find the elements in the doc. Unitronics also replied to me and it turns out that most of the items I wanted info on are items that are used for internal debugging and so I have no use for them.

Hello, I just realized that the RTC time of the unistream automaton had changed with the time change. I am surprised because the FAQ from PL-System, the French distributor of Unitronics, says that the PLC does not change the time automatically. I don't mind but I would like to be sure because I need to display the current time to the user and keep a universal timestamp for saved data. So I'm thinking of using RTC for the user time if it changes automatically according to the season and I'll use UTC for the timestamp of my data. Do you have any info on this time change thing? Translated with www.DeepL.com/Translator (free version)

Hello, I just sent a ticket to support to ask them. If the answer is relevant, I will put it in this thread. Thanks Brice

Hello, I have been working for a few weeks on a unistream USC-B10-TR22. I can't find in the documentation precise information about the system structures proposed by default such as : System Error Execution Ladder ERRNO etc... Some parameters are easily understandable but not all of them are for me. Do you know if there is a specific documentation on these system structures? Thanks in advance for your help Brice

8 years later, I am doing something similar. 😁 To go from UINT to REAL I used the "store" block to put a UINT in an INT and then I applied a formula with the right parameters. Multiplication by -1 should work but I don't know what is better between "multiplication by -1" and "store" from a memory and CPU resource point of view. Does anyone have an idea?