--- title: "Reporting Import" slug: "reporting-import" updated: 2024-11-13T05:50:48Z published: 2024-11-13T05:50:48Z canonical: "skthelp.syniti.com/reporting-import" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Reporting Import This topic is related to the following sections: - [Mapping the Fields of a Datasource](/v1/docs/mapping-the-fields-of-a-datasource) - [Mapping Import](/v1/docs/mapping-import) - [ETL Import](/v1/docs/ [!NOTE] > Note > > *UTF- 8 double-byte characters load using Excel Import (Ex: Japanese or Korean language).* ## Prerequisites Prior to importing mappings metadata from a prior version of Stewardship Tier ADM or from DMR Concento complete the following steps: - Create the Datasources within [Catalog > Datasources](/v1/docs/datasources) for Source Datasource and Target Datasource. - Create the Subject Area within [Administer > Setup > Subject Areas](/v1/docs/subject-areas). - Create the Dataset within [Catalog > Dataset Design](/v1/docs/dataset-design). - The Project, Release, Milestones, and assigned Subject Area must be set up within [Migrate > Project Setup](/v1/docs/project-setup). - The object data must be exported from the system and organized within the template spreadsheet and saved as an Excel file. - The Reporting Import Template may be produced locally by clicking the **Download Template** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/8f3d5288-b775-42f4-a1d8-7dd5f271cd35.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=tNRogtkcZfZv2IEWhyBNimZz%2BfmIct6GhJatG6lke38%3D) button. Refer to [Download Reporting Import Template](/v1/docs/reporting-import#download-reporting-import-template) section for details. ## Reporting Import Template Spreadsheet During initial setup of this application for a new project, there may be a need to import the reports used in prior ADM projects or DMR Concento projects. The spreadsheet must remain in its original form with no changes to the column sequence and the first two rows must not be altered as the import expects these rows as they are in the template. The Reporting Import Template spreadsheet contains column headers for: Report, Report Type, Report Priority, and etc. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Reporting Import_1B.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=OSeA9MpcVl9Nb8RssHy7QbJTIpXipB1ywxJ%2BtkEJMF8%3D) Reporting Import: Excel Import Template ## Import the Template Spreadsheet View the following page by navigating to **Administer > Reporting Import** from the Syniti Migrate Homepage. The initial page displays as Import Setup. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Reporting Import.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=sOUH6ApG4mFs02Y6UXzEh%2FKz7QdAOZ5HtweIv9hDygg%3D) Reporting Import: Display ## Add a Report for Import Click the **Choose File** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/8e224a15-c489-48dd-9f16-d4fbde25eee2.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=%2FomiyzR8kH%2BGsnP7TtLBHjyJtL4qLuSiESYFM8Oz%2Bxg%3D) button and then select the appropriate file. Click **Open** to add this file to the page. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Reporting Import_1.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=nTYDNgQ2FW0aZEjnFtHp%2FB%2BDkyMZBb9P9AZZIm6yE4Y%3D) Reporting Import: Choose File The REPORT_IMPORT_TEMPLATE spreadsheet contains a row of notes and instructions at the top, and so the value in **Header Start Row** defaults to 3. Should there be need to alter the start row, change it now. The preview lists the first ten rows of data and the count of rows is provided within the Import File section in **Number of Records Detected**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Reporting Import_2.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=kE75G5UV51atvIKBzbqqkM4%2BRpD0NuHMYKl0yBACI2Y%3D) Reporting Import: Choose File Click the **IMPORT** **REPORTS**![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/d198cf02-cde3-4505-a289-f533b5d7dddf.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=OXBJFcCa6hPPe%2BL%2FfEpBOuWxm3%2BjiLwHrYYYm7Oj8%2F4%3D) button to initiate the import of reporting data . A warning message displays to request a selection of either **CANCEL** or **APPEND** or **TRUNCATE**. Depending upon the need, the user may want to append this new data onto an existing object, or they may want to truncate the tables and add this data as the only data for the object. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Reporting Import_3.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=O%2FSwk%2FNFVME6MZ2rrpx1ex2EKVUKQd7ozQyGNYm6oB0%3D) Reporting Import: Import Data Click on either the **APPEND** button or the **TRUNCATE** button to initiate the import of data. The page indicates that the job is running. It updates to **Status: Import Finished** once complete. > [!NOTE] > Note > > *Refresh the Job Status panel by clicking the* ***Refresh ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/fd229b6e-1eff-43ad-b75e-cbae9849e243.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=rSjjGf7NzsPa4tnvqs5afQxE0oqdizgtoTOW5b5cwFA%3D)*** *icon within the Job Status panel, otherwise the page defaults back to the initial page.* ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Reporting Import_6.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=Wv83tw8Ayw6dY%2F7QMnlkWegqmIPJVA0t7T2d58CHPHM%3D) Reporting Import: Import Data The completed job displays once finished. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Reporting Import_6B.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=vSkaIOxmio80AmQLjcNexKGhjgiydcYXgFuTGaY8m3o%3D) Reporting Import: Job Complete If the job should fail, the user may **VIEW DIAGNOSTICS** (Debug Log) for the job queue. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Reporting Import_4.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=Ggy%2BH0IjKLjOyZmzpk1VPeu1UnxbyxU%2BIa%2FKCeUcMno%3D) Reporting Import: Job Failed ## Job Queue Steps for Each Import The resulting job is entered as a Job Queue with the import of the reporting data set as a step. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Reporting Import_5.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=GrUsltCe0Zi4L0Q5KF794k346jG269PuThnYiGqjP8o%3D) Job Queue: Reporting Import Debug log for the step provides details of the processing. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Reporting Import_5A.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=Np%2BLZO704bweHIa7GX1oZ%2FNawqGJChGN6HzKNys426Y%3D) Debug Log: Reporting Import ## Download Reporting Import Template To produce a local copy of the Reporting Import Template, click the **Download Template** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/8f3d5288-b775-42f4-a1d8-7dd5f271cd35.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=tNRogtkcZfZv2IEWhyBNimZz%2BfmIct6GhJatG6lke38%3D) button. This produces a local version of the Excel spreadsheet used to store the rows of data for Reporting Import. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Reporting Import_8.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=Qbo%2BasK4wegMW7r2GcnEvbj9mRJ9PnkY56zx%2FCqyrOQ%3D) Reporting Import: Download Template