Show/Hide Toolbars

Navigation: Using ASPRunner.NET > Choose pages

asprunnernet32x32     ASPRunner.NET manual

Export/Import pages

Scroll Prev Next More


Export/Import pages

Starting from version 9.8 onwards you are able to use new settings for the export function:
Export raw/formatted values option will work in both old (non-Bootstrap) and new layouts.
The Field Separator option and the new option to choose a list of fields are available in Bootstrap layouts only.

The export page by default is opened in popup. This is how it will look on the generated pages in Bootstrap layout.


Supported file formats are:

Excel 2007 (.xlsx)


CSV (comma separated values)


Labels are used as headings in Excel/Word files. Field names are used as headings in XML/CSV files. This is done in order CSV file that is exported using ASPRunner.NET could be imported into other software.


Supported file formats are:


Excel 2007 (.xlsx)

Field names or labels can be used as headers in Excel files. In CSV files field names should be used as headings.

ASPRunner.NET adds the new records or updates the existing ones while importing.

During import ASPRunner.NET will try to insert a new record first. If insert fails for any reason like duplicate primary key it will try to locate and update this record with new data.

It will update the existing records instead of adding them in the following case:

1.A primary key is defined for the table in question.

2.Key fields selected on the 'Choose pages' screen match the primary key in the database.

3.Primary key column or columns exist in the file being imported.

You can copy and paste import data instead of uploading the whole file.


At first copy a few lines of data from Excel. You do not have to include column headers. Then paste it to the import page.


Map columns define date format and import the data. Examples of date format you can use:





If you need to combine the import with any extra actions, use BeforeInsert Event. For example, if you want to specify the file creation date or fill in an OwnerID field.

yellowbulbNote: since ASRunner.NET creates temporary files used for import preview in templates_c folder under output directory, web server user needs to have editing permissions on this folder.