Resolve Problems When Importing Data

When you import data from a file, if you see a warning message that the data was not imported or only partially imported, you might need to make changes to the file and import the file again.

To resolve problems during import, you might want to compare the data in your file to the data in the database. You can see the actual data in the database in the Data tab of your business object. You can also export the current data as a CSV file and compare the data using a tool on your local system.

When you import a CSV file with a Date field, dates must be in the standard ISO format, for example, 2017-09-31. For files with string type fields, the data in each string field must not exceed 4000 bytes.

When you see a warning message:

1. Confirm that the name of the file or Excel workbook is the same as the name of the business object.
2. Compare the columns in the files to the fields in the business objects.
   Importing a file will not create fields in the database schema. Columns in the file are ignored if a field with that name does not exist in the business object. The import tool expects the data in the first row of the CSV file or Excel workbook to be the name of the field.
3. Confirm that the format and type of the data in the file are the same as those specified in the schema.
4. Make sure that the MIME type of the file is compatible with the browser you're using. The following MIME type is accepted by most browsers:

   [[["application/vnd.ms-excel","text/csv"]]]