Wie importieren Sie CSV-Reports in eine Datenbank

Mit AIDA64 Business und Network Audit können Sie CSV-Dateien in eine Datenbank importieren. Auf diese Weise können Sie ganz einfach CSV-Berichtsdateien hinzufügen oder auf PCs, die nicht direkt mit dem Firmennetzwerk verbunden sind, zu Ihrer zentralen Inventardatenbank hinzufügen.

If we decide to store the reports collected at scheduled times from client computers in individual files rather than in a database, we should follow the following steps. Let's create a shared folder for the reports with “Modify” permission, to which all clients have access with “Write” NTFS permission only. Running on the clients, AIDA64 will be able to copy the reports here.

The folder can be: \\Server2012\Shares\AIDA64_Reports.

Then we have two options to add the CSV reports files to our database. In AIDA64 Database Manager, which can be used to maintain SQL databases and reads reports from existing databases, we can do so manually by clicking Operations in the main menu and then selecting “Insert report files to database”. Here we can select either individual files or a folder where reports are stored.

But we can also automate this process using command-line options. Specifically, we will need the /CSV2SQL [folder] switch to insert all the reports in the selected folder into a SQL database. We can create a scheduled task on the main computer to perform this task. You don't need to worry, the files already imported will not be imported again.

We need to open Task Scheduler, then locate Actions | Create task. On the Trigger tab, click “New” and create a new trigger.

In the Program/Script field on the New action tab, we need to browse to the AIDA64 executable found in the network share, and add the required command-line options. For example: \\SRVR2012\Shares\AIDA64BE\aida64.exe /CSV2SQL \\SRVREN\Shares\AIDA64_Reports\

Then we need to set the privileges, and check the option “Run whether user is logged on or not”.

To read about how to configure databases to work with AIDA64,  click here.