Changes for page Import von CSV-Dateien

Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -1,6 +1,6 @@
1	1	{{aagon.floatingbox/}}
2	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.
	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	4
5	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	6
...	...	@@ -9,15 +9,15 @@
9	9
10	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	11
12		-|(% style="width:354px" %)**ACMP area**|(% style="width:590px" %)**Description**|(% style="width:749px" %)**Specialities**
	12	+|(% style="width:354px" %)**acmp area**|(% style="width:590px" %)**Description**|(% style="width:749px" %)**Specialities**
13	13	|(% style="width:354px" %)(((
14	14	**Asset Management**
15	15
16	16	(//Asset Management// > //Hardware Assets//)
17	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).
	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	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.69.ACMP-Solutions.Asset Management.Assets verwalten.WebHome||anchor="HAssetsbearbeiten2ClF6schenundduplizieren"]].
	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.610.ACMP-Solutions.Asset Management.Assets verwalten.WebHome||anchor="HEditing2CDeletingandDuplicatingAssets"]].
21	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	22	)))
23	23	|(% style="width:354px" %)**Licence Management**|In Licence Management, you may also need to import a CSV file if:|(% style="width:749px" %)
...	...	@@ -25,23 +25,23 @@
25	25	Licences
26	26
27	27	(//Licence Management //> //Licences//)
28		-)))|(% style="width:590px" %)- New licenses are to be installed and information on the [[licence metrik>>doc:ACMP.69.ACMP-Solutions.Lizenzmanagement.Lizenzen.WebHome||anchor="HLizenzenhinzufFCgen"]] and [[calculation method>>doc:ACMP.69.ACMP-Solutions.Lizenzmanagement.Lizenzen.Lizenzen und Produkte in ACMP importieren.WebHome||anchor="HKalkulationsmethode"]] can already be entered in the file.|(% style="width:749px" %)(((
	28	+)))|(% style="width:590px" %)- New licenses are to be installed and information on the [[licence metrik>>doc:ACMP.610.ACMP-Solutions.Lizenzmanagement.Lizenzen.WebHome||anchor="HAddlicences"]] and [[calculation method>>doc:ACMP.610.ACMP-Solutions.Lizenzmanagement.Lizenzen.Lizenzen und Produkte in ACMP importieren.WebHome||anchor="HCalculationmethod"]] can already be entered in the file.|(% style="width:749px" %)(((
29	29	* The license name is mandatory when importing licenses.
30		-* Specify the appropriate value for determining the [[calculation method>>doc:ACMP.69.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.
	30	+* Specify the appropriate value for determining the [[calculation method>>doc:ACMP.610.ACMP-Solutions.Lizenzmanagement.Lizenzen.Lizenzen und Produkte in ACMP importieren.WebHome||anchor="HCalculationmethod"]] in the file so that it can be assigned to the correct attributes.
31	31	)))
32	32	|(% style="width:354px" %)(((
33	33	Products
34	34
35	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.69.ACMP-Solutions.Lizenzmanagement.Lizenzen.Lizenzen und Produkte in ACMP importieren.WebHome||anchor="HKalkulationsmethode"]] can be stored within the import.|(% style="width:749px" %)(((
	36	+)))|(% style="width:590px" %)- A larger quantity of new products is to be entered into the acmp Console. The [[calculation method>>doc:ACMP.610.ACMP-Solutions.Lizenzmanagement.Lizenzen.Lizenzen und Produkte in ACMP importieren.WebHome||anchor="HKalkulationsmethode"]] can be stored within the import.|(% style="width:749px" %)(((
37	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.69.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.
	38	+* Specify the appropriate value for determining the [[calculation method>>doc:ACMP.610.ACMP-Solutions.Lizenzmanagement.Lizenzen.Lizenzen und Produkte in ACMP importieren.WebHome||anchor="HCalculationmethod"]] in the file so that it can be assigned to the correct attributes.
39	39	)))
40	40	|(% style="width:354px" %)(((
41	41	**Manual Clients**
42	42
43	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" %)(((
	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	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	46	)))
47	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" %)
...	...	@@ -49,8 +49,8 @@
49	49	Contacts
50	50
51	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.69.ACMP-Solutions.System.Einstellungen.Stammdaten.WebHome||anchor="HKontakte"]] //(the email or custom ID) must be stored in the CSV file.
	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.610.ACMP-Solutions.System.Einstellungen.Stammdaten.WebHome||anchor="HContacts"]] //(the email or custom ID) must be stored in the CSV file.
54	54
55	55
56	56	)))
...	...	@@ -65,7 +65,7 @@
65	65	Companies
66	66
67	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.|(((
	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	69	* The company name is required for mapping. The import cannot be finished without this information.
70	70	)))
71	71	|(% style="width:354px" %)(((
...	...	@@ -93,8 +93,8 @@
93	93	== General notes ==
94	94
95	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.69.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.
	96	+* The identification characteristic that you have defined in the settings for [[Asset Management>>doc:ACMP.610.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	98
99	99	= Structure of the import file and CSV datasets =
100	100
...	...	@@ -108,7 +108,7 @@
108	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	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	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.
	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	112
113	113	=== Examples of CSV datasets ===
114	114
...	...	@@ -123,7 +123,7 @@
123	123
124	124	== Importing CSV files ==
125	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.
	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	127
128	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	129
...	...	@@ -137,7 +137,7 @@
137	137
138	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	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.
	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	141
142	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	143