Could you clarify what you are seeking?

Receive direct support from the TBMS team.

Importing Data

Simplify Data Handling with Easy External Data Imports.

Effective data management is key to running your business smoothly. TBMS offers a straightforward import feature that lets you effortlessly bring in data from external sources, keeping your records accurate and current.

Step-by-Step Import Process

Access the Import Area: Find the import tool within tabs like bookings, passengers, customers, or pricing, each designed for specific data import purposes.

Get the Template: Start by downloading the provided template file, which includes all importable columns, ensuring your data fits the required structure for seamless entry.

Complete the Template: Open the template and input your data, aligning it with the column headers and matching the correct data types for each field.

Upload Your File: Go to the import tool, select "Upload File," pick your completed template, and choose a supported format: CSV, XLSX, or XLS.

Map the Columns: Check the columns and link them to the appropriate fields in TBMS. Ensure all mandatory fields marked with “*” are mapped correctly to preserve data accuracy.

Start the Import: After mapping, hit the "Import" button. The system will review the file, verify the data, and complete the import process.

Formatting Phone Numbers for Excel

Excel might strip the "+" sign from phone numbers during imports due to its data handling. To avoid this, use these tips:

  1. Set as Text: Format the phone number column as text before adding numbers to prevent Excel from treating them as numerical values.
  2. Add "+" Manually: Insert the "+" sign before each phone number to keep it intact during the process.
  3. Apply a Custom Format: Use a custom number format that includes the "+" sign. Right-click the column, choose "Format Cells," select "Custom," and input a format like "+#########" to retain the "+" sign.