More Formats for Import CSV

Goal: Usability

Developer: Carlos Ruiz

Description:

The import CSV template allows now to define more options:

Separator Character: allows to define the field separator on the CSV file, the default is the commonly used comma (,) but it can also support any other character like semicolon or tab
Quote Char: allows to define the character that surrounds strings, commonly used is the double quote (") but it can also support any other character like single quote
Import Template Type: The default is still CSV files, and now is possible also to import directly from Excel files with format XLS or XLSX. Note that the Excel file is preprocessed to create a CSV file with the format defined, and then importing the CSV

01 Template

Technical Info: IDEMPIERE-6040

See Also​