Skip to main content
All CollectionsImport & Export
How do I create an import template for location and room lists?
How do I create an import template for location and room lists?

You can find out here how you can create an interface to your existing room lists.

Corinna Hahnefeld avatar
Written by Corinna Hahnefeld
Updated over a week ago

Before you can import data from your previous systems, you have to create an import template. In this you specify which data should be transferred and which fields are required. so you don't have to import all fields of your import file.

That's how it works:

We'll show you the complete import process including a video tutorial here.

  • Go to the Import/Export menu

  • Click on the Locations tab and then on File Format

  • Click the Create button

  • Choose Import

  • Drag & drop your template file into the window (see below) or click in the window and select the template file, then click on Continue

Note that the template file must be in .csv format (UTF-8) so that there are no complications or misrepresentations in the upload.

  • Select your options in the preview and give the template a name

You can set whether the template should use the first line as a heading, which separator should be used and whether empty fields in the template should overwrite existing fields.

  • When mapping, assign all seventhings fields to the corresponding fields in the import file. To do this, drag the seventhings fields on the left to the corresponding position in the middle.

Note that you cannot create any new fields here. So make sure in advance that you have already created all the fields to be imported in the inventory manager.

You can remove fields from the import file using the cross if you do not want to import them.

Note that you only drag the identical field types (text, number, date, ...) next to each other. If the field type of an import field is incorrect, you can set the category manually. To do this, simply double-click on the field.

Then select the appropriate field type here.

  • Choose a key field

Note: The key field is used to uniquely assign the import fields to the seventhings fields.

If all the rooms in the different locations have different room numbers, it makes sense to select the room number as a key field, as this allows a one-to-one assignment.

Do you have several locations, e.g. In buildings in which there are rooms with the same room number, you have to select both the location and the room number as the key field in order to guarantee a unique assignment.

Also note that the import overwrites all existing fields (including those that you have defined as "Not editable" in the field definitions).

If you do not want to overwrite a field during import, make sure not to drag this field into the middle when mapping.

  • Confirm your entries with Finish

Did this answer your question?