Editor's Generator provides a quick and easy method to construct everything you need to use Editor on your own site. Generator will construct a package customised for your exact needs that you can upload to your server and start using Editor almost immediately with a minimum of configuration (simply upload the files, install the generated SQL and add your SQL DB username and password credentials).
Note that Generator is not designed to present all of the options that are available in Editor - it is a quick start tool only! To get the most out of Editor working with the API and initialisation options is required.
Once you have downloaded the generated package, you will need to complete the database connection parameters so it can actually communicate with your database. For details on how to use Generator, please refer to the Generator manual page.
The number of options available in Generator can seem daunting, but to get started, all you really need to do is fill in the text boxes! From there you can customise the generated Editor files by changing some of the options in the table. The definitions for the options in Editor are shown below.
See also the Generator manual page for information on using Generator and the created files.
Software and styling
Select the software and the styling library that you wish to include in your created package.
|Styling||DataTables and Editor can use the styling options provided by a number of popular CSS styling libraries to ensure that your tables and forms fit into your site seamlessly.|
|Software||The DataTables suite provides a large amount number of additional features in add-on packages (called extensions) which can be included to add extra functionality to your tables.|
Server and database
The four fields in this section tells Generator about your server and database environment.
|Server type||Platform that Generator will create a package for. The .NET option will create a Visual Studio project that can be open and run from Visual Studio.|
|Database type||This option will custom the SQL that Generator creates to match your database.|
|Table name||The SQL table name so the scripts can query the table. Note that Generator does not currently support queries which require a JOIN. For occasions where you do need Editor to read from and update multiple tables (joins), you'll need to modify the created scripts, as described in the join documentation (PHP / .NET).|
|Primary key||This is the name of the primary key column in your database table - a column which contains a unique value for each row. This provides Editor with the ability to be able to address each database row individually. The default is
Form / Table
The fields in the main Generator table, tells Generator about the data that you want to be shown in DataTables and Editor.
|Form label||The text that is presented both in the header of the DataTable for the column and the label for the Editor field input.|
|SQL column||Name of the SQL column that will hold the data for this column - something similar to the label would be best!|
|Field type||The Editor input type.|
|Extra options||Depending on the field type selected you might be asked to provide extra information - for example when choosing the Select field type you'll need to provide the options for the select list.|
|Default||Default value for the field when the user adds a new row to the table.|
|Required||Indicate if a value is required from the end user when adding or editing a row. Note that empty strings are rejected here!|
|Type||Depending on the field type selected you can select from a list of validation options. Note that validation in Generator created Editor installs is done on the server-side, not the client-side.|
|Options||Depending on the validation type you might be required to enter additional options|
|Table||When checked the value will be shown in the DataTable.|
|Editor||When checked the field will be shown in the Editor form.|
|Delete||Remove the field definition from Generator.|
Don't forget that Generator is just a quick start tool to get going with Editor only! Generator does not provide access to the full set of features that Editor has available (it would make Generator far to complex to present all available options!).
DataTables and its extensions provide a wide range of options and features that can be used to enhance your table. Selecting the files that you want to include on your page can be a little complex, so Generator provides the ability to select the software you want using the options below. At a minimum jQuery, DataTables and Editor should be included. You will likely want to also include Select and Buttons and possibly a styling library.
Editor is a commercial extension for DataTables, it requires a license to use it for longer than the free trial period. Please create an account or login to be able to include Editor in the package. License holders can also select additional field type plug-ins using this downloader to extend Editor's functionality.