Massive data insertion is possible in the HEVAR Database. Let’s break down the steps for importing data into the HEVAR Database:
- Prepare the Data:
- Organize your data in a worksheet file, such as Microsoft Excel.
- Ensure that the first row contains the titles of the parameters to be inserted into the database. Each title should be in a separate cell. This will create columns, with each column representing a parameter for the dataset.
- Include only data from the same section in this worksheet.
- Save the Worksheet:
- Save the worksheet as a .csv file. This format is commonly used for data exchange and can be easily imported into databases.
- Access the HEVAR Database:
- Log into the database as Administrator.
- Open the plugin named “CSV import.”
- Upload the CSV File:
- Upload the previously saved .csv file to the HEVAR database.
- Select File Format:
- Choose “CSV (German)” from the available file format options. This ensures that the data is interpreted correctly during the import process.
- Select Target Table:
- Finally, select the appropriate target table (section) within the HEVAR database where you want to import the data.
- Follow the steps as explained the images
Remember to follow these steps carefully, and you’ll successfully import your data into the HEVAR Database! If you have any further questions or need additional assistance, feel free to ask. 😊