Show/Hide Toolbars

Navigation: Using ASPRunner.NET > Choose pages

asprunnernet32x32     ASPRunner.NET manual


Export/Import pages

Scroll Prev Next More

 

Export/Import pages

Export
 
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.

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

 
export_popup

Supported file formats are:

Excel 2007 (.xlsx)

Word

CSV (comma separated values)

XML

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.

Import

Supported file formats are:

CSV

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.

import_options

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.

import_page

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

dd.mm.yyyy

mm/dd/yyyy

yyyy-mm-dd

dd/mm/yyyy

import_mapping

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.