Import files (with examples)

If you have decided to upload certain information instead of creating it manually, a CSV file (comma-separated value) as an input source is required. This article gives a brief account of how to convert data from MS Excel workbook format to .csv extension. All import files must be generated in .csv format.

TABLE OF CONTENTS

• Report file
• Work orders file
• Site file
• Asset file
• Sub assembly and component file
• Inventory
• Personnel
• Personnel skills and transport certificates file
• Example files

Before uploading any file, make sure your file is in the required .csv format! If you are using Excel to create the CSV file, you will have to save the file as CSV:

1. Go to File - Save as… in the Excel workbook that contains the data of interest. Choose .csv extension file format drop-down menu and save the new file to any convenient folder.

Your file is now ready for importing.

Report file

A report file contains user-created information which needs to be consistent with the data already available in the tool including Site ID, Report number, Date, and similar. See an example below.

Note: Make sure that all data are in the required format. You can obtain this information by hovering over the ? icon in the import section.

Work orders file

A work order file contains user-created information which needs to be consistent with the data already available in the tool including Site ID, Asset ID, Order type, Work order ID, and similar. See an example below.

Note: Make sure that all data are in the required format. You can obtain this information by hovering over the ? icon in the import section.

Site file

A site file contains user-created information which needs to be consistent with the data already available in the tool including Name, Country, Site ID, Type, and similar. See an example below.

Note: Make sure that all data are in the required format. You can obtain this information by hovering over the ? icon in the import section.

Asset file

An asset file contains user-created information which needs to be consistent with the data already available in the tool including Site ID, Name, Asset ID, Latitude and Longitude and similar. See an example below.

Note: Make sure that all data are in the required format. You can obtain this information by hovering over the ? icon in the import section.

Sub assembly and component file

A sub assembly or component file contains user-created information which needs to be consistent with the data already available in the tool including Site ID, Name, Asset ID, Serial number and similar. See an example below.

Inventory

An inventory file contains user-created information needs to be consistent with the data already available in the tool; Work package, responsible, and location. See an example below.

Personnel

A personnel file contains user-created information needs to be consistent with the data already available in the tool; Role, Department, and Permission. See an example below.

Note: Make sure that all data are in the required format. You can obtain this information by hovering over the ? icon in the import section.

Personnel skills and transport certificates file

A personnel skills or transport certificates file contains user-created information including Name and Group Name. See an example below.

Once you've uploaded the files, you can find skills and their skill groups under Account settings > Personnel, and transport certificates under Account settings > Logistics

Example files

Example files can be found underneath.

For more information related to importing files to Shoreline Execution in the Account settings, please see Import account settings.