Advanced CSV
A CSV template is defined with a *.csv.properties file. This properties gives you options to change general
configuration, define format or provide custom validation.
The available options are:
| Key | Default | Description |
|---|---|---|
| charsetName | UTF-8 | Option to change the charset name. |
| quote | « | The quote character is used when a cell contains special characters, such as the delimiter char, a quote char, or spans multiple lines. |
| separator | ; | The delimiter character separates each cell in a row. |
| endOfLine | \n | The end of line symbols to use when writing. |
| showHeader | true | If true, show the column headers. |
| columns | N/A | Mandatory. List of the model fields to render. |
| xxxx.name | N/A | Header name to write. If the name property is not present the header will be the field name |
| xxxx.type | String | Available types are «date», «boolean», «int»,«double», «long», «bigdecimal». |
| xxxx.format | N/A | Used to format date, boolean and number (ex: birthdate.format=dd/MM/yyyy). For the boolean type you can specify how to write true or false values by two comma separated values: married.format=Yes,No. |
| xxxx.notNull | false | Is used to define if the field is optional or not. |
| xxxx.unique | false | Is used to define the field must be unique. |
Example
# General configuration
quote="
separator=;
endOfLine=\n
charsetName=UTF-8
columns=customerNo, firstName, lastName, birthDate, mailingAddress, married, numberOfKids, favouriteQuote, email, loyaltyPoints
# customerNo (must be unique)
customerNo.name=ID
customerNo.nullable=false
customerNo.unique=true
# firstName
firstName.name=First name
firstName.nullable=false
# lastName
lastName.name=Last name
lastName.nullable=false
# birthDate
birthDate.name=Birth date
birthDate.nullable=false
birthDate.type=date
birthDate.format=dd/MM/yyyy
# mailingAddress
mailingAddress.name=Mailling address
mailingAddress.nullable=false
# married
married.name=Married
married.nullable=true
married.type=boolean
married.format=Yes,No
# numberOfKids
numberOfKids.name=Number of kids
numberOfKids.nullable=true
# favouriteQuote
favouriteQuote.name=Favorite quote
favouriteQuote.nullable=false
# email
email.name=Email
email.nullable=false
# loyaltyPoints
loyaltyPoints.name=Loyalty points
loyaltyPoints.nullable=false