Platinum sponsors
Before using this plugin you have to include the static template in your site template:
Now you have included the necessary TypoScript to show your extension in the FrontEnd:
plugin.tx_wfqbe_pi1 {
template = EXT:wfqbe/pi1/wfqbe_template.html
style = EXT:wfqbe/pi1/stile.css
defLayout = 0
debugQuery = 0
insert{
pageConfirmation = 1
requiredSymbol = *
add_new{
icon = EXT:wfqbe/res/add.gif
}
select_wizard{
icon = EXT:wfqbe/res/open.gif
}
}
classes {
even = wfqbe_even
odd = wfqbe_odd
}
}
## This enables the csv file export
csv_wfqbe >
csv_wfqbe = PAGE
csv_wfqbe {
typeNum = 181
10 < plugin.tx_wfqbe_pi1
10.template = EXT:wfqbe/pi1/wfqbe_csv_template.html
10.defLayout = 0
config {
disableAllHeaderCode = 1
additionalHeaders = Content-type:application/csv|Content-Disposition: attachment; filename=results.csv|Content-Transfer-Encoding:binary
xhtml_cleaning = 0
admPanel = 0
}
}
The csv_wfqbe object is used to create a new page object (with a default typeNum=181) that is used if you want to create a CSV file with your results.
The next step is to create a new system folder where to store the credentials of the DBMS. Inside this new system folder, follow the “Create a new record” link and select “User credentials”. In this form you must insert the following data:
Title: this is the name of your connection.
Host: in this field you have to insert the host where is located your DBMS
DBMS type: select the correct DBMS
Username: insert the username which you use to connect to DBMS
Password: insert the password which you use to connect to DBMS
Connection type: you can choose the connection type you need:
Connect: this is used to create a non-persistent connection (this is the default value ).
PConnect: this is used to create a persistent connection.
NConnect: this is used to always force a new connection (use this if you are trying to connect to a database that is stored in the same DBMS of the TYPO3's local DB!!!).
Connect SQL configuration: you can fill in this field with SQL statements (separated by ';') that are sent to DB right after connecting. This is useful, e.g., for charset configuration (SET NAMES utf8).
By default a connection to the local TYPO3 DB is available that you can use without the need to create the credentials for it.
If you have to integrate more than one DBMS, you can create a lot of credential records. This is a screenshot of the User Credentials form:
Now you are ready to use the extension!
