Getting started with data imports for IT asset management

Codenica can import data from XML, JSON, and CSV files, Codenica PC Audit Scanner, Ewida Standard, Ewida Audit, and Azure Entra ID. This guide explains how to set up each source and what data it can bring in. If you are preparing your own file, start by exporting a sample from any list in Codenica.

The Codenica IT asset list with the data export menu open

This is the IT asset list, with its action menu open. From this list, an administrator can export records to XML, JSON, or CSV. The export can serve as a sample import file, which you can edit or use to migrate data from another system.


Import settings to know

The following screens show that some settings are shared across all import types. Here is what the main ones mean:

  • Import source name identifies a source when you run recurring imports from different companies or business units. Use clear names, such as Company ABC or Company XYZ, so you can tell each source apart and update the right records.
  • Data set specifies what you are importing, such as assets (hardware or software), documents, employees or clients, or vendors.
  • Item type classifies an asset in the inventory, for example as a computer, device, or license.
  • Computer type is compatible with Ewida Standard, which uses the label “Set”. In Codenica, you can keep that label or use “Computer” instead.
  • Location, Department, Section, and Room number describe where an asset belongs physically and within the organization. These fields help you organize records across companies, branches, and internal locations.

Importing XML, JSON, and CSV files

Importing XML, JSON, and CSV files is one of the most flexible ways to bring information into Codenica. Many organizations keep their records in spreadsheets or export them from another IT asset management system, so importing those files directly can save a great deal of time.

CSV is widely used for IT inventories because it is easy to edit in Excel, making it simple to correct data and prepare a file for import.

JSON can represent more complex data structures, such as lists of software, devices, or hardware configurations, and is useful when you need to preserve those details accurately.

XML remains common in business systems and is well suited to exchanging data between applications.

Codenica processes these files and can create records for computers, licenses, users, locations, and other items. This makes it quicker to build an IT inventory while reducing the errors that often come with manual data entry. You can also run full, partial, or update imports on a recurring basis, which is useful for organizations that regularly review their IT assets. It is a flexible way to keep your records in sync with the rest of your organization.

Importing data from XML, JSON, and CSV files in Codenica

File import brings in data stored in XML, JSON, or CSV format. The administrator chooses the import source and data set, then decides how existing records should be updated. It is a straightforward way to migrate file-based records or connect Codenica with another system.


Importing data from Codenica PC Audit Scanner

Codenica PC Audit Scanner is a quick way to inventory company computers automatically. It reads hardware details, detected applications, and key system information without installing software on the computer being scanned. The results are saved to files that you can import into Codenica, helping you build an IT inventory much faster. Run the scanner from a USB drive, from a network location, or through scripts that automate the process. It works for both internal and external audits. Importing the scan creates computer and device records, along with detected software, so you can review hardware and software licenses straight away. The scanner is a useful starting point when an organization first introduces IT asset management. It is free to use and can inventory computers across even a large organization. Learn more about the IT audit process.

Importing Codenica PC Audit Scanner results into Codenica

Importing a Codenica PC Audit Scanner file brings hardware and software audit results into the system. Codenica creates computer records, their associated devices, and the applications detected during the scan. It is one of the quickest ways to start an IT inventory.


Importing data from Ewida Standard

Ewida Standard is a desktop application that thousands of companies in Poland have used for more than 20 years to manage their IT assets. Many organizations have built up extensive records in Ewida Standard, including computers, licenses, software, documents, and locations. Codenica can import the full database while preserving links between records. This makes it possible to move from the desktop application to Codenica without losing historical information. After the import, you can use Codenica Cloud or install the system locally as Codenica On-Premise. The import restores relationships such as computer-to-user, license-to-software, and document-to-asset, along with many others. It is a practical way to modernize IT asset management while keeping the records you already rely on. Choosing Cloud or On-Premise lets you match the deployment to your organization. Once the import is complete, your team can continue working in the new system without having to move records by hand.

Importing data from Ewida Standard into Codenica

The Ewida Standard import moves records from the desktop application into Codenica while preserving links between computers, users, licenses, and documents. You can then continue managing your inventory in Codenica Cloud or Codenica On-Premise.


Importing data from Ewida Audit

Ewida Audit is a professional tool for IT audits and monitoring employee computers. It collects detailed information about hardware, software, user activity, and system configuration. Codenica can import complete audit results from Ewida Audit, bringing detailed scanner data into your central IT inventory. The import creates records for computers, applications, devices, and users, and restores their relationships. This is especially useful for IT audit firms that work with multiple clients and need to keep their data in one place. Once the results are in Codenica, you can create reports, review licenses, and plan IT investments alongside your other asset records. The two tools can work together in one audit process: use Ewida Audit in the field and Codenica to organize and analyze the results. That gives auditors and IT administrators a clearer view of the environment.

Importing audit data from Ewida Audit into Codenica

The Ewida Audit import brings detailed IT audit results into your central asset inventory. Codenica creates records for computers, software, and users, and restores the relationships between them. It supports both internal and external audits.


Importing users from Azure Entra ID

The Azure Entra ID integration lets you import your user directory into Codenica. This makes it easier to assign computers, licenses, and software to the right employees and keep those records up to date. Changes in your directory can then be reflected in your IT asset inventory instead of being entered manually. Organizations using Microsoft 365 can keep their employee records aligned with the rest of their IT inventory. This is particularly helpful in medium-sized and large organizations, where teams and responsibilities change frequently. The integration saves time, reduces manual entry errors, and makes it easier to manage licenses, equipment, and IT security in one place.

Configuring an OAuth 2.0 connection to Azure Entra ID and granting permission to read users

Set up an OAuth 2.0 connection to Azure Entra ID and grant the permissions needed to read the user list and basic user details. This is a key step in securely importing employee records from Azure.

Connecting to Azure Entra ID and importing users

Importing users from Azure Entra ID takes a few steps: configure a secure OAuth 2.0 connection, grant the required permissions in Entra ID, and assign the connection to a Codenica user. Once those steps are complete, that user can start the import. This setup keeps access to employee data under control and supports the security needs of medium-sized and large organizations.

Assigning a configured Azure Entra ID connection to a Codenica user

Assign the configured Azure Entra ID connection to a specific Codenica user. Only users with that connection assigned can import users from Entra ID.

Importing users from Azure Entra ID with an assigned OAuth 2.0 connection

Import users from Azure Entra ID into Codenica using the OAuth 2.0 connection assigned to your account. Codenica reads the current user list and basic identifying details, then creates new records or updates existing ones in the IT inventory.


Summary

Codenica can import data from XML, JSON, and CSV files, Codenica PC Audit Scanner, Ewida Standard, Ewida Audit, and Azure Entra ID. The import process and the data available depend on the source. This guide explains how to configure and use each option.