Importing Data
Preparing Template Data Files
-
From the side menu select Toolbox, select System Setup then Import Data.
-
Click Download Templates to download a templates.zip file to your workstation.
-
Open the ZIP file and extract the CSV files to a folder.
-
Navigate to the folder, open and prepare the CSV file data based on the templates requirements.
Note:
Each data file created must have a maximum file size of 10MB; you can upload and import multiple files per data type. Uniquely name each file. For example:Account01.csv
andAccounts02.csv
.
Uploading and Validating Data Files
-
From the side menu select Toolbox, select System Setup and then Import Data.
-
Enter or select the property to which you want to import data and click Import Data.
-
Click Add Data Types (Objects) to Import and specify the number of files you have to upload for each data type.
-
For each data type, click Select/Upload File.
-
Click Choose File and select the CSV file from the file system. Click Open to select.
-
Click OK.
-
-
Repeat for each data type and file to upload.
Note:
Once the first file is uploaded successfully you have 14 days to complete the import cycle. You can always Save and Close the existing import cycle during the 14 day time frame and come back later and make changes. If you don’t initiate the Import Validated Data into OPERA Cloud within the 14 days’ time frame, all the existing files and any references to the files will be removed. -
Once all the files are uploaded successfully, click Validate Data to validate the data against the property configuration, column widths, and Primary-Foreign key relationships.
Note:
Any unused rows must be removed for the validate action to be enabled. All the upload files status must indicate success state for the validate action to be enabled.
Validation Errors
-
Any validation failures will generate an error file for each uploaded file. You can download the error file by clicking the error file name link or clicking the Vertical Ellipsis and selecting Download Error File.
-
Review the [template]_errrors.csv file.
-
Each error record in the file will have Unique_Id_Column and a column called ERROR_MESSAGE with the Error description (includes the column name, value and error message. For example,
res_rate_code--profroma-reservation
Rate Code is not configured in OPERA Cloud),res_source_code--ref--source_code
is not configured in OPERA Cloud),res_room_type--stdx--reservation
Room Type is not configured in OPERA Cloud,res_room_type_charge--stdx--reservation
Room Type Charge is not configured in OPERA Cloud).
-
-
Correct the errors in the data CSV file uploaded and save changes to file.
-
From the vertical ellipsis, click Remove Uploaded File, click OK to confirm.
-
Re-upload the corrected data CSV file, click Select/Upload File.
-
Re-validate the data, click Validate Data.
Cancelling Upload and Validation Process
You can cancel the import process anytime during the 14 day time frame prior to initiating the import of validated data by clicking Cancel Import Process to remove all uploaded files and references to the current import cycle.
Importing Validated Data
Once all files are validated successfully you can import the data. Inventory and rate availability checks are performed as required.
-
Click Import Validated Data.
-
Click Import Validated Data to confirm.
-
A Data Import Overview page provides details about the import progress.
-
Once import is complete, click Close to return to the import data screen.
-
Click OK to confirm and remove all uploaded files and references to the current import cycle.
Parent topic: Data Import