Databases Reference
In-Depth Information
•
Lines
terminated
with
: This decides the character that ends each line.
We should use a proper line delimiter here depending on the operating
system on which we will manipulate the resulting export file. The default
value of this option comes from the
$cfg['Export']['csv_terminated']
parameter, which contains
'AUTO'
by default. The
'AUTO'
value produces a
value of
\r\n
if the browser's OS is Windows, and
\n
otherwise. However,
this might not be the best choice if the export file is intended for a machine
with a different OS.
•
Replace
NULL
with
: This determines which string occupies the place in the
export file of any
NULL
value found in a column.
•
Remove
carriage
return/line
feed
characters
within
columns
: As a column
can contain carriage return or line feed characters, this determines if such
characters should be removed from the exported data.
•
Put
column
names
in
the
first
row
: This gets some information about the
meaning of each column. Some programs will use this information to name
the column. For the exercise, we select this option.
Finally, we select the
author
table.
Clicking on
Go
produces a file containing the following lines:
"id","name","phone"
"1","John Smith","+01 445 789-1234"
"2","Maria Sunshine","+01 455 444-5683"
CSV for Microsoft Excel
This export mode produces a CSV file specially formatted for Microsoft Excel (using
semicolons instead of commas). We can select the exact Microsoft Excel edition as
shown in the following screenshot:
Search WWH ::
Custom Search