Skip to Content

Changes for page 06 Data Tool

Last modified by Jett on 2025/02/18 16:43
From version 24.2
edited by Stone Wu
on 2022/08/06 10:10
Change comment: (Autosaved)
To version 25.1
edited by Stone Wu
on 2022/08/06 10:27
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -284,7 +284,7 @@
284 284  * = 0: In the CsvFile directory of U disk
285 285  * = 1: In the CsvFile directory of the SD card
286 286  
287 -The path for offline simulation is: C:\ HMIEmulation\ CustomFileDir\ CsvFile
287 +**The path for offline simulation is: C:\ HMIEmulation\ CustomFileDir\ CsvFile**
288 288  )))
289 289  |HSW242|Numerical input object|Returns the results of the csv import:(((
290 290  * = 37: CSV file imported successfully
... ... @@ -293,84 +293,56 @@
293 293  
294 294  **Select CSV recipe file (take U disk as an example):**
295 295  
296 -* 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.
297 -* Use the special address of the above table to configure the path of the CSV file: HSW106, configure recipe file name: HSW1050 to1065
296 +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.
298 298  
299 -(2Use HSW1066 address to select the corresponding CSV recipe file type.
298 +Use the special address of the above table to configure the path of the CSV file: HSW106, configure recipe file name: HSW1050 to1065
300 300  
300 +Use HSW1066 address to select the corresponding CSV recipe file type.
301 301  
302 - A) HSW1066 = 0: Import a user-defined CSV recipe file (all data in the custom CSV file must be valid);
302 +* HSW1066 = 0: Import a user-defined CSV recipe file (all data in the custom CSV file must be valid);
303 303  
304 +(% style="text-align:center" %)
305 +[[image:image-20220806101129-5.jpeg]]
304 304  
307 +* HSW1066=1: Import the normal recipe file of regular series HMI (the data in line 1 of the file is invalid);
305 305  
306 - B) HSW1066=1: Import the normal recipe file of regular series HMI (the data in line 1 of the file is invalid);
309 +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.**
307 307  
311 +(% style="text-align:center" %)
312 +[[image:image-20220806101520-6.jpeg]]
308 308  
309 -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.
314 +* 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);
310 310  
316 +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.**
311 311  
318 +(% style="text-align:center" %)
319 +[[image:image-20220806102610-7.jpeg]]
312 312  
313 - C) 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);
321 +**Perform import**
314 314  
323 +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:
315 315  
316 -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.
325 +* Configure the DB recipe file name by text input object: HDW500 = 3 (recipe file configured in Figure 1),
326 +* Set the recipe function address to: HDW1000 = 64 (the function address configured in Figure 1),
327 +* Transform the CSV recipe file in U disk into DB recipe file with file name “3.rcp2”.
317 317  
329 +**DB recipe file for storing CSV data:**
318 318  
331 +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.
319 319  
333 +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).
320 320  
321 -(3) Perform import
335 +**Import results:**
322 322  
337 +* HSW242 = 37: Import succeeded;
338 +* HSW242 = 38: Import failed.
323 323  
324 - 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 +**Precautions:**
325 325  
342 +* 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);
343 +* 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;
344 +* 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.
326 326  
327 - A) Configure the DB recipe file name by text input object: HDW500 = 3 (recipe file configured in Figure 1),
328 -
329 -
330 - B) Set the recipe function address to: HDW1000 = 64 (the function address configured in Figure 1),
331 -
332 -
333 - C) Transform the CSV recipe file in U disk into DB recipe file with file name “3.rcp2”.
334 -
335 -
336 -5. DB recipe file for storing CSV data:
337 -
338 -
339 -(1) Simple mode:
340 -
341 -
342 - 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.
343 -
344 -
345 -(2) Advanced mode:
346 -
347 -
348 - 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).
349 -
350 -
351 -6. Import results:
352 -
353 -
354 -(1) HSW242 = 37: Import succeeded;
355 -
356 -
357 -(2) HSW242 = 38: Import failed.
358 -
359 -
360 -
361 -3. Precautions:
362 -
363 -
364 -~1. 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);
365 -
366 -
367 -2. 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;
368 -
369 -
370 -3. 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.
371 -
372 -
373 -
374 374  = (% style="color:inherit; font-family:inherit; font-size:29px" %)**Traditional recipe**(%%) =
375 375  
376 376  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.
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