To export the entire list of vessels on the position list, press the key “E” for export on the keyboard or click the “Export” from here
This will display the below window.
The system will default to the “Standard” format (Current View) but if you wish you can select one of the currently saved formats from the dropdown
or click the Add symbol to create a new format. For more guidance refer to Export Formats
There are five options for exporting a position list (Output buttons below):
Email: The Position List is automatically brought into a format to email directly from the system.
Text: The Position List is exported as plain text properly spaced using a fixed-font style.
Data: The Position List is exported as tab delimited which is the best way to copy/paste into Excel.
Table: The Position List is exported as an html table which is useful when using html supported emails.
This view will give you the option to adjust column widths, as below. Make sure that you change the pull down to Adjust Column
Excel: The Position List is automatically downloaded as an Excel file.
The Settings hyperlink
will display below window which is used to apply additional settings to the position list grid and export format.
The settings are explained below:
Email client: Some email clients don’t work well with our ‘Text’ output format so select the other options on this drop-down to find the one that works best
Export format: Change export text case between normal and ALLCAPS.
Date format: Allows you to select which date format you wish to use for the exported list
Year format: Specifies if the Year Built field will display as 2 or 4 digit year. We recommend using 4-digit year if you are frequently using Excel.
Dwt/Cubic/Slops: Specifies if these 3 fields will display in thousands or full number (i.e. “301,123” or “301”)
Cubic Capacity: Tick the ‘Include Slops’ checkbox to include the slop cubic as part of the Cubic column
Date Ranges: Open Dates can be specified as a range, for example “Nov 15-25”. Ticking this checkbox will include the date range when export the ETA and Open Date fields.
Repeating Data: Tick the ‘Display in first column’ to include repeating values in the first column
Max Length - Notes: Click the dropdown to select the maximum length of your notes to display (from 25 to 200)