Importing a csv file
About this task
After you have created a csv file and an import template,you can use the import file function to add the data from your file into the BigFix® Remote Control database. This is useful for adding numerous records of data to the database at once instead of having to add the items individually.
To add the data into the database, complete the following steps :
Procedure
- Click
.The Import Existing Data screen is displayed
- Choose the appropriate method for selecting your csv file.
- If your file has no header row, select an import template
from the list that will be used to map your data to the relevant database
table. Note: If your file has a header in it, it will match automatically with a defined template and therefore no selection is required.
- Click SubmitThe message File has been queued for processing is displayed
Results
Your data is added to the database. You can check this by displaying the relevant report for this data. For example if you have added user data, you can use the All users report to check that the data has been added correctly.