Skip to content
Trio Travel guide

Importing sightseeing records from Excel

On this page
  1. Accessing the sightseeing import
  2. Completing the name references and costs
  3. Uploading the file and reviewing rejection
  4. Correcting the country name
  5. Reviewing the corrected import
  6. Checking the remaining saved fields

Accessing the sightseeing import

This guide explains how to import sightseeing records from Excel and correct a rejected country reference. Open Settings, then Sight Seeing, or https://portal.etolv.net/newportal/settings/sightseen

1 The screen includes Import File and Search. Use the import arrow to download the Example template and Catalog guide.
The screen includes Import File and Search. Use the import arrow to download the Example template and Catalog guide.
2 The template has six columns. Keep the headings unchanged and enter data from row 2.
The template has six columns. Keep the headings unchanged and enter data from row 2.

The catalogue contains Catalog, Countries and Cities sheets. Upload the data template; use the catalogue to check fields and reference names.

Completing the name references and costs

sightseen_name is the sightseeing name, country the country name and city the city name. Country and city are required; copy their reference names rather than identifier numbers.

3 A uses Egypt and Cairo. B uses the invalid country DEMO-NOT-FOUND-COUNTRY to demonstrate correction.
A uses Egypt and Cairo. B uses the invalid country DEMO-NOT-FOUND-COUNTRY to demonstrate correction.

cost is the local adult cost, foreign_cost the foreign cost and child_cost the child cost. This template has no currency column; use your approved pricing policy.

4 Both rows use costs of 250, 15 and 125 in that order. Save the file as xlsx.
Both rows use costs of 250, 15 and 125 in that order. Save the file as xlsx.

Uploading the file and reviewing rejection

5 Click Import File and select the file. Check sightseen-demo-mixed.xlsx, then choose Yes to submit or No to return.
Click Import File and select the file. Check sightseen-demo-mixed.xlsx, then choose Yes to submit or No to return.
6 The import operation shows 1 succeeded and 1 rejected. Click Download details to download the rejected-row report.
The import operation shows 1 succeeded and 1 rejected. Click Download details to download the rejected-row report.

A was saved as number 53 while B was rejected. Search for the rejected record and confirm that it is absent before uploading again. Correct only that row.

Correcting the country name

7 The error says Country DEMO-NOT-FOUND-COUNTRY was not found.
The error says Country DEMO-NOT-FOUND-COUNTRY was not found.

Copy B from the report into a copy of the original template. Replace its country with Egypt, retaining Cairo and costs of 250, 15 and 125.

8 The corrected file contains only B with Egypt and Cairo. Keep the original six columns without error and exclude the successful A row.
The corrected file contains only B with Egypt and Cairo. Keep the original six columns without error and exclude the successful A row.

Save the correction in a new file, upload it through Import File and confirm Yes once.

Reviewing the corrected import

9 The new operation shows 1 succeeded and Completed. The first operation remains separately listed below it.
The new operation shows 1 succeeded and Completed. The first operation remains separately listed below it.
10 Search for DEMO-XLS-SIGHT-20261115- to review A as number 53 and B as number 54. The search returns two records with an adult cost of 250 ea...
Search for DEMO-XLS-SIGHT-20261115- to review A as number 53 and B as number 54. The search returns two records with an adult cost of 250 each.

Checking the remaining saved fields

Use the horizontal scrollbar beneath the table to review the remaining columns for both records.

11 FOREIGN COST is 15, with Egypt and Cairo shown for both rows.
FOREIGN COST is 15, with Egypt and Cairo shown for both rows.
12 Continuing horizontally reveals the child cost of 125 for both rows.
Continuing horizontally reveals the child cost of 125 for both rows.

Compare the name, country, city and costs with the file you uploaded.

Sign in to record the lessons you have read. Sign in