This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
en:user_guide:first_process [2021/01/21 15:25] tiger [The First Process] |
en:user_guide:first_process [2023/08/04 22:21] (current) tiger [Know your process] |
||
---|---|---|---|
Line 6: | Line 6: | ||
===== Know your process ===== | ===== Know your process ===== | ||
- | Djeeni is the tool to automate your process | + | Djeeni is the tool to automate your process |
- | * The process is to consolidate data from several //source worksheets// | + | * The process is to consolidate data from several //source worksheets// |
+ | * The typical | ||
- Open the //target template// worksheet | - Open the //target template// worksheet | ||
- Open the //master data// worksheet and go through the entries in it one by one. For each entry: | - Open the //master data// worksheet and go through the entries in it one by one. For each entry: | ||
- Open the corresponding //source worksheet// | - Open the corresponding //source worksheet// | ||
- | - Perform some selection of source data | + | - Identify every separate cell or range on the //target template// that you can fill in a simple step using the current //source |
- | - Perform some calculations | + | - set a cell or a range to a fix value (either constant or taken from the source worksheet or calculated |
- | - Perform some copying of (calculated) | + | - find a cell with a certain value in a range to use the value or the location (row number or column letter) of the found cell later. |
- | - Perform some calculations | + | - note this step for each such cell or range |
+ | - Identify a column or a row on the //target template// | ||
+ | - note the step for a single cell; | ||
+ | - enclose it in a **row list** (for a column) or **column list** (for a row) construct that will perform the cell-by-cell navigation | ||
- Close the //source worksheet// | - Close the //source worksheet// | ||
- | - Get the next entry in //master data// | + | - Get the next entry in //master data// |
- Close the //master data// worksheet | - Close the //master data// worksheet | ||
- Save and close the //target template// worksheet | - Save and close the //target template// worksheet | ||
- | * This is just the skeleton of the process: selection, calculation and copying of source data must be further elaborated. You can easily reach 30-40-50 steps but do not be afraid. | + | * This is the skeleton of the process. You can easily reach 30-40-50 steps but do not be afraid. |
- | * Once you have your process on paper you are 75% ready. Good news! | + | * Once you have your process on paper, you are 75% ready. Good news! |
===== Create your first process ===== | ===== Create your first process ===== | ||
- | When you start Djeeni there is no process in the editor. You should either create a new or open an existing process. | + | When you start Djeeni there is no process in the editor. You should either create a new one or open an existing process. |
- | Alternatively, | + | Alternatively, |
===== Let Djeeni know the process ===== | ===== Let Djeeni know the process ===== | ||
- | Open Djeeni (maybe you have to first [[: | + | Open Djeeni (you might have to [[: |
- Read the next step from your paper | - Read the next step from your paper | ||
- | - Decide: is this step to deal with workbooks; | + | - Decide: is this step to deal with workbooks; worksheets; ranges; communication; |
- | * the first steps are about worksheets; then | + | * the first steps are about worksheets |
- | * a list is started on the //master data// worksheet; then | + | * a list (structure) |
- | * we select, calculate, copy data from ranges/ | + | * we select, calculate, copy data from ranges/ |
- | * a worksheet is closed; then | + | * a worksheet is closed |
- | * the //master data// list goes to its next step; then | + | * the //master data// list goes to its next step |
* two worksheets are closed | * two worksheets are closed | ||
- Select the appropriate category at the top of the Process Toolbar. | - Select the appropriate category at the top of the Process Toolbar. | ||
- Select the matching process step from the list below the categories | - Select the matching process step from the list below the categories | ||
- | - Click on the To End button to add the step at the end of the process | + | - Click on the 'To End' |
- | - Repeat | + | - Repeat until all process steps are added |
- | - Click on the Save icon on the Excel ribbon. | + | - Click on the 'Save' |
- | Have you forgotten | + | Did you forget |
- | ===== Hello World? ===== | + | ===== Hello World! ===== |
- | If you have not entered any process | + | If you have not entered any processes |
- | - Check that the Process Editor is cleared: the only step is Exit in row 4. You can clear the editor (first Save if you want to keep the process in it) by clicking | + | - Check that the Process Editor is cleared |
- | - Select | + | - If you want to keep your changes, save the current |
+ | - Click on 'Clear' | ||
+ | - Select | ||
- Select the ' | - Select the ' | ||
- Click on 'To end' | - Click on 'To end' | ||
- Double-click on the process step name ' | - Double-click on the process step name ' | ||
- | - Enter into the only parameter: | + | - Enter 'Hello World!' |
- Click on ' | - Click on ' | ||
- Djeeni should display a popup saying 'Hello World!' | - Djeeni should display a popup saying 'Hello World!' | ||
Line 66: | Line 72: | ||
===== Edit/Remove process steps ===== | ===== Edit/Remove process steps ===== | ||
- | You have your first process in the [[en: | + | You have your first process in the [[en: |
+ | - on the visual editor by clicking on the process step. The selected process step becomes the //current process step// and gets a red colour frame | ||
+ | - on the detail editor | ||
- | You can insert a new process step before the current process step by selecting the new process step in the Process Toolbar and then clicking on the Before | + | You can insert a new process step before the current process step by selecting the new process step on the Process Toolbar and then clicking on the Insert |
- | You can remove the current process step by clicking on the Remove button. | + | You can remove the current process step by clicking on the 'Remove' |
===== Setting the parameters of the process steps ===== | ===== Setting the parameters of the process steps ===== | ||
- | There is a process in the [[: | + | Let's suppose that there is a process in the [[: |
* Directly editing the parameters in the Process Editor (in column C) - suggested for advanced users | * Directly editing the parameters in the Process Editor (in column C) - suggested for advanced users | ||
* Double-clicking on the name of the process step in column A - this brings up a pop-up letting you fill the parameter values in a more user-friendly way. | * Double-clicking on the name of the process step in column A - this brings up a pop-up letting you fill the parameter values in a more user-friendly way. | ||
- | Most of the parameters are straightforward to set. Several process steps have a general Options parameter. It lets you set a series of values separated by semicolons (;) altering or refining the behaviour of the process step. The exact list of allowed values | + | Most of the parameters are straightforward to set. Several process steps have a general |
You can read further about process steps and their parameters [[en: | You can read further about process steps and their parameters [[en: | ||
- | Once you entered all the parameters Djeeni knows everything. Let Djeeni work instead and for you. | + | Once you entered all the parameters, Djeeni knows everything. Let Djeeni work instead and for you. |
===== Executing the process ===== | ===== Executing the process ===== | ||
- | Do you have a process entered or loaded into the Process Editor? Executing it is the easiest part: click on the Execute button on the Process Toolbar. | + | Do you have a process entered or loaded into the Process Editor? Executing it is the easiest part: click on the 'Execute' |
===== Try it out ===== | ===== Try it out ===== | ||
- | The best learning is experiencing. Take Djeeni and while you read this guide try all features | + | The best learning is experiencing. Take Djeeni and while you read this guide try out all features by creating and editing the processes. |