### Importing a CSV File

A Comma Separated Value file (CSV) is a text file with values generally separated by commas. Many third party tools support a CSV export of measurement data, including DataPage+. This CSV import lets you import these data files into DataPage+.

1. Once you have a CSV file, on the Choose a data file screen of the wizard, choose the CSV option, click Browse, and select the CSV file. Click Next.

2. On the Customize the data 1 screen, use the available tools to match the fields in the CSV with any header information.

1. Define the number of rows in the CSV file that contain header information.

2. In the Header Info area, define the Part Name by choosing the column and cell for the appropriate field.

3. In the Header Info area, define a transaction date and time by either using the individual Date and Time lists to point to two separate fields where the date and time are defined in the data file or by using the Date Time list to point to a single field containing both the date and time.

4. Click Next.

3. On the Customize the data 2 screen, determine whether or not the first row of the data file contains field names by marking or clearing the First row contains field names check box. Click Next.

4. On the Customize the data 3 screen, use the available tools to match columns in the CSV file with required column names understood by the database or with trace fields.

1. 1. To do this, select a column to map from Original column list.

   2. In the Map to area, choose one of these three options depending on what columns you want mapped:

      - Fixed column - This refers to a fixed column of data in the database. If you've mapped multiple MEASURED columns, those are imported automatically as separate transactions.

      - Trace field - This is used to track part-specific data that may change from part to part. If you choose Trace field, you will need to give that column of data a trace field name.

      - Skip - This cause DataPage+ import wizard to ignore a column of data.

   3. Click Set to associate the original column with the specified database column or trace field or to skip the selected column. In the preview window, the column headers text will change to indicate what you have mapped for each column of data.

   4. Continue selecting columns until all the desired columns are mapped.

5. If desired, click the Save button to save CSV settings for future CSV imports. If you later mark the Use saved settings check box on the first screen of the wizard, the CSV import will use those settings.

6. Click Finish. The Performing Operation... screen shows details of the import process. Once this finishes, click Cancel to close the wizard. The imported data will then be available for selection from within DataPage+.