Structure of the import file and CSV datasets
Last modified by S V on 2023/03/24 09:42
Structure of the import file
If you want to create your own file, you should observe the following notes to guarantee a successful import:
- If you use IP addresses, they must be enclosed in double inverted commas. Example: "192.156.200.18".
- If you use memory values such as hard disk sizes, RAM, etc., these values must also be placed in double inverted commas if they contain a decimal separator and a unit. Example: "10.5 GB".
- Select between the available units (KB to TB). The binary prefixes (KiB to TiB) are not supported and are replaced by the value "0" during import.
- 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 placed in double inverted commas.
Examples of CSV datasets
Below you can see some examples of how the CSV datasets can be structured:
Computer Name;Computer Domain;OS Name;Main User;Primary IP;ACMP Client MAC Adress;CPU Name;CPU Frequency (Mhz);Total Ram;Total harddrive capacity
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"
ComputerName;MSHEIMNETZ;Windows 8 Pro;John;"10.0.0.2";CC:CC:CC:CC:CC:CC;Phenom II x4;3400;"4 GB";"5 GB"
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"
ComputerName;MSHEIMNETZ;Windows 8 Pro;John;"10.0.0.2";CC:CC:CC:CC:CC:CC;Phenom II x4;3400;"4 GB";"5 GB"