Formatting Information for Export and Import

The formatting options in Integration Manager let you:

• Specify the format of values containing both date and time parts in your CSV file. Integration Manager supports different formats for date and time information in your CSV file, and converts OpenAir date and time values into the format you specify when exporting OpenAir information to a CSV file, or converts date and time values from the format you specify to the format used by the OpenAir database, when you import information a CSV file into OpenAir. See Setting the Date and Time Format Used in the CSV File.

• (Export only) Add length and range validation for field values in your CSV file. See Validating Field Value Length and Range on Export.

• Using conditional overrides to compare numeric or text field values to a fixed value or pattern, and replace the value if the condition is met. See Setting Up Conditional Overrides.