Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Screens

Import Field Map window

Show all hidden content
Mapping columns establishes a link between the spreadsheet columns and the Fixed Assets CS data. Use the Import Field Map window to create or update the column mappings, to edit spreadsheet data before importing it, and to prevent data from specific rows in the spreadsheet from being imported.
To open this window, select Next in the Import Spreadsheet window.

Fields & buttons

Import data from
This read-only field contains the path to the spreadsheet from which you are importing data.
Column mapping name
This field contains the name of the import field map. You can use this field to edit the name of the import map.
Data to import grid
The data from the Excel spreadsheet appears in this grid. Use the Map Field buttons to map the columns to the fields in Fixed Assets CS. Use the
Omit Row
 checkboxes to exclude the data from the import.
Previous Field / Next Field buttons
Use these buttons to go through the columns in the Data to import grid.
Map field buttons
There is a Map Field button for each column in the Data to import grid. Select Map Field to open the Map field window, where you can map the selected column to Fixed Assets CS.
Omit Row
An
Omit Row
 checkbox appears to the left of each row in the Data to import grid. Mark the checkbox that corresponds to any row that should be excluded from the import.
Verify Data button
Select Verify Data to run the data verification process, which determines whether the data is valid for import.
Import button
Select Import to begin the Import process.
Suspend button
Select Suspend to save the information you have entered in the Import Field Map window without completing the import process.

This article applies to:

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close