# Tanks Import

The Tanks Import tool is a specialized tool for creating new sites, components and component jobs by importing an Excel file. While it was initially developed for importing tank data, it can be used for any type of component.

# Known Limitations

1. The jobs defined on the Jobs sheet will be assigned to all components. If different jobs need to be assigned, different Excel files need to be created.
2. The job description is currently limited to job code and job name

# Preparing the Excel File

All data found in the Excel file will be used for creating or updated the related database records. Already existing records won't be created again and will be updated instead.

The Excel must contain two sheets: sheet 1 named Tanks and sheet 2 named Jobs.

Sheet Tanks needs to have the following columns:

Unlike in previous versions of the tool, columns Main Group and Group Name will be ignored. All sites listed in the Excel table will be added to the currently selected site group in the component tree.

• General Ship Name - name to be used for the site
• External ID - external ID to be added to the system and to be used as reference to an external system
• IMO No. - IMO number of the site (sites will be created or updated by using the IMO No. as reference); if no IMO no. is given, the import tool tries to identify potential already existing sites via the name given in General Ship Name; if no matching site is found, an internal IMO no. will be created and assigned.
• EMail - e-mail to be added to the site as service contact
• Component Name - name of the component
• Component Type - type of the component
• Serial No - serial number
• internal No. - internal number/reference number

Sheet Jobs needs to have the following columns:

Even if no maintenance jobs are to be assigned, a sheet named Jobs with the correct structure must exist in the Excel file.

• JobCode - job code to be used
• JobName - short name for the job
• Internal - numerical value for the interval to be used
• IntervalUnit - interval unit to be used (H, D, M)
• PreWarning - number of days before the due date the warning period should start

# Importing Data

The function can be found in the Maintenance module under More Actions > Admin Tools > Import Sites and Components from Excel. Due to the huge potential impact on the system's database, this tool is available only to user Administrator.

The tool shows a simple window where and Excel file needs to be selected via the ... button right to the File Name text box.

The import will be started by clicking on Import and the import progress will be shown in the log window.

After importing the data it's suggested to refresh the tree view in the Maintenace module by pressing F5 or using the Refresh function.