--- title: Intuitive for MPS - CSV File Import Process description: Prior to loading data into the main SQLServer Data Warehouse, the Intuitive for MPS system imports data from the three main CSV import files into an intermediate SQLite Database via the Intuitive ETL Service. --- [Skip to content](https://help.intuitivebusinessintelligence.com/csv-file-import-process#main-content) English Show submenu for translations ![Intuitive logo RGB-1.png\]](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20RGB-1.png?height=40&name=Intuitive%20logo%20RGB-1.png) Open main navigation Close main navigation - English Show submenu for translations - [Go to weareintuitive.com](https://weareintuitive.com/) [Go to weareintuitive.com](https://weareintuitive.com/) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Help Center](https://help.intuitivebusinessintelligence.com/?hsLang=en) 2. [Intuitive For Managed Print Services (MPS)](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en) 3. [Intuitive For MPS - Loading the Data Warehouse](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-loading-the-data-warehouse) # Intuitive for MPS - CSV File Import Process ## Prior to loading data into the main SQLServer Data Warehouse, the Intuitive for MPS system imports data from the three main CSV import files into an intermediate SQLite Database via the Intuitive ETL Service. ![MPS\_ETL\_Service\_Diagram](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/MPS_ETL_Service_Diagram.png?width=360&name=MPS_ETL_Service_Diagram.png) The three CSV import files are as follows: - [OPS\_MIF.CSV](https://help.intuitivebusinessintelligence.com/mps-file-layout-specification-ops_mif.csv?hsLang=en) - [OPS\_SERVICE.CSV](https://help.intuitivebusinessintelligence.com/mps-file-specification-layout-ops_service.csv?hsLang=en) - [OPS\_LOOKUP.CSV](https://help.intuitivebusinessintelligence.com/mps-file-specification-layout-ops_lookup.csv?hsLang=en) The ETL Service imports the three CSV files based on an XML configuration file. Appendix A below shows a sample template for the ***ETLService.Config*** file which normally resides in the folder: *C:\\Program Files\\Intuitive Business Intelligence\\Intuitive Dashboards\\Tools\\ETL Service* The ETL service for MPS creates three tables in the **BI\_Combined\_Database\_SQLite.db** database as follows: - **ops\_mif** - **ops\_service** - **ops\_lookup** **Note**: If the BI\_Combined\_Database\_SQLite.db file does not exist, it will be created by the process when the ETL service is first started. The ETL Service can also be run as a console application (C:\\Program Files\\Intuitive Business Intelligence\\Intuitive Dashboards\\Tools\\ETL Service\\ETLService.Console.exe). Once the ETL Service is running, it will load data according to the XML configuration file and the schedule that has been defined. ### ETLService.config XML Configuration File explained: Header Section: ![ETL\_Config\_Header\_Section](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/ETL_Config_Header_Section.png?width=688&name=ETL_Config_Header_Section.png) This section defines system information and defines the paths where different system and log files reside. The location and name of the SQLite database to be created and the initial SQL script (init.sql here) that should be executed on first creation of the database is defined here (this script can create custom views etc.). (Line 12) When the "Intuitive Dashboards ETL service" is started for the first time (under Windows Services), it will create a file in the 'Initialised' folder (Line 8) to indicate that the initial creation of the database and load has been undertaken. **Note**: If you wish to re-initialise the system for any reason this file and the BI\_Combined\_Database\_SQLite.db database must be deleted and the service restarted. Table definition Section: ![ETL\_Config\_Import\_File\_Header](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/ETL_Config_Import_File_Header.png?width=688&name=ETL_Config_Import_File_Header.png) This section defines the name of the table to be created in the SQLite database (ops\_mif) and whether the table is to be cleared of data before loading new data (Line 3) The source data file and delimeter is defined here too (line 4) The ETL service will load data according to the schedule that is defined here (Line 7). In this example, the table will be loaded from the CSV file every day at 6:00am. There are also other options (commented in green) to run the schedule at intervals throughout the day and to end the schedule at a certain time each day. Table field definition Section: ![ETL\_Config\_Table\_Fields\_Section](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/ETL_Config_Table_Fields_Section.png?width=513&name=ETL_Config_Table_Fields_Section.png) This section defines how the fields present in the CSV file are to be named/typed and imported into the SQLite database table. **Note**: There are many configuration options available when defining the ETLService.config file. There is a document availabel from Intuitive which describes the ETL Service in full detail. ### Next Load Step: Once the CSV files have been loaded to the intermediate SQLite database via the ETL Service, the MPS Data Warehouse can now be loaded by following the [Data Warehouse Load Process](https://help.intuitivebusinessintelligence.com/intuitive-for-mps-data-warehouse-load-process?hsLang=en). ### Appendix A: Example ETLService.config \ \   \     \
  \   \     \       \       \     \     \       \         \           \