Differences

This shows you the differences between two versions of the page.

--- en:concepts:djeeniname [2020/05/06 17:25]
andraz
+++ en:concepts:djeeniname [2021/09/03 11:24] (current)
levi [Rules, best practice]
@@ Line 1: / Line 1: @@
+{{indexmenu_n>1}}
 ====== Djeeni Names ======
@@ Line 5: / Line 6: @@
   * copy **range D234:D245** on **%%\\server\finance\analysis\erp_exports\report202001.xlsx%%** workbook **Sheet1** worksheet to **range starting from B25** on **%%\\server\finance\consolidations\year2020\consolidation202001.xlsx%%** workbook **ERP data** worksheet
-Please note that in Djeeni you work always with worksheets. Every worksheet has a physical location in a workbook that can be found in some folder of the computer or network. Once this location is specified in the **WSheet Use** process step you can simply refer to this worksheet throughout your process by its Djeeni name. Using **WSheet Use** has one more advantage. If the location of the workbook or the Excel name of the worksheet is changed you only have to change **WSheet Use** to refer to the new location and/or worksheet name and your process is running again.
+Please note that in Djeeni you work always with worksheets (and not workbooks). Every worksheet has a physical location in a workbook that can be found in some folder of the computer or network. Once this location is specified in the **[[en:process_steps:worksheet:wsheet_use|WSheet Use]]** process step you can simply refer to this worksheet throughout your process by its Djeeni name. Using **WSheet Use** has one more advantage. If the location of the workbook or the Excel name of the worksheet is changed you only have to change **WSheet Use** to refer to the new location and/or worksheet name and your process is running again.
 ===== Rules, best practice =====
-Djeeni names can contain only letters (a-z, A-z), numbers (0-9), underscore (_), dash (-) and question mark (? - Useful for naming if sections). A Djeeni name **must** contain at least 5 characters. No space or other characters are allowed. To improve the readability of the process it is recommended to start all Djeeni names with 2 characters identifying the element named:
+Djeeni names
+  * can contain letters (a-z, A-Z), numbers (0-9), underscore (_), dash (-) and question mark (? - Useful for naming if sections);
+  * must contain at least 5 characters;
+  * no space or other characters are allowed;
+  * must identify each and every object uniquely i.e., not just two worksheets but also a worksheet and a range must have different Djeeni names. This rule applies also within a workbook, row or column list. For example, it is not allowed to use **WSheet Use** inside a workbook list without **WSheet Release** in the same workbook list to give space for the next worksheet in the loop with the same Djeeni name.
+To improve the readability of the process it is recommended (but not compulsory) to start all Djeeni names with 2 characters identifying the element named:
 ^If you name a ^Start with   ^Example           ^
@@ Line 15: / Line 23: @@
 |Range             |rg                  |rgSummary     |
 |Cell                  |ce                 |ceDateFound  |
-|If                      |if                   |ifEmpty?         |
+|Condition       |if                   |ifEmpty?         |
 |WBook List    |wl                 |wlCountryData|
 |Row List         |rl                   |rlDepartments|
 |Column List   |cl                   |clMonths         |
+If you follow this recommendation please apply it both for the Djeeni name parameter in **[[en:process_steps:worksheet:wsheet_use|WSheet Use]]** and later when you refer to the worksheet in cell or range references.

User Tools

Site Tools

Differences

Page Tools