What is the format for the CSV DTO Template?

DTOClosed DTO is an abbreviation for Data Take On - a method for importing into Timegate Web. Templates use the CSVClosed A CSV file is a Comma Separated Values (CSV) file. It is a delimited text file that uses a comma to separate the values. Each line of the file is a seperate data record. These files are used to export/import data from one system into another format. These files should be completed by following this format:
  • Each record is located on a separate line
  • The first record should be the header record
  • Each record contains the same number of comma-separated fields
  • Any field may be quoted with double quotes
  • Fields containing a line-break, double -quote or commas should be quoted
  • A double quote character in a field must be represented by two double quotes

Note: When saving from a spreadsheet (such as Microsoft Excel), saving as a CSV file should automatically apply this formatting. These standards do not apply to the standard Contract Times Import as it is not designed to parse such documents.