Question

is it possible to get the smartform database in excel format

Answer 1

Hi -

Smartform is provided as a MySQL database, but it's easy enough to export files from the smartform database to Excel using standard commands in MySQL, such as (here exporting everything for the year 2010 in one command line step):

SELECT * FROM historic_races join historic_runners using (race_id) where year(meeting_date) = 2010 INTO OUTFILE '/tmp/smartform_2011_2012.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n';

Or you can use the export facilities in popular MySQL visual interface tools like SequelPro (for Mac) or HeidiSQL (for Windows).

Comments

Very odd...when I run this script I get an error stating:

error 1227 (42000): Access Denied; you need (at least one of) the FILE privilege(s) for this operation

---

This error occurs when MySQL does not have permission to write to the OUTFILE specified.  

For MySQL errors like this, cutting and pasting the error into google search will reveal a number of potential solutions - or rephrase the question such as "can't create/write to file mysql outfile" . This phrase in google search reveals a number of potential solutions - but basically the file and directory you are writing to must be permissioned for MySQL.

Answer 2

Hello, Stocky. Yes, It is possible. You can try ZetExcel.