The Fast Loader employs a CSV file that is named for every object. This file contains
values for the columns that are defined for the staging table, in one or an unlimited number of
rows. The file provides the data in a columnar sequence as described in the control
file.
Date and time
The default date format that is used is dd-mm-yyyy. This date format is
specified in the sample Control files and the SQL files.
Consider the following points about the Date field in the data input file.
- A Date field can contain a time stamp. The time defaults to 00:00:00 if no time value is
provided.
- If you want to use a date with a different format or if you want to add a time stamp along with
the date, you must update the Control files and the SQL files.
- The date-time format used must be supported by the database that is used by the Emptoris® Contract Management
application.