We recommend that you use the .xlsx template. Click the link on the File Upload page. There is a template, containing sample
data, for each business object.
Select a business object.
Click the Upload icon.
Drop the import file to the File Upload page, or browse to
the file and click Open.
Select one of these options:
Option
Description
Add/Update
Add the imported data to the existing data in the model.
Caution:
Existing records are updated with the values from the
selected file. You can protect manually edited properties from
update in the Manual Adjustments step of the wizard.
Replace
Replace all existing data in the model for the selected business
object.
If you selected the Add/Update
option, and there are manually edited properties that you want to preserve, then
select the check boxes of those properties.
Optionally, to ensure that the selected properties are protected during future
uploads, selectSave settings as default for this
business object.
Your saved settings are written to the Manage Properties dialog box.
To view or update the saved settings, click Manage Properties and turn on Import Settings.
Click Next and then
click Upload.
The upload fails if the source contains invalid data, such as
an invalid currency code. The Result page
shows the number of invalid records, their row numbers in the source file, and
the reason for failure.
Optionally, click Save Log File to save the log to a text
file. In addition to the row numbers and reasons, the text file shows the column
names and the details of the failed rows.