How to create a BAPLIE file from an Excel spreadsheet
With BAPLIE Viewer Online, we provide the ability to upload an Excel spreadsheet and generate a BAPLIE file easily, without having to know the structure of the file.
To start, you need an excel spreadsheet with a load list of containers, positions and other relevant data points. The format does not have to be in a specific order because we have the ability to match the fields.
From any page on baplieviewer.com, click Import Excel on the menu options to the left side of the screen.
On the New BAPLIE Header Details screen, fill in the information requested which will be used to create the BAPLIE Header data. Hover over the question mark (?) icon on each field to get more information about each field, as per the SMDG BAPLIE specification.
Values labeled in red are mandatory and must have a value (NOTE - only one of the Date/Time segments are required, not all), then click Next Step.
Choose the Excel or CSV file you wish to import from your computer.
If you are importing an Excel file that has multiple worksheets, you will be prompted to select the worksheet that contains the data you wish to create a BAPLIE file from.
If the worksheet you are importing has column titles on a row that is not Row 1, then select the row containing the column titles from the dropdown on the very top left. This will update the sample table below and the mapping dropdown boxes accordingly.
Then, use the dropdown boxes to map the fields from your Excel file to the corresponding fields that will be created in the new BAPLIE file. Values in red are required.
** For multiple hazardous information: Primary IMDG Code and Primary UN Number fields can accept multiple values. To accomplish this: please separate each value in the Excel file with a space. The sequence of the corresponding UN number should be the same as the sequence for the IMO numbers for them to be joined together into a single hazardous record when performing the import from Excel process.
**For OOG containers, you cannot import this information into the import Excel function. Once you have completed the import process, you will need to manually add the OOG information by using the edit container feature.
If you do not have a column for Port Of Load (POL) in your Excel file, you can use the Edit button to add a value that will be applied to all records in the new BAPLIE file.
Enter a mapping name at the top of the page and click the Save button. This will create a saved mapping for you to reuse on future Excel files. *Note that you will not see the option to select and load a custom mapping until you have imported an Excel file and saved those mappings. Then, there will be a dropdown to allow you to select and apply mappings to future imports.
Once you have completed mapping all the values, select Validate File.
BAPLIE Viewer Online will validate the data in your Excel file to ensure the values supplied adhere to SMDG Requirements for each field.
Any errors will be noted on the next screen, including the Row number containing the bad data, the reason for the validation error, and the data that will be used if you click Proceed.
From here, you can either return to the Mapping screen and correct any mis-mapped values, or start over after correcting the data in the Excel file, or click Proceed.
Clicking Proceed will create the BAPLIE file and download it to your computer. At the same time, the newly generated BAPLIE file will be automatically uploaded as if it was a regular BAPLIE file, so you can view the content from the View BAPLIE function, and make any corrections to the data using the Edit features available. We recommend that for any files that are created using this method, you view the file and check the Anomalies function to verify the BAPLIE data validity.