Knowledge Base Article: Import Functionality in MediaOS

Overview #

The Import functionality in MediaOS allows users to seamlessly bring data from external sources into the system using .csv import tool templates. To ensure a smooth and successful import, your data must be formatted correctly and contain all required fields.

File Requirements #

Before importing your data, ensure your file meets the following requirements:

• File Format: The import file must be saved as a .csv (Comma-Separated Values) file.
• Required Fields: Your file must include all required columns. Missing data in any required column will cause the import to fail.
• Optional Fields: While some fields are optional, including them can enhance data accuracy and completeness.
• Blank Rows: Any completely blank row in your file will cause the import to fail.
• Data Consistency: Ensure proper formatting (e.g., dates, numbers, and text fields) to avoid errors during the import process.

Best Practices for a Successful Import #

To maximize the success of your import process, follow these best practices:

1. Use the Provided Template - Utilize the template provided in the link below to ensure proper field alignment.
2. Double-Check Required Fields - Ensure that all required fields are included and populated before uploading.
3. Remove Blank Rows - Eliminate any completely blank rows to prevent errors.
4. Verify Data Formatting - Confirm proper data formats, such as date formats and numeric values.
5. Perform a Test Import - Upload a small dataset first to identify potential issues before processing a full import.

Following these guidelines will help streamline the import process and prevent common errors. For additional support, refer to the documentation or contact MediaOS support.

Click here to view for MediaOS Import Tool Templates via Google Sheets. #