You made your first step towards automating your process – congratulations!
We have listed the sources and targets, but how will we refer to them further? To find a worksheet someone should know the path of its workbook + the name of the worksheet. Paths in an enterprise environment can be very-very long and worksheet default names are different in different languages (only in English it is ‘Sheet1’). Who can remember: ‘[L:\Finance\Controlling\2023\Quarterly\Q1\Suppliers\Supplier24\Invoices-202302.xlsx]!AR202302’?
Djeeni makes life much easier by allowing you to use a compact name for every worksheet (btw., SQL connections and other elements, too) that describes crystal clear the content and purpose of it. The above worksheet, for example, can get the name: wsSupplier24AR (‘ws’ at the beginning denotes that this element is indeed an Excel worksheet). Later, in the process this worksheet will be referred to by using this Djeeni name.
You can select every item from the Definitions Block (to the right) by clicking on them and setting their Djeeni name:
- Base Folder needs no Djeeni name.
- Must be at least 5 characters.
- May contain only letters.
- The best practice naming convention is to start the Djeeni name with 2 letters: ‘ws’ for worksheet; ‘sq’ for SQL connection.
Once you have finished, click on To the blocks.