ASP.NET Settings

General Options

No Cache	Whether caching is required on browser
Multi-Language	Enable multi-language project. If enabled, a combobox will appear on the top of the generated scripts for user to select language. See Tools for selecting languages for the multi-language project. Important Multi-Language project must use utf-8 encoding. The charset of the project must be "utf-8". The data in your database must be stored in unicode, otherwise your data will not be displayed properly.
Default Language	Default language of the project. It must be compatible with Charset (see HTML Settings). Default is English. There is always one default language for a project. Only the English language file (english.xml) is shipped with ASP.NET Maker. If your project is single language but you use another language, create a language file for your language (see Making Language Files), put it in the "languages" subfolder under the installation folder and then select your default language using this combobox. If you enable Multi-Language, you must select one of the selected languages as the default language.
File Upload	Upload folder - The global folder where the uploaded files resides. If you do not enter a specific folder for a file upload field in the Edit Tag panel of the Field Setup page, all the uploaded files will be put in this folder. Notes Always specify an upload folder if you allow file upload. This folder is used as the root folder of temporary folders for file upload fields during Add/Edit. It is also used as the root folder of the user files folder of CKEditor. Unlike the field specific upload folder setting (which is a C# expression), this field specific setting must be a constant string (without double quotes). If you want dynamic upload folders for different fields, specify upload folder for each field (see Field Setup). The path is relative to wwwroot. Use slashes "/" as path delimiter, no leading slash. e.g. If the wwwroot of your website is C:\MyProjectFolder\wwwroot and you enter "uploads/" in this textbox, the folder for the uploaded files will be C:\MyProjectFolder\wwwroot\uploads. If you are not sure which folder is wwwroot, please read Generate Settings. If for some reasons you must use another absolute path, use the Advanced Setting File upload path (absolute) for temporary files. Make sure that the Web server user have read/write access to the folder. Max File Size - Maximum file upload size in bytes. If <= 0, default is used. Note By default the default maximum file size allowed by ASP.NET Core is 30,000,000 bytes, which is approximately 28.6MB. Allowed file type - The allowed file extensions of the uploaded files. Separate the file extensions (without ".") by comma, e.g. gif,png,png) If blank, all file types are allowed. Delete file on update/delete - Option to delete the uploaded file when the field value is replaced, removed or if the record is deleted.
Audit Trail	You can choose to log activities in a log file or in a database table. Log file folder - The folder where the audit trail log file resides. Notes Make sure that the Web server user have read/write access to the folder. The path is relative to wwwroot. Use slashes "/" as path delimiter, no leading slash. e.g. If the wwwroot of your website is C:\MyProjectFolder\wwwroot and you enter "uploads/" in this textbox, the folder for the log file will be C:\MyProjectFolder\wwwroot\uploads. If you are not sure which folder is wwwroot, please read Generate Settings. Use database table - Log the activities in the specified table instead of log file. The table must have the following fields: (actual data types depend on database type) DateTime (DateTime) Script (VarChar) User (VarChar) Action (VarChar) Table (VarChar) Field (VarChar) KeyValue (Long VarChar) OldValue (Long VarChar) NewValue (Long VarChar) You can create the database yourselves and select the table in the combobox, then click the [...] button to select the fields in your table. Alternatively, if you have not created the table yet, you can click [Create Table] and let ASP.NET Maker creates the table and setup the settings for you. Notes The [Create Table] button supports Access, SQL Server, MySQL, PostgreSQL and Oracle only. Track login/logout activities - If security feature is enabled, login/logout activities will also be logged.
Validation	Server-side - Enable server-side form validation. Client-side (JavaScript) - Enable client-side form validation. Note If the available validation format in the Edit Tag panel (see Field Setup) does not fulfil your requirements, you can use your own server-side and/or client-side validation code using Server Event and Client Scripts.

Page Options (Global)

The following page options are global for all tables. If you want different settings for a particular table, you can use table-specific options available in the Table Setup page.

Records per page

Number of records to be displayed on the list page of all tables. If blank or 0, default setting of 20 will be used.

Selectable page sizes

Number of records to be selected by user. Comma separated values, e.g. 10,20,50,ALL.

Note "ALL" (without quotes) is supported, other values must be integers.

Paging section style

"NumericPages" or "NextPrev"

Sort type

None, Single column or Multiple column. If Multiple column is selected, the generated list page supports multi-column sorting by Ctrl-clicking the table header.

Multiple column

Show multiple records per row. Default is 0. This feature will only take effect if the value is > 0. Possible values: 1, 2, 3, 4, 6, 12

Paging section at top

Show the paging section at top (also applies to View page)

Paging section at bottom

Show the paging section at bottom (also applies to View page)

Paging section in View page

Show paging section in View page also

Paging section in Edit page

Show paging section in Edit page also

Multiple delete

Show checkboxes in the list page for selecting multiple records to delete

Links on left side

Show the links on the left instead of right

Use buttons as links

Show the links in record row as a button group instead of individual icons or links.

Use button dropdown for links

Show the links in record row as a button with dropdown menu instead of individual icons or links.

Use button dropdown in paging section

Show the links in paging section as buttons with dropdown menu instead of individual links.

Export

Enable export in List page - allow export in List pages

Enable export in View page - allow export in View pages also

Use button dropdown - show the export links as a button with dropdown menu. Default is showing the export links as a row of icons.

Print/CSV/HTML/Excel/Word/XML/PDF/Email - Records can be exported to Print (printer-friendly), CSV, HTML, Excel, Word, XML, PDF format or sent as HTML email content.

Note The fields in printer friendly version are same as in List/View page, while the fields in other format are determined by the Export setting of the field in Field Setup page.

Note that the fields in printer friendly version are same as in List/View page, while the fields in other format are determined by the Export setting of the field in Field Setup page.

Export type - Determines which records to export. The follows are supported:

All Page - Records in all pages are exported
Current Page - All records in current page are exported
Selected Record - If selected, a checkbox will be displayed in each row for selection. Only selected records in the current page are exported. (Selecting records in different pages is not allowed.) To select records primary key is required, Current Page export type will be used for tables without primary key.

Notes

Binary data (BLOB fields) cannot be exported.
Export to HTML/CSV/XML/PDF are not applicable to reports.
Export to Word/Excel works by exporting data in HTML format for Word/Excel to convert/import, the exported file is not native .doc/.xls format. However, registered users can use the EPPlus extension which outputs .xlsx file format.
Images cannot be exported to Word/Excel/CSV/XML. However, registered users can use the EPPlus extension which outputs images also.
Export to PDF (for all users) and EPPlus extensions (for registered users) support images (jpg, gif and png only), but a temporary folder is required during export, the extensions use the Upload folder (see File Upload above) because write permission for the folder should be already setup properly. Even you do not use file upload to folder, if you want to export with images, make sure you still specify an upload folder and set up write permission.

Notes (Export to PDF)

There are some known issues, read the note in the extension setup page (see Tools -> Extensions) for more information before use.
The extension supports non-unicode alphanumerical characters (e.g. iso-8859-1) in the built-in PDF fonts (Times, Courier, and Helvetica) only. Currently unicode characters and double byte characters are NOT supported.
By default export is only enabled in View page. If you want to enable it in the List page also (the number of records to be exported is not large), you can set the advanced settings of the extension (see Tools -> Extensions).

Comparison

Export	Print	HTML	PDF	Excel (Extension)	Excel	Word	Email
Format	HTML	HTML	PDF	Excel 2007	HTML (NOT native)	HTML (NOT native)	HTML
Images
Custom Template

Email Settings

ASP.NET Maker supports many features that can send emails. If you use these features, you'll need to specify a SMTP server.

SMTP server	The host name or IP of the SMTP server. Note Make sure you need to specify a valid SMTP server in the network of the web server. "localhost" will not work if it is not a SMTP server.
SMTP server port	Port number of SMTP server. Default is 25.
SMTP server username	User name for SMTP server authentication. If your SMTP server does not require authentication, leave it blank.
SMTP server password	Password for SMTP server authentication. If your SMTP server does not require authentication, leave it blank.
Sender (Email address)	Email address of the sender of all emails
Recipient (Email address)	Email address of the recipient(s) for notification emails when a record is added/edited/deleted (if enabled). If there are multiple recipients, separate them by comma.
Security	Protocol used by the SMTP server. Possible value is: SSL. Note Leave this setting empty if your SMTP server does not use such protocol.