User Tools

Site Tools


updates:pax-it-is-now-possible-to-import-pax-list-from-excel-file

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

updates:pax-it-is-now-possible-to-import-pax-list-from-excel-file [2019/11/09 15:42] (current)
bartek created
Line 1: Line 1:
 +====== PAX list import from Excel ======
 +
 +
 +PAX data import from Excel file is possible only if the file is in **the same format** as the one which is generated in Leon when you export PAX data to Excel (see screenshot below). If you change columns order in the file or add a column, Leon will not import PAX data. Below you can see the format of Leon PAX Excel file.
 +
 +{{:leon:schedule:PAX in excel.png|}}
 +
 +In order to import PAX from Excel, once the file is filled in with PAX details, in a section OPS open a tab 'PAX' in the right filter, click icon **IMPORT PAX** and select **Import from Excel**, then select PAX file (make sure it is saved as .xls) and Leon will automatically import all PAX data (click SAVE to finish the import). 
 +
 +{{:leon:schedule:PAX imported.png|}}
 +
 +All other PAX details which can not be inserted into to file, such as i.e. place of birth, need to be added manually.
 +
  
updates/pax-it-is-now-possible-to-import-pax-list-from-excel-file.txt · Last modified: 2019/11/09 15:42 by bartek