Check points on Application Data Import

When we configure data Import from application, we need to look for some key points.

1. For any attribute that gets value from a sequence or auto numbering, Don’t include them in XML input file.

For Flat files, we must give unique values for auto key in the input file for supporting the conversion of Flat file to XML internally. The use of auto key or manual is decided by using the Restrict Attributes select action in Database Configuration at Object level or Inbound Setting Restrictions select action in Object Structure application. This setting will be considered for all integrations using this Object.

2.     For flat files, make last column of the file with value for each row. It will avoid problem of missing comma delimiter for some columns. 

Reference:  TPAE75_App+Import-Export.pdf