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 SuiteProjects Pro date and time values into the format you specify when exporting SuiteProjects Pro information to a CSV file, or converts date and time values from the format you specify to the format used by the SuiteProjects Pro database, when you import information a CSV file into SuiteProjects Pro. 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.