Skip to main content

Importing from Excel

Instead of creating many systems, equipment and sub-equipment one by one, add them with an Excel file: download the template, fill it in, upload it again. kommuns reads and checks the file and shows a preview; nothing is saved until you confirm.

Where?​

The Import button is in the lists' toolbar, next to Export. Each place imports what goes under it:

WhereWhat can be added
A location's Systems listSystems, equipment and sub-equipment
A system's Equipment listEquipment and sub-equipment
An equipment's Sub-Equipment listSub-equipment

The same window opens from the card's ⋮ menu (Import) in the Locations tree. Without the permission to add inventory there, the button doesn't show.

The Import button in the Systems list's toolbar
Import (1) on a location's Systems list.

1. Download the template​

The window has three steps: Template, Upload, Preview. In the first one click Download Template. The template is made at that moment for that place: the headers are in the app's language, the required ones (*) orange; the drop-down lists (Type, Active) are ready.

The Template step of the Import window
The Template step: Download Template, the template's columns and short rules.

If you downloaded the template before, go straight to Upload the File.

2. Fill in the template​

The file has three sheets: Inventory (the one you fill in), How to Fill In (a short guide and the External System Numbers of the inventory already in that place) and a hidden sheet for the drop-down lists. Each row is one item:

ColumnWhat goes in
Code *The row's unique code (e.g. BLR-01). It becomes the item's External System Number when saved.
Parent CodeBuilds the tree: empty for a system, the system's code for equipment, the equipment's for sub-equipment.
Type *System, Equipment or Sub-Equipment.
Name *The item's name.
Description, Serial NoFree text.
Commissioning Date, Warranty End DateAn Excel date or DD.MM.YYYY.
Equipment Lifetime (months)A positive whole number.
Floor No, Room NoEquipment only.
ActiveYes or No; empty means Yes.
Brand, ModelOptional, written by name (equipment and sub-equipment only).
TagsTag names separated by ;; the ones the organization doesn't have are created.

A few rules:

  • The order of the rows doesn't matter; Code / Parent Code build the tree.
  • Adding under an existing item: write the External System Number of an item already in that place in Parent Code (you find them on the How to Fill In sheet).
  • A system's template offers only Equipment / Sub-Equipment as Type. An equipment's template has no Type and Parent Code columns: every row is a sub-equipment under that equipment.
  • Cells the type doesn't use (e.g. Brand on a system) are grey and not read.
  • There is no Category column. Give categories after the import, on the item's page or with the lists' bulk action. An older file that still has a Category column isn't refused: the column isn't read and the preview shows a note.
  • .xlsx files only; at most 5 MB and 2,000 rows.
Numbers (Mac)

You can open and fill in the template in Apple Numbers too; the drop-down lists work there. Before uploading, save it as .xlsx with File › Export To › Excel (a .numbers file isn't accepted).

3. Upload and read the preview​

In the Upload step drag the filled file onto the box, or click and pick it. kommuns reads and checks the file, then shows the Preview: the numbers to add by type, the rows with errors and warnings, your plan's inventory limit and the rows.

Errors​

While any row has an error, nothing is imported. The error is written under the row (e.g. "Parent Code “BLR-S9” is neither in the file nor in this location."). Download Rows with Errors downloads the file you uploaded with an Error column next to the rows with errors; fix the file and upload it again with Upload Another File.

A preview with an error in one row
The number of rows with errors (1), the row and its reason (2), Upload Another File and Download Rows with Errors (3).

Errors are: an empty Type or Name, a Code that appears twice in the file or is another item's External System Number in the organization, a Parent Code that isn't found or of the wrong type, a date that can't be read, an invalid Equipment Lifetime or Active value.

Warnings and suggestions​

Warnings don't stop the import:

  • Brands and models not found: with Add the brands and models not found as the organization's own ticked they are added as your organization's brand / model (Brands & Models); unticked those fields stay empty. Only people with the Brands & Models permission see this choice.
  • New tags: tags the organization doesn't have are created; the preview names them.
  • Filled cells a type doesn't use are ignored.
A preview without errors, ready to import
The numbers to add (1), the brand / model and tag suggestions (2) and the import button (3).

List / Tree shows the rows as a tree too; parents that already exist are marked "already there".

The preview's Tree view
The preview's tree view.

Plan limit​

If your plan limits the inventory, the preview shows today's count, the items to add and what is left. A file over the limit isn't imported: the red warning tells how many items the file may have at most; cut the file down to that many rows and upload it again, or upgrade your plan.

4. Import​

Without errors the button tells how many items will be added (e.g. Import 6 Items). Clicking it saves every row at once: if even one can't be saved, none is. The last screen tells how many items were added and the brands, models and tags created. The import shows as one record in the Activity Log.

The imported items keep their codes as their External System Number: when you later add more under the same place with another file, you can write these codes in Parent Code.

For now

Importing adds new inventory; it doesn't update existing items. The mobile app has no import.