Information

Data Validation ensures that the data entered into a system is accurate, complete, and reliable. This helps prevent errors that could arise from incorrect data.

For instance, ensuring that numeric fields contain numbers, date fields contain valid dates, or categorical fields follow the specified categories is important for consistency.

Trial imports allow you to import your data into the Training Environment for review to verify that the data is clean, consistent, and conforms to expected patterns before importing data into the live production environment.

Import File Validation

All data import files should be validated within the RMS Training environment to confirm the correct required format.

1. Navigate to Tools > Data Imports.
2. Select a Property.
3. Choose the appropriate 'File Type' for the data import.
4. Select the 'Browse' button to locate the Import File on your computer.

1. Select the Import File.
2. Click 'Open' to complete the file upload.

1. Select 'Validate' to confirm the data is in the required file format.

1. Review the Validation Results. 

Trial Import

Once the file passes all validation checks, it is considered ready for the next phase. This ensures that only data that meets quality standards is moved forward. The validated file is then imported into the Training Environment for further review to ensure the integrity of the imported data.

1. Select the 'Import' button to begin the data import in the Training Environment.

1. Review the warning message and select 'Yes.'

1. Review the Import Results.