Can I create a BAPLIE from an Excel file?
Yes, with our tool it is possible to convert an excel file into a EDI standard BAPLIE file.
All membership types now have the ability to upload an Excel spreadsheet and generate a BAPLIE file easily, without having to know the structure of the file.
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 which will be used to create the BAPLIE Header data. Hover over the question mark (?) icon on a field to get more information 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.
se 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.
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. Press Continue to close the Port of Load pop-up message.
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.