Wiki source code of Import von CSV-Dateien

Last modified by Sabrina V. on 2025/02/27 11:03
Show last authors
1 {{aagon.floatingbox/}}
2
3 At various points in the ACMP Console, you have the option to import additional data. The import of CSV files is cross-system and always useful when external information relevant to your work in the console is not yet entered. The advantage of this approach is that you can upload a larger quantity of selected data in just one step, centrally in a file, and you do not have to enter this information manually. This not only saves time, but you can also access existing CSV datasets and use them directly or in a slightly modified form. However, the prerequisite for this is that the file has already been created for the import and you only have to upload it to the ACMP Console.
4
5 Each import of a CSV file follows the same principle: Open the //Import //([[image:1731311907510-969.png||height="18" width="18"]]) action in the ribbon bar. You will be guided step by step by a wizard that opens on several pages to load the information from the CSV file into the system.
6
7
8 = Areas of application =
9
10 Below you will find a short description of the respective areas of application and in which context an import may be useful. The //Specialities //column contains information and notes that you should consider when importing.
11
12 |(% style="width:354px" %)**ACMP area**|(% style="width:590px" %)**Description**|(% style="width:749px" %)**Specialities**
13 |(% style="width:354px" %)(((
14 **Asset Management**
15
16 (//Asset Management// > //Hardware Assets//)
17 )))|(% style="width:590px" %)(((
18 Import a CSV file to inventory continuing assets and goods in the ACMP Console (for example, when a larger quantity of new hardware has been ordered and is to be added to the system).
19 )))|(% style="width:749px" %)(((
20 * In Asset Management, there are additional settings that you need to configure under //System// > //Settings// > //Asset// //Management// > //Import//. Here you determine how you want to deal with the automatic processing of [[asset duplicates>>doc:ACMP.67.ACMP-Solutions.Asset Management.Assets verwalten.WebHome||anchor="HAssetsbearbeiten2ClF6schenundduplizieren"]].
21 * During the mapping (second step of the import of a CSV file), only available fields of the //Asset Management //type are taken into account.
22 )))
23 |(% style="width:354px" %)**Licence Management**|In Licence Management, you may also need to import a CSV file if:|(% style="width:749px" %)
24 |(% style="width:354px" %)(((
25 Licences
26
27 (//Licence Management //> //Licences//)
28 )))|(% style="width:590px" %)- New licenses are to be installed and information on the [[licence metrik>>doc:ACMP.67.ACMP-Solutions.Lizenzmanagement.Lizenzen.WebHome||anchor="HLizenzenhinzufFCgen"]] and [[calculation method>>doc:ACMP.67.ACMP-Solutions.Lizenzmanagement.Lizenzen.Lizenzen und Produkte in ACMP importieren.WebHome||anchor="HKalkulationsmethode"]] can already be entered in the file.|(% style="width:749px" %)(((
29 * The license name is mandatory when importing licenses.
30 * Specify the appropriate value for determining the [[calculation method>>doc:ACMP.67.ACMP-Solutions.Lizenzmanagement.Lizenzen.Lizenzen und Produkte in ACMP importieren.WebHome||anchor="HKalkulationsmethode"]] in the file so that it can be assigned to the correct attributes.
31 )))
32 |(% style="width:354px" %)(((
33 Products
34
35 (//Licence Management //> //Products//)
36 )))|(% style="width:590px" %)- A larger quantity of new products is to be entered into the ACMP Console. The [[calculation method>>doc:ACMP.67.ACMP-Solutions.Lizenzmanagement.Lizenzen.Lizenzen und Produkte in ACMP importieren.WebHome||anchor="HKalkulationsmethode"]] can be stored within the import.|(% style="width:749px" %)(((
37 * When importing products, you must enter the product name in the mandatory field.
38 * Specify the appropriate value for determining the [[calculation method>>doc:ACMP.67.ACMP-Solutions.Lizenzmanagement.Lizenzen.Lizenzen und Produkte in ACMP importieren.WebHome||anchor="HKalkulationsmethode"]] in the file so that it can be assigned to the correct attributes.
39 )))
40 |(% style="width:354px" %)(((
41 **Manual Clients**
42
43 (//Client Management// > //Manual Clients//)
44 )))|Importing manual Clients can be useful, for example, if you want to reserve a computer at one of your locations as a replacement device and you want to import it into the manual Clients in advance. If several Clients are to be entered at once, importing via a CSV file saves time and you can replace the computer and connect it up as quickly as possible during your daily work, because all the relevant information is already entered in ACMP.|(% style="width:749px" %)(((
45 * Should such a scenario occur as described in the //description, //it is necessary that you store the MAC address in the CSV file for the import. The MAC address is required for a clear mapping.
46 )))
47 |(% style="width:354px" %)**Master Data**|The Master Data consists of various areas, each of which you can import separately. It may be useful to import data if:|(% style="width:749px" %)
48 |(% style="width:354px" %)(((
49 Contacts
50
51 (Ribbon bar //Master Data //> //Kontakte//)
52 )))|A larger quantity of new employees is to be stored in the ACMP Console. If, for example, you have a new contractual partner or close new collaborations with other companies (or their employees/contact persons), manually entering all new contacts can otherwise be time-consuming.|(% style="width:749px" %)(((
53 * The unique identifier that you have stored in the settings under //[[Unique identifier for contact support>>doc:ACMP.67.ACMP-Solutions.System.Einstellungen.Stammdaten.WebHome||anchor="HKontakte"]] //(the email or custom ID) must be stored in the CSV file.
54
55
56 )))
57 |(% style="width:354px" %)(((
58 Locations
59
60 (Ribbon bar //Master Data //> //Locations//)
61 )))|Your company is opening a new location and you want to integrate the location directly according to the types (location, building, room).|(((
62 * A location name is required for mapping. Without a location name (e.g. a city name or a regional classification (south, west, etc.)), no file can be imported.
63 )))
64 |(% style="width:354px" %)(((
65 Companies
66
67 (Ribbon bar //Master Data //> //Companies//)
68 )))|A larger number of companies can be added in just one step if, for example, you want to add several suppliers, service partners or manufacturers to the ACMP Console.|(((
69 * The company name is required for mapping. The import cannot be finished without this information.
70 )))
71 |(% style="width:354px" %)(((
72 Departments
73
74 (Ribbon bar //Master Data //> //Departments//)
75 )))|- You want to add several departments at the same time.|(% style="width:749px" %)(((
76 * A name is required for the department, otherwise the wizard will cause an error during mapping.
77 )))
78 |(% style="width:354px" %)(((
79 Cost Centers
80
81 (Ribbon bar //Master Data //> //Cost Centers//)
82 )))|- Your company is to be divided into several cost centres or new cost centres are to be added in order to achieve a better overview of costs and services for the respective departments.|(% style="width:749px" %)(((
83 * Enter a name for the cost centre. Otherwise, the import cannot continue.
84 )))
85 |(% style="width:354px" %)(((
86 Contracts
87
88 (Ribbon bar //Master Data //> //Contracts//)
89 )))|- You want to upload several contracts at the same time.|(% style="width:749px" %)(((
90 * A mapping for the name of the contract is required, otherwise the import cannot be completed.
91 )))
92
93 == General notes ==
94
95 * A double field assignment will cause an error. Make sure that you do not assign the same caption to a field within the mapping.
96 * The identification characteristic that you have defined in the settings for [[Asset Management>>doc:ACMP.67.ACMP-Solutions.Asset Management.WebHome]] must be available for mapping. Otherwise, the import will also cause an error here.
97 * The categories //contacts//, //locations//, //companies//, //departments// and //cost centres//, which are specified when importing Assets but are not available in ACMP, are automatically created as available values. If you need more dates than you can specify in the mapping, import the respective entity beforehand.
98
99 = Structure of the import file and CSV datasets =
100
101 == Structure of the import file ==
102
103 You can create CSV files in any text editor (e.g. Microsoft Excel, Notepad++ etc.). It is important that you save the file in //CSV// format.
104
105 If you would like to create your own file, you should note the following points to ensure a successful import:
106
107 * If you use IP addresses, these must be enclosed in double quotation marks. Example: ‘192.156.200.18’
108 * If you use memory sizes such as hard drive sizes, RAM, etc., these values must also be enclosed in double quotation marks if they contain a decimal separator and a unit. Example: ‘10.5 GB’.
109 * Select from the available units (KB to TB). The binary prefixes (KiB to TiB) are not supported and will be replaced by the value ‘0’ during import.
110 * The CPU frequency must be specified in MHz, whereby the unit must not be included in the CSV file. If the frequency is specified with a separator, this must also be enclosed in double quotation marks.
111 * The content of the CSV file is transferred to ACMP exactly as it was created. So pay attention to the spelling when naming the individual fields.
112
113 === Examples of CSV datasets ===
114
115 Below are some examples of how the CSV datasets can be structured:
116
117 {{code language="none"}}
118 Computer Name;Computer Domain;OS Name;Main User;Primary IP;ACMP Client Mac Address;CPU Name;CPU Frequency (Mhz);Total RAM;Total harddrive capacity
119 Computer 1;DOMAINTEST;Windows 7 Home;Benutzer 1;"10.0.0.1";AA:BB:CC:AA:3A:AF;Phenom 1;"2000,56";"1024 MB";"1 TB"
120 ComputerName;MSHEIMNETZ;Windows 8 Pro;John;"10.0.0.2";CC:CC:CC:CC:CC:CC;Phenom II x4;3400;"4 GB";"5 GB"
121
122 {{/code}}
123
124 == Importing CSV files ==
125
126 To import a CSV file, you must select the action //Import// ([[image:1731313214858-303.png||height="18" width="18"]]) in the ribbon bar of the application area mentioned above. The procedure is always the same in all areas, so it is irrelevant for the general explanation whether you want to enter manual Clients, Assets or licenses into the ACMP Console. Click on the button and a wizard will open.
127
128 Select the prepared CSV file by inserting it into the line provided. Then specify which symbols delimiters you have used in the uploaded CSV file. Specify whether the file contains column names and whether character encoding should be forced. Use one of the listed encoding types. The corresponding code page is displayed in the field on the right, which is for control purposes only.
129
130 Click //Next >// to continue with the mapping.
131
132
133
134 [[Importing a file>>image:66_CSV-Datei importieren_Datei importieren_761.png]]
135
136 == Mapping ==
137
138 After you have selected a CSV file in the file browser, it is read in and displayed in the wizard. In this example, manual Clients are imported.
139
140 The column headings from the CSV file are displayed in the top rows. To display the manual Clients for each column, select the field in ACMP that you want to assign to the respective column. Please note the respective specifics for the [[individual imports>>doc:||anchor="HAreasofapplication"]] so that the import can run successfully.
141
142 If you have already created and saved mappings in the past, you can use them here. This option offers you faster access to previously created mappings that you want to reuse as templates and have saved. To do this, use the //Load Mapping// ([[image:1731313703025-142.png]]), //Save// ([[image:1731313703026-981.png]]) or //Reset //([[image:1731313703026-197.png]]) functions. The mappings use the .lmp format.
143
144 Once you have finished mapping, click //Next >//.
145
146 [[Mapping file>>image:66_ClientManagement_ManuelleClients_Zuordnung_747.png]]
147
148 On the last page of the wizard, you can see the progress and results of the import. The items that were processed, successfully imported or skipped are listed there. You can save the corresponding log file if required. Now click on //Done// to complete the import of the CSV file.
149
150 [[Import progress>>image:66_CSV-Datei importieren_Import einer CSV-Datei Asset Management_766.png]]
151
152
© Aagon GmbH 2025
Besuchen Sie unsere neue Aagon-Community