Illko Studio

By purchasing one license of the Program, you acquire the right to install and use the Program on two computers, provided that the copy of the Program is never loaded in the RAM of one computer at the same time as the copy loaded in the RAM of the other computer, and provided that both computers are operated by you.

Isn’t.

Cannot save database, print / import / export / send / receive => max. 20 appliance

The program sorts the list of appliancealphabetically. The tree displays the applianceID first, so the sorting cannot be changed.

The date of the next test and the result are determined AUTOMATICALLY based on the latest measurement date and test interval. If a new appliance is inserted, it is necessary to insert a new measurement with empty values (Ctrl+M). You can write in the note, for example, “Default check”, etc. It is then documented that the inspection of the new appliancewas actually carried out (including the name of the authorized person).

Yes. However, it must be ensured that only 1 user accesses the database at a time – when the database is accessed and saved by another user, all changes made by the first user will be lost (the program does not check for database locking).

Select the specific appliance(s) and export it to a CSV (all measurements) file. Do not open the CSV file! Open another customer and import the CSV file. When importing/exporting a CSV, ALL data is transferred without loss.

Previous software used custom settings for each database. That brought a lot of problems. ILLKO Studio has only global settings, which are the same for all databases (files). Therefore, it is not possible to do automatic numbering for each customer separately with remembering the last value of the appliance.

The program is designed to optimize RAM – previous programs loaded complete database structures into RAM (hundreds of MB) and then it was possible to use these functions. ILLKO Studio loads only the recording structure that the user sees on the screen into RAM.

Yes – using a CSV file. The file you want to import (e.g. created during export from your information system, the inventory file of appliance, etc.) cannot simply be converted to CSV format. You must proceed as follows:

1. Create 1 appliance without measuring in ILLKO Studio
2. Export this appliance to a CSV file (menu File-Export> to CSV-Last> measurement)
3. Open the newly created CSV file (beware of automatic column formatting – e.g. removing “0001” -> “1”)
4. Copy the desired columns from the original file to the newly created CSV file
5. Import the CSV file (menu File-Import> from CSV) into ILLKO Studio (only new appliance will be added to the database; the existing appliancewill be preserved and the parameters will not be changed)

Notes:

• Do not delete empty columns
• You do not need to fill in the LastRev, NextRev, AutoRev, Result, or Archive columns (they can remain blank)
• If you get an error during import, check and possibly change the decimal point after a comma (or vice versa) in the CableLen column (depending on Windows settings)

The program is primarily designed for a single user who works alone on a specific database. If multiple users work on one database, the individual DBs must be modified during the merge.
When merging DB (importing from CSV), the rule is that new records are added (appliancee or measurement), but existing records cannot be modified for security reasons.

Example:
Technician A (or another user who completes the resulting DB)
Technician B
Technician C

Procedure:

1. A+B+C technicians download the complete DB from the server, send the data to the device, perform revisions
2. A+B+C technicians download the data from the device to a PC and make adjustments, or remove the appliancefrom the register
3. Technicians A+B+C modify the DB in this way:
   – open Filter (F3 key)
   – check the option (under the table): “Show appliancee” -> Only valid
   – read all appliance, sort by the date of the last check
   – delete appliancethat have the last inspection older (i.e. the technician has not revised them)
   – applianceremoved from the register will remain in the DB (only valid appliancehave been deleted)
4. Technicians B+C will send their modified (incomplete) DB to Technician A, which will contain only the appliancethey have worked with + applianceremoved from the register
5. Technician A (or another user) merges the DB in the following order:
   – imports (merges) B into A
   – imports (merges) C into merged A+B
   – in case of other users, it continues in the same way (imports D into A+B+C, etc.)
   – finally merges the original DB from the server into A+B+C(+D…) to appliancethat no technician has worked with
6. The resulting DB is stored back on the server

Note: If an appliance returns from discarded to valid, this change must be made manually (the new measurement will be added to this applianceeven during merging, but the “Removed from Registration” flag will not change). In the filter, there is again the option to perform a bulk check, i.e. to display only the appliancee Removed from the register and sort them according to the date of the last inspection – if a new date appears there, it is clear that the appliance has been revised (found) and the status of Removed from the register must be manually adjusted. If there are more of these appliance, they can of course be modified in bulk.

Data about the technician (including the stamp) or the measuring device are copied from the program settings to the Measurement record only when downloading data from the device. These data are not permanently linked to the program settings, i.e. it is not enough to change the settings, but a bulk modification must be made:

1. Run the filter (F3 key)
2. Press the “Load and display appliance” button
3. Select all appliancee (CTRL+A)
4. Switch to the “Measurements for selected appliance” tab
5. Click on the relevant column to sort by date, or apply a filter
6. Mark the selected observations that will be affected by the change
7. Press the “Edit selected measurements” button
8. Select Technician and/or Measuring instrument and select data from the list
9. Save your changes

Note: The technician’s stamp is generated in the forms only in cases where the Technician’s Registration Number for a specific measurement is exactly the same as the Technician’s Registration Number specified in the settings. If the signature is not displayed, make bulk edit of the Measurement records.