4. We need a temporary directory??”under the main phpMyAdmin
directory??”for the .xls generation. It can be created on a Linux system with:
mkdir tmp ; chmod o+rwx tmp.
5. We set the $cfg['TempDir'] parameter in config.inc.php to './tmp'.
We should now be able to see the new Native MS Excel data export choice.
Open Document Spreadsheet
This spreadsheet format is a subset of the Open Document (http://en.wikipedia.
org/wiki/OpenDocument), which was made popular with the OpenOffice.org office
suite. We need to choose only one table to be exported in order to have a coherent
spreadsheet. Here is our author table, exported into a file named author.ods
subsequently looked at from OpenOffice:
Exporting Structure and Data
[ 132 ]
Open Document Text
This is another subset of the Open Document standard, this time oriented towards
text processing. The available options are:
Our author table is now exported and viewed from OpenOffice:
YAML
This acronym stands for "YAML Ain't Markup Language". YAML is a
human-readable data serialization format; its official site is http://www.yaml.org.
This format has no option that we can choose from within phpMyAdmin. Here is the
YAML export for the author table:
1:
id: 1
name: John Smith
phone: +01 445-789-1234
Chapter 7
[ 133 ]
2:
id: 2
name: Maria Sunshine
phone: 333-3333
Table Exports
The Export link in the Table view brings up the export sub-panel for a specific table.
Pages:
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140