Please enable JavaScript to view this site.

Navigation: Using PHPRunner > Choose pages screen

Export/Import pages

Scroll Prev Next More


To access the Export page settings, proceed to the Choose pages screen and click the Settings button next to the Export page checkbox. To enable the Import page, click the Import page checkbox on the same screen.


Export page

These are the Export page settings:

The Export page is opened in a popup by default. This is how it looks like in the generated application:



The supported file formats are:


Excel 2007 (.xlsx);

Word (.doc);

CSV (comma separated values).


The field labels are used as the headers for the Excel/Word files. The field names are used as the headers for the CSV files so that the exported file can be imported into other software.

Import page



Supported file formats are:



Excel 2007 (.xlsx);

Excel 97-2003 (.xls).


The field names or labels can be used as the headers for the Excel files. For the CSV files, the field names should be used as the headers.


PHPRunner adds new records or updates the existing ones when importing. During an import, PHPRunner tries to insert new records first. If the insert fails for any reason (for example, when there is a duplicate primary key), it then tries to locate and update the existing records.


PHPRunner updates the existing records instead of adding new ones when:


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


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


3.The key column/columns exist in the imported file.


When importing the data, set the Date format mask, so that PHPRunner recognizes the date correctly. Here are a few examples of supported date formats:






If you wish to combine the import with any extra actions, use the BeforeInsert event. For example, you may want to specify the file creation date or fill in the OwnerID field.


Note: PHPRunner creates temporary files to preview the import results in the templates_c folder under the output directory. You need to set the writing permissions for this folder in the web server.

Copy and paste text

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


Copy a few lines of data, then paste it into the import page after clicking the Copy and paste text button.



Note: you do not need to include the column headers.

See also:

Choose pages screen

Key columns

List page settings / Click actions

Add/Edit page settings

CAPTCHA on Add/Edit pages

Update selected

Printer-friendly/PDF view settings



Created with Help+Manual 7 and styled with Premium Pack Version 3 © by EC Software