Skip to Content

Changes for page 06 Data Tool

Last modified by Jett on 2025/02/18 16:43
From version 20.1
edited by Stone Wu
on 2022/08/02 11:56
Change comment: There is no comment for this version
To version 27.1
edited by Hunter
on 2023/01/09 18:37
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.Stone
1 +XWiki.Hunter
Content
... ... @@ -180,26 +180,23 @@
180 180  
181 181  * **Recipe Folder:** Give Recipe folder name (It can be used, when setting Recipe display object);
182 182  ** **✎Note: **Recipe Folder name can only consist of (0~~9), (a~~z), (A~~Z), ('_'), (' ') and other non-English characters;
183 -* **Group: **It sets the groups' initial number of recipe;
183 +* **Group: **Set the recipe group number, the number of elements, the data format. The data format has 8 modes: 16-bit signed decimal, 16-bit unsigned decimal, 16-bit BCD, 32-bit signed decimal, 32-bit unsigned decimal, 16-bit BCD, 32-bit floating point number, 64-bit (double-precision) floating-point number, string, and the choice of data integer and decimal places.
184 184  * **Elements:** It sets members' initial number of each group;
185 185  * **Data Format:** There are some formats can be supported in Recipe, like 16-bit BCD, 16-bit signed, 16-bit unsigned, 32-bit BCD, 32-bit signed, 32-bit unsigned, 32-bit floating and string. If each member requires different formats, please set it one by one in form;
186 186  * **Decimal: **It sets integer and scale digits;
187 187  
188 -**Mode Selection**
188 +**Mode Selection: **Select Simple or Advanced mode. Recipe file is divided into simple mode and advanced mode. Only in advanced mode can exist multiple recipe files used at the same time. (used wiht file list onject), Simple mode can only support a recipe file; Aadvanced mode can insert group information and reordered.
189 189  
190 -Users could select Simple or Advanced mode.
190 +Function address: all operations are done through function addresses, different operating value is as follows:
191 191  
192 -**Function Address:**
192 +* = 0: no operation;
193 +* = 1: trigger read data;
194 +* = 2: new trigger or update (If there is group number, it updates.)
195 +* = 4: insert (only valid in advanced mode)
196 +* = 8: delete (Delete according to the writing group number. If write and read address are consistent, refer to the reading group number);
197 +* = 16: delete and sorted ((Delete according to the writing group number. If write and read address are consistent, refer to the reading group number)
198 +* = 64: import CSV recipe file.
193 193  
194 -All the operations for recipe is by this address
195 -
196 -* =0 No operation.
197 -* =1 Read data from recipe.
198 -* =2 Insert a new group or write data to exist group.
199 -* =4 Inserted (only advanced mode).
200 -* =8 Delete.
201 -* =16 Delete and Sequence.
202 -
203 203  **Use Multiple File**
204 204  
205 205  Check it to use more than one recipe file in HMI, but this option only valid in [Advanced mode];
... ... @@ -244,27 +244,124 @@
244 244  **✎Note: **This function only supported in HMI+, i series, ie series, ig series.
245 245  )))
246 246  
247 -**Operating Procedures**
248 248  
249 -* Click "Project"→"Bit Alarm" as below shows.
245 +**description of Adcanced mode**
250 250  
247 +According to the recipe configuration information in Figure 2 above. The function address is HDW70, and each function configuration corresponds to the group number address, recipe element address and recipe file name address. The recipe information configured in figure 2 can be displayed in the table in figure 3 with the "Record Display" object.
248 +
249 +[[image:image-20220806111333-1.jpeg]]
250 +
251 +**Read recipe**: Input 1 to the file name, when the group number addresses HDW100=1 and HDW70=1 (read), the element data of the first group (ID=1) is written to the recipe address from the recipe file. As shown in Figure 3 above: HDW105=1, HHDW106=2, HDW107=3, HDW108=4, HDW109=5.
252 +
253 +**Write recipe**: Input 1 to the file name, when the group number addresses HDW101=4 and HDW70=2 (write), the data will be read from the recipe address and written to the corresponding group of the recipe file. As shown in figure 3 above: HDW110=20, HHDW111=21, HDW112=22, HDW113=23, HDW114=24. Write the data of this set to the elements of ID=4 in the recipe table (if there is no data of Group 4 in the recipe file, a new set of data will be added; If there is data of Group 4 in the original recipe, the original data will be overwritten and the latest data will be displayed in the recipe file).
254 +
255 +**Index recipe**: When the file name is input 1, when the group number address HDW102=3, the data of ID=3 (Group 3) in the recipe file will be directly displayed in the component address of the index, that is, HDW115=11, HHDW116=12, HDW117=13, HDW118=14 and HDW119=15. If the data of the index component address is modified, the modified data will be automatically filled into the table of the recipe file, that is, the data of the recipe file will be automatically updated after the data is modified.
256 +
257 +[[image:image-20220806111355-2.jpeg]]
258 +
259 +**Insert recipe**: Input 1 to the file name, when the group number addresses HDW103=3 and HDW70=4 (insert), the data of the 3rd group will be inserted, but the data of the third group already exists in the original recipe file (see Figure 3 above), then the original data will be moved down by one group, that is, the original 3rd group will become the 4th group, and so on, and HDW120=16, HHDW121=17, HDW122=18, HDW123=19 and HDW124=20 will be written into the new 3rd group of the recipe file at the same time. The results are shown in Figure 4 above.
260 +
261 +When the group number address HDW101=2 (**The delete function only works on the group number of the write function**), HDW70=8 (delete), the data in the recipe file with ID=2 (Group 2) will be deleted.
262 +
263 +When the group number address HDW101=5 (**The delete function only works on the group number of the write function**), HDW70=16 (delete and sort), the data of ID=5 (Group 5) in the recipe file will be deleted, and the original ID=6 (Group 6) data will be reordered to become the new Group 5 data, the original ID=7 (Group 7) data will be reordered to become the new Group 6 data, and so on.
264 +
265 +**Recipe Demo Download Link: **[[Download>>url:https://drive.google.com/open?id=1Cjbq_tW-NIirHFBpxt47g7IKvoYaWqUR]]
266 +
267 +== Calling CSV recipe file ==
268 +
269 +**Overview**
270 +
271 +The recipe files used by the regular series HMI are in CSV format, and the recipe files used by the current series HMI are in database format. In order to be compatible with CSV format recipe files on the current series of HMI, please follow the instruction when using it.
272 +
273 +**Operations**
274 +
275 +Create the recipe as it is configured. The default recipe file name is “1. rcp2”, which is placed in folder 123, as shown in the following figure.
276 +
251 251  (% style="text-align:center" %)
252 -[[image:8.Basic Function_html_a7d1546a3a9f752f.png||height="144" width="535" class="img-thumbnail"]]
278 +(((
279 +(% style="display:inline-block" %)
280 +[[Figure 1>>image:image-20220806100702-2.jpeg]]
281 +)))
253 253  
254 -* Click "Add" button to open "Recipe" setting window.
283 +2. Place a "Recipe Record Display" object and a "File List" object on the project screen for viewing the recipe files in the folder 123, and the address configuration in the object should be consistent with the above configuration.
255 255  
256 256  (% style="text-align:center" %)
257 -[[image:8.Basic Function_html_8f04e01413981054.png||height="307" width="554" class="img-thumbnail"]]
286 +[[image:image-20220806100753-3.jpeg]]
258 258  
259 -* Set basic settings for recipe.
260 -* Select mode according to actual condition.
261 -* Other settings can be set according to the actual situation.
262 -* Click "OK“ button to complete settings.
288 +By configuring the address in the table and combining the recipe function, the CSV recipe files of regular series are imported.
263 263  
264 -**Recipe Demo Download Link**
290 +|=Address range|=Object type|=Address function
291 +|HSW1050 to 1065|Text input object|Enter the CSV recipe file name to import
292 +|HSW1066|Numerical input object|Import CSV file type:(((
293 +* = 0: Custom CSV file (all data in the file is valid)
294 +* = 1: Normal recipe file for regular series HMI (the data in line 1 of the file is invalid)
295 +* = 2: Special recipe file for regular series HMI (the data in line 1 and 2 and column 1 of the file are invalid)
296 +)))
297 +|HSW1067|Numerical input object|(((
298 +Where the CSV file is saved:
265 265  
266 -[[https:~~/~~/drive.google.com/open?id=1Cjbq_tW-NIirHFBpxt47g7IKvoYaWqUR>>url:https://drive.google.com/open?id=1Cjbq_tW-NIirHFBpxt47g7IKvoYaWqUR]]
300 +* = 0: In the CsvFile directory of U disk
301 +* = 1: In the CsvFile directory of the SD card
267 267  
303 +**The path for offline simulation is: C:\ HMIEmulation\ CustomFileDir\ CsvFile**
304 +)))
305 +|HSW242|Numerical input object|Returns the results of the csv import:(((
306 +* = 37: CSV file imported successfully
307 +* = 38: CSV file import failed
308 +)))
309 +
310 +**Select CSV recipe file (take U disk as an example):**
311 +
312 +Using the file list object, select the recipe file in the U disk by path, and configure the recipe file name address directly to the special address HSW1050 in the above table, which can directly detect the CSV file in the U disk; Select the recipe file in the file list, and write the selected recipe file name into the recipe file name: In HSW1050 to 1065.
313 +
314 +Use the special address of the above table to configure the path of the CSV file: HSW106, configure recipe file name: HSW1050 to1065
315 +
316 +Use HSW1066 address to select the corresponding CSV recipe file type.
317 +
318 +* HSW1066 = 0: Import a user-defined CSV recipe file (all data in the custom CSV file must be valid);
319 +
320 +(% style="text-align:center" %)
321 +[[image:image-20220806101129-5.jpeg]]
322 +
323 +* HSW1066=1: Import the normal recipe file of regular series HMI (the data in line 1 of the file is invalid);
324 +
325 +The data in line 1 of the normal recipe file is used to define the format of the recipe and will not be imported into the recipe table as recipe information, **but you must ensure that the data in line 1 representing the elements and number of groups is correct, otherwise the CSV recipe file will fail to be imported.**
326 +
327 +(% style="text-align:center" %)
328 +[[image:image-20220806101520-6.jpeg]]
329 +
330 +* HSW1066=2: Import the special recipe file of regular series HMI (the data in line 1, 2 and column 1 of the file are invalid);
331 +
332 +In the special recipe file, line 1 is used to define the format of the recipe, line 2 is used to define the element name of the recipe, and column 1 is used to define the group name of the recipe, so lines 1, 2 and column 1 of the special recipe will not be imported into the recipe table as recipe information. **During use, ensure that the data such as the number of groups and elements representing the recipe format in the first line are correct, otherwise the import of the CSV recipe file will fail.**
333 +
334 +(% style="text-align:center" %)
335 +[[image:image-20220806102610-7.jpeg]]
336 +
337 +**Perform import**
338 +
339 +After configuring the saving path of CSV recipe file, the name of recipe file and the type of recipe according to the above steps, the method of transferring CSV file to DB file is as follows:
340 +
341 +* Configure the DB recipe file name by text input object: HDW500 = 3 (recipe file configured in Figure 1),
342 +* Set the recipe function address to: HDW1000 = 64 (the function address configured in Figure 1),
343 +* Transform the CSV recipe file in U disk into DB recipe file with file name “3.rcp2”.
344 +
345 +**DB recipe file for storing CSV data:**
346 +
347 +Simple mode: When the recipe file is set to simple mode, the file of CSV data is saved as the DB recipe file of 1. rcp2 by default.
348 +
349 +Advanced mode: When the recipe is enabled in advanced mode (multi-file recipe), the imported CSV file data is saved to the file recorded at the recipe file address HDW500 (the address configured in Figure 1).
350 +
351 +**Import results:**
352 +
353 +* HSW242 = 37: Import succeeded;
354 +* HSW242 = 38: Import failed.
355 +
356 +**Precautions:**
357 +
358 +* Ensure that the data format of each element in the CSV file is the same as the recipe data format set in the software (DB), and ensure that the elements of each row in the valid data area is the same as the elements set in the software (DB);
359 +* When the elements of a line in CSV file is more than the elements set in the software (DB), it will prompt the import failure;
360 +* When the CSV file imported into the regular series HMI is a recipe file, the data representing the recipe format (elements, number of groups, whether it is a special recipe) in line 1 must be correct, otherwise the import of CSV file will fail.
361 +
268 268  = (% style="color:inherit; font-family:inherit; font-size:29px" %)**Traditional recipe**(%%) =
269 269  
270 270  Traditional recipe is composed of multiple groups of information with the same structure and different data. Due to the similarity of these information, you could edit them into a set of recipes to facilitate the transfer of data between HMI and PLC.
... ... @@ -421,7 +421,7 @@
421 421  
422 422  Different from TrendChart, uses need to set history XY curve items in project. Please click "Project"-> "History XY Plot" to open the setting screen.
423 423  
424 -Recipe function settings will be display in "[[History XY Plot>>path:http://docs.we-con.com.cn/wiki/pistudio/view/Helps/06.Objects/#HHistoryXYplot]]" object.
518 +Recipe function settings will be display in "[[History XY Plot>>path:https://docs.we-con.com.cn/bin/view/PIStudio/08.Basic%20Function/#HHistoryXYplot]]" object.
425 425  
426 426  (% style="text-align:center" %)
427 427  [[image:历史XY 2.png||class="img-thumbnail"]]
... ... @@ -582,15 +582,8 @@
582 582  * The channel name does not include these 5 special characters: ", ", "| "," <", "> "," & ".
583 583  * The data would be overwritten automatically if the capacity exceed the maximum capacity. For 8000/9000 series, the size of single file cannot exceed 300MB, and total capacity of data records cannot exceed 1000MB. For 3000/3000i/3000ie series, the size of single file cannot exceed 4MB, and total capacity of data records cannot exceed 10MB. If the total amount exceeds the range , an error will be prompted when the project is compiled.
584 584  
585 -You could click here to jump to object "[[Data Record Display>>http://docs.we-con.com.cn/wiki/pistudio/view/Helps/06.Objects/#HDataRecordDisplay]]"
679 +You could click here to jump to object "[[Data Record Display>>https://docs.we-con.com.cn/bin/view/PIStudio/06.Objects/#HDatarecorddisplay]]"
586 586  
587 -(% class="wikigeneratedid" id="H" %)
588 -**PI Data Record Demo Download**
589 -
590 -**[[Demo Link>>https://drive.google.com/open?id=1h7VUsIJqH4LIRjjtphbv9Kmzd6jUMPtE]]**
591 -
592 -**[[Video Link>>https://drive.google.com/open?id=1h7VUsIJqH4LIRjjtphbv9Kmzd6jUMPtE]]**
593 -
594 594  = **User permission** =
595 595  
596 596  **Introduction**
... ... @@ -602,7 +602,10 @@
602 602  
603 603  (% class="box infomessage" %)
604 604  (((
605 -✎**Note: **The user name and password must be unique.
692 +✎**Note: **
693 +
694 +* The user name and password must be unique.
695 +* The multi language function of User permission only supported on HMI system version V2.0 or above
606 606  )))
607 607  
608 608  == Settings ==
... ... @@ -612,6 +612,11 @@
612 612  (% style="text-align:center" %)
613 613  [[image:用户权限 1.png||class="img-thumbnail"]]
614 614  
705 +Click on the cell from UserName and Desc, which can support the multi language.
706 +
707 +(% style="text-align:center" %)
708 +[[image:UserPermissionMultilan.png]]
709 +
615 615  1. Click "User Permission" in "Data Tool" toolbar.
616 616  1. Edit user name, click "User0" cell under "UserName", and then enter the user name, one project allows maximum 20 users.
617 617  1. Edit password, click "User0" cell under "PassWord", and then enter the user name.
... ... @@ -625,6 +625,9 @@
625 625  * Only a maximum of one administrator permission is allowed in a profile with one user permission. If you want to use "Funtion address" to modify the user permission, you must log in the administrator account to operate.
626 626  * When the configured file does not have the administrator account, a new user can be added  through "Funtion address" and set as the administrator.
627 627  * If you select hidden fucntion when configuring user account, the account would display as "~*~*~*~*~*~*" in the list. You only need to enter the password of the corresponding hidden user to log in.
723 +* (((
724 +Adding new UserName and Desc on the HMI by special addresses in the current language of the HMI, other languages will also configure the user names and user descriptions to the current language by default, i.e. switching to other languages, the new user names and user descriptions will not change with the language.
725 +)))
628 628  
629 629  == Object permission configuration ==
630 630  
... ... @@ -631,6 +631,11 @@
631 631  (% style="text-align:center" %)
632 632  [[image:用户权限 2.png||class="img-thumbnail"]]
633 633  
732 +User operation logs support multi languages configuration. Click on the Log Message, the text editor of multi language will be pop up:
733 +
734 +(% style="text-align:center" %)
735 +[[image:LogMessagesMultilan.png]]
736 +
634 634  **Operation Procedure of Object Permission**
635 635  
636 636  1. Open the object setting windows;
... ... @@ -638,7 +638,7 @@
638 638  1. Check the "User Permission";
639 639  1. Select "Level" to set permission level;
640 640  1. Enter "Log Message", it is for operation records, if it was empty, the operation for this object would be not be recorded;
641 -1. Select the "[[Access Denied Setting>>path:#_Security]]" mode;
744 +1. Select the "Access Denied Setting" mode;
642 642  
643 643  **Log information description**
644 644  
LogMessagesMultilan.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Hunter
Size
... ... @@ -1,0 +1,1 @@
1 +37.5 KB
Content
UserPermissionMultilan.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Hunter
Size
... ... @@ -1,0 +1,1 @@
1 +23.2 KB
Content
image-20220805170000-1.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +1.1 KB
Content
image-20220805170046-2.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +34.5 KB
Content
image-20220805170102-3.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +58.3 KB
Content
image-20220805170147-4.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +58.3 KB
Content
image-20220805170232-5.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +58.3 KB
Content
image-20220805174501-1.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +79.3 KB
Content
image-20220805174543-2.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +80.0 KB
Content
image-20220806100635-1.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +85.6 KB
Content
image-20220806100702-2.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +131.3 KB
Content
image-20220806100753-3.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +10.5 KB
Content
image-20220806101048-4.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +226.9 KB
Content
image-20220806101129-5.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +168.6 KB
Content
image-20220806101520-6.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +24.8 KB
Content
image-20220806102610-7.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +43.9 KB
Content
image-20220806111333-1.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +131.4 KB
Content
image-20220806111355-2.jpeg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Stone
Size
... ... @@ -1,0 +1,1 @@
1 +135.4 KB
Content