Load script

Time to complete: 2 minutes

Existing data model

To ensure that the storing of data works smooth it is good practice to wrap your existing data model load into the following if statement.

If not IsPartialReload() then

<Existing data model load script>

end if

Just insert it at the very beginning of your data load and in the end. You can have as many script sections included between the then and end if statements as you like.

Example:
If not IsPartialReload() then
FEATURES:
LOAD
CASEID,
COUNTRY
FROM [lib://Komment/Call_Center.xlsx]
(ooxml, embedded labels, table is Sheet1);
โ€‹
End if

If you use the autoCalender script you need to have this sit outside the "if not ispartialreload() section". e.g. starting after the "End if" in line 9 in the example above.

Adding Komment fields

Before you start configuring Komment in the User Interface you need to define if any new fields are to be used as an editable field.

Still in the load script:

  1. Find an existing data table for which you want your Komment fields to be related to.

  2. Add new lines for each of these fields using the following notation null() as Comment

  3. Reload the application after you've added the needed fields.

CASES:
LOAD
CASEID,
Country,
Severity,
//Newly defined input fields
Null() as Status,
Null() as Action,
Null() as Date
FROM [lib://Komment/Call_Center.xlsx]
(ooxml, embedded labels, table is Sheet1);

If you have all the fields you need in your current data e.g. if you want to be able to edit the Severity field and this is already in your data - just load it as you'd normally would.

You can also set a default value instead of Null(). E.g. for a status field you could insert 'Pending' as Status