Skip to content

CSV Import Example Workstations#

Please create a complete backup before making any changes to an interface/import. If the result is not satisfactory, the backup can then be restored

This example builds on the CSV import of locations. You import workstations, assign them to a room, and link them with clients, monitors, and printers.

This article was last verified for i-doit version 1.16.2

Required Information#

  • Object name -- Name of the workstation, client, monitor, or printer
  • Location -- Under which location should the object be placed?
  • Object type -- Which object type will be created?
  • Workstation assignment -- To which workstation will the component be assigned?

Example CSV file for this import:

Import-workstations.csv

Import-workstations.csv 
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
objectName;Standort;objecttyp;AP Zuweisung
AP0001;RAUM 1.001;C__OBJTYPE__WORKSTATION;
AP0002;RAUM 1.002;C__OBJTYPE__WORKSTATION;
AP0003;RAUM 1.003;C__OBJTYPE__WORKSTATION;
AP0004;RAUM 1.004;C__OBJTYPE__WORKSTATION;
AP0005;RAUM 1.005;C__OBJTYPE__WORKSTATION;
AP0006;RAUM 1.006;C__OBJTYPE__WORKSTATION;
AP0007;RAUM 1.007;C__OBJTYPE__WORKSTATION;
AP0008;RAUM 2.001;C__OBJTYPE__WORKSTATION;
AP0009;RAUM 2.002;C__OBJTYPE__WORKSTATION;
AP0010;RAUM 2.003;C__OBJTYPE__WORKSTATION;
AP0011;RAUM 2.004;C__OBJTYPE__WORKSTATION;
AP0012;RAUM 2.005;C__OBJTYPE__WORKSTATION;
AP0013;RAUM 2.006;C__OBJTYPE__WORKSTATION;
AP0014;RAUM 2.007;C__OBJTYPE__WORKSTATION;
AP0015;RAUM 3.003;C__OBJTYPE__WORKSTATION;
AP0016;RAUM 3.004;C__OBJTYPE__WORKSTATION;
AP0017;RAUM 3.005;C__OBJTYPE__WORKSTATION;
AP0018;RAUM 3.006;C__OBJTYPE__WORKSTATION;
AP0019;RAUM 3.007;C__OBJTYPE__WORKSTATION;
AP0020;RAUM 3.008;C__OBJTYPE__WORKSTATION;
WS001;;C__OBJTYPE__CLIENT;AP0001
WS002;;C__OBJTYPE__CLIENT;AP0002
WS003;;C__OBJTYPE__CLIENT;AP0003
WS004;;C__OBJTYPE__CLIENT;AP0004
WS005;;C__OBJTYPE__CLIENT;AP0005
WS006;;C__OBJTYPE__CLIENT;AP0006
WS007;;C__OBJTYPE__CLIENT;AP0007
WS008;;C__OBJTYPE__CLIENT;AP0008
WS009;;C__OBJTYPE__CLIENT;AP0009
WS010;;C__OBJTYPE__CLIENT;AP0010
WS011;;C__OBJTYPE__CLIENT;AP0011
WS012;;C__OBJTYPE__CLIENT;AP0012
WS013;;C__OBJTYPE__CLIENT;AP0013
WS014;;C__OBJTYPE__CLIENT;AP0014
WS015;;C__OBJTYPE__CLIENT;AP0015
WS016;;C__OBJTYPE__CLIENT;AP0016
WS017;;C__OBJTYPE__CLIENT;AP0017
WS018;;C__OBJTYPE__CLIENT;AP0018
WS019;;C__OBJTYPE__CLIENT;AP0019
WS020;;C__OBJTYPE__CLIENT;AP0020
TFT001;;C__OBJTYPE__MONITOR;AP0001
TFT002;;C__OBJTYPE__MONITOR;AP0002
TFT003;;C__OBJTYPE__MONITOR;AP0003
TFT004;;C__OBJTYPE__MONITOR;AP0004
TFT005;;C__OBJTYPE__MONITOR;AP0005
TFT006;;C__OBJTYPE__MONITOR;AP0006
TFT007;;C__OBJTYPE__MONITOR;AP0007
TFT008;;C__OBJTYPE__MONITOR;AP0008
TFT009;;C__OBJTYPE__MONITOR;AP0009
TFT010;;C__OBJTYPE__MONITOR;AP0010
TFT011;;C__OBJTYPE__MONITOR;AP0011
TFT012;;C__OBJTYPE__MONITOR;AP0012
TFT013;;C__OBJTYPE__MONITOR;AP0013
TFT014;;C__OBJTYPE__MONITOR;AP0014
TFT015;;C__OBJTYPE__MONITOR;AP0015
TFT016;;C__OBJTYPE__MONITOR;AP0016
TFT017;;C__OBJTYPE__MONITOR;AP0017
TFT018;;C__OBJTYPE__MONITOR;AP0018
TFT019;;C__OBJTYPE__MONITOR;AP0019
TFT020;;C__OBJTYPE__MONITOR;AP0020
PRNT001;;C__OBJTYPE__PRINTER;AP0001
PRNT002;;C__OBJTYPE__PRINTER;AP0002
PRNT003;;C__OBJTYPE__PRINTER;AP0003
PRNT004;;C__OBJTYPE__PRINTER;AP0004
PRNT005;;C__OBJTYPE__PRINTER;AP0005
PRNT006;;C__OBJTYPE__PRINTER;AP0006
PRNT007;;C__OBJTYPE__PRINTER;AP0007
PRNT008;;C__OBJTYPE__PRINTER;AP0008
PRNT009;;C__OBJTYPE__PRINTER;AP0009
PRNT010;;C__OBJTYPE__PRINTER;AP0010
PRNT011;;C__OBJTYPE__PRINTER;AP0011
PRNT012;;C__OBJTYPE__PRINTER;AP0012
PRNT013;;C__OBJTYPE__PRINTER;AP0013
PRNT014;;C__OBJTYPE__PRINTER;AP0014
PRNT015;;C__OBJTYPE__PRINTER;AP0015
PRNT016;;C__OBJTYPE__PRINTER;AP0016
PRNT017;;C__OBJTYPE__PRINTER;AP0017
PRNT018;;C__OBJTYPE__PRINTER;AP0018
PRNT019;;C__OBJTYPE__PRINTER;AP0019
PRNT020;;C__OBJTYPE__PRINTER;AP0020

Observe the Order#

This import has dependencies: the locations must already exist (see Creating Locations). Additionally, the workstations must be created before the components so that clients, monitors, and printers can be directly assigned. Therefore, the workstations appear first in the CSV file.

Step-by-Step Instructions#

  1. Navigate to the CSV import under Extras > Import > CSV Import
  2. Upload the CSV file and click Prepare for Import
  3. Leave the settings at the default values and click Prepare Mapping

CSV Mapping

  1. Configure the assignments as shown in the screenshot and start the import

CSV Mapping

Result#

After the import, the workstations are assigned to a location. Under each workstation, you will find the associated client, monitor, and printer.

CSV Mapping